P 2 K_SH_LOCATION_SAFETY_RULES
Back to current versionRestore this version

Alias: HLSR#

Unique Keys: HSP_ID (Safety Policy) + DLN_ID (Location) + POLICY_START_DATE
Child Table: P2K_SH_SAFETY_EQUIPMENT, P2K_SH_SAFETY_ACTIVITIES, P2K_SH_SAFETY_MEMBERS, P2K_SH_SAFETY_REVIEWS
Parent Table: P2K_SH_SAFETY_POLICIES

This table associates a safety policy with a location.

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
HSP_IDNumber(10)IDYRelated to P2K_SH_SAFETY_POLICIES
DLN_IDNumber(10)IDYRelated to P2K_CM_LOCATIONS
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