Table slot9.WORLD.TSTA.ARRESTS
This table stores the ARREST header information as entered in the application
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ARREST_ID number 0
ARREST_ADDRESS_SEARCH_VW.ARREST_ID Implied Constraint R
ARREST_ATTACHMENTS.ARREST_ID ARRATT_ARR_FK C
ARREST_BUSINESSES.ARREST_ID ARRBU_ARR_FK R
ARREST_CASES.ARREST_ID ARRC_ARR_FK R
ARREST_CFS_SEARCH_VW.ARREST_ID Implied Constraint R
ARREST_CHARGE_VW.ARREST_ID Implied Constraint R
ARREST_CHARGES.ARREST_ID AC_ARR_FK C
ARREST_DISPATCHES.ARREST_ID ARRDISP_ARR_FK C
ARREST_DISPOSITION_SEARCH_VW.ARREST_ID Implied Constraint R
ARREST_IMAGES.ARREST_ID ARRIMG_ARR_FK R
ARREST_JAIL_SEARCH_VW.ARREST_ID Implied Constraint R
ARREST_LIVESCAN_VW.ARREST_ID Implied Constraint R
ARREST_LOG.ARREST_ID ARL_ARR_FK R
ARREST_NARRATIVE_SEARCH_VW.ARREST_ID Implied Constraint R
ARREST_NARRATIVES.ARREST_ID ARRN_ARR_FK R
ARREST_OFFICERS.ARREST_ID AO_ARR_FK C
ARREST_ORG_SEARCH_VW.ARREST_ID Implied Constraint R
ARREST_PEOPLE.ARREST_ID ARRP_ARR_FK R
ARREST_PERSON_SEARCH_VW.ARREST_ID Implied Constraint R
ARREST_PROPERTIES.ARREST_ID ARP_ARR_FK R
ARREST_PROPERTY_SEARCH_VW.ARREST_ID Implied Constraint R
ARREST_QUESTIONS.ARREST_ID ARRQ_ARR_FK R
ARREST_REF_NUMBERS.ARREST_ID ARRREFN_ARR_FK C
ARREST_SEARCH_VW.ARREST_ID Implied Constraint R
ARREST_TYPES.ARREST_ID AT_ARR_FK C
ARREST_VEHICLE_SEARCH_VW.ARREST_ID Implied Constraint R
ARREST_WARRANTS.ARREST_ID ARRWAR_ARR_FK R
CASE_ACTIVITY_ARRESTS.ARREST_ID CACTARR_ARR_FK R
COURT_APPEARANCE_SEARCH_VW.ARREST_ID Implied Constraint R
COURT_CASE_APP_SEARCH_VW.ARREST_ID Implied Constraint R
COURT_CASE_ARRESTS.ARR_ARREST_ID CRTCASEARR_ARR_FK R
COURT_CASE_SEARCH_VW.ARREST_ID Implied Constraint R
CRIMINAL_COMPLAINT_ARRESTS.ARR_ARREST_ID CCARRS_ARR_FK R
DOMESTIC_VIOLENCE_VICTIMS.ARREST_ID DVV_ARR_FK C
DS_ICR_ARRESTS.ARREST_ID Implied Constraint R
DS_ICR_ARRESTS_GTT.ARREST_ID Implied Constraint R
DS_ICR_GROUPB_GTT.ARREST_ID Implied Constraint R
EXPORT_TRANSACTION_LOGS.ARREST_ID Implied Constraint R
INCIDENT_ARRESTS.ARR_ARREST_ID IA_ARR_FK C
JS_FIELD_ARREST_CHARGE_VW.ARREST_ID Implied Constraint R
JS_FIELD_ARREST_VW.ARREST_ID Implied Constraint R
PERSON_FINGERPRINTS.ARREST_ID PF_ARR_FK C
PERSON_FINGERPRINTS_VW.ARREST_ID Implied Constraint R
USI_FIELD_ARREST_FIELDS.ARREST_ID USI_ARRF_ARR_FK R
USI_FIELD_ARREST_VEH_FIELDS.ARREST_ID USI_ARRVF_ARR_FK R
USI_FIELD_ARRESTS.ARREST_ID USI_FA_ARR_FK R
USRSCRN_FIELDARREST_VW.ARREST_ID Implied Constraint R
Arrest ID number.
PERSON_ID number 0
PEOPLE.PERSON_ID ARR_PER_FK C
Person ID number
JAIL_STAFF_ID number 0  √  null
OFFICERS.OFFICER_ID ARR_JS_FK R
Officer ID number
ARREST_STATUS_CODE varchar2 3  √  null
ARREST_STATUS_CODES.ARREST_STATUS_CODE ARR_ASC_FK R
ARREST_DATE date 7 Date the suspect was arrested.
TOWING_CO_ID number 0  √  null
TOW_COMPANY_CODES.TOWING_CO_ID ARR_TCC_FK R
Unique id for business
ARR_COMMENT varchar2 4000  √  null
ARREST_TIME date 7  √  null Time the suspect was arrested.
DCFS_NOTIFIED varchar2 1  √  'N' DCFS has been notified
COMMITMENT_DATE date 7  √  null Date the suspect was commited.
MEDICAL_ATTENTION varchar2 1  √  'N' Medical Attention required
MEDICAL_COMMENT varchar2 4000  √  null
ARREST_STATUS_DATE date 7  √  null Date status was changed.
ARREST_STATUS_COMMENT varchar2 255  √  null reason for arrest status.
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
TOWING_CO_AREA varchar2 3  √  null
TOWING_CO_CITY varchar2 40  √  null
TOWING_CO_NAME varchar2 40  √  null
TOWING_CO_PREFIX varchar2 3  √  null
TOWING_CO_STREET varchar2 40  √  null
TOWING_CO_SUFFIX varchar2 4  √  null
TOWING_CO_ZIP varchar2 5  √  null
VEH_VEHICLE_ID number 0  √  null
VEHICLES.VEHICLE_ID ARR_VEH_FK R
NOTE_ID number 0  √  null
EJS_NOTES.NOTE_ID ARR_EJSN_FK R
ADDR_ADDRESS_ID number 38  √  null
ADDRESSES.ADDRESS_ID ARR_ADDR_FK R
STATE_TRACKING_NUMBER varchar2 20  √  null
REC_ID number 0  √  null
TOWING_CO_STATE_CODE varchar2 30  √  null
EJS_CODES.CODE ARR_TOW_STATE_EJS_CD_FK R
TOWING_CO_STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ARR_TOW_STATE_EJS_CD_FK R
PBT varchar2 10  √  null
AGENCY_CODE varchar2 100
AGENCY_CODES.AGENCY_CODE ARR_AGNCY_CD_FK R
FINGERPRINT_CODE varchar2 30  √  null
EJS_CODES.CODE ARR_FINGERPR_EJS_CD_FK R
FINGERPRINT_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ARR_FINGERPR_EJS_CD_FK R
ARREST_NUM varchar2 100 Arrest Number
ARREST_DSP_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ARR_DISPOSITION_EJS_CD_FK R
Arrest Dispostion Code Type
ARREST_DSP_CODE varchar2 30  √  null
EJS_CODES.CODE ARR_DISPOSITION_EJS_CD_FK R
Arrest Dispostion Code
ARREST_DSP_COMMENT varchar2 4000  √  null Arrest Dispostion Comment
ARREST_DSP_CNTY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ARR_DISP_CNTY_EJS_CD_FK R
Arrest Disp Cnty Code Type
ARREST_DSP_CNTY_CODE varchar2 30  √  null
EJS_CODES.CODE ARR_DISP_CNTY_EJS_CD_FK R
Arrest Disp Cnty Code
ARREST_DSP_JAIL_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ARR_DISP_JAIL_EJS_CD_FK R
Arrest Disp Jail Code Type
ARREST_DSP_JAIL_CODE varchar2 30  √  null
EJS_CODES.CODE ARR_DISP_JAIL_EJS_CD_FK R
Arrest Disp Jail Code
BOND_TYPE varchar2 2  √  null
BOND_TYPE_CODES.BOND_TYPE ARR_BTC_FK R
Bond Type
BOND_AMOUNT number 12,2  √  null Bond Amount
ARREST_CNTY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ARR_CNTY_EJS_CD_FK R
Arrest County Code Type
ARREST_CNTY_CODE varchar2 30  √  null
EJS_CODES.CODE ARR_CNTY_EJS_CD_FK R
Arrest County Code
INC_REPORT_NUMBER varchar2 20  √  null Incident Report Number
JAIL_DATE date 7  √  null Date Sent to Jail
IMPOUND_ID number 0  √  null
IMPOUND.IMPOUND_ID ARR_IMPD_FK R
VEHICLE_SEIZED_FLAG varchar2 1  √  'N'
VEHICLE_STORED_FLAG varchar2 1  √  'N'
CURRENCY_SEIZED_FLAG varchar2 1  √  'N'
CURRENCY_TOTAL number 0  √  null
DISCHARGE_DATE date 7  √  null
STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE ARR_EJSCD_STAT_FK R
STATUS_CODE_TYPE varchar2 30  √  'ARREST_STATUS_CODES'
EJS_CODES.CODE_TYPE ARR_EJSCD_STAT_FK R
CASE_NUMBER varchar2 50  √  null
REVIEW_STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE ARR_EJSCD_RVW_STAT_FK R
REVIEW_STATUS_CODE_TYPE varchar2 30  √  'ARREST_REVIEW_STATUS_CODES'
EJS_CODES.CODE_TYPE ARR_EJSCD_RVW_STAT_FK R
LOC_AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE ARR_LOC_AGNCY_CD_FK R
LOCAL_JAIL_CODE varchar2 30  √  null
EJS_CODES.CODE ARR_EJSCD_LJC_STAT_FK R
LOCAL_JAIL_CODE_TYPE varchar2 30  √  'LOCAL_JAIL_CODES'
EJS_CODES.CODE_TYPE ARR_EJSCD_LJC_STAT_FK R
PROPERTY_FLAG varchar2 1  √  null Y/N to mark that no property was inventoried.
ARRESTEE_AGE_CODE varchar2 30  √  null
EJS_CODES.CODE ARR_EJSCD_AGECD_FK R
ARRESTEE_AGE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ARR_EJSCD_AGECD_FK R
ASSOCIATED_EVENT_FLAG varchar2 1  √  null
EXPUNGE varchar2 1  √  'N' Y/N flag to mark arrest as expunged.
EXPUNGE_COMMENT_ID number 0  √  null
EJS_COMMENTS.EJS_COMMENT_ID ARR_E_CMNT_FK R
Comment ID for expungement comments.
TRACKING_NUMBER varchar2 30  √  null
OWNER_PROP_FLAG varchar2 1  √  null Y/N to mark that the arrestee has no property

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL ARR_AGENCY_CODE_NN
"ARREST_DATE" IS NOT NULL ARR_ARREST_DATE_NN
"ARREST_ID" IS NOT NULL ARR_ARREST_ID_NN
"ARREST_NUM" IS NOT NULL ARR_ARREST_NUM_NN
"PERSON_ID" IS NOT NULL ARR_PERSON_ID_NN
CURRENCY_SEIZED_FLAG IN ( 'Y' , 'N' ) CK_ARR_CURR_SEIZED_FLAG
dcfs_notified IN ( 'Y' , 'N' ) CK_ARR_DCFS_NOTIFIED
medical_attention IN ( 'Y' , 'N' ) CK_ARR_MEDICAL_ATTENTION
OWNER_PROP_FLAG IN ( 'Y' , 'N' ) CK_ARR_OWN_PROP_FLAG
PROPERTY_FLAG IN ( 'Y' , 'N' ) CK_ARR_PROPERTY_FLAG
VEHICLE_SEIZED_FLAG IN ( 'Y' , 'N' ) CK_ARR_VEH_SEIZED
VEHICLE_STORED_FLAG IN ( 'Y' , 'N' ) CK_ARR_VEH_STORED

