TABLES-SH
Table NameAliasDescription
P2K_SH_HAZARDSHHZDefines hazards
P2K_SH_HEALTH_CLAIMSHHCHealth Claims
P2K_SH_HEALTH_COSTSHCSHealth Costs
P2K_SH_HEALTH_ISSUESHHIHealth Issues
P2K_SH_HEALTH_RECORDSHHRHealth Records
P2K_SH_INCIDENTSHINIncidents
P2K_SH_INCIDENT_WITNESSESHWTIncident Witnesses
P2K_SH_INOCULATIONSHICInoculations
P2K_SH_JOB_HAZARDSHJHAssociate a hazard to a job
P2K_SH_LOCATION_HAZARDSHLHAssociate a hazard to a location
P2K_SH_LOCATION_SAFETY_RULESHLSRAssociate a safety policy with a location
P2K_SH_MEDICAL_EXAMSHMEMedical Exams
P2K_SH_MEDICAL_EXAM_TYPESHTPThis table identifies the types of medical exams.
P2K_SH_MEDICAL_TESTSHMTThis table contains medical test information for employees or candidates.
P2K_SH_MEDICATIONSHMDThis table contains information on medications for employees or candidates.
P2K_SH_REQUIRED_MEDICAL_TESTSHRTThis table contains medical test types associated with a medical exam.
P2K_SH_SAFETY_ACTIVITIESHSAThis table contains activities related to a location's safety policies.
P2K_SH_SAFETY_EQUIPMENTHSEThis table contains information regarding safety equipment pertinent to a location's safety policies.
P2K_SH_SAFETY_LOGSHSLThis table contains logging information on safety activities.
P2K_SH_SAFETY_MEMBERSHSMThis table identifies the personnel associated with a safety rule, and the role they fulfill.
P2K_SH_SAFETY_POLICIESHSPThis table identifies the safety policies that will be linked to locations.
P2K_SH_SAFETY_REVIEWSHSRContains details of a safety review in accordance with a policy or a rule for a location.
P2K_SH_TIME_LOST_DETAILSHTL
P2K_SH_VEHICLE_PASSENGERSHVPThis table identifies passengers in a vehicle, related to a safety incident.
P2K_SH_VEHICLE_REPORTSHVRThis table records vehicle information pertinent to a safety incident.


Notes #

Click to create a new notes page