Table slot9.WORLD.TSTA.VICTIMS
This table stores victim information for a MASTER PERSON added to an INCIDENT as a victim 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
VICTM_CD_VICTIM_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE VIC_VICTM_CD_VICTI_EJS_CODE_FK R
Victim type code
V_NUMBER number 38
INCIDENT_VICTIM_NAME_VW.V_NUMBER Implied Constraint R
OFFENSE_CIRCUMSTANCES.V_NUMBER OC_CIRCUM_VIC_FK R
OFFENSE_HOMICIDE_CIRCUMSTANCES.V_NUMBER OH_CIRCUM_VIC_FK R
VICTIM_ARRESTEES.V_NUMBER VA_VIC_FK C
CREATOR_DATE date 7  √  null
CREATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
INC_PER_ID number 0  √  null
INCIDENT_PEOPLE.INC_PER_ID VIC_INCPER_FK C
INCIDENT_ID number 0  √  null
INCIDENT_BUSINESSES.INC_INCIDENT_ID VIC_INCBUS_FK C
BUSINESS_NUMBER number 0  √  null
INCIDENT_BUSINESSES.BUSNS_BUSINESS_NUMBER VIC_INCBUS_FK C
ACTIVITY_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE VIC_ACTIVITY_TYPE__EJS_CODE_FK R
ASSIGNMENT_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE VIC_ASSIGNMENT_TYP_EJS_CODE_FK R
ORI_OTHER_JURIS varchar2 9  √  null
ACTIVITY_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE VIC_ACTIVITY_TYPE__EJS_CODE_FK R
ASSIGNMENT_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE VIC_ASSIGNMENT_TYP_EJS_CODE_FK R
VICTM_CD_VICTIM_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE VIC_VICTM_CD_VICTI_EJS_CODE_FK R
REC_ID number 0  √  null
NEG_DEATH_FLAG varchar2 1  √  'N'
VR_METHOD_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE VIC_VR_METHOD_EJS_CD_FK R
VR_METHOD_CODE varchar2 30  √  null
EJS_CODES.CODE VIC_VR_METHOD_EJS_CD_FK R
VR_DATE_NOTIFIED date 7  √  null
VR_COMMENTS varchar2 4000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
NEG_DEATH_FLAG IN ( 'Y','N') CK_VIC_NEG_DEATH_FLAG
"V_NUMBER" IS NOT NULL VIC_V_NUMBER_NN

Indexes:
Column(s) Type Sort Constraint Name
V_NUMBER Primary key Asc VIC_PK
ACTIVITY_TYPE_CODE_TYPE + ACTIVITY_TYPE_CODE Performance Asc/Asc VIC_ACTIVITY_TYPE__EJS_CODE_I
ASSIGNMENT_TYPE_CODE_TYPE + ASSIGNMENT_TYPE_CODE Performance Asc/Asc VIC_ASSIGNMENT_TYP_EJS_CODE_I
INCIDENT_ID + BUSINESS_NUMBER Performance Asc/Asc VIC_INCBUS_FK_I
INC_PER_ID Performance Asc VIC_INCPER_FK_I
ACTIVITY_TYPE_CODE Performance Asc VIC_UCRACTTP_CD_FK_I
ASSIGNMENT_TYPE_CODE Performance Asc VIC_UCRASTP_CD_FK_I
VICTM_CD_VICTIM_TYPE_CODE Performance Asc VIC_VICTM_CD_FK_I
VICTM_CD_VICTIM_TYPE_CODE_TYPE + VICTM_CD_VICTIM_TYPE_CODE Performance Asc/Asc VIC_VICTM_CD_VICTI_EJS_CODE_I
VR_METHOD_CODE_TYPE + VR_METHOD_CODE Performance Asc/Asc VIC_VR_METHOD_EJS_CD_FK_I

Close relationships  within of separation: