This is version 1 2 3 4 5 6 7 8 9 10 11 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

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]	Regarding P2K_HR_CONTACTS
ECT_ID_REPORTED_BY	Number(10)	ID	[ARC1]	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
DATE_REPORTED	Date()	DATE
TIME_REPORTED	Number(5)	MINUTES
HOW_REPORTED	Varchar2(2)	X_HOW_REPORTED
CAUSE_OF_HEALTH_ISSUE	Varchar2(4000)	VARCHAR4000
TASK_BEING_PERFORMED	Varchar2(4000)	VARCHAR4000
HAZARDOUS_CONDITIONS	Varchar2(4000)	VARCHAR4000
PROTECTIVE_APPAREL	Varchar2(4000)	VARCHAR4000
EQUIPMENT	Varchar2(4000)	VARCHAR4000
SUBSTANCE_INVOLVED	Varchar2(4000)	VARCHAR4000
EMPLOYEE_PREVENTION	Varchar2(4000)	VARCHAR4000
EMPLOYER_PREVENTION	Varchar2(4000)	VARCHAR4000
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
BODY_PART_LIST	Varchar2(4000)	VARCHAR4000
LEFT_SIDE_AFFECTED	Varchar2(1)	TOGGLE
RIGHT_SIDE_AFFECTED	Varchar2(1)	TOGGLE
PREVIOUS_INJURY	Varchar2(4000)	VARCHAR4000
DATE_LAST_EXPOSED	Date()	DATE
DATE_DISABLED	Date()	DATE
DATE_OF_DEATH	Date()	DATE
TIME_OF_DEATH	Number(5)	NUMBER5
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
DAYS_AWAY_FROM_WORK	Number(9)	AMT5V4
DAYS_RESTRICTED_WORK	Number(9)	AMT5V4
ESTIMATED_FUTURE_DAYS_LOST	Number(9)	AMT5V4
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	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
PRIVACY_CASE	Varchar2(1)	TOGGLE
ECT_ID_REGARDING	Number(10)	ID	[ARC2]	Regarding P2K_HR_CONTACTS
EID_ID_REPORTED_BY	Number(10)	ID	[ARC1]	Reported by P2K_HR_IDENTITIES

User Fields: Allowed
Audit Logging: Allowed

Notes

[ARC1] May only select one of EID_ID_REPORTED_BY or ECT_ID_REPORTED_BY to indicate who reported the issue

[ARC2] May only select one of ECT_ID_REGARDING or EAS_ID to indiate who this health issue is about