Table slot9.WORLD.TSTA.DS_ICR_OFFENDERS_GTT
This table stores Offenders Segment Staging transformation from DS_ICR_OFFENDERS 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
HEADERID number 0
DS_ICR_HEADERS.HEADERID Implied Constraint R
UNIQUE_KEY varchar2 255
REC_NUM varchar2 255
SEGMENT_LENGTH varchar2 2000  √  null
SEGMENT_LEVEL varchar2 2000  √  null
ACTION varchar2 2000  √  null
MONTH date 7  √  null
ORIGYEAR date 7  √  null
CITYINDICATOR varchar2 2000  √  null
ORIGORI varchar2 2000  √  null
INCIDENTNO varchar2 2000  √  null
OFFPERSNO varchar2 2000  √  null
OFFNO varchar2 2000  √  null
OFFAGE varchar2 2000  √  null
OFFSEX varchar2 2000  √  null
OFFRACE varchar2 2000  √  null
OFFETHNICITY varchar2 2000  √  null
INC_PER_ID number 0  √  null
INCIDENT_PEOPLE.INC_PER_ID Implied Constraint R
INCIDENT_PEOPLE.INC_PER_ID - PK back to Original Incident Person
ENTITYIDNUMBER number 0  √  null Entity Identification Number - Unique to each Victim, Offender, Arrestee and GroupB in the Incident
OFFRESSTAT varchar2 2000  √  null
LOCATION_HOUSE_NUMBER varchar2 2000  √  null Location House Number
LOCATION_STRUCTURE_NUMBER varchar2 2000  √  null Location Structure Number
LOCATION_PRIMARY_ST_DIR varchar2 2000  √  null Location Primary Street Directional
LOCATION_STREET_NAME varchar2 2000  √  null Location Street Name
LOCATION_STREET_TYPE varchar2 2000  √  null Location Street Type
LOCATION_SECONDARY_ST_DIR varchar2 2000  √  null Location Secondary Street Directional
LOCATION_OCCUPANCY_CODE varchar2 2000  √  null Location Occupancy Code
LOCATION_OCCUPANCY_NUMBER varchar2 2000  √  null Location Occupancy Number
LOCATION_CITY_NAME varchar2 2000  √  null Location City Name
LOCATION_STATE varchar2 2000  √  null Location State
LOCATION_POSTAL_CODE varchar2 2000  √  null Location Postal Code
OFFLNAME varchar2 2000  √  null Last Name of offender based on inc_per_id
OFFFNAME varchar2 2000  √  null First Name of offender based on inc_per_id
OFFMNAME varchar2 2000  √  null Middle Name of offender based on inc_per_id

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DATASETID" IS NOT NULL DDICROFNDGTT_DATESETID_NN
"HEADERID" IS NOT NULL DDICROFNDGTT_HEADERID_NN
"REC_NUM" IS NOT NULL DDICROFNDGTT_RECNUM_NN
"UNIQUE_KEY" IS NOT NULL DDICROFNDGTT_UNIQUE_KEY_NN


Close relationships: