P 2 K_SH_INCIDENTS
Back to current versionRestore this version

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 nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DEN_IDNumber(10)IDYLink to P2K_CM_UNITS
DSP_IDNumber(10)IDYLink to P2K_CM_UNITS
DLN_IDNumber(10)ID Link to P2K_CM_UNITS
ECT_IDNumber(10)ID Link to P2K_CM_UNITS
ECT_ID_INVESTIGATED_BYNumber(10)ID Link to P2K_CM_UNITS
INCIDENT_CODEVarchar2(16)CODEY
DATE_OF_INCIDENTDate()DATEY
TIME_OF_INCIDENTNumber(5)MINUTESY
INCIDENT_STATUSVarchar2(2)(Lexicon)
INCIDENT_TYPEVarchar2(2)(Lexicon)
INCIDENT_CATEGORYVarchar2(2)(Lexicon)
INCIDENT_REASONVarchar2(2)(Lexicon)
INCIDENT_TEXTVarchar2(4000)VARCHAR4000
DATE_REPORTEDDate()DATE
TIME_REPORTEDNumber(5)MINUTES
HOW_REPORTEDVarchar2(2)(Lexicon)
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 Link to P2K_CM_UNITS
EID_IDNumber(10)ID Link to P2K_CM_UNITS
EID_ID_INVESTIGATED_BYNumber(10)ID Link to P2K_CM_UNITS

User Fields: Allowed
Audit Logging: Allowed

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