Table slot9.WORLD.TSTA.DS_ICR_ORI_GTT
ORI Segment Staging Table. Stores transformed ORI and AGENCY_CODES details into its Final (or close to) NIBRS (or given EXTERNAL_SYSTEM_CODES.CODE) Format.
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
DATASETID number 0
DS_ICR_DATA_SETS.DATASETID Implied Constraint R
SEGMENT_LENGTH varchar2 2000  √  null
SEGMENT_LEVEL varchar2 2000  √  null
ACTION varchar2 2000  √  null
MONTH date 7  √  null
ORIGYEAR date 7  √  null
ORINUMBER varchar2 2000  √  null
ORINAME varchar2 2000  √  null
AGENCYADDRESS1 varchar2 2000  √  null
AGENCYADDRESS2 varchar2 2000  √  null
AGENCYCITY varchar2 2000  √  null
AGENCYSTATE varchar2 2000  √  null
AGENCYZIP varchar2 2000  √  null
CHIEFADMINISTRATOR varchar2 2000  √  null
AGENCYPHONENUMBER varchar2 2000  √  null
AGENCYRECORDSCLERK varchar2 2000  √  null
NUMOFFTMALEOFFICERS varchar2 2000  √  null
NUMOFFTFEMALEOFFICERS varchar2 2000  √  null
NUMOFFTMALECIVILIANS varchar2 2000  √  null
NUMOFFTFEMALECIVILIANS varchar2 2000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DATASETID" IS NOT NULL DSICRORIGTT_DATASETID_NN


Close relationships: