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 6 changed one line
|[ID]|Number(10)|[ID]| |Used internally to define a unique identification for the record. This field would not be loaded.
|[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded.
At line 8 changed 2 lines
|[USER_NAME]|Varchar2(30)| |
|[GOVERNMENT_CODE]|Varchar2(16)| |
|[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.
At line 13 changed 3 lines
|[GENDER]|Varchar2(30)| |
|[LANGUAGE_CODE]|Varchar2(30)| |
|[ETHNIC]|Varchar2(30)| |
|[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]
At line 17 changed 2 lines
|[SALUTATION]|Varchar2(30)| |
|[RANK]|Varchar2(30)| |
|[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]
At line 20 changed 2 lines
|[CHALLENGED]|Varchar2(30)| |
|[VETERAN_STATUS]|Varchar2(30)| |
|[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]
At line 27 changed 4 lines
|[EFFECTIVE]|Date()|Y|
|[EXPIRY]|Date()| |
|[CHANGE_CODE]|Varchar2(16)| |
|[GEO_CODE]|Varchar2(16)| |
|[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.
At line 34 changed 3 lines
|[STATE_PROVINCE_CODE]|Varchar2(16)| |
|[COUNTRY_CODE]|Varchar2(16)| |
|[ZIP_POSTAL]|Varchar2(16)| |
|[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.
At line 40 changed 8 lines
|[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)| |
|[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.
At line 49 changed 2 lines
|[MARITAL_STATUS]|Varchar2(30)| |
|[MARRIED_DATE]|Date()| |
|[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
At line 53 changed 3 lines
|[TRANSPORTATION]|Varchar2(30)| |
|[BONDED_STATUS]|Varchar2(30)| |
|[CITIZEN_STATUS]|Varchar2(30)| |
|[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]
At line 58 changed one line
|[SCHOOL_DISTRICT_CODE]|Varchar2(16)| |
|[SCHOOL_DISTRICT_CODE]|Varchar2(16)| |Validation: Must be a valid school district code defined on [P2K_CM_SCHOOL_DISTRICTS].
At line 69 changed 4 lines
|[CREATE_DATE]|Date()| |
|[CREATE_USER]|Varchar2(30)| |
|[CHANGE_DATE]|Date()| |
|[CHANGE_USER]|Varchar2(30)| |
|[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.
This page (revision-13) was last changed on 26-Nov-2021 10:22 by rforbesTop