P 2 K_HR_CONTACTS
Back to current versionRestore this version

Alias: ECT#

(P2K_HR_CONTACTS)

Unique Keys:
Child Table:
Parent Table:

This table contains contacts for both user and the system

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
EID_IDNumber(10)ID Link to P2K_HR_IDENTITIES
MUS_IDNumber(10)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_ADDRESSVarchar2(50)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

Derived Fields#

Column Name
DRV_EMPLOYER_AND_NAME
DRV_PHONE

User Fields: Allowed
Audit Logging: Allowed

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