This page (revision-13) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
13 26-Nov-2021 10:22 7 KB rforbes to previous
12 26-Nov-2021 10:22 7 KB jmyers to previous | to last
11 26-Nov-2021 10:22 7 KB jmyers to previous | to last EMAIL_ADDRESS ==> EMAIL_ADDRESS(Disambiguation)
10 26-Nov-2021 10:22 7 KB JMyers to previous | to last
9 26-Nov-2021 10:22 7 KB RForbes to previous | to last
8 26-Nov-2021 10:22 7 KB JEscott to previous | to last
7 26-Nov-2021 10:22 7 KB JEscott to previous | to last
6 26-Nov-2021 10:22 6 KB JEscott to previous | to last _CIT
5 26-Nov-2021 10:22 2 KB JEscott to previous | to last
4 26-Nov-2021 10:22 3 KB JEscott to previous | to last
3 26-Nov-2021 10:22 3 KB JEscott to previous | to last
2 26-Nov-2021 10:22 2 bytes JEscott to previous | to last
1 26-Nov-2021 10:22 1 KB JEscott to last

Page References

Incoming links Outgoing links
INF_CV_PERSONALS
INF_CV_PERSONALS

Version management

Difference between version and

At line 1 changed 4 lines
!!!Alias: IVPPRN
(INF_CV_PAYRUNS)
\\
Pay Runs
!!!Alias: [IVEPS]
(INF_CV_PERSONALS)
At line 4 added 7 lines
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)
At line 8 changed 33 lines
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]| |
|[ENTITY_CODE]|Varchar2(16)|[CODE]|Y|
|[PAY_RUN_NUMBER]|Number(10)|[NUMBER10|NUMBERn]|Y|
|[USER_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[PAYROLL_CODE]|Varchar2(16)|[CODE]|Y|
|[PAY_POINT_SET_CODE]|Varchar2(16)|[CODE]|Y|
|[PAY_CALENDAR_CODE]|Varchar2(16)|[CODE]|Y|
|[PAY_PERIOD]|Number(10)|[NUMBER10|NUMBERn]|Y|
|[PAY_RUN_STAGE]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[PAY_PERIOD_FUTURE]|Number(10)|[NUMBER10|NUMBERn]| |
|[COUNTRY_CODE]|Varchar2(16)|[CODE]| |
|[BANK_TRANSIT_CODE]|Varchar2(16)|[CODE]| |
|[BANK_ACCOUNT]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[STARTING_NUMBER]|Number(10)|[NUMBER10|NUMBERn]| |
|[PAY_RUN_START_TIMESTAMP]|Date()|[TIMESTAMP]| |
|[PAY_RUN_END_TIMESTAMP]|Date()|[TIMESTAMP]| |
|[EMPLOYEE_COUNT]|Number(5)|[NUMBER5|NUMBERn]| |
|[REVERSAL_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| |
|[ADJUSTMENT_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| |
|[CURRENT_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| |
|[FUTURE_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| |
|[ADVANCE_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| |
|[BONUS_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| |
|[RETROACTIVE_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| |
|[DISBURSED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[TRIAL_RUN]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[JOURNALIZED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[JOURNALIZED_FUND]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[CREATE_DATE]|Date()|[DATE]| |
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CHANGE_DATE]|Date()|[DATE]| |
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
||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|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]
|[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|Edit:Internal.INF_CV_PERSONALS]
[{InsertPage page='Internal.INF_CV_PERSONALS' default='Click to create a new notes page'}]
This page (revision-13) was last changed on 26-Nov-2021 10:22 by rforbesTop