Table slot9.WORLD.TSTA.NIBRS_CODE_EJS_MAPPINGS
This table stores the acceptable values for drop down lists when completing an INCIDENT. For example, the NIBRS Code of 200 can only have specific Bias Codes available. When completing an INCIDENT report the application will query this table and only present values that are valid for the defined offense. If only one value can be reported the value will be defaulted and the user will not be required to select the value
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
CODE_TYPE varchar2 30
EJS_CODE_NIBRS_MAPPINGS.CODE_TYPE EJS_CD_NIBRS_MAP_ENCM_FK R
EJS_CODES.CODE_TYPE NIBRS_CD_EJS_MAP_EJS_CD_FK R
EJS Codes Code Type- code table
CODE varchar2 30
EJS_CODE_NIBRS_MAPPINGS.CODE EJS_CD_NIBRS_MAP_ENCM_FK R
EJS_CODES.CODE NIBRS_CD_EJS_MAP_EJS_CD_FK R
EJS Codes Code - code value
NIBRS_CODE varchar2 30
EJS_CODE_NIBRS_MAPPINGS.NIBRS_CODE EJS_CD_NIBRS_MAP_ENCM_FK R
NIBRS_CODES.NIBRS_CODE NIBRS_CD_EJS_MAP_NIBRS_CD_FK R
NIBRS Code - code value
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
CREATOR_ID varchar2 100  √  null Person creating the record
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CODE_TYPE" IS NOT NULL NIBRS_CD_EJS_MAP_CD_TYP_NN
"CODE" IS NOT NULL NIBRS_CD_EJS_MAP_CODE_NN
"NIBRS_CODE" IS NOT NULL NIBRS_CD_EJS_MAP_NIBRS_CD_NN

Indexes:
Column(s) Type Sort Constraint Name
CODE_TYPE + CODE + NIBRS_CODE Primary key Asc/Asc/Asc NIBRS_CD_EJS_MAP_PK
CODE_TYPE + CODE Performance Asc/Asc NIBRS_CD_EJS_MAP_EJS_CD_FK_I
NIBRS_CODE Performance Asc NIBRS_CD_EJS_MAP_NIBRS_CD_FK_I

Close relationships  within of separation: