!!!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: *[P2K_HR_IDENTITIES] (first record for each employee only) *[P2K_HR_PERSONALS] (first record and subsequent effective splits) *[P2K_HR_ALIASES] (subsequent records only) *[P2K_AM_USER_FIELD_VALUES] (one per user field specified) !!Table Columns \\ ||Column name||Data Type / Size||Mand.||Notes |[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded. |[PERSON_CODE]|Varchar2(16)|Y|Validation: Must be a unique person code on the [P2K_HR_IDENTITIES] table. |[USER_NAME]|Varchar2(30)| |Validation: Must be a valid user name defined on [P2K_AM_USERS]. |[GOVERNMENT_CODE]|Varchar2(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_NAME]|Varchar2(50)|Y| |[LAST_NAME]|Varchar2(50)|Y| |[BIRTH_DATE]|Date()| | |[GENDER]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_GENDER] |[LANGUAGE_CODE]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_LANGUAGE_CODE] |[ETHNIC]|Varchar2(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_NAME]|Varchar2(50)| | |[SALUTATION]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_SALUTATION] |[RANK]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_RANK] |[BIRTHPLACE]|Varchar2(50)| | |[CHALLENGED]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_CHALLENGED] |[VETERAN_STATUS]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_VETERAN_STATUS] |[GOVT_CODE_VERIFIED]|Varchar2(4)| | |[PHOTO_LOCATION]|Varchar2(50)| | |[DRIVERS_LICENSE]|Varchar2(30)| | |[ALT_LANGUAGE_CODE]|Varchar2(30)| | |[GOVT_CODE_ORIGIN]|Varchar2(30)| | |[EFFECTIVE]|Date()|Y|Validation: 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. |[EXPIRY]|Date()| |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_CODE]|Varchar2(16)| |Validation: The Change Code provided must be defined on [P2K_CM_CHANGE_REASONS] |[GEO_CODE]|Varchar2(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_1]|Varchar2(50)| | |[ADDRESS_LINE_2]|Varchar2(50)| | |[LOCALITY]|Varchar2(50)| | |[STATE_PROVINCE_CODE]|Varchar2(16)| |Validation: Must be a valid state code or province code, for the [COUNTRY_CODE] indicated on [P2K_CM_STATE_PROVINCES]. |[COUNTRY_CODE]|Varchar2(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_POSTAL]|Varchar2(16)| |Validation: Must be formatted in the correct format, for the country indicated. |[MAIL_ADDRESS_LINE_1]|Varchar2(50)| | |[MAIL_ADDRESS_LINE_2]|Varchar2(50)| | |[MAIL_LOCALITY]|Varchar2(50)| | |[MAIL_STATE_PROVINCE_CODE]|Varchar2(16)| |Validation: Must be a valid state code or province code, for the [COUNTRY_CODE] indicated on [P2K_CM_STATE_PROVINCES]. |[MAIL_COUNTRY_CODE]|Varchar2(16)| |Validation: Must be a valid country code on [P2K_CM_COUNTRIES]. |[MAIL_ZIP_POSTAL]|Varchar2(16)| |Validation: Must be formatted in the correct format, for the country indicated for the mailing address. |[PHONE_UNLISTED]|Varchar2(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_NUMBER]|Varchar2(20)| |Validation: Must be formatted in the correct format, for the country indicated by the physical location |[ALT_PHONE_NUMBER]|Varchar2(20)| |Validation: Must be formatted in the correct format, for the country indicated by the physical location. |[CELLULAR_NUMBER]|Varchar2(20)| |Validation: Must be formatted in the correct format, for the country indicated by the physical location |[FAX_NUMBER]|Varchar2(20)| |Validation: Must be formatted in the correct format, for the country indicated by the physical location. |[EMAIL_ADDRESS]|Varchar2(50)| | |[MARITAL_STATUS]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_MARITAL_STATUS] |[MARRIED_DATE]|Date()| |Validation: Must be a valid date |[NUMBER_DEPENDENTS]|Number(5)| | |[YEARS_EDUCATION]|Number(5)| | |[TRANSPORTATION]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_TRANSPORTATION] |[BONDED_STATUS]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_BONDED] |[CITIZEN_STATUS]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_CITIZEN_STATUS] |[FOREIGN_CODE]|Varchar2(16)| | |[CITIZENSHIP]|Varchar2(16)| | |[SCHOOL_DISTRICT_CODE]|Varchar2(16)| |Validation: Must be a valid school district code defined on [P2K_CM_SCHOOL_DISTRICTS]. |[USER_FIELD_VALUE_01|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EPS01 defined on [IMUF] |[USER_FIELD_VALUE_02|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EPS02 defined on [IMUF] |[USER_FIELD_VALUE_03|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EPS03 defined on [IMUF] |[USER_FIELD_VALUE_04|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EPS04 defined on [IMUF] |[USER_FIELD_VALUE_05|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EPS05 defined on [IMUF] |[USER_FIELD_VALUE_06|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EPS06 defined on [IMUF] |[USER_FIELD_VALUE_07|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EPS07 defined on [IMUF] |[USER_FIELD_VALUE_08|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EPS08 defined on [IMUF] |[USER_FIELD_VALUE_09|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EPS09 defined on [IMUF] |[USER_FIELD_VALUE_10|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EPS10 defined on [IMUF] [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.IVEPS] [{InsertPage page='Internal.IVEPS' default='Click to create a new discussion page'}] }]