!!!Alias: ECT

(P2K_HR_CONTACTS)

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]\\
\\ 
\\
This table contains contacts for both user/system and employees
 
!!Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y| 
|[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]
|[DSP_ID_ADDRESS]|Number(10)|[ID]| |Link to [P2K_CM_STATE_PROVINCES]
|[DSP_ID_MAIL]|Number(10)|[ID]| |Link to [P2K_CM_UNITS]
|[FIRST_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]|Y|
|[LAST_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]|Y|
|[RELATION]|Varchar2(2)|[X_RELATION]| |
|[EMPLOYER]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[CONTACT_TITLE]|Varchar2(50)|[DESCRIPTION]| |
|[GENDER]|Varchar2(2)|[X_GENDER]| |
|[GOVERNMENT_CODE]|Varchar2(16)|[GOVERNMENT CODE]| |
|[BIRTH_DATE]|Date()|[DATE]| |
|[LANGUAGE_CODE]|Varchar2(3)|[X_LANGUAGE_CODE]| |
|[MIDDLE_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn] |
|[SALUTATION]|Varchar2(4)|[X_SALUTATION]| |
|[RANK]|Varchar2(4)|[X_RANK]| |
|[ADDRESS_LINE_1]|Varchar2(50)|[ADDRESS]| |
|[ADDRESS_LINE_2]|Varchar2(50)|[ADDRESS]| |
|[LOCALITY]|Varchar2(50)|[ADDRESS]| |
|[ZIP_POSTAL]|Varchar2(16)|[POSTAL CODE]| |
|[MAIL_ADDRESS_LINE_1]|Varchar2(50)|[ADDRESS]| |
|[MAIL_ADDRESS_LINE_2]|Varchar2(50)|[ADDRESS]| |
|[MAIL_LOCALITY]|Varchar2(50)|[ADDRESS]| |
|[MAIL_ZIP_POSTAL]|Varchar2(16)|[POSTAL CODE]| |
|[PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| |
|[PHONE_EXTENSION]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[ALT_PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| |
|[ALT_PHONE_EXTN]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[CELLULAR_NUMBER]|Varchar2(20)|[TELEPHONE]| |
|[FAX_NUMBER]|Varchar2(20)|[TELEPHONE]| |
|[EMAIL_ADDRESS(Field)]|Varchar2(100)|[EMAIL]| |
|[WEB_ADDRESS]|Varchar2(200)|[URL]| |
|[SECURITY_LEVEL]|Varchar2(2)|[X_SECURITY_LEVEL]| |
|[PRIVATE_ITEM]|Varchar2(1)|[TOGGLE]| |
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[GOVT_CODE_ORIGIN]|Varchar2(2)|[X_GOVT_CODE_ORIGIN]| |
|[STUDENT_INDICATOR]|Varchar2(1)|[TOGGLE]| |
|[STUDENT_UNTIL]|Date()|[DATE]| |
|[DISABLED]|Varchar2(1)|[TOGGLE]| | 
|[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]| |

!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_AGE]
|[DRV_DEPENDANT]
|[DRV_EMERGENCY]
|[DRV_EMPLOYER_AND_NAME]
|[DRV_PHONE]
|[DRV_VCALENDAR_TEST]


User Fields: Allowed\\
Audit Logging: Allowed\\


----
![Notes|Edit:Internal.P2K_HR_CONTACTS] 	
[{InsertPage page='Internal.P2K_HR_CONTACTS' default='Click to create a new notes page'}]