INF_CV_PERSONALS
Back to current versionRestore this version

Alias: IVEPS#

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)
USER_FIELD_VALUE_02Varchar2(2000)
USER_FIELD_VALUE_03Varchar2(2000)
USER_FIELD_VALUE_04Varchar2(2000)
USER_FIELD_VALUE_05Varchar2(2000)
USER_FIELD_VALUE_06Varchar2(2000)
USER_FIELD_VALUE_07Varchar2(2000)
USER_FIELD_VALUE_08Varchar2(2000)
USER_FIELD_VALUE_09Varchar2(2000)
USER_FIELD_VALUE_10Varchar2(2000)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.

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