P 2 K_SH_INCIDENTS
Back to current versionRestore this version

Alias:HIN#

Unique Keys: DEN_ID (Entity) + INCIDENT_CODE

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

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DEN_IDNumber(10)IDYBelongs to P2K_CM_ENTITIES
DSP_IDNumber(10)IDYOccurred in P2K_CM_STATE_PROVINCES
DLN_IDNumber(10)ID Occurred in P2K_CM_LOCATIONS
ECT_IDNumber(10)ID[ARC1]Reported by P2K_HR_CONTACTS
ECT_ID_INVESTIGATED_BYNumber(10)ID[ARC2]Investigated byP2K_HR_CONTACTS
INCIDENT_CODEVarchar2(16)CODEY
DATE_OF_INCIDENTDate()DATEY
TIME_OF_INCIDENTNumber(5)MINUTESY
INCIDENT_STATUSVarchar2(2)X_INCIDENT_STATUS
INCIDENT_TYPEVarchar2(2)X_INCIDENT_TYPE
INCIDENT_CATEGORYVarchar2(2)X_INCIDENT_CATEGORY
INCIDENT_REASONVarchar2(2)X_INCIDENT_REASON
INCIDENT_TEXTVarchar2(4000)VARCHAR4000
DATE_REPORTEDDate()DATE
TIME_REPORTEDNumber(5)MINUTES
HOW_REPORTEDVarchar2(2)X_HOW_REPORTED
NOTIFICATION_LISTVarchar2(4000)VARCHAR4000
ENVIRONMENTAL_FACTORSVarchar2(4000)VARCHAR4000
INCIDENT_CAUSED_BYVarchar2(4000)VARCHAR4000
ON_EMPLOYER_SITEVarchar2(1)TOGGLE
ON_STATE_PROPERTYVarchar2(1)TOGGLE
ENTIRE_DEPT_AFFECTEDVarchar2(1)TOGGLE
VEHICLE_INVOLVEDVarchar2(1)TOGGLE
EQUIPMENT_INVOLVEDVarchar2(1)TOGGLE
ANONYMOUSVarchar2(1)TOGGLE
PLACE_OF_INCIDENTVarchar2(50)DESCRIPTION
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
ZIP_POSTALVarchar2(16)POSTAL CODE
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESSVarchar2(50)EMAIL
DATE_INVESTIGATEDDate()DATE
INVESTIGATION_RESULTVarchar2(4000)VARCHAR4000I
AVOIDABLEVarchar2(1)TOGGLE
DATE_CLOSEDDate()DATE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
EEM_IDNumber(10)ID Caused by P2K_HR_EMPLOYMENTS
EID_IDNumber(10)ID[ARC1]Reported by P2K_HR_IDENTITIES
EID_ID_INVESTIGATED_BYNumber(10)ID[ARC2]Investigated by P2K_HR_IDENTITIES

User Fields: Allowed
Audit Logging: Allowed

[ARC1]Can only select one of EID_ID or ECT_ID to indicate who reported the incident.
[ARC1]Can only select one of EID_ID_INVESTIGATED_BY or ECT_ID_INVESTIGATED_BY to indicate who investigated the incident.

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation