Table slot9.WORLD.TSTA.INCIDENT_PEOPLE
This table stores the associations to MASTER PEOPLE added to an INCIDENT 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
INC_INCIDENT_ID number 0
INCIDENT_SUPPLEMENTS.INC_INCIDENT_ID INCPER_INCSUP_FK C
Incident ID number assigned
PER_PERSON_ID number 0
MASTER_NAMES.PER_PERSON_ID INCPER_MN_FK C
Person ID number
MN_MN_ID number 0
MASTER_NAMES.MN_ID INCPER_MN_FK C
Master Name ID number
RELTN_RELATION_CODE varchar2 30  √  null
EJS_CODES.CODE INCPER_REL_EJS_CODES_FK R
This is a possible dead column. - EDC 10/21/98
SUSPUS_USING_CODE varchar2 1  √  null Suspected of using?
VEH_VEHICLE_ID number 0  √  null Vehicle ID number
VICTM_CD_VICTIM_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE INCPER_VICTM_CD_VI_EJS_CODE_FK R
Possible dead column added 10/22/98 EDC
APPROX_AGE varchar2 3  √  null Age of person involved in incident
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
SUPP_SEQ number 38
INCIDENT_SUPPLEMENTS.SUPP_SEQ INCPER_INCSUP_FK C
Supplement Sequence Number 1 = Original Report
VEH_VEHICLE_ID_ASSOCIATED_WITH number 0  √  null
RES_ST_CD_RESIDENT_STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE INCPER_RES_ST_CD_R_EJS_CODE_FK R
INC_PER_ID number 0
ARRESTEES.INC_PER_ID ARR1_INCPER_FK C
CASE_SEARCH_NAMES_VW.INC_PER_ID Implied Constraint R
DS_ICR_ARRESTS.INC_PER_ID Implied Constraint R
DS_ICR_ARRESTS_GTT.INC_PER_ID Implied Constraint R
DS_ICR_GROUPB_GTT.INC_PER_ID Implied Constraint R
DS_ICR_OFFENDERS.INC_PER_ID Implied Constraint R
DS_ICR_OFFENDERS_GTT.INC_PER_ID Implied Constraint R
DS_ICR_VICTIMS.INC_PER_ID Implied Constraint R
DS_ICR_VICTIMS_GTT.INC_PER_ID Implied Constraint R
INC_NARRATIVE_PEOPLE.INC_PER_ID INCNARPEOP_INCPER_FK R
INC_PER_FORCES.INC_PER_ID INPERFOR_INCPER_FK R
INC_PER_SUP_VW.INC_PER_ID Implied Constraint R
INC_PROP_LATEST_APPR_VW.INC_PER_ID Implied Constraint R
INCIDENT_NAME_VW.INC_PER_ID Implied Constraint R
INCIDENT_PEOPLE_OFFENSES.INC_PER_ID IPO_INCPER_FK C
INCIDENT_PEOPLE_VW.INC_PER_ID Implied Constraint R
INCIDENT_PERSON_ROLE_HISTORIES.INC_PER_ID INCPERRLHST_INCPER_FK C
INCIDENT_PERSON_ROLES.INC_PER_ID IPR_INC_PER_ID_FK R
INCIDENT_PROPERTIES.INC_PER_ID INCPRO_INCPER_FK R
INCIDENT_VEHICLES.INC_PER_ID INCVEH_INCPER_FK R
INCIDENT_VICTIM_NAME_VW.INC_PER_ID Implied Constraint R
INJURIES.INC_PER_ID INJ_INCPER_FK C
JS_INCIDENT_CASE_VW.INC_PER_ID Implied Constraint R
MODUS_OPERANDI.INC_PER_ID MO_INC_PEOPLE_FK R
PEOPLE_WARRANTS.INC_PER_ID Implied Constraint R
USI_INCIDENT_PEOPLE.INC_PER_ID USI_IP_INCPER_FK R
VICTIM_ARRESTEES.INC_PER_ID VA_INCPER_FK C
VICTIMS.INC_PER_ID VIC_INCPER_FK C
RES_ST_CD_RESIDENT_STATUS_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INCPER_RES_ST_CD_R_EJS_CODE_FK R
VICTM_CD_VICTIM_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INCPER_VICTM_CD_VI_EJS_CODE_FK R
RELATION_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INCPER_REL_EJS_CODES_FK R
REC_ID number 0  √  null
CLEAR_MULTIPLE_ARREST_CD varchar2 30  √  null
EJS_CODES.CODE INCPER_CLRMARST_EJS_CODES_FK R
CLEAR_MULTIPLE_ARREST_CD_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INCPER_CLRMARST_EJS_CODES_FK R
EXPUNGE varchar2 1  √  'N' Y/N flag to mark an incident person as expunged from the report.
EXPUNGE_COMMENT_ID number 0  √  null
EJS_COMMENTS.EJS_COMMENT_ID INCPER_E_CMNT_FK R
Comment ID from expungement comments.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"INC_INCIDENT_ID" IS NOT NULL INCPER_INC_INCIDENT_ID_NN
"INC_PER_ID" IS NOT NULL INCPER_INC_PER_ID_NN
"MN_MN_ID" IS NOT NULL INCPER_MN_MN_ID_NN
"PER_PERSON_ID" IS NOT NULL INCPER_PER_PERSON_ID_NN
"SUPP_SEQ" IS NOT NULL INCPER_SUPP_SEQ_NN

Indexes:
Column(s) Type Sort Constraint Name
INC_PER_ID Primary key Asc INCPER_PK
CLEAR_MULTIPLE_ARREST_CD_TYPE + CLEAR_MULTIPLE_ARREST_CD Performance Asc/Asc INCPER_CLRMARST_EJS_CODES_FK_I
EXPUNGE_COMMENT_ID Performance Asc INCPER_E_CMNT_FK_I
INC_INCIDENT_ID Performance Asc INCPER_INC_FK_I
INC_INCIDENT_ID + SUPP_SEQ Performance Asc/Asc INCPER_INCSUP_FK_I
MN_MN_ID + PER_PERSON_ID Performance Asc/Asc INCPER_MN_FK_I
RELATION_CODE_TYPE + RELTN_RELATION_CODE Performance Asc/Asc INCPER_REL_EJS_CODES_FK_I
RES_ST_CD_RESIDENT_STATUS_CODE Performance Asc INCPER_RES_ST_CD_FK_I
RES_ST_CD_RESIDENT_STATUS_TYPE + RES_ST_CD_RESIDENT_STATUS_CODE Performance Asc/Asc INCPER_RES_ST_CD_R_EJS_CODE_I
SUSPUS_USING_CODE Performance Asc INCPER_SUSPUS_FK_I
INC_INCIDENT_ID + PER_PERSON_ID Must be unique Asc/Asc INCPER_UI
VEH_VEHICLE_ID Performance Asc INCPER_VEH_FK_I
VICTM_CD_VICTIM_TYPE_CODE Performance Asc INCPER_VICTM_CD_FK_I
VICTM_CD_VICTIM_TYPE_CODE_TYPE + VICTM_CD_VICTIM_TYPE_CODE Performance Asc/Asc INCPER_VICTM_CD_VI_EJS_CODE_I

Close relationships  within of separation: