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_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) RAW51
RAW_GOVERNMENT_CODERAW(50) RAW52
EXTERNAL_RETIREMENT_IDVARCHAR2(16) VARCHAR16

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
This particular version was published on 26-Nov-2021 10:22 by khiggs.Top