!!!Alias:HHI
Unique Keys: [DEN_ID] (Entity) + [CASE_NUMBER]\\
Child Table: [P2K_SH_TIME_LOST_DETAILS], [P2K_SH_HEALTH_CLAIMS], [P2K_SH_MEDICAL_EXAMS]\\
\\
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|Owned by [P2K_CM_ENTITIES]
|[EAS_ID]|Number(10)|[ID]| |Link to [P2K_HR_ASSIGNMENTS]
|[DDP_ID]|Number(10)|[ID]| |Occurred in [P2K_CM_DEPARTMENTS]
|[DJB_ID]|Number(10)|[ID]| |Occurred in [P2K_CM_JOBS]
|[HIN_ID]|Number(10)|[ID]| |Result of [P2K_SH_INCIDENTS]
|[ECT_ID]|Number(10)|[ID]|[ARC2|2]|Regarding  [P2K_HR_CONTACTS]
|[ECT_ID_REPORTED_BY]|Number(10)|[ID]|[ARC1|1]|Reported by [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)|[X_HEALTH_ISSUE_TYPE]| |
|[HEALTH_ISSUE_REASON]|Varchar2(2)|[X_HEALTH_ISSUE_REASON]| |
|[HEALTH_ISSUE_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[DATE_REPORTED]|Date()|[DATE]| |
|[TIME_REPORTED]|Number(5)|[MINUTES]| |
|[HOW_REPORTED]|Varchar2(2)|[X_HOW_REPORTED]| |
|[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(Field)]|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)|[X_INJURY_CLASS]| |
|[ILLNESS_CLASS]|Varchar2(2)|[X_ILLNESS_CLASS]| |
|[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]| |
|[LOST_TIME_CLASS]|Varchar2(2)|[X_LOST_TIME_CLASS]| |
|[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]| |
|[ECT_ID_REGARDING]|Number(10)|[ID]|[ARC2|2]|Regarding [P2K_HR_CONTACTS]
|[EID_ID_REPORTED_BY]|Number(10)|[ID]|[ARC1|1]|Reported by [P2K_HR_IDENTITIES]


!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_INJURED_EMPLOYEE_CONTACT]

User Fields: Allowed\\
Audit Logging: Allowed\\
;Notes:
;:[ARC1|#1] May only select one of EID_ID_REPORTED_BY or ECT_ID_REPORTED_BY to indicate who reported the issue
;:[ARC2|#2] May only select one of ECT_ID_REGARDING or EAS_ID to indicate who this health issue is about


----
![Notes|Edit:Internal.P2K_SH_HEALTH_ISSUES] 	
[{InsertPage page='Internal.P2K_SH_HEALTH_ISSUES' default='Click to create a new notes page'}]