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.Table Columns#
| Column name | Data Type / Size | Mand. | Notes | |
|---|---|---|---|---|
| ID | Number(10) | ID | 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) | |||
| GOVERNMENT_CODE | Varchar2(16) | |||
| FIRST_NAME | Varchar2(50) | Y | ||
| LAST_NAME | Varchar2(50) | Y | ||
| BIRTH_DATE | Date() | |||
| GENDER | Varchar2(30) | |||
| LANGUAGE_CODE | Varchar2(30) | |||
| ETHNIC | Varchar2(30) | |||
| MIDDLE_NAME | Varchar2(50) | |||
| SALUTATION | Varchar2(30) | |||
| RANK | Varchar2(30) | |||
| BIRTHPLACE | Varchar2(50) | |||
| CHALLENGED | Varchar2(30) | |||
| VETERAN_STATUS | Varchar2(30) | |||
| 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 | ||
| EXPIRY | Date() | |||
| CHANGE_CODE | Varchar2(16) | |||
| GEO_CODE | Varchar2(16) | |||
| ADDRESS_LINE_1 | Varchar2(50) | |||
| ADDRESS_LINE_2 | Varchar2(50) | |||
| LOCALITY | Varchar2(50) | |||
| STATE_PROVINCE_CODE | Varchar2(16) | |||
| COUNTRY_CODE | Varchar2(16) | |||
| ZIP_POSTAL | Varchar2(16) | |||
| MAIL_ADDRESS_LINE_1 | Varchar2(50) | |||
| MAIL_ADDRESS_LINE_2 | Varchar2(50) | |||
| MAIL_LOCALITY | Varchar2(50) | |||
| MAIL_STATE_PROVINCE_CODE | Varchar2(16) | |||
| MAIL_COUNTRY_CODE | Varchar2(16) | |||
| MAIL_ZIP_POSTAL | Varchar2(16) | |||
| PHONE_UNLISTED | Varchar2(4) | |||
| PHONE_NUMBER | Varchar2(20) | |||
| ALT_PHONE_NUMBER | Varchar2(20) | |||
| CELLULAR_NUMBER | Varchar2(20) | |||
| FAX_NUMBER | Varchar2(20) | |||
| EMAIL_ADDRESS | Varchar2(50) | |||
| MARITAL_STATUS | Varchar2(30) | |||
| MARRIED_DATE | Date() | |||
| NUMBER_DEPENDENTS | Number(5) | |||
| YEARS_EDUCATION | Number(5) | |||
| TRANSPORTATION | Varchar2(30) | |||
| BONDED_STATUS | Varchar2(30) | |||
| CITIZEN_STATUS | Varchar2(30) | |||
| FOREIGN_CODE | Varchar2(16) | |||
| CITIZENSHIP | Varchar2(16) | |||
| SCHOOL_DISTRICT_CODE | Varchar2(16) | |||
| USER_FIELD_VALUE_01 | Varchar2(2000) | |||
| USER_FIELD_VALUE_02 | Varchar2(2000) | |||
| USER_FIELD_VALUE_03 | Varchar2(2000) | |||
| USER_FIELD_VALUE_04 | Varchar2(2000) | |||
| USER_FIELD_VALUE_05 | Varchar2(2000) | |||
| USER_FIELD_VALUE_06 | Varchar2(2000) | |||
| USER_FIELD_VALUE_07 | Varchar2(2000) | |||
| USER_FIELD_VALUE_08 | Varchar2(2000) | |||
| USER_FIELD_VALUE_09 | Varchar2(2000) | |||
| USER_FIELD_VALUE_10 | Varchar2(2000) | |||
| CREATE_DATE | Date() | |||
| CREATE_USER | Varchar2(30) | |||
| CHANGE_DATE | Date() | |||
| CHANGE_USER | Varchar2(30) |
