Alias: HLSR#

Unique Keys:
Child Table:
Parent Table:

This table contains date sensitive information @@@

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
HSP_IDNumber(10)IDYLink to P2K_CM_UNITS
DLN_IDNumber(10)IDYLink to P2K_CM_UNITS
POLICY_START_DATEDate()DATE
POLICY_END_DATEDate()DATE
LOCATION_SAFETY_POLICYVarchar2(4000)VARCHAR4000
LOCATION_MEDICAL_POLICYVarchar2(4000)VARCHAR4000
NEAREST_TREATMENTVarchar2(4000)VARCHAR4000
TRANSPORTATION_AVAILABLEVarchar2(4000)VARCHAR4000
SAFETY_PROGRAM_IN_PLACEVarchar2(1)TOGGLE
ACTIVE_SAFETY_COMMITTEEVarchar2(1)TOGGLE
PREVENTION_SERVICES_REQUESTEDVarchar2(1)TOGGLE
PREVENTION_SERVICES_USEDVarchar2(1)TOGGLE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

User Fields: Allowed
Audit Logging: Allowed