Alias: HSA#

(P2K_SH_SAFETY_ACTIVITIES)

Unique Keys: none
Parent Table: P2K_SH_LOCATION_SAFETY_RULES
ERD: ERD-SH10

This table contains activities related to a location's safety policies.

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
HLSR_ID	Number(10)	ID	Y	Part of P2K_SH_LOCATION_SAFETY_RULES
SAFETY_ACTIVITY_TYPE	Varchar2(2)	X_SAFETY_ACTIVITY_TYPE	Y
SAFETY_ACTIVITY_STATUS	Varchar2(2)	X_SAFETY_ACTIVITY_STATUS	Y
ECT_ID	Number(10)	ID	[ARC]	Performed by P2K_HR_CONTACTS
EID_ID	Number(10)	ID	[ARC]	Performed by P2K_HR_IDENTITIES
HSE_ID	Number(10)	ID		For P2K_SH_SAFETY_EQUIPMENT
DESCRIPTION	Varchar2(50)	DESCRIPTION
SAFETY_ACTIVITY_DATE	Date()	DATE
SAFETY_ACTIVITY_PROCESS	Varchar2(4000)	VARCHAR4000
SAFETY_ACTIVITY_RESULT	Varchar2(4000)	VARCHAR4000
REPEAT_INTERVAL	Number(10)	NUMBER10
REPEAT_BASIS	Varchar2(2)	X_PERIOD_BASIS
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y

User Fields: Allowed
Audit Logging: Allowed

Notes

[ARC] Only one of ECT_ID or EID_ID may be used (optinoal)

---

Notes #

Click to create a new notes page