!!!Alias:LCM
(P2K_LR_COMPLAINTS)

Unique Keys: [DEN_ID] (Entity) + [COMPLAINT_CODE] \\
Child Table: [P2K_LR_COMPLAINT_PARTICIPANTS]\\
ERD: [ERD-LR02]

\\
This table contains information about each complaint noted within the system.\\
 
!!Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
| [ID]                   |Number(10)|[ID]|Y| 
| [DEN_ID]|Number(10)|[ID]|Y|For [P2K_CM_ENTITIES] 
| [DDP_ID]|Number(10)|[ID]| |About [P2K_CM_DEPARTMENTS]
| [DLN_ID]|Number(10)|[ID]| |About [P2K_CM_LOCATIONS]
| [LDI_ID]|Number(10)|[ID]| |Results in [P2K_LR_DISCIPLINARY_ISSUES]
| [LGV_ID]|Number(10)|[ID]| |Elevated to[P2K_LR_GRIEVANCES]
| [EID_ID]|Number(10)|[ID]| |About [P2K_HR_IDENTITIES]
| [LDT_ID]|Number(10)|[ID]| |For [P2K_LR_DISPUTE_TYPES]
| [DUN_ID]|Number(10)|[ID]| |About [P2K_CM_UNITS]
| [COMPLAINT_CODE]       |Varchar2(16)|[CODE]|Y| 
| [COMPLAINT_ISSUED_DATE]|Date()|[DATE]|Y| 
| [COMPLAINT_STATUS]     |Varchar2(2)|[X_COMPLAINT_STATUS]|Y| 
| [COMPLAINT_STAGE]      |Varchar2(2)|[X_COMPLAINT_STAGE]| | 
| [COMPLAINT_SEVERITY]   |Varchar2(2)|[X_COMPLAINT_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|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| 


!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_PARTICIPANTS_LIST]


User Fields: Allowed\\
Audit Logging: Allowed\\
 


----
![Notes|Edit:Internal.P2K_LR_COMPLAINTS] 	
[{InsertPage page='Internal.P2K_LR_COMPLAINTS' default='Click to create a new notes page'}]