| Table slot9.WORLD.TSTA.EJS_CODE_NIBRS_MAPPINGS This table defines valid values or conditions based on values selected or applicable to NIBRS_CODE_EJS_MAPPINGS (and is a child table to NIBRS_CODE_EJS_MAPPINGS). For example, a NIBRS Code of 200, a property loss of 8 - unknown, can only allow a value of 8 - unknown for a valid property status. If only one value is valid the application will default it for the user and not prompt them for entry.
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "CODE" IS NOT NULL | EJS_CD_NIBRS_MAP_CD_NN |
| "CODE_TYPE" IS NOT NULL | EJS_CD_NIBRS_MAP_CD_TYP_NN |
| "EC_CODE" IS NOT NULL | EJS_CD_NIBRS_MAP_ECC_NN |
| "EC_CODE_TYPE" IS NOT NULL | EJS_CD_NIBRS_MAP_ECCT_NN |
| "NIBRS_CODE" IS NOT NULL | EJS_CD_NIBRS_MAP_NIBRSCD_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| CODE_TYPE + CODE + NIBRS_CODE + EC_CODE_TYPE + EC_CODE | Primary key | Asc/Asc/Asc/Asc/Asc | EJS_CD_NIBRS_MAP_PK |
| EC_CODE_TYPE + EC_CODE | Performance | Asc/Asc | EJS_CD_NIBRS_MAP_EJS_CD_FK_I |
| CODE_TYPE + CODE + NIBRS_CODE | Performance | Asc/Asc/Asc | EJS_CD_NIBRS_MAP_ENCM_FK_I |
| NIBRS_CODE | Performance | Asc | EJS_CD_NIBRS_MAP_NIBRS_CD_I |
|