| Table slot9.WORLD.TSTA.CALL_DISPOSITION_CODES This table defines the valid disposition codes for CALLS FOR SERVICE
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "AGENCY_CODE" IS NOT NULL | CALLDISPCD_AGENCY_CODE_NN |
| "CALL_DISPOSITION_CODE" IS NOT NULL | CALLDISPCD_CALL_DISP_CD_NN |
| "EVENT_TYPE_CODE" IS NOT NULL | CALLDISPCD_EVENT_TYPE_CD_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| CALL_DISPOSITION_CODE + EVENT_TYPE_CODE | Primary key | Asc/Asc | CALLDISPCD_PK |
| AGENCY_CODE | Performance | Asc | CALLDISPCD_AGNCY_CD_FK_I |
|