!!!Alias:HCS
Unique Keys: \\
Child Table: \\
Parent Table: [P2K_HR_HEALTH_ISSUES]\\
\\
This table contains cost information pertinent to a logged health issue.

!!Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[COST_TYPE]|Varchar2(2)|[(Lexicon)]|Y|
|[REFERENCE_ID]|Number(10)|[NUMBER10]|Y|
|[COST_DATE]|Date()|[DATE]|Y|
|[COST_CATEGORY]|Varchar2(2)|[(Lexicon)]|Y|
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[COST_REFERENCE]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[COST_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[CURRENCY]|Varchar2(2)|[(Lexicon)]| |
|[EMPLOYER_PERCENT]|Number(5)|[PERCENT]| |
|[PAYMENT_STATUS]|Varchar2(2)|[(Lexicon)]| |
|[PAYMENT_METHOD]|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|

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