P 2 K_HR_CONTACTS
Back to current versionRestore this version

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_DEPENDANT
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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation