!!!Alias:HHI
Unique Keys: \\
Child Table: \\
Parent Table;\\
\\
This table contains logged health issues related to an employee.
 
!!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]
|[EAS_ID]|Number(10)|[ID]| |Link to [P2K_HR_ASSIGNMENTS]
|[DDP_ID]|Number(10)|[ID]| |Link to [P2K_CM_DEPARTMENTS]
|[DJB_ID]|Number(10)|[ID]| |Link to [P2K_CM_JOBS]
|[HIN_ID]|Number(10)|[ID]| |Link to [P2K_SH_INCIDENTS]
|[ECT_ID]|Number(10)|[ID]| |Link to [P2K_HR_CONTACTS]
|[ECT_ID_REPORTED_BY]|Number(10)|[ID]| |Link to [P2K_HR_CONTACTS]
|[CASE_NUMBER]|Varchar2(16)|[CODE]|Y| 
|[DATE_OF_INCIDENT]|Date()|[DATE]|Y| 
|[TIME_OF_INCIDENT]|Number(5)|[MINUTES]|Y| 
|[TIME_STARTED_WORK]|Number(5)|[MINUTES]| |
|[TIME_LEFT_WORK]|Number(5)|[MINUTES]| |
|[HEALTH_ISSUE_TYPE]|Varchar2(2)|[(Lexicon)]| |
|[HEALTH_ISSUE_REASON]|Varchar2(2)|[(Lexicon)]| |
|[HEALTH_ISSUE_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[DATE_REPORTED]|Date()|[DATE]| |
|[TIME_REPORTED]|Number(5)|[MINUTES]| |
|[HOW_REPORTED]|Varchar2(2)|[(Lexicon)]| |
|[CAUSE_OF_HEALTH_ISSUE]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[TASK_BEING_PERFORMED]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[HAZARDOUS_CONDITIONS]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[PROTECTIVE_APPAREL]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[EQUIPMENT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[SUBSTANCE_INVOLVED]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[EMPLOYEE_PREVENTION]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[EMPLOYER_PREVENTION]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[CONDUCTING_BUSINESS]|Varchar2(1)|[TOGGLE]| |
|[REGULAR_DUTIES]|Varchar2(1)|[TOGGLE]| |
|[SAFEGUARDS_IN_PLACE]|Varchar2(1)|[TOGGLE]| |
|[SAFEGUARDS_USED]|Varchar2(1)|[TOGGLE]| |
|[RULES_OBEYED]|Varchar2(1)|[TOGGLE]| |
|[MACHINE_FAILURE]|Varchar2(1)|[TOGGLE]| |
|[SUBSTANCE_ABUSE]|Varchar2(1)|[TOGGLE]| |
|[ANONYMOUS]|Varchar2(1)|[TOGGLE]| |
|[DEVELOPED_OVER_TIME]|Varchar2(1)|[TOGGLE]| |
|[CUMULATIVE_INURY]|Varchar2(1)|[TOGGLE]| |
|[INJURY_CLASS]|Varchar2(2)|[(Lexicon)]| |
|[ILLNESS_CLASS]|Varchar2(2)|[(Lexicon)]| |
|[INJURY_LIST]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[BODY_PART_LIST]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[LEFT_SIDE_AFFECTED]|Varchar2(1)|[TOGGLE]| |
|[RIGHT_SIDE_AFFECTED]|Varchar2(1)|[TOGGLE]| |
|[PREVIOUS_INJURY]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[DATE_LAST_EXPOSED]|Date()|[DATE]| |
|[DATE_DISABLED]|Date()|[DATE]| |
|[DATE_OF_DEATH]|Date()|[DATE]| |
|[TIME_OF_DEATH]|Number(5)|[NUMBER5|NUMBERn]| |
|[WIDOW_SURVIVING]|Varchar2(1)|[TOGGLE]| |
|[AUTOPSY_PERFORMED]|Varchar2(1)|[TOGGLE]|A |
|[LOST_TIME_CLASS]|Varchar2(2)|[(Lexicon)]| |
|[RETURN_TO_WORK_PLAN]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[DAYS_AWAY_FROM_WORK]|Number(9)|[AMT5V4|AMTnn]| |
|[DAYS_RESTRICTED_WORK]|Number(9)|[AMT5V4|AMTnn]| |
|[ESTIMATED_FUTURE_DAYS_LOST]|Number(9)|[AMT5V4|AMTnn]| |
|[START_OF_LOST_TIME]|Date()|[DATE]| |
|[RETURNED_TO_PARTIAL_DUTIES]|Date()|[DATE]| |
|[RETURNED_TO_FULL_DUTIES]|Date()|[DATE]| |
|[STOPPED_WORK_IMMEDIATELY]|Varchar2(1)|[TOGGLE]| |
|[WORKED_NEXT_DAY]|Varchar2(1)|[TOGGLE]| |
|[PAID_FOR_DAY_OF_INCIDENT]|Varchar2(1)|[TOGGLE]| |
|[PAY_CONTINUING]|Varchar2(1)|[TOGGLE]| |
|[WILL_MODIFY_DUTIES]|Varchar2(1)|[TOGGLE]| |
|[OVERTIME_PAID]|Varchar2(1)|[TOGGLE]| |
|[CREATE_DATE]|Date()|[DATE]|Y| 
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| 
|[CHANGE_DATE]|Date()|[DATE]|Y| 
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| 
|[PRIVACY_CASE]|Varchar2(1)|[TOGGLE]|P |
|[ECT_ID_REGARDING]|Number(10)|[ID]| |Link to [P2K_HR_CONTACTS]
|[EID_ID_REPORTED_BY]|Number(10)|[ID]| |Link to [P2K_HR_IDENTITIES]

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