Alias: IVEPS#

(INF_CV_PERSONALS)

The INF_CV_PERSONALS table is used to import employee identity and personal information into the software data structures. Basic employee information is created through Identity and Personal tables.

Tables loaded:

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
PERSON_CODEVarchar2(16)YValidation: Must be a unique person code on the P2K_HR_IDENTITIES table.
USER_NAMEVarchar2(30) Validation: Must be a valid user name defined on P2K_AM_USERS.
GOVERNMENT_CODEVarchar2(16) This field is required if this record is the first INF_CV_PERSONALS record for this employee that will result in the creation of a P2K_HR_IDENTITIES record. It is not required if it is a subsequent record that will result in the “splitting” of the P2K_HR_PERSONALS record.
FIRST_NAMEVarchar2(50)Y
LAST_NAMEVarchar2(50)Y
BIRTH_DATEDate()
GENDERVarchar2(30) Validation: If provided, must be one of the fixed lexicon values from X_GENDER
LANGUAGE_CODEVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from X_LANGUAGE_CODE
ETHNICVarchar2(30) This field is required if this record is the first INF_CV_PERSONALS record for this employee that will result in the creation of a P2K_HR_IDENTITIES record. It is not required if it is a subsequent record that will result in the “splitting” of the P2K_HR_PERSONALS record. Validation: If provided, must be one of the fixed lexicon values from X_ETHNIC
MIDDLE_NAMEVarchar2(50)
SALUTATIONVarchar2(30) Validation: If provided, must be one of the fixed lexicon values from X_SALUTATION
RANKVarchar2(30) Validation: If provided, must be one of the fixed lexicon values from X_RANK
BIRTHPLACEVarchar2(50)
CHALLENGEDVarchar2(30) Validation: If provided, must be one of the fixed lexicon values from X_CHALLENGED
VETERAN_STATUSVarchar2(30) Validation: If provided, must be one of the fixed lexicon values from X_VETERAN_STATUS
GOVT_CODE_VERIFIEDVarchar2(4)
PHOTO_LOCATIONVarchar2(50)
DRIVERS_LICENSEVarchar2(30)
ALT_LANGUAGE_CODEVarchar2(30)
GOVT_CODE_ORIGINVarchar2(30)
EFFECTIVEDate()YValidation: Must be a valid date format. Suggestion: If you are not loading multiple date-effective records for the same person code, then populate this field with a constant ‘01-Jan-0001’ which represents the beginning of time.
EXPIRYDate() Validation: Must be a valid date format, with a date after the effective date. Suggestion: If you are not loading multiple date-effective records for the same person code, then populate this field with a constant ‘31-Dec-3999’ which represents the end of time.
CHANGE_CODEVarchar2(16) Validation: The Change Code provided must be defined on P2K_CM_CHANGE_REASONS
GEO_CODEVarchar2(16) Validation: The GEO Code must be a valid GEO code on the P2K_CM_TAX_JURISDICTIONS table. If the STATE_PROVINCE_CODE is provided, then the GEO_CODE must be within that specific state, as well.
ADDRESS_LINE_1Varchar2(50)
ADDRESS_LINE_2Varchar2(50)
LOCALITYVarchar2(50)
STATE_PROVINCE_CODEVarchar2(16) Validation: Must be a valid state code or province code, for the COUNTRY_CODE indicated on P2K_CM_STATE_PROVINCES.
COUNTRY_CODEVarchar2(16) Validation: Must be a valid country code on P2K_CM_COUNTRIES. If you provide a STATE_PROVINCE_CODE, then you must provide a COUNTRY_CODE.
ZIP_POSTALVarchar2(16) Validation: Must be formatted in the correct format, for the country indicated.
MAIL_ADDRESS_LINE_1Varchar2(50)
MAIL_ADDRESS_LINE_2Varchar2(50)
MAIL_LOCALITYVarchar2(50)
MAIL_STATE_PROVINCE_CODEVarchar2(16) Validation: Must be a valid state code or province code, for the COUNTRY_CODE indicated on P2K_CM_STATE_PROVINCES.
MAIL_COUNTRY_CODEVarchar2(16) Validation: Must be a valid country code on P2K_CM_COUNTRIES.
MAIL_ZIP_POSTALVarchar2(16) Validation: Must be formatted in the correct format, for the country indicated for the mailing address.
PHONE_UNLISTEDVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N”, “NO” or “0”. All other values will translate to True.
PHONE_NUMBERVarchar2(20) Validation: Must be formatted in the correct format, for the country indicated by the physical location
ALT_PHONE_NUMBERVarchar2(20) Validation: Must be formatted in the correct format, for the country indicated by the physical location.
CELLULAR_NUMBERVarchar2(20) Validation: Must be formatted in the correct format, for the country indicated by the physical location
FAX_NUMBERVarchar2(20) Validation: Must be formatted in the correct format, for the country indicated by the physical location.
EMAIL_ADDRESSVarchar2(50)
MARITAL_STATUSVarchar2(30) Validation: If provided, must be one of the fixed lexicon values from X_MARITAL_STATUS
MARRIED_DATEDate() Validation: Must be a valid date
NUMBER_DEPENDENTSNumber(5)
YEARS_EDUCATIONNumber(5)
TRANSPORTATIONVarchar2(30) Validation: If provided, must be one of the fixed lexicon values from X_TRANSPORTATION
BONDED_STATUSVarchar2(30) Validation: If provided, must be one of the fixed lexicon values from X_BONDED
CITIZEN_STATUSVarchar2(30) Validation: If provided, must be one of the fixed lexicon values from X_CITIZEN_STATUS
FOREIGN_CODEVarchar2(16)
CITIZENSHIPVarchar2(16)
SCHOOL_DISTRICT_CODEVarchar2(16) Validation: Must be a valid school district code defined on P2K_CM_SCHOOL_DISTRICTS.
USER_FIELD_VALUE_01Varchar2(2000) Looking for EPS01 defined on IMUF
USER_FIELD_VALUE_02Varchar2(2000) Looking for EPS02 defined on IMUF
USER_FIELD_VALUE_03Varchar2(2000) Looking for EPS03 defined on IMUF
USER_FIELD_VALUE_04Varchar2(2000) Looking for EPS04 defined on IMUF
USER_FIELD_VALUE_05Varchar2(2000) Looking for EPS05 defined on IMUF
USER_FIELD_VALUE_06Varchar2(2000) Looking for EPS06 defined on IMUF
USER_FIELD_VALUE_07Varchar2(2000) Looking for EPS07 defined on IMUF
USER_FIELD_VALUE_08Varchar2(2000) Looking for EPS08 defined on IMUF
USER_FIELD_VALUE_09Varchar2(2000) Looking for EPS09 defined on IMUF
USER_FIELD_VALUE_10Varchar2(2000) Looking for EPS10 defined on IMUF