!!!Alias:HHC
Unique Keys: \\
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|Link to [P2K_SH_INCIDENTS] 
|[ECT_ID]|Number(10)|[ID]| |Link to [P2K_HR_CONTACTS]
|[ECT_ID_THE_TPA]|Number(10)|[ID]| |Link to [P2K_HR_CONTACTS]
|[ECT_ID_INSURED_BY]|Number(10)|[ID]| |Link to [P2K_HR_CONTACTS]
|[CLAIM_STATUS]|Varchar2(2)|[(Lexicon)]|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)|[(Lexicon)]| |
|[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]| |Link to [P2K_HR_IDENTITIES]


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