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 22 changed one line
|[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_CODE]|Varchar2(16)|[CODE]|Y|Destination:P2K_HR_ASSIGNMENTS.ASSIGNMENT_CODE Suggestion:Set the Assignment Code to be the same as the assignment type.
At line 40 changed 2 lines
|[COUNTRY_CODE]|Varchar2(16)|[CODE]| |Destination: Not moved to the software structures, but used for validation of STATE_PROVINCE. 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.
|[STATE_PROVINCE_CODE]|Varchar2(16)|[CODE]| |Destination: Not moved to the software structures, but used for validation of GEO_CODE. Validation: Must be a valid state code or province code, for the country indicated on [P2K_CM_STATE_PROVINCES]. If you provide a STATE_PROVINCE_CODE, then you must provide a COUNTRY_CODE.
|[COUNTRY_CODE]|Varchar2(16)|[CODE]| |Destination: Not moved to the software structures, but used for validation of STATE_PROVINCE. 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].
|[STATE_PROVINCE_CODE]|Varchar2(16)|[CODE]| |Destination: Not moved to the software structures, but used for validation of [GEO_CODE]. Validation: Must be a valid state code or province code, for the country indicated on [P2K_CM_STATE_PROVINCES]. If you provide a STATE_PROVINCE_CODE, then you must provide a COUNTRY_CODE.
At line 44 changed 2 lines
|[AUTHORIZATION_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENTS.DAA_ID and P2K_HR_ASSIGNMENT_DETAILS.DAA_ID
Validation: The Authorization Code provided must be defined on [P2K_CM_AUTHORIZATIONS]. Derivation: The authorization code is derived from the authorization defined for the position. If there is no position defined, then the code is derived from the department.
|[AUTHORIZATION_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENTS.DAA_ID and P2K_HR_ASSIGNMENT_DETAILS.DAA_ID Validation: The Authorization Code provided must be defined on [P2K_CM_AUTHORIZATION_AREAS]. Derivation: The authorization code is derived from the authorization defined for the position. If there is no position defined, then the code is derived from the department.
At line 49 changed 4 lines
|[PERSON_CODE_SUPERVISED_BY]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.EID_ID_SUPERVISED_ID Validation: Must be an employee who has already been defined on [P2K_CM_IDENTITIES]
|[RANGE_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.SSR_ID Validation: The Range Code provided must be defined on [P2K_SA_RANGES]. Derivation: The range code is derived from the range code specified for the position. If no position is specified, then it is taken from the job definition.
|[SCALE_CODE]|Varchar2(16)|[CODE]| |Destination: Not moved to the [P2K_CM_LOCATIONS] table, but used for validation of STEP_CODE. Validation: The Scale Code provided must be defined on [P2K_SA_WAGE_SCALES] Derivation: The scale code is derived from the scale code specified for the position. If no position is specified, then it is taken from the job definition
|[STEP_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.DWSS_ID Validation: The Step Code provided must be defined on [P2K_SA_WAGE_SCALES] for the SCALE_CODE provided. Derivation: The step code is derived from the step code specified for the position. If no position is specified, then it is taken from the job definition
|[PERSON_CODE_SUPERVISED_BY]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.EID_ID_SUPERVISED_ID Validation: Must be an employee who has already been defined on [P2K_HR_IDENTITIES]
|[RANGE_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.SSR_ID Validation: The Range Code provided must be defined on [P2K_SA_SALARY_RANGES]. Derivation: The range code is derived from the range code specified for the position. If no position is specified, then it is taken from the job definition.
|[SCALE_CODE]|Varchar2(16)|[CODE]| |Destination: Not moved to the [P2K_CM_LOCATIONS] table, but used for validation of [STEP_CODE]. Validation: The Scale Code provided must be defined on [P2K_SA_WAGE_SCALES] Derivation: The scale code is derived from the scale code specified for the position. If no position is specified, then it is taken from the job definition
|[STEP_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.DWSS_ID Validation: The Step Code provided must be defined on [P2K_SA_WAGE_SCALES] for the [SCALE_CODE] provided. Derivation: The step code is derived from the step code specified for the position. If no position is specified, then it is taken from the job definition
At line 62 changed 2 lines
|[USE_FTE_WAGES]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.USE_FTE_WAGES
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. Derivation: This toggle’s value is taken from that specified for the position. If there is no position specified, then the value is taken from the group definition.
|[USE_FTE_WAGES]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.USE_FTE_WAGES 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. Derivation: This toggle’s value is taken from that specified for the position. If there is no position specified, then the value is taken from the group definition.
At line 65 changed 6 lines
|[RATE_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.RATE_BASIS
Validation: If provided, must be one of the fixed lexicon values from [X_RATE_BASIS]. Derivation: The rate basis is taken from the wage rate specified on the scale/step code, if specified. If there is no scale/step code specified, then the rate basis is taken from the position. If there is no position specified (or no rate basis on the position record), then it is derived from the job definition. Suggestion: Do not provide a Rate_Basis without a Wage_Rate, as the derived rate basis may not be the one you intend
|[OUT_OF_RANGE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.OUT_OF_RANGE
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.
|[SCALE_OVERRIDDEN]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.SCALE_OVERRIDDEN
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.
|[RATE_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.RATE_BASIS Validation: If provided, must be one of the fixed lexicon values from [X_RATE_BASIS]. Derivation: The rate basis is taken from the wage rate specified on the scale/step code, if specified. If there is no scale/step code specified, then the rate basis is taken from the position. If there is no position specified (or no rate basis on the position record), then it is derived from the job definition. Suggestion: Do not provide a Rate_Basis without a Wage_Rate, as the derived rate basis may not be the one you intend
|[OUT_OF_RANGE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.OUT_OF_RANGE 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.
|[SCALE_OVERRIDDEN]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.SCALE_OVERRIDDEN 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.
At line 74 changed 2 lines
|[PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.PHONE_NUMBER
Validation: Must be formatted in the correct format, for the country indicated by the physical location. Derivation: This phone number is derived from the phone number defined for the department.
|[PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.PHONE_NUMBER Validation: Must be formatted in the correct format, for the country indicated by the physical location. Derivation: This phone number is derived from the phone number defined for the department.
At line 94 changed 2 lines
|[PREMIUM_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_SA_PREMIUM_USAGES.SPM_ID Validation: Must be a valid premium defined on P2K_SA_PREMIUMS, and may not have already been defined for this job, effective at the same time.
|[PREMIUM_RATE_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |Destination: P2K_SA_PREMIUM_USAGES.PREMIUM_RATE_BASIS Validation: If provided, must be one of the fixed lexicon values from [X_PREMIUM_RATE_BASIS]
|[PREMIUM_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_SA_PREMIUM_USAGES.SPM_ID Validation: Must be a valid premium defined on [P2K_SA_PREMIUMS], and may not have already been defined for this job, effective at the same time.
|[PREMIUM_RATE_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |Destination: P2K_SA_PREMIUM_USAGES.PREMIUM_RATE_BASIS Validation: If provided, must be one of the fixed lexicon values from [X_RATE_BASIS]
At line 98 changed one line
|[DISTRIBUTION_CODE]|Varchar2(50)|[DISTRIBUTION]| |Destination: P2K_CM_DISTRIBUTIONS.DISTRIBUTION_CODE Validation: The DISTRIBUTION_MASK is validated against the DISTRIBUTION_FORMAT specified for the GLCOMPANY that is associated with the ENTITY_CODE_SUB_DIVISION
|[DISTRIBUTION_CODE]|Varchar2(50)|[DISTRIBUTION]| |Destination: P2K_CM_DISTRIBUTIONS.DISTRIBUTION_CODE Validation: The [DISTRIBUTION_MASK] is validated against the [DISTRIBUTION_FORMAT] specified for the GLCOMPANY that is associated with the ENTITY_CODE_SUB_DIVISION
This page (revision-19) was last changed on 26-Nov-2021 10:22 by rforbesTop