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 nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
EID_IDNumber(10)IDone of EID_ID or MUS_ID Link to P2K_HR_IDENTITIES
MUS_IDNumber(10)IDone of EID_ID or MUS_ID Link to P2K_AM_USERS
DSP_ID_ADDRESSNumber(10)ID Link to P2K_CM_STATE_PROVINCES
DSP_ID_MAILNumber(10)ID Link to P2K_CM_UNITS
FIRST_NAMEVarchar2(50)VARCHAR50Y
LAST_NAMEVarchar2(50)VARCHAR50Y
RELATIONVarchar2(2)X_RELATION
EMPLOYERVarchar2(50)VARCHAR50
CONTACT_TITLEVarchar2(50)DESCRIPTION
GENDERVarchar2(2)X_GENDER
GOVERNMENT_CODEVarchar2(16)GOVERNMENT CODE
BIRTH_DATEDate()DATE
LANGUAGE_CODEVarchar2(3)X_LANGUAGE_CODE
MIDDLE_NAMEVarchar2(50)VARCHAR50
SALUTATIONVarchar2(4)X_SALUTATION
RANKVarchar2(4)X_RANK
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
ZIP_POSTALVarchar2(16)POSTAL CODE
MAIL_ADDRESS_LINE_1Varchar2(50)ADDRESS
MAIL_ADDRESS_LINE_2Varchar2(50)ADDRESS
MAIL_LOCALITYVarchar2(50)ADDRESS
MAIL_ZIP_POSTALVarchar2(16)POSTAL CODE
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
ALT_PHONE_NUMBERVarchar2(20)TELEPHONE
ALT_PHONE_EXTNVarchar2(16)VARCHAR16
CELLULAR_NUMBERVarchar2(20)TELEPHONE
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESS(Field)Varchar2(100)EMAIL
WEB_ADDRESSVarchar2(200)URL
SECURITY_LEVELVarchar2(2)X_SECURITY_LEVEL
PRIVATE_ITEMVarchar2(1)TOGGLE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
GOVT_CODE_ORIGINVarchar2(2)X_GOVT_CODE_ORIGIN
STUDENT_INDICATORVarchar2(1)TOGGLE
STUDENT_UNTILDate()DATE
DISABLEDVarchar2(1)TOGGLE
RAW_BIRTH_DATERAW(50) RAW50
RAW_GOVERNMENT_CODERAW(50) RAW50
EXTERNAL_RETIREMENT_IDVARCHAR2(16) VARCHAR16
CONTACT_STATUSVARCHAR2(2)X_CONTACT_STATUS

Derived Fields#

Column Name
DRV_AGE
DRV_DEPENDENT
DRV_EMERGENCY
DRV_EMPLOYER_AND_NAME
DRV_PHONE
DRV_VCALENDAR_TEST

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page