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 | 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. |
Notes #
Click to create a new notes pageScreen 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