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:
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_UNITS
EAS_ID	Number(10)	ID		Link to P2K_CM_UNITS
DDP_ID	Number(10)	ID		Link to P2K_CM_UNITS
DJB_ID	Number(10)	ID		Link to P2K_CM_UNITS
HIN_ID	Number(10)	ID		Link to P2K_CM_UNITS
ECT_ID	Number(10)	ID		Link to P2K_CM_UNITS
ECT_ID_REPORTED_BY	Number(10)	ID		Link to P2K_CM_UNITS
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
DATE_REPORTED	Date()	DATE
TIME_REPORTED	Number(5)	MINUTES
HOW_REPORTED	Varchar2(2)	(Lexicon)
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)	(Lexicon)
ILLNESS_CLASS	Varchar2(2)	(Lexicon)
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	A
LOST_TIME_CLASS	Varchar2(2)	(Lexicon)
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	P
ECT_ID_REGARDING	Number(10)	ID		Link to P2K_CM_UNITS
EID_ID_REPORTED_BY	Number(10)	ID		Link to P2K_CM_UNITS

User Fields: Allowed
Audit Logging: Allowed