Indexes:
Column(s) Type Sort Constraint Name
ARREST_ID Primary key Asc ARR_PK
ADDR_ADDRESS_ID Performance Asc ARR_ADDR_FK_I
AGENCY_CODE + ARREST_NUM Performance Asc/Asc ARR_AGNCY_ARRNUM_I
AGENCY_CODE Performance Asc ARR_AGNCY_CD_FK_I
ARREST_STATUS_CODE Performance Asc ARR_ASC_FK_I
BOND_TYPE Performance Asc ARR_BTC_FK_I
ARREST_CNTY_CODE_TYPE + ARREST_CNTY_CODE Performance Asc/Asc ARR_CNTY_EJS_CD_FK_I
ARREST_DSP_CODE_TYPE + ARREST_DSP_CODE Performance Asc/Asc ARR_DISPOSITION_EJS_CD_FK_I
ARREST_DSP_CNTY_CODE_TYPE + ARREST_DSP_CNTY_CODE Performance Asc/Asc ARR_DSP_CNTY_EJS_CD_FK_I
ARREST_DSP_JAIL_CODE_TYPE + ARREST_DSP_JAIL_CODE Performance Asc/Asc ARR_DSP_JAIL_EJS_CD_FK_I
EXPUNGE_COMMENT_ID Performance Asc ARR_E_CMNT_FK_I
ARRESTEE_AGE_CODE_TYPE + ARRESTEE_AGE_CODE Performance Asc/Asc ARR_EJSCD_AGECD_FK_I
LOCAL_JAIL_CODE_TYPE + LOCAL_JAIL_CODE Performance Asc/Asc ARR_EJSCD_LJC_STAT_FK_I
REVIEW_STATUS_CODE_TYPE + REVIEW_STATUS_CODE Performance Asc/Asc ARR_EJSCD_RVW_STAT_FK_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc ARR_EJSCD_STAT_FK_I
NOTE_ID Performance Asc ARR_EJSN_FK_I
FINGERPRINT_CODE_TYPE + FINGERPRINT_CODE Performance Asc/Asc ARR_FINGERPR_EJS_CD_FK_I
IMPOUND_ID Performance Asc ARR_IMPD_FK_I
JAIL_STAFF_ID Performance Asc ARR_JS_FK_I
LOC_AGENCY_CODE Performance Asc ARR_LOCAGNCY_CD_FK_I
PERSON_ID Performance Asc ARR_PER_FK_I
STATE_TRACKING_NUMBER Performance Asc ARR_STATE_TRACKING_I
TOWING_CO_ID Performance Asc ARR_TOW_FK_I
TOWING_CO_STATE_CODE_TYPE + TOWING_CO_STATE_CODE Performance Asc/Asc ARR_TOW_STATE_EJS_CD_FK_I
VEH_VEHICLE_ID Performance Asc ARR_VEH_FK_I
ARREST_DATE + ARREST_STATUS_CODE Performance Asc/Asc ARREST_ARREST_DATE_I

Close relationships  within of separation: