!!!Alias:HHC
Unique Keys: None\\
Parent Table: [P2K_SH_HEALTH_ISSUES]\\
\\
This table contains health claims related to logged health issues
 
!!Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y| 
|[HHI_ID]|Number(10)|[ID]|Y|Resulting from [P2K_SH_INCIDENTS] 
|[ECT_ID]|Number(10)|[ID]|[ARC|1]|Prepared by [P2K_HR_CONTACTS]
|[ECT_ID_THE_TPA]|Number(10)|[ID]| |3rd Party Administrator is [P2K_HR_CONTACTS]
|[ECT_ID_INSURED_BY]|Number(10)|[ID]| |Insured by [P2K_HR_CONTACTS]
|[CLAIM_STATUS]|Varchar2(2)|[X_CLAIM_STATUS]|Y| 
|[DATE_PREPARED]|Date()|[DATE]| |
|[DATE_SUBMITTED]|Date()|[DATE]| |
|[CLAIM_REFERENCE]|Varchar2(50)|[DESCRIPTION]| |
|[CLAIM_STATEMENT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[CLAIM_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[GOVERNMENT_ACT]|Varchar2(2)|[X_GOVERNMENT_ACT]| |
|[CREATE_DATE]|Date()|[DATE]|Y| 
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| 
|[CHANGE_DATE]|Date()|[DATE]|Y| 
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| 
|[EID_ID]|Number(10)|[ID]|[ARC|1]|Prepared by [P2K_HR_IDENTITIES]


User Fields: Allowed\\
Audit Logging: Allowed\\
;Notes
;:[ARC|#1] May only select one of EID_ID or ECT_ID to indicate who prepared the claim (optional)