!!!Alias:LCM
Description: Complaints
 
!! Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
| [ID]                   |Number(10)|[ID]|Y| 
| [DEN_ID]|Number(10)|[ID]|Y|Link to [P2K_CM_ENTITIES] 
| [DDP_ID]|Number(10)|[ID]| |Link to [P2K_CM_DEPARTMENTS]
| [DLN_ID]|Number(10)|[ID]| |Link to [P2K_CM_LOCATIONS]
| [LDI_ID]|Number(10)|[ID]| |Link to [P2K_LR_DISCIPLINARY_ISSUES]
| [LGV_ID]|Number(10)|[ID]| |Link to [P2K_LR_GRIEVANCES]
| [EID_ID]               |Number(10)|[ID]| |Link to [P2K_HR_IDENTITIES]
| [LDT_ID]               |Number(10)|[ID]| |Link to [P2K_LR_DISPUTE_TYPES]
| [DUN_ID]               |Number(10)|[ID]| |Link to [P2K_CM_UNITS]
| [COMPLAINT_CODE]       |Varchar2(16)|[CODE]|Y| 
| [COMPLAINT_ISSUED_DATE]|Date()|[DATE]|Y| 
| [COMPLAINT_STATUS]     |Varchar2(2)|[X_COMPLAINT_STATUS]|Y| 
| [COMPLAINT_STAGEs]      |Varchar2(2)|[X_COMPLAINT_STAGE]| | 
| [COMPLAINT_SEVERITY]   |Varchar2(2)|[X_DISPUTE_SEVERITY]| | 
| [DATE_OF_INCIDENT]     |Date()|[DATE]| |  
| [INCIDENT_WITNESSES]   |Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | 
| [DESCRIPTION]          |Varchar2(50)|[DESCRIPTION]| | 
| [COMPLAINT_TEXT]       |Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | 
| [CONTRACT_REFERENCE]   |Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | 
| [UNION_REFERENCE]      |Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | 
| [COMPLAINT_CLOSED_DATE]|Date()|[DATE]| | 
| [COMPLAINT_DECISION]   |Varchar2(2)|[X_COMPLAINT_DECISION]| | 
| [SETTLEMENT_AMOUNT]    |Number(18)|[AMT12V6]| | 
| [CREATE_DATE]          |Date()|[DATE]|Y| 
| [CREATE_USER]          |Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| 
| [CHANGE_DATE]          |Date()|[DATE]|Y|  
| [CHANGE_USER]          |Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| 

User Fields: Allowed
Audit Logging: Allowed