Wiki: P 2 K_SH_INCIDENTS

Alias:HIN#

Unique Keys:
Child Table:
Parent Table:

This table contains descriptive and process information for each logged safety and health incident.

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
DSP_ID	Number(10)	ID	Y	Link to P2K_CM_UNITS
DLN_ID	Number(10)	ID		Link to P2K_CM_UNITS
ECT_ID	Number(10)	ID		Link to P2K_CM_UNITS
ECT_ID_INVESTIGATED_BY	Number(10)	ID		Link to P2K_CM_UNITS
INCIDENT_CODE	Varchar2(16)	CODE	Y
DATE_OF_INCIDENT	Date()	DATE	Y
TIME_OF_INCIDENT	Number(5)	MINUTES	Y
INCIDENT_STATUS	Varchar2(2)	(Lexicon)
INCIDENT_TYPE	Varchar2(2)	(Lexicon)
INCIDENT_CATEGORY	Varchar2(2)	(Lexicon)
INCIDENT_REASON	Varchar2(2)	(Lexicon)
INCIDENT_TEXT	Varchar2(4000)	VARCHAR4000
DATE_REPORTED	Date()	DATE
TIME_REPORTED	Number(5)	MINUTES
HOW_REPORTED	Varchar2(2)	(Lexicon)
NOTIFICATION_LIST	Varchar2(4000)	VARCHAR4000
ENVIRONMENTAL_FACTORS	Varchar2(4000)	VARCHAR4000
INCIDENT_CAUSED_BY	Varchar2(4000)	VARCHAR4000
ON_EMPLOYER_SITE	Varchar2(1)	TOGGLE
ON_STATE_PROPERTY	Varchar2(1)	TOGGLE
ENTIRE_DEPT_AFFECTED	Varchar2(1)	TOGGLE
VEHICLE_INVOLVED	Varchar2(1)	TOGGLE
EQUIPMENT_INVOLVED	Varchar2(1)	TOGGLE
ANONYMOUS	Varchar2(1)	TOGGLE
PLACE_OF_INCIDENT	Varchar2(50)	DESCRIPTION
ADDRESS_LINE_1	Varchar2(50)	ADDRESS
ADDRESS_LINE_2	Varchar2(50)	ADDRESS
LOCALITY	Varchar2(50)	ADDRESS
ZIP_POSTAL	Varchar2(16)	POSTAL CODE
PHONE_NUMBER	Varchar2(20)	TELEPHONE
PHONE_EXTENSION	Varchar2(16)	VARCHAR16
FAX_NUMBER	Varchar2(20)	TELEPHONE
EMAIL_ADDRESS	Varchar2(50)	EMAIL
DATE_INVESTIGATED	Date()	DATE
INVESTIGATION_RESULT	Varchar2(4000)	VARCHAR4000	I
AVOIDABLE	Varchar2(1)	TOGGLE
DATE_CLOSED	Date()	DATE
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
EEM_ID	Number(10)	ID		Link to P2K_CM_UNITS
EID_ID	Number(10)	ID		Link to P2K_CM_UNITS
EID_ID_INVESTIGATED_BY	Number(10)	ID		Link to P2K_CM_UNITS

User Fields: Allowed
Audit Logging: Allowed