!!!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(Disambiguation)]|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 indiate 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'}]