P 2 K_SH_HEALTH_CLAIMS
Back to current versionRestore this version

Alias:HHC#

Unique Keys: None
Parent Table: P2K_SH_HEALTH_ISSUES

This table contains health claims related to logged health issues

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
HHI_IDNumber(10)IDYResulting from P2K_SH_INCIDENTS
ECT_IDNumber(10)ID[ARC]Prepared by P2K_HR_CONTACTS
ECT_ID_THE_TPANumber(10)ID 3rd Party Administrator is P2K_HR_CONTACTS
ECT_ID_INSURED_BYNumber(10)ID Insured by P2K_HR_CONTACTS
CLAIM_STATUSVarchar2(2)X_CLAIM_STATUSY
DATE_PREPAREDDate()DATE
DATE_SUBMITTEDDate()DATE
CLAIM_REFERENCEVarchar2(50)DESCRIPTION
CLAIM_STATEMENTVarchar2(4000)VARCHAR4000
CLAIM_AMOUNTNumber(18)AMT12V6
GOVERNMENT_ACTVarchar2(2)X_GOVERNMENT_ACT
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
EID_IDNumber(10)ID[ARC]Prepared by P2K_HR_IDENTITIES

User Fields: Allowed
Audit Logging: Allowed

Notes
[ARC] May only select one of EID_ID or ECT_ID to indicate who prepared the claim (optional)