!!!Alias:LCM
Unique Keys: [DEN_ID] (ENTITY_CODE) + [COMPLAINT_CODE] \\
Child Table: [P2K_LR_COMPLAINT_PARTICIPANTS]\\
\\
 
This table contains [date sensitive] information pertinent to the definition of a unit and other descriptive text
 
!!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)|[(Lexicon)]|Y| 
| [COMPLAINT_STAGE]      |Varchar2(2)|[(Lexicon)]| | 
| [COMPLAINT_SEVERITY]   |Varchar2(2)|[(Lexicon)]| | 
| [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)|[(Lexicon)|Lexicon]| | 
| [SETTLEMENT_AMOUNT]    |Number(18)|[AMT12V6|AMTnn]| | 
| [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\\