| Table slot9.WORLD.TSTA.ARRESTEE_DISPOSITION_CODES This table defines the valid disposition codes that can be assigned to an arrestee in the application
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "DISPOSITION_CODE" IS NOT NULL | ARR_DSP_CD_DISPOSITION_CODE_NN |
| "NDC_NIBRS_DISPOSITION_CODE" IS NOT NULL | ARR_DSP_CD_NDC_NIBRS_DISPOS_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| DISPOSITION_CODE | Primary key | Asc | ARR_DSP_CD_PK |
| NDC_NIBRS_DISPOSITION_CODE | Performance | Asc | ARR_DSP_CD_NDC_FK_I |
| NDC_NIBRS_DISPOSITION_COD_TYPE + NDC_NIBRS_DISPOSITION_CODE | Performance | Asc/Asc | ARR_DSP_CD_NDC_NIB_EJS_CODE_I |
|