Table slot9.WORLD.TSTA.NIBRS_CODES
This table defines the valid NIBRS Codes
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
NIBRS_CODE varchar2 30
ARREST_REQQUES_VW.NIBRS_CODE Implied Constraint R
BI_OFFENSE_VW.NIBRS_CODE Implied Constraint R
INC_OFF_CRIME_TARGETS_VW.NIBRS_CODE Implied Constraint R
INC_REVIEW_ROUTE_NIBRS.NIBRS_CODE INCRVWRTNBR_NIBRS_CD_FK R
INCIDENT_CRIME_TARGET_VW.NIBRS_CODE Implied Constraint R
INCIDENT_OFF_CRIME_TARGETS_VW.NIBRS_CODE Implied Constraint R
JS_BAIR_MO_FIELDS_VW.NIBRS_CODE Implied Constraint R
JS_DOMESTIC_VIOLENCE_VW.NIBRS_CODE Implied Constraint R
JS_INCIDENT_OFFENSE_RANK_VW.NIBRS_CODE Implied Constraint R
JS_INCIDENT_OFFENSE_VW.NIBRS_CODE Implied Constraint R
NIBRS_CODE_EJS_MAPPINGS.NIBRS_CODE NIBRS_CD_EJS_MAP_NIBRS_CD_FK R
NIBRS_CRIME_TARGETS.NIBRS_CODE NCT_NIBRS_CD_FK C
NIBRS_DATE_RECOV_REQ_VW.NIBRS_CODE Implied Constraint R
NIBRS_EST_DRUG_QUANT_REQ_VW.NIBRS_CODE Implied Constraint R
NIBRS_LESSER_OFFENSES.LESSER_NIBRS_CODE NIBRSLESSOFF_LESS_NIBR_CD_FK R
NIBRS_LESSER_OFFENSES.NIBRS_CODE NIBRSLESSOFF_NIBRS_CD_FK R
NIBRS_OFFENSES.NIBRS_CODE NIBRS_OFFNS_NIBRS_CD_FK R
NIBRS_PROP_LOSS_VW.NIBRS_CODE Implied Constraint R
NIBRS_PROP_MAPPINGS.NIBRS_CODE NIBRSPROP_MAP_NIBRS_CD_FK R
NIBRS_PROP_VALUE_REQ_VW.NIBRS_CODE Implied Constraint R
OFFENDER_REQQUES_VW.NIBRS_CODE Implied Constraint R
OFFENSE_COND_QANSCHOICES_VW.NIBRS_CODE Implied Constraint R
OFFENSE_CONDITIONAL_QUES_VW.NIBRS_CODE Implied Constraint R
OFFENSE_REQQUES_VW.NIBRS_CODE Implied Constraint R
PROPERTY_REQQUES_VW.NIBRS_CODE Implied Constraint R
VICTIM_INJURY_CODES_VW.NIBRS_CODE Implied Constraint R
VICTIM_RELATION_CODES_VW.NIBRS_CODE Implied Constraint R
VICTIM_REQQUES_VW.NIBRS_CODE Implied Constraint R
VICTIM_TYPE_CODES_VW.NIBRS_CODE Implied Constraint R
ZZ_EJS_CODE_NIBRS_MAPPINGS.NIBRS_CODE Implied Constraint R
ZZ_NIBRS_CODE_EJS_MAPPINGS.NIBRS_CODE Implied Constraint R
ZZ_NIBRS_CRIME_TARGETS.NIBRS_CODE Implied Constraint R
ZZ_NIBRS_LESSER_OFFENSES.NIBRS_CODE Implied Constraint R
ZZ_NIBRS_OFFENSES.NIBRS_CODE Implied Constraint R
ZZ_NIBRS_PROP_MAPPINGS.NIBRS_CODE Implied Constraint R
ZZC1_EJS_CODE_NIBRS_MAPPINGS.NIBRS_CODE Implied Constraint R
ZZC1_NIBRS_CODE_EJS_MAPPINGS.NIBRS_CODE Implied Constraint R
ZZC1_NIBRS_CRIME_TARGETS.NIBRS_CODE Implied Constraint R
ZZC1_NIBRS_LESSER_OFFENSES.NIBRS_CODE Implied Constraint R
ZZC1_NIBRS_OFFENSES.NIBRS_CODE Implied Constraint R
ZZC1_NIBRS_PROP_MAPPINGS.NIBRS_CODE Implied Constraint R
ZZV1_EJS_CODE_NIBRS_MAPPINGS.NIBRS_CODE Implied Constraint R
ZZV1_NIBRS_CODE_EJS_MAPPINGS.NIBRS_CODE Implied Constraint R
ZZV1_NIBRS_CRIME_TARGETS.NIBRS_CODE Implied Constraint R
ZZV1_NIBRS_LESSER_OFFENSES.NIBRS_CODE Implied Constraint R
ZZV1_NIBRS_OFFENSES.NIBRS_CODE Implied Constraint R
ZZV1_NIBRS_PROP_MAPPINGS.NIBRS_CODE Implied Constraint R
NIBRS_DESC varchar2 255  √  null
OFFENSE_GROUP_CODE varchar2 30  √  null
EJS_CODES.CODE NIBRS_CD_OFFG_EJS_CODES_FK R
REC_ID number 0  √  null
OFFENSE_GROUP_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE NIBRS_CD_OFFG_EJS_CODES_FK R
LAYER_CODE varchar2 30  √  null
EJS_CODES.CODE NIBRS_CD_LC_EJS_CODES_FK R
LAYER_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE NIBRS_CD_LC_EJS_CODES_FK R
MAP_ICON_ID number 0  √  null
MAP_ICONS.ID NIBRS_CD_MAPIC_ID_FK R
DETAILED_DESCRIPTION varchar2 4000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"NIBRS_CODE" IS NOT NULL NIBRS_CD_NIBRS_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
NIBRS_CODE Primary key Asc NIBRS_CD_PK
LAYER_CODE_TYPE + LAYER_CODE Performance Asc/Asc NIBRS_CD_LC_EJS_CODES_FK_I
MAP_ICON_ID Performance Asc NIBRS_CD_MAPIC_ID_FK_I
OFFENSE_GROUP_TYPE + OFFENSE_GROUP_CODE Performance Asc/Asc NIBRS_CD_OFFG_EJS_CODES_FK_I

Close relationships  within of separation: