Alias: EPS#

(P2K_HR_PERSONALS)

Unique Keys:
Child Table:
Parent Table:

Holds all date sensitive information on any given

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
EID_IDNumber(10)IDYlink to P2K_HR_IDENTITIES
EFFECTIVEDate()EFFECTIVEY
DSP_ID_ADDRESSNumber(10)IDYlink to P2K_CM_STATE_PROVINCES
DCO_IDNumber(10)ID Citizenship link to P2K_CM_COUNTRIES
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
DSD_IDNumber(10)ID link to P2K_CM_SCHOOL_DISTRICTS
DSP_ID_MAILNumber(10)ID link to P2K_CM_STATE_PROVINCES
DTX_IDNumber(10)ID link to P2K_CM_TAX_JURISDICTIONS
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
EXPIRYDate()EXPIRYY
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_UNLISTEDVarchar2(1)TOGGLE
PHONE_NUMBERVarchar2(20)TELEPHONE
ALT_PHONE_NUMBERVarchar2(20)TELEPHONE
CELLULAR_NUMBERVarchar2(20)TELEPHONE
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESSVarchar2(50)EMAIL
MARITAL_STATUSVarchar2(2)X_MARITAL_STATUS
MARRIED_DATEDate()DATE
NUMBER_DEPENDENTSNumber(5)NUMBER5
YEARS_EDUCATIONNumber(5)NUMBER5
TRANSPORTATIONVarchar2(2)X_TRANSPORTATION
BONDED_STATUSVarchar2(2)X_BONDED
CITIZEN_STATUSVarchar2(2)X_CITIZEN_STATUS
FOREIGN_CODEVarchar2(16)CODE

Derived Fields#

Column Name
DRV_ADDRESS_LINE_1
DRV_ADDRESS_LINE_2
DRV_LOCALITY_STATE_ZIP

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page