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 850 bytes Administrator to previous | to last
3 26-Nov-2021 10:22 696 bytes Administrator to previous | to last
2 26-Nov-2021 10:22 685 bytes Administrator to previous | to last
1 26-Nov-2021 10:22 661 bytes Administrator to last

Page References

Incoming links Outgoing links
P 2 K_SH_SAFETY_MEMBERS
P2K_SH_SAFETY_MEMBERS

Version management

Difference between version and

At line 2 changed 9 lines
(P2K_SH_SAFETY_MEMBERS)
Unique Keys: None\\
Parent Table: [P2K_SH_LOCATION_SAFETY_RULES]\\
ERD: [ERD-SH10]
\\
This table identifies the personnel associated with a safety rule, and the role they fulfill.
Unique Keys: \\
Child Table: \\
Parent Table: \\
\\
This table contains [date sensitive] information @@@
At line 13 changed 5 lines
|[ID]|Number(10)|[ID]|Y|
|[HLSR_ID]|Number(10)|[ID]|Y|Related to [P2K_SH_LOCATION_SAFETY_RULES]
|[SAFETY_MEMBER_ROLE]|Varchar2(2)|[X_SAFETY_MEMBER_ROLE]|Y|
|[ECT_ID]|Number(10)|[ID]|[ARC|1]|Related to[P2K_HR_CONTACTS]
|[EID_ID]|Number(10)|[ID]|[ARC|1]|Related to[P2K_HR_IDENTITIES]
|[ID]|Number(10)|[ID]|Y|
|[HLSR_ID]|Number(10)|[ID]|Y|Link to [P2K_CM_UNITS]
|[SAFETY_MEMBER_ROLE]|Varchar2(2)|[(Lexicon)]|Y|
|[ECT_ID]|Number(10)|[ID]| |Link to [P2K_CM_UNITS]
|[EID_ID]|Number(10)|[ID]| |Link to [P2K_CM_UNITS]
At line 25 removed 6 lines
;Notes: [ARC|#1] Only one of EID_ID or ECT_ID __must__ be selected (required)
----
![Notes|Edit:Internal.P2K_SH_SAFETY_MEMBERS]
[{InsertPage page='Internal.P2K_SH_SAFETY_MEMBERS' default='Click to create a new notes page'}]
This page (revision-5) was last changed on 26-Nov-2021 10:22 by JEscottTop