Wiki: TABLES-SH

Table Name	Alias	Description
P2K_SH_HAZARDS	HHZ	Defines hazards
P2K_SH_HEALTH_CLAIMS	HHC	Health Claims
P2K_SH_HEALTH_COSTS	HCS	Health Costs
P2K_SH_HEALTH_ISSUES	HHI	Health Issues
P2K_SH_HEALTH_RECORDS	HHR	Health Records
P2K_SH_INCIDENTS	HIN	Incidents
P2K_SH_INCIDENT_WITNESSES	HWT	Incident Witnesses
P2K_SH_INOCULATIONS	HIC	Inoculations
P2K_SH_JOB_HAZARDS	HJH	Associate a hazard to a job
P2K_SH_LOCATION_HAZARDS	HLH	Associate a hazard to a location
P2K_SH_LOCATION_SAFETY_RULES	HLSR	Associate a safety policy with a location
P2K_SH_MEDICAL_EXAMS	HME	Medical Exams
P2K_SH_MEDICAL_EXAM_TYPES	HTP	This table identifies the types of medical exams.
P2K_SH_MEDICAL_TESTS	HMT	This table contains medical test information for employees or candidates.
P2K_SH_MEDICATIONS	HMD	This table contains information on medications for employees or candidates.
P2K_SH_REQUIRED_MEDICAL_TESTS	HRT	This table contains medical test types associated with a medical exam.
P2K_SH_SAFETY_ACTIVITIES	HSA	This table contains activities related to a location's safety policies.
P2K_SH_SAFETY_EQUIPMENT	HSE	This table contains information regarding safety equipment pertinent to a location's safety policies.
P2K_SH_SAFETY_LOGS	HSL	This table contains logging information on safety activities.
P2K_SH_SAFETY_MEMBERS	HSM	This table identifies the personnel associated with a safety rule, and the role they fulfill.
P2K_SH_SAFETY_POLICIES	HSP	This table identifies the safety policies that will be linked to locations.
P2K_SH_SAFETY_REVIEWS	HSR	Contains details of a safety review in accordance with a policy or a rule for a location.
P2K_SH_TIME_LOST_DETAILS	HTL
P2K_SH_VEHICLE_PASSENGERS	HVP	This table identifies passengers in a vehicle, related to a safety incident.
P2K_SH_VEHICLE_REPORTS	HVR	This table records vehicle information pertinent to a safety incident.

Notes #

Click to create a new notes page