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

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
19 26-Nov-2021 10:22 2 KB kparrott to previous DRV_DEPENDANT ==> DRV_DEPENDENT
18 26-Nov-2021 10:22 2 KB rforbes to previous | to last
17 26-Nov-2021 10:22 2 KB rforbes to previous | to last
16 26-Nov-2021 10:22 2 KB rforbes to previous | to last
15 26-Nov-2021 10:22 2 KB khiggs to previous | to last
14 26-Nov-2021 10:22 2 KB khiggs to previous | to last
13 26-Nov-2021 10:22 2 KB jmyers to previous | to last
12 26-Nov-2021 10:22 2 KB jmyers to previous | to last EMAIL_ADDRESS ==> EMAIL_ADDRESS(Disambiguation)
11 26-Nov-2021 10:22 2 KB jaiken to previous | to last
10 26-Nov-2021 10:22 2 KB jmyers to previous | to last
9 26-Nov-2021 10:22 2 KB JMyers to previous | to last
8 26-Nov-2021 10:22 2 KB JEscott to previous | to last
7 26-Nov-2021 10:22 2 KB JEscott to previous | to last
6 26-Nov-2021 10:22 2 KB JEscott to previous | to last
5 26-Nov-2021 10:22 2 KB JEscott to previous | to last
4 26-Nov-2021 10:22 2 KB JEscott to previous | to last
3 26-Nov-2021 10:22 2 KB Administrator to previous | to last
2 26-Nov-2021 10:22 2 KB Administrator to previous | to last
1 26-Nov-2021 10:22 2 KB Administrator to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 5 changed 3 lines
Unique Keys: \\
Child Table: \\
Parent Table: \\
Unique Keys: [FIRST_NAME] + [LAST_NAME] + (either [EID_ID] (Person Code) or [MUS_ID] (User Name) )\\
Parent Table: [P2K_HR_IDENTITIES] or [P2K_AM_USERS]\\
ERD: [ERD-HR1]\\
At line 9 changed one line
This table contains contacts for both user and the system
\\
This table contains contacts for both user/system and employees
At line 14 changed 2 lines
|[EID_ID]|Number(10)|[ID]| |Link to [P2K_HR_IDENTITIES]
|[MUS_ID]|Number(10)|[ID]| |Link to [P2K_AM_USERS]
|[EID_ID]|Number(10)|[ID]|one of [EID_ID] or [MUS_ID] |Link to [P2K_HR_IDENTITIES]
|[MUS_ID]|Number(10)|[ID]|one of [EID_ID] or [MUS_ID] |Link to [P2K_AM_USERS]
At line 44 changed one line
|[EMAIL_ADDRESS]|Varchar2(50)|[EMAIL]| |
|[EMAIL_ADDRESS(Field)]|Varchar2(100)|[EMAIL]| |
At line 55 changed one line
|[EXTERNAL_RETIREMENT_ID]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[RAW_BIRTH_DATE]|RAW(50)| [RAW50]| |
|[RAW_GOVERNMENT_CODE]|RAW(50)| [RAW50]| |
|[EXTERNAL_RETIREMENT_ID]|VARCHAR2(16)| [VARCHAR16|VARCHARnn]| |
|[CONTACT_STATUS]|VARCHAR2(2)|[X_CONTACT_STATUS]| |
At line 60 changed one line
|[DRV_DEPENDANT]
|[DRV_DEPENDENT]