Alias: HSL#

(P2K_SH_SAFETY_LOGS)

Unique Keys: None
Parent Table: P2K_SH_SAFETY_ACTIVITIES
ERD: ERD-SH10

This table contains logging information on safety activities.

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
HSA_ID	Number(10)	ID	Y	Logging for P2K_SH_SAFETY_ACTIVITIES
ECT_ID	Number(10)	ID	[ARC]	Logged by P2K_HR_CONTACTS
EID_ID	Number(10)	ID	[ARC]	Logged by P2K_HR_IDENTITIES
SAFETY_LOG_DATE	Date()	DATE	Y
SAFETY_LOG_TIME	Number(5)	MINUTES	Y
SAFETY_LOG_STATUS	Varchar2(2)	X_SAFETY_LOG_STATUS	Y
DESCRIPTION	Varchar2(50)	DESCRIPTION
NEXT_ACTIVITY_DATE	Date()	DATE
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 EID_ID or ECT_ID may be specified as the logger (optional).

---

Notes #

Click to create a new notes page