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(Field) | 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 | Varchar2(2000) | Looking for EPS01 defined on IMUF | |
| USER_FIELD_VALUE_02 | Varchar2(2000) | Looking for EPS02 defined on IMUF | |
| USER_FIELD_VALUE_03 | Varchar2(2000) | Looking for EPS03 defined on IMUF | |
| USER_FIELD_VALUE_04 | Varchar2(2000) | Looking for EPS04 defined on IMUF | |
| USER_FIELD_VALUE_05 | Varchar2(2000) | Looking for EPS05 defined on IMUF | |
| USER_FIELD_VALUE_06 | Varchar2(2000) | Looking for EPS06 defined on IMUF | |
| USER_FIELD_VALUE_07 | Varchar2(2000) | Looking for EPS07 defined on IMUF | |
| USER_FIELD_VALUE_08 | Varchar2(2000) | Looking for EPS08 defined on IMUF | |
| USER_FIELD_VALUE_09 | Varchar2(2000) | Looking for EPS09 defined on IMUF | |
| USER_FIELD_VALUE_10 | Varchar2(2000) | Looking for EPS10 defined on IMUF | |
| CREATE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| CREATE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| CHANGE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| CHANGE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |
