Table slot9.WORLD.TSTA.OFFICER_CASE_LOAD
This table stores the case load assigned to an officer 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
OFF1_OFFICER_ID number 0
EVIDENCE_COC_MOST_RECENT_VW.OFF1_OFFICER_ID Implied Constraint R
EVIDENCE_CUSTODY_VW.OFF1_OFFICER_ID Implied Constraint R
EVIDENCE_STATUS_VW.OFF1_OFFICER_ID Implied Constraint R
JS_EVIDENCE_VW.OFF1_OFFICER_ID Implied Constraint R
OFFICER_CASE_LOAD_BY_MONTHS.OFF1_OFFICER_ID OCLBM_OCL_FK C
OFFICERS.OFFICER_ID OCL_OFF1_FK C
Officer ID number
NUM_CASES_ASIGN number 5 Number of Cases Assigned
NUM_CASES_PENDING number 5 Number of cases pending
NUM_CASES_CLEARED number 5 Number of cases cleared
LAST_ASIGN_DATE date 7  √  null Date of last case assignment
YEAR_TO_DATE_ASSIGNED number 5
YEAR_TO_DATE_CLEARED number 5
YEAR_TO_DATE_PENDING number 5
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"NUM_CASES_ASIGN" IS NOT NULL OCL_NUM_CASES_ASIGN_NN
"NUM_CASES_CLEARED" IS NOT NULL OCL_NUM_CASES_CLEARED_NN
"NUM_CASES_PENDING" IS NOT NULL OCL_NUM_CASES_PENDING_NN
"OFF1_OFFICER_ID" IS NOT NULL OCL_OFF1_OFFICER_ID_NN
"YEAR_TO_DATE_ASSIGNED" IS NOT NULL OCL_YEAR_TO_DATE_ASSIGNED_NN
"YEAR_TO_DATE_CLEARED" IS NOT NULL OCL_YEAR_TO_DATE_CLEARED_NN
"YEAR_TO_DATE_PENDING" IS NOT NULL OCL_YEAR_TO_DATE_PENDING_NN

Indexes:
Column(s) Type Sort Constraint Name
OFF1_OFFICER_ID Primary key Asc OCL_PK

Close relationships  within of separation: