This page (revision-5) was last changed on 26-Nov-2021 10:22 by JEscott

This page was created on 26-Nov-2021 10:22 by Administrator

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
5 26-Nov-2021 10:22 1 KB JEscott to previous
4 26-Nov-2021 10:22 987 bytes Administrator to previous | to last
3 26-Nov-2021 10:22 852 bytes Administrator to previous | to last
2 26-Nov-2021 10:22 842 bytes Administrator to previous | to last
1 26-Nov-2021 10:22 822 bytes Administrator to last

Page References

Incoming links Outgoing links
P 2 K_SH_SAFETY_LOGS
P2K_SH_SAFETY_LOGS

Version management

Difference between version and

At line 1 changed 10 lines
!!!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.
!!!Alias:
Unique Keys: \\
Child Table: \\
Parent Table: \\
\\
This table contains [date sensitive] information @@@
At line 13 changed 4 lines
|[ID]|Number(10)|[ID]|Y|
|[HSA_ID]|Number(10)|[ID]|Y|Logging for [P2K_SH_SAFETY_ACTIVITIES]
|[ECT_ID]|Number(10)|[ID]|[ARC|1]|Logged by [P2K_HR_CONTACTS]
|[EID_ID]|Number(10)|[ID]|[ARC|1]|Logged by [P2K_HR_IDENTITIES]
|[ID]|Number(10)|[ID]|Y|
|[HSA_ID]|Number(10)|[ID]|Y|Link to [P2K_SH_SAFETY_ACTIVITIES]
|[ECT_ID]|Number(10)|[ID]| |Link to [P2K_HR_CONTACTS]
|[EID_ID]|Number(10)|[ID]| |Link to [P2K_HR_IDENTITIES]
At line 19 changed one line
|[SAFETY_LOG_STATUS]|Varchar2(2)|[X_SAFETY_LOG_STATUS]|Y|
|[SAFETY_LOG_STATUS]|Varchar2(2)|[(Lexicon)]|Y|
At line 29 removed 7 lines
;Notes
;:[ARC|#1] Only one of EID_ID or ECT_ID may be specified as the logger (optional).
----
![Notes|Edit:Internal.P2K_SH_SAFETY_LOGS]
[{InsertPage page='Internal.P2K_SH_SAFETY_LOGS' default='Click to create a new notes page'}]
This page (revision-5) was last changed on 26-Nov-2021 10:22 by JEscottTop