!!!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_STAGE] |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