This page (revision-19) 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
19 26-Nov-2021 10:22 14 KB rforbes to previous
18 26-Nov-2021 10:22 14 KB klawler to previous | to last
17 26-Nov-2021 10:22 14 KB jmyers to previous | to last
16 26-Nov-2021 10:22 14 KB jmyers to previous | to last EMAIL_ADDRESS ==> EMAIL_ADDRESS(Disambiguation)
15 26-Nov-2021 10:22 14 KB jmyers to previous | to last WORK_RULE_CODE ==> WORK_RULE (Field)
14 26-Nov-2021 10:22 14 KB rforbes to previous | to last
13 26-Nov-2021 10:22 14 KB JMyers to previous | to last
12 26-Nov-2021 10:22 14 KB RForbes to previous | to last
11 26-Nov-2021 10:22 14 KB RForbes to previous | to last
10 26-Nov-2021 10:22 13 KB JEscott to previous | to last
9 26-Nov-2021 10:22 13 KB JEscott to previous | to last
8 26-Nov-2021 10:22 13 KB JEscott to previous | to last
7 26-Nov-2021 10:22 13 KB JEscott to previous | to last
6 26-Nov-2021 10:22 13 KB JEscott to previous | to last
5 26-Nov-2021 10:22 17 KB JEscott to previous | to last
4 26-Nov-2021 10:22 17 KB JEscott to previous | to last
3 26-Nov-2021 10:22 8 KB JEscott to previous | to last
2 26-Nov-2021 10:22 5 KB JEscott to previous | to last
1 26-Nov-2021 10:22 4 KB JEscott to last

Page References

Incoming links Outgoing links
INF_CV_ASSIGNMENTS
INF_CV_ASSIGNMENTS

Version management

Difference between version and

At line 18 changed 12 lines
|[ENTITY_CODE]|Varchar2(16)|[CODE]|Y|
|[PERSON_CODE]|Varchar2(16)|[CODE]|Y|
|[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[HIRE_DATE]|Date()|[DATE]| |
|[ASSIGNMENT_CODE]|Varchar2(16)|[CODE]|Y|
|[ASSIGNMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ASSIGNMENT_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ASSIGNMENT_START_DATE]|Date()|[DATE]| |
|[ASSIGNMENT_END_DATE]|Date()|[DATE]| |
|[PRIME_ASSIGNMENT]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[NEXT_REVIEW_DATE]|Date()|[DATE]| |
|[ENTITY_CODE]|Varchar2(16)|[CODE]|Y|Destination:Not moved to the software data structures, but used for validation of the employment record. Validation: The Entity Code provided must be defined on [P2K_CM_ENTITIES].
|[PERSON_CODE]|Varchar2(16)|[CODE]|Y|Destination:Not moved to the [P2K_CM_LOCATIONS] table, but used for validation of the employment record. Validation: Must be a valid PERSON_CODE already defined on the [P2K_HR_IDENTITIES] table.
|[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |Destination:Not moved to the [P2K_CM_LOCATIONS] table, but used for validation. Validation: The employee must have an active employment record for this employment type. Must be one of the [X_EMPLOYMENT_TYPE] fixed lexicon values.
|[HIRE_DATE]|Date()|[DATE]| |Destination:Not moved to the [P2K_CM_LOCATIONS] table, but used for validation of the employment record. Validation: Must be a valid date.
|[ASSIGNMENT_CODE]|Varchar2(16)|[CODE]|Y|Destination:P2K_HR_ASSIGNMENTS.ASSIGNMENT_CODE Validation: None. Suggestion:Set the Assignment Code to be the same as the assignment type.
|[ASSIGNMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |Destination:P2K_HR_ASSIGNMENTS.ASSIGNMENT_TYPE. Validation: If provided, must be a value from the [X_ASSIGN_TYPE] fixed lexicon
|[ASSIGNMENT_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENTS.ASSIGNMENT_STATUS. Validation: If provided, must be a value from the [X_ASSIGN_STATUS] fixed lexicon
|[ASSIGNMENT_START_DATE]|Date()|[DATE]| |Destination: P2K_HR_ASSIGNMENTS.ASSIGNMENT_START_DATE Validation: Must be a valid date.
|[ASSIGNMENT_END_DATE]|Date()|[DATE]| |Destination:P2K_HR_ASSIGNMENTS.ASSIGNMENT_END_DATE. Validation: Must be a valid date.
|[PRIME_ASSIGNMENT]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENTS.PRIME_ASSIGNMENT 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.
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |Destination: P2K_HR_ASSIGNMENTS.DESCRIPTION
|[NEXT_REVIEW_DATE]|Date()|[DATE]| |Destination: P2K_HR_ASSIGNMENTS.NEXT_REVIEW_DATE
At line 31 changed 6 lines
|[EFFECTIVE]|Date()|[EFFECTIVE]| |
|[EXPIRY]|Date()|[EXPIRY]|Y|
|[CHANGE_CODE]|Varchar2(16)|[CODE]| |
|[STATUS_CODE]|Varchar2(16)|[CODE]| |
|[POSITION_CODE]|Varchar2(16)|[CODE]| |
|[DEPARTMENT_CODE]|Varchar2(16)|[CODE]| |
|[EFFECTIVE]|Date()|[EFFECTIVE]| |Destination: P2K_CM_ASSIGNMENT_DETAILS.EFFECTIVE Validation: Must be a valid date format.
Suggestion: If you are not loading multiple date-effective records for the same entity code, then populate this field with a constant ‘01-Jan-0001’ which represents the beginning of time.
|[EXPIRY]|Date()|[EXPIRY]|Y|Destination: P2K_CM_ASSIGNMENT_DETAILS.EXPIRY 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 entity code, then populate this field with a constant ‘31-Dec-3999’ which represents the end of time.
|[CHANGE_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_CM_ASSIGNMENT_DETAILS.DCR_ID. Validation: The Change Code provided must be defined on [P2K_CM_CHANGE_REASONS].
|[STATUS_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_CM_ASSIGNMENT_DETAILS.DES_ID Validation: Must be an Employment Status code defined on [P2K_CM_EMPLOYMENT_STATUSES].
|[POSITION_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.DPS_ID Validation: The Position Code provided must be defined on [P2K_CM_POSITIONS]
|[DEPARTMENT_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.DDP_ID Validation: The Department Code provided must be defined on [P2K_CM_DEPARTMENTS]
This page (revision-19) was last changed on 26-Nov-2021 10:22 by rforbesTop