Table slot9.WORLD.TSTA.INC_CASE_ACTIVITIES
This table stores activities added to a case 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_CASE_ACT_ID number 0
CASE_ACTIVITY_ARRESTS.INC_CASE_ACT_ID CACTARR_INCCASACT_FK R
CASE_ACTIVITY_ASSIGNMENTS.INC_CASE_ACT_ID CASE_ACT_ASSGN_INCCASACT_FK R
CASE_ACTIVITY_FLDINTS.INC_CASE_ACT_ID CACTINT_INCCASACT_FK R
CASE_ACTIVITY_NAMES.INC_CASE_ACT_ID CACTNAMES_INCCASACT_FK R
CASE_ACTIVITY_NARRATIVES.INC_CASE_ACT_ID CASEACTNARR_INCCASACT_FK R
CASE_ACTIVITY_VEHICLES.INC_CASE_ACT_ID CACTVEH_INCCASACT_FK R
CASE_ACTIVITY_WARRANTS.INC_CASE_ACT_ID CACTWAR_INCCASACT_FK R
CASE_LOG.INC_CASE_ACT_ID CASELG_INCCASACT_FK R
INC_CASE_ACTIVITY_NOTIFIES.INC_CASE_ACT_ID ICAN_INCCASACT_FK R
USI_CASE_ACTIVITIES.INC_CASE_ACT_ID USI_CACT_INCCASACT_FK R
USI_CASE_ACTIVITY_FIELDS.INC_CASE_ACT_ID USICASACTFLD_INCCASACT_FK R
USRSCRN_CASE_ACTIVITY_VW.INC_CASE_ACT_ID Implied Constraint R
Unique identifier for this record. PK
INC_CASE_ID number 0
INCIDENT_CASES.INC_CASE_ID INCCASACT_IC_FK R
Incident Case that the activity is for
ACTIVITY_CODE_TYPE varchar2 30 'INCCASE_ACTIVITY_CODES'
EJS_CODES.CODE_TYPE INCCASACT_ACTCD_EJS_CODE_FK R
Activity code that is being captured for the incident case.
ACTIVITY_CODE varchar2 30
EJS_CODES.CODE INCCASACT_ACTCD_EJS_CODE_FK R
Activity code that is being captured for the incident case.
ACTIVITY_DATE date 7  √  null Date the Activity occured.
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
NOTE_ID number 0  √  null
EJS_NOTES.NOTE_ID INCCASACT_EJSN_FK R
MINUTES_SPENT number 0  √  null Total number of minutes spent on the case activity
START_DATE date 7  √  null Date/time case activity started
END_DATE date 7  √  null Date/time case activity ended
REVIEW_DATE date 7  √  null Date/time for case activities next review
PRIORITY_CODE varchar2 30  √  null
EJS_CODES.CODE INCCASACT_PRIOR_EJSCD_FK R
EJS_CODE code for activity priority
PRIORITY_CODE_TYPE varchar2 30  √  'CASE_ACTIVITY_PRIORITY_CODES'
EJS_CODES.CODE_TYPE INCCASACT_PRIOR_EJSCD_FK R
EJS_CODE code type for activity priority
STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE INCCASACT_STAT_EJSCD_FK R
EJS_CODE code for activity status
STATUS_CODE_TYPE varchar2 30  √  'CASE_ACTIVITY_STATUS_CODES'
EJS_CODES.CODE_TYPE INCCASACT_STAT_EJSCD_FK R
EJS_CODE code type for activity status

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ACTIVITY_CODE_TYPE" IS NOT NULL INCCASACT_ACT_CODE_TYPE_NN
"ACTIVITY_CODE" IS NOT NULL INCCASACT_ACTIVITY_CODE_NN
"INC_CASE_ACT_ID" IS NOT NULL INCCASACT_INC_CASE_ACT_ID_NN
"INC_CASE_ID" IS NOT NULL INCCASACT_INC_CASE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
INC_CASE_ACT_ID Primary key Asc INCCASACT_PK
ACTIVITY_CODE_TYPE + ACTIVITY_CODE Performance Asc/Asc INCCASACT_ACTCD_EJS_CODE_FK_I
NOTE_ID Performance Asc INCCASACT_EJSN_FK_I
END_DATE Performance Asc INCCASACT_END_DATE_I
INC_CASE_ID Performance Asc INCCASACT_IC_FK_I
PRIORITY_CODE_TYPE + PRIORITY_CODE Performance Asc/Asc INCCASACT_PRIOR_EJSCD_FK_I
REVIEW_DATE Performance Asc INCCASACT_REVIEW_DATE_I
START_DATE Performance Asc INCCASACT_START_DATE_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc INCCASACT_STAT_EJSCD_FK_I

Close relationships  within of separation: