!!!Alias: ECT

(P2K_HR_CONTACTS)

Unique Keys: \\
Child Table: \\
Parent Table: \\
\\ 
This table contains contacts for both user and the system
 
!!Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y| 
|[EID_ID]|Number(10)|[ID]| |Link to [P2K_HR_IDENTITIES]
|[MUS_ID]|Number(10)|[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]|Varchar2(50)|[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]| |

!!Derived Fields
||Column Name
|[DRV_AGE]
|[DRV_EMPLOYER_AND_NAME]
|[DRV_PHONE]


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


[{If var='loginstatus' contains 'authenticated'

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

}]