Table slot9.WORLD.TSTA.DS_ICR_HEADERS
This table stores the Administrative Segment based on a given EXTERNAL_SYSTEM_CODES.CODE populated from DS_ICR Package when Incident is Approved 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
HEADERID number 0
DATASET_HEADER_VW.HEADERID Implied Constraint R
DS_ICR_ADDL_PROPERTY_ITEMS_GTT.HEADERID Implied Constraint R
DS_ICR_ADDRESSES.HEADERID DSICRADD_DSICRHD_FK R
DS_ICR_ARRESTS.HEADERID DSICRARR_DSICRHD_FK R
DS_ICR_ARRESTS_GTT.HEADERID Implied Constraint R
DS_ICR_GROUPB_GTT.HEADERID Implied Constraint R
DS_ICR_HEADER_FILES.HEADERID DSICRHF_DSICRHD_FK C
DS_ICR_HEADER_MESSAGES.HEADERID DSICRHM_DSICRHD_FK C
DS_ICR_HEADERS_GTT.HEADERID Implied Constraint R
DS_ICR_MORE_DATA.HEADERID DISCRMD_DSICRHD_FK R
DS_ICR_OFFENDERS.HEADERID DSICROFND_DSICRHD_FK R
DS_ICR_OFFENDERS_GTT.HEADERID Implied Constraint R
DS_ICR_OFFENSES.HEADERID DSICROFF_DSICRHD_FK R
DS_ICR_OFFENSES_GTT.HEADERID Implied Constraint R
DS_ICR_PROPERTY_DRUGS_GTT.HEADERID Implied Constraint R
DS_ICR_PROPERTY_ITEMS.HEADERID DSICRPROP_DSICRHD_FK R
DS_ICR_PROPERTY_ITEMS_GTT.HEADERID Implied Constraint R
DS_ICR_SEGMENTS.HEADERID DSICRSEG_DSICRHD_FK R
DS_ICR_VICTIM_SUSPECTS_GTT.HEADERID Implied Constraint R
DS_ICR_VICTIMS.HEADERID DSICRVIC_DSICRHD_FK R
DS_ICR_VICTIMS_GTT.HEADERID Implied Constraint R
DS_ICR_ZERO_GTT.HEADERID Implied Constraint R
MICR_INCIDENT_HEADER_VW.HEADERID Implied Constraint R
Header Id [Unique, Primary Key]
DATASETID number 0
DS_ICR_DATA_SETS.DATASETID DSICRHD_DSICR_FK R
REPNUM number 0 Incident Report Number
NIBRSTAT char 1  √  null DDP MICR Status Code (for internal program use)-empty/written/sent/sent waiting response/sent passed
NIBREDIT char 1  √  null DDP MICR Edit Check Status (Y/N)
ACTION varchar2 255  √  null Data Element 1 (Action Code)
ORIGORI varchar2 255  √  null Data Element 2 (Originating agency ORI)
ORIGYEAR varchar2 255  √  null Data Element 3 (Original Year - Incident)
INCIDENTNO varchar2 255  √  null Data Element 4 (Incident Number)
COUNTY1 varchar2 255  √  null Data Element 5 (County)
CITYTWP varchar2 255  √  null Data Element 6 (City/Township)
GEOCODE varchar2 255  √  null Data Element 7 (Geo Code)
INCDATE date 7  √  null Data Element 8 (Incident/Report Date)
DATEIND varchar2 255  √  null Data Element 9 (Date Occurred/Reported)
HOUROCC varchar2 255  √  null Data Element 10 (Hour Occured)
EXCCLEAR varchar2 255  √  null Data Element 11 (Exceptional Clearance Code)
EXCCLEARDT date 7  √  null Data Element 12 (Exceptional Clearance Date)
ASSISTORI varchar2 255  √  null Data Element 13 (Assisting Agency ORI)
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
REC_ID number 0  √  null
STATE_STATUS_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DSICRHD_EJS_CODE_FK R
STATE_STATUS varchar2 30  √  null
EJS_CODES.CODE DSICRHD_EJS_CODE_FK R
FAMVIOL varchar2 255  √  null TIBRS Data Element #T2 Family Violence Indicator
MAX_ORIG_SUPP_SEQ number 38  √  null
MAX_ORIG_DSICR_STATUS varchar2 30  √  null
INCDATEEND date 7  √  null
INCDATEENDTIME date 7  √  null
INCDATESTART date 7  √  null
INCDATESTARTTIME date 7  √  null
INCIDENTNO_CONVERTED varchar2 255  √  null
CARGOTHEFT varchar2 1  √  null
POSTED varchar2 1 'N' Indicates whether or not the UCR Administrator has confirmed that the database is to be submitted on external systems reporting files

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
CARGOTHEFT IN ('Y','N') CK_DSICRHD_CARGOTHEFT
"DATASETID" IS NOT NULL DSICRHD_DATASETID_NN
"HEADERID" IS NOT NULL DSICRHD_HEADERID_NN
"POSTED" IS NOT NULL DSICRHD_POSTED_NN
"REPNUM" IS NOT NULL DSICRHD_REPNUM_NN

Indexes:
Column(s) Type Sort Constraint Name
HEADERID Primary key Asc DSICRHD_PK
DATASETID Performance Asc DSICRHD_DSICR_FK_I
STATE_STATUS_TYPE + STATE_STATUS Performance Asc/Asc DSICRHD_EJS_CODE_FK_I
DATASETID + REPNUM + ORIGORI + INCIDENTNO Must be unique Asc/Asc/Asc/Asc DSICRHD_REPNUM_DSICRDS_UK_I
REPNUM Performance Asc DSICRHD_REPNUM_FK_I

Close relationships  within of separation: