Table slot9.WORLD.TSTA.NIBRS_TAB_COLS
This is a system table used by the application for dynamically presenting lists of values for a related NIBRS offense
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_DEST_ID number 38 NIBRS_DEST_ID sequence number-pk
DEST_TABLE_NAME varchar2 30 Destination Table Name
DEST_COLUMN_NAME varchar2 30 Destination Column Name
KEY_1 varchar2 30  √  null Primary Key for the target table
KEY_2 varchar2 30  √  null Primary Key for the target table
KEY_3 varchar2 30  √  null Primary Key for the target table
REQ_FLG varchar2 1 'Y' Used to flag if the EJS_CODE Data element is required
CODE varchar2 30  √  null
EJS_CODES.CODE NIBRTC_CODE_EJS_CODE_FK R
Defines the related ejs_code table lookup list
CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE NIBRTC_CODE_EJS_CODE_FK R
Defines the related ejs_code table lookup list
INC_SECTION_CODE varchar2 30  √  null
EJS_CODES.CODE NIBRTC_INCSECT_EJS_CODE_FK R
Defines the application section where the data elements are displayed.
INC_SECTION_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE NIBRTC_INCSECT_EJS_CODE_FK R
Defines the application section where the data elements are displayed.
MULTI_SELECT_FLG varchar2 1 'N' used to indicate if multiple CODES can be used during population
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null Date Record was created
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null Date Record was last updated
REC_ID number 0  √  null Sequence used to uniquely identify this record.
KEY_4 varchar2 30  √  null
DEST_COLUMN_CODE_TYPE varchar2 30  √  null
SUMMARY_LEVEL_SETTING varchar2 1 'N' Indicator to specify whether or not the column defined summarizes a set of codes, like cargo theft.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
SUMMARY_LEVEL_SETTING IN ( 'Y','N') CK_NIBRTC_SMRY_LVL_STNG
"DEST_COLUMN_NAME" IS NOT NULL NIBRTC_DEST_COLUMN_NAME_NN
"DEST_TABLE_NAME" IS NOT NULL NIBRTC_DEST_TABLE_NAME_NN
"MULTI_SELECT_FLG" IS NOT NULL NIBRTC_MULTI_SELECT_FLG_NN
"NIBRS_DEST_ID" IS NOT NULL NIBRTC_NIBRS_DEST_ID_NN
"REQ_FLG" IS NOT NULL NIBRTC_REQ_FLG_NN
"SUMMARY_LEVEL_SETTING" IS NOT NULL NIBRTC_SMRY_LVL_STNG_NN

Indexes:
Column(s) Type Sort Constraint Name
NIBRS_DEST_ID Primary key Asc NIBRTC_PK
CODE_TYPE + CODE Performance Asc/Asc NIBRTC_CODE_EJS_CODE_FK_I
INC_SECTION_CODE_TYPE + INC_SECTION_CODE Performance Asc/Asc NIBRTC_INCSECT_EJS_CODE_FK_I

Close relationships  within of separation: