Table slot9.WORLD.TSTA.INCIDENT_CASES
This table stores the case information created 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
RSC_STATUS_CODE varchar2 30
EJS_CODES.CODE IC_RSC_STATUS_CODE_EJS_CODE_FK R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE IC_AGNCY_CD_FK R
INC_CASE_NUMBER varchar2 20
INC_CASE_ID number 0
ARREST_CASES.INC_CASE_ID ARRC_IC_FK R
CASE_ASSIGNMENT_HISTORIES.INC_CASE_ID CAH_IC_FK R
CASE_ATTACHMENTS.CASE_ID CASATT_IC_FK C
CASE_FIELD_INTS.CASE_ID CFINT_IC_FK R
CASE_IMAGES.CASE_ID CASIMG_IC_FK R
CASE_LOG.INC_CASE_ID CASELG_IC_FK R
CASE_SEARCH_ADDRESS_VW.INC_CASE_ID Implied Constraint R
CASE_SEARCH_FIELD_CONTACT_VW.INC_CASE_ID Implied Constraint R
CASE_SEARCH_INCIDENTS_VW.INC_CASE_ID Implied Constraint R
CASE_SEARCH_NAMES_VW.INC_CASE_ID Implied Constraint R
CASE_SEARCH_OFFENSES_VW.INC_CASE_ID Implied Constraint R
CASE_SEARCH_OFFICERS_VW.INC_CASE_ID Implied Constraint R
INC_CASE_ACTIVITIES.INC_CASE_ID INCCASACT_IC_FK R
INC_CASE_INC_STATUS_VW.INC_CASE_ID Implied Constraint R
INC_CASE_INCIDENTS.INC_CASE_ID ICI_IC_FK C
INC_CASE_INCIDENTS_VW.INC_CASE_ID Implied Constraint R
INC_CASE_OFFICERS_VW.INC_CASE_ID Implied Constraint R
INC_CASE_WORKGROUPS.INC_CASE_ID ICW_IC_FK R
INC_CASE_XREFS.INC_CASE_ID ICX_IC_FK R
INC_CASE_XREFS.PARENT_INC_CASE_ID ICX_PARENT_IC_FK R
INC_CASE_XREFS_VW.INC_CASE_ID Implied Constraint R
INCIDENT_CASE_OFFICERS.INC_CASE_ID INCCASOFF_IC_FK R
INCIDENT_CASE_OFFICERS_VW.INC_CASE_ID Implied Constraint R
INCIDENT_CASE_RWSCH_VW.INC_CASE_ID Implied Constraint R
INCIDENT_CASE_SEARCH_MIN_VW.INC_CASE_ID Implied Constraint R
INCIDENT_CASE_SEARCH_VW.INC_CASE_ID Implied Constraint R
INCIDENT_CASE_STATUS_HISTORY.INC_CASE_ID ICS_HSTRY_IC_FK C
INCIDENT_CASE_VW.INC_CASE_ID Implied Constraint R
JS_INCIDENT_CASE_SUMMARY_VW.INC_CASE_ID Implied Constraint R
JS_INCIDENT_CASE_VW.INC_CASE_ID Implied Constraint R
MY_CASE_SEARCH_VW.INC_CASE_ID Implied Constraint R
PHOTO_LINEUP_CASES.CASE_ID PHLNCA_IC_FK R
TAG_CASES.CASE_ID TAGCS_IC_FK R
USI_CASE_FIELDS.CASE_ID USI_CAF_IC_FK R
USI_CASES.CASE_ID USI_CA_IC_FK R
USRSCRN_CASE_ACTIVITY_VW.INC_CASE_ID Implied Constraint R
CASE_STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE IC_CASE_EJS_CODES_FK R
SC1_SOLVABILITY_CODE varchar2 30  √  null
EJS_CODES.CODE IC_SC1_SOLVABILITY_EJS_CODE_FK R
DATE_EXPIRED date 7  √  null
DATE_CLEARED date 7  √  null
SUPERVISOR_COMMENT varchar2 512  √  null
NOTES clob 4000  √  null
REVIEW_UPDATE varchar2 1  √  null
UCR_STATUS_DATE date 7  √  null
UNIT_CODE varchar2 5  √  null
EMP_SERVICE_ASSIGN_CODES.CODE IC_EMPSRVASC_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
RSC_STATUS_CODE_TYPE varchar2 30  √  'REVIEW_STATUS_CODES'
EJS_CODES.CODE_TYPE IC_RSC_STATUS_CODE_EJS_CODE_FK R
SC1_SOLVABILITY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE IC_SC1_SOLVABILITY_EJS_CODE_FK R
CASE_STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE IC_CASE_EJS_CODES_FK R
REC_ID number 0  √  null
SECURITY_LEVEL number 38  √  null
INCIDENT_SECURITY_LEVEL_CODES.INC_SEC_LEVEL_CODE IC_INC_SEC_LVL_FK R
NEXT_UPDATE_DATE date 7  √  null
RESTRICT_SG_EXCLSV_FLAG varchar2 1  √  'N'
AGENCY_ONLY varchar2 1  √  'N'
CASE_HOURS number 7,2  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
AGENCY_ONLY IN ( 'Y','N') CK_IC_AGENCY_ONLY
"AGENCY_CODE" IS NOT NULL IC_AGENCY_CODE_NN
"INC_CASE_ID" IS NOT NULL IC_INC_CASE_ID_NN
"INC_CASE_NUMBER" IS NOT NULL IC_INC_CASE_NUMBER_NN
"RSC_STATUS_CODE" IS NOT NULL IC_RSC_STATUS_CODE_NN
RESTRICT_SG_EXCLSV_FLAG IN ( 'Y','N') IC_WRK_EXLV_FLG_CK

Indexes:
Column(s) Type Sort Constraint Name
INC_CASE_ID Primary key Asc IC_PK
AGENCY_CODE Performance Asc IC_AGNCY_CD_FK_I
CASE_STATUS_CODE_TYPE + CASE_STATUS_CODE Performance Asc/Asc IC_CASE_EJS_CODES_FK_I
UNIT_CODE Performance Asc IC_EMPSRVASC_FK_I
SECURITY_LEVEL Performance Asc IC_INC_SEC_LVL_FK_I
RSC_STATUS_CODE Performance Asc IC_RSC_FK_I
RSC_STATUS_CODE_TYPE + RSC_STATUS_CODE Performance Asc/Asc IC_RSC_STATUS_CODE_EJS_CODE_I
SC1_SOLVABILITY_CODE Performance Asc IC_SC1_FK_I
SC1_SOLVABILITY_CODE_TYPE + SC1_SOLVABILITY_CODE Performance Asc/Asc IC_SC1_SOLVABILITY_EJS_CODE_I

Close relationships  within of separation: