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 1 changed one line
!!!Alias: IVEAS
!!!Alias: [IVEAS]
At line 3 removed 2 lines
\\
Provides all of the details for the Assignment
At line 8 changed 6 lines
SQL Loader control file sample: ASSIGNMENTS.CTL, loading from ASSIGNMENTS.DAT
Tables loaded: \\
P2K_HR_ASSIGNMENTS (first record for each employee only\\
P2K_HR_ASSIGNMENT_DETAILS (first record and subsequent effective splits)\\
P2K_AM_USER_FIELD_VALUES (one for each user field value provided)
Tables loaded:
*[P2K_HR_ASSIGNMENTS] (first record for each employee only
*[P2K_HR_ASSIGNMENT_DETAILS] (first record and subsequent effective splits)
*[P2K_AM_USER_FIELD_VALUES] (one for each user field value provided)
At line 16 changed 101 lines
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]| |
|[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 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
|[TS_SENIORITY_DATE]|Date()|[DATE]| |
|[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]
|[UNIT_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.DUN_ID Validation: The Unit Code provided must be defined on [P2K_CM_UNITS].
|[JOB_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.DJB_ID Validation: The Job Code provided must be defined on [P2K_CM_JOBS]
|[LOCATION_CODE_WORK_IN]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENTS.DLN_ID_WORK_IN Validation: The Location Code provided must be defined on [P2K_CM_LOCATIONS]
|[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.
|[GEO_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.DTX_ID. 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.
|[GROUP_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.DGR_ID Validation: The Group Code provided must be defined on [P2K_CM_GROUPS]
|[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.
|[WORK_RULE_CODE]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.DWR_ID Validation: The work rule code provided must be defined on [P2K_CM_WORK_RULES]. Derivation: This field is derived from the work rule defined for the position. If there is no work rule specified for the position, then the work rule is taken from the group. If there is no work rule defined on the group, then it is taken from the job definition.
|[LOCATION_CODE_PAYDEST]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.DLN_ID_PAYDEST. Validation: The Location Code provided must be defined on [P2K_CM_LOCATIONS]
|[PERSON_CODE_REPLACED_BY]|Varchar2(16)|[CODE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.EID_ID_REPLACED_BY
|[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
|[FTE]|Number(9)|[AMT5V4|AMTnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.FTE
|[WORK_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.WORK_TYPE
|[WCB_CLASS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.WCB_CLASS Validation: If provided, must be one of the values defined for the [X_WCB_CLASS] lexicon
|[HOURS_PER_DAY]|Number(9)|[AMT5V4|AMTnn]| |Destination: P2K_CM_ASSIGNMENT_DETAILS.HOURS_PER_DAY Validation: May not exceed 24. Derivation: The hours worked per day is derived from the value defined for the work rule specified. If there is no value defined for the work rule, then the value is derived from the position code. If there is no position code, then the value is derived from the group. Finally, if there is no value defined on the group, the hours per day is derived from the value for the job.
|[HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| |Destination: P2K_CM_ASSIGNMENT_DETAILS.HOURS_PER_DAY Validation: May not exceed 168.Derivation: The hours worked per week is derived from the value defined for the work rule specified. If there is no value defined for the work rule, then the value is derived from the position code. If there is no position code, then the value is derived from the group. Finally, if there is no value defined on the group, the hours per week is derived from the value for the job.
|[HOURS_PER_PAY]|Number(9)|[AMT5V4|AMTnn]| |Destination: P2K_CM_ASSIGNMENT_DETAILS.HOURS_PER_PAY Validation: May not exceed 744. Derivation: The hours worked per pay is derived from the value defined for the work rule specified. If there is no value defined for the work rule, then the value is derived from the position code. If there is no position code, then the value is derived from the group. Finally, if there is no value defined on the group, the hours per pay is derived from the value for the job.
|[PERIODS_ELECTED]|Number(5)|[NUMBER5|NUMBERn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.PERIODS_ELECTED
|[CONTRACT_DAYS]|Number(9)|[AMT5V4|AMTnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.CONTRACT_DAYS
|[CONTRACT_LIMIT]|Number(18)|[AMT12V6|AMTnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.CONTRACT_LIMIT
|[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.
|[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.WAGE_RATE. Derivation: The wage rate is taken from the wage rate specified on the scale/step code, if specified. If there is no scale/step code specified, then the wage is taken from the position. If there is no position specified (or no wage on the position record), then it is derived from the job definition. Suggestion: Do not provide a Wage_Rate without a Rate_Basis, as the derived rate basis may not be the one you intend.
|[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.
|[ASSIGNMENT_TITLE]|Varchar2(50)|[DESCRIPTION]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.ASSIGNMENT_TITLE. Derivation: The assignment title is derived from the position title specified for the position. If no position is specified, then it is taken from the job title on the job definition
|[JOB_SENIORITY_DATE]|Date()|[DATE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.JOB_SENIORITY_DATE Validation: Must be a valid date
|[RESPONSIBILITY_LEVEL]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | Destination: P2K_HR_ASSIGNMENT_DETAILS.RESPONSIBILITY_LEVEL Derivation: The responsibility level is taken from the responsibility level defined for the position. If there is no position defined, then it is derived from the department specified
|[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_EXTENSION]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.PHONE_EXTENSION. Derivation: This phone extension is derived from the phone extension defined for the department
|[EMAIL_ADDRESS]|Varchar2(50)|[EMAIL]| |Destination: P2K_HR_EMPLOYMENT_DETAILS.EMAIL_ADDRESS Derivation: This e-mail address is derived from thee-mail address defined for the department
|[SERVICE_RATING]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |Destination: P2K_ HR_ASSIGNMENT_DETAILS.SERVICE_RATING. Validation: If provided, must be one of the fixed lexicon values from [X_SERVICE_RATING]
|[LEAVE_DATE]|Date()|[DATE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.LEAVE_DATE
|[LEAVE_RETURN_DATE]|Date()|[DATE]| |Destination: P2K_HR_ASSIGNMENT_DETAILS.LEAVE_RETURN_DATE
|[LEAVE_REASON]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |Destination: P2K_ HR_ASSIGNMENT_DETAILS.LEAVE_REASON Validation: Must be either a valid lexicon code, or a valid lexicon description
|[PAY_STARTING_DATE]|Date()|[DATE]| |
|[TRIGGER_RETRO]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[PROVIDE_PUBLIC_SERVICE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[PROVIDE_INTERNAL_SERVICE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[SUPERVISORY]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[BURDEN_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[BURDEN_PERCENT]|Number(18)|[AMT12V6|AMTnn]| |
|[LONG_TERM_ASSIGNMENT]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[REQUIRES_TIME_SHEET]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[JOB_PROFILE_CODE]|Varchar2(16)|[CODE]| |
|[WORK_CALENDAR_CODE]|Varchar2(16)|[CODE]| |
|[WEB_PAY_STUB_ONLY]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[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]
|[PREMIUM_RATE]|Number(18)|[AMT12V6|AMTnn]| |Destination: P2K_SA_PREMIUM_USAGES.PREMIUM_RATE
|[SPLIT_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| |Destination: P2K_CM_DISTRIBUTIONS.SPLIT_SEQUENCE
|[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
|[SPLIT_RULE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |Destination: P2K_CM_DISTRIBUTIONS.SPLIT_RULE Validation: If provided, must be one of the fixed lexicon values from [X_SPLIT_RULE]
|[SPLIT_PERCENT]|Number(5)|[PERCENT]| |Destination: P2K_CM_DISTRIBUTIONS.SPLIT_PERCENT
|[SPLIT_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |Destination: P2K_CM_DISTRIBUTIONS.SPLIT_AMOUNT
|[ADDITIONAL]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[START_DATE]|Date()|[DATE]| |
|[END_DATE]|Date()|[DATE]| |
|[GL_FUND_CODE]|Varchar2(16)|[CODE]| |
|[USER_PERCENT]|Number(5)|[PERCENT]| |
|[USER_FIELD_VALUE_01]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_02]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_03]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_04]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_05]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_06]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_07]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_08]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_09]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_10]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_11]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_12]|Varchar2(2000)|[VARCHAR2000|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.
|[ENTITY_CODE]|Varchar2(16)|Y|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)|Y|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)| |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()| |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)|Y| Suggestion:Set the Assignment Code to be the same as the assignment type.
|[ASSIGNMENT_TYPE]|Varchar2(30)| | Validation: If provided, must be a value from the [X_ASSIGN_TYPE] fixed lexicon
|[ASSIGNMENT_STATUS]|Varchar2(30)| | Validation: If provided, must be a value from the [X_ASSIGN_STATUS] fixed lexicon
|[ASSIGNMENT_START_DATE]|Date()| |Validation: Must be a valid date.
|[ASSIGNMENT_END_DATE]|Date()| | Validation: Must be a valid date.\\If you are converting in a terminated employee, then this date must match the termination_date.
|[PRIME_ASSIGNMENT]|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.
|[DESCRIPTION]|Varchar2(50)| |
|[NEXT_REVIEW_DATE]|Date()| |
|[TS_SENIORITY_DATE]|Date()| |
|[EFFECTIVE]|Date()| |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()|Y| 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)| | Validation: The Change Code provided must be defined on [P2K_CM_CHANGE_REASONS].
|[STATUS_CODE]|Varchar2(16)| | Validation: Must be an Employment Status code defined on [P2K_CM_EMPLOYMENT_STATUSES].
|[POSITION_CODE]|Varchar2(16)| | Validation: The Position Code provided must be defined on [P2K_CM_POSITIONS]
|[DEPARTMENT_CODE]|Varchar2(16)| | Validation: The Department Code provided must be defined on [P2K_CM_DEPARTMENTS]
|[UNIT_CODE]|Varchar2(16)| | Validation: The Unit Code provided must be defined on [P2K_CM_UNITS].
|[JOB_CODE]|Varchar2(16)| | Validation: The Job Code provided must be defined on [P2K_CM_JOBS]
|[LOCATION_CODE_WORK_IN]|Varchar2(16)| |Validation: The Location Code provided must be defined on [P2K_CM_LOCATIONS]
|[COUNTRY_CODE]|Varchar2(16)| |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)| | 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].
|[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.
|[GROUP_CODE]|Varchar2(16)| | Validation: The Group Code provided must be defined on [P2K_CM_GROUPS]
|[AUTHORIZATION_CODE]|Varchar2(16)| | 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.
|[WORK_RULE (Field)]|Varchar2(16)| | Validation: The work rule code provided must be defined on [P2K_CM_WORK_RULES]. Derivation: This field is derived from the work rule defined for the position. If there is no work rule specified for the position, then the work rule is taken from the group. If there is no work rule defined on the group, then it is taken from the job definition.
|[LOCATION_CODE_PAYDEST]|Varchar2(16)| | Validation: The Location Code provided must be defined on [P2K_CM_LOCATIONS]
|[PERSON_CODE_REPLACED_BY]|Varchar2(16)| |
|[PERSON_CODE_SUPERVISED_BY]|Varchar2(16)| | Validation: Must be an employee who has already been defined on [P2K_HR_IDENTITIES]
|[RANGE_CODE]|Varchar2(16)| | 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)| | 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)| | 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
|[FTE]|Number(9)| |
|[WORK_TYPE]|Varchar2(30)| |
|[WCB_CLASS]|Varchar2(30)| | Validation: If provided, must be one of the values defined for the [X_WCB_CLASS] lexicon
|[HOURS_PER_DAY]|Number(9)| | Validation: May not exceed 24. Derivation: The hours worked per day is derived from the value defined for the work rule specified. If there is no value defined for the work rule, then the value is derived from the position code. If there is no position code, then the value is derived from the group. Finally, if there is no value defined on the group, the hours per day is derived from the value for the job.
|[HOURS_PER_WEEK]|Number(9)| | Validation: May not exceed 168.Derivation: The hours worked per week is derived from the value defined for the work rule specified. If there is no value defined for the work rule, then the value is derived from the position code. If there is no position code, then the value is derived from the group. Finally, if there is no value defined on the group, the hours per week is derived from the value for the job.
|[HOURS_PER_PAY]|Number(9)| | Validation: May not exceed 744. Derivation: The hours worked per pay is derived from the value defined for the work rule specified. If there is no value defined for the work rule, then the value is derived from the position code. If there is no position code, then the value is derived from the group. Finally, if there is no value defined on the group, the hours per pay is derived from the value for the job.
|[PERIODS_ELECTED]|Number(5)| |
|[CONTRACT_DAYS]|Number(9)| |Note: Only provide this field if you are using the teacher contract processing logic. Otherwise leave this field NULL (or do not provide it)
|[CONTRACT_LIMIT]|Number(18)| |Note: Only provide this field if you are using the teacher contract processing logic. Otherwise leave this field NULL (or do not provide it)
|[USE_FTE_WAGES]|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. 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.
|[WAGE_RATE]|Number(18)| | Derivation: The wage rate is taken from the wage rate specified on the scale/step code, if specified. If there is no scale/step code specified, then the wage is taken from the position. If there is no position specified (or no wage on the position record), then it is derived from the job definition. Suggestion: Do not provide a Wage_Rate without a Rate_Basis, as the derived rate basis may not be the one you intend.
|[RATE_BASIS]|Varchar2(30)| | 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)| | 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)| | 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.
|[ASSIGNMENT_TITLE]|Varchar2(50)| | Derivation: The assignment title is derived from the position title specified for the position. If no position is specified, then it is taken from the job title on the job definition
|[JOB_SENIORITY_DATE]|Date()| | Validation: Must be a valid date
|[RESPONSIBILITY_LEVEL]|Varchar2(30)| | Derivation: The responsibility level is taken from the responsibility level defined for the position. If there is no position defined, then it is derived from the department specified
|[PHONE_NUMBER]|Varchar2(20)| | 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_EXTENSION]|Varchar2(16)| | Derivation: This phone extension is derived from the phone extension defined for the department
|[EMAIL_ADDRESS(Field)]|Varchar2(50)| | Derivation: This e-mail address is derived from thee-mail address defined for the department
|[SERVICE_RATING]|Varchar2(30)| | Validation: If provided, must be one of the fixed lexicon values from [X_SERVICE_RATING]
|[LEAVE_DATE]|Date()| |
|[LEAVE_RETURN_DATE]|Date()| |
|[LEAVE_REASON]|Varchar2(30)| | Validation: Must be either a valid lexicon code, or a valid lexicon description
|[PAY_STARTING_DATE]|Date()| |
|[TRIGGER_RETRO]|Varchar2(4)| |
|[PROVIDE_PUBLIC_SERVICE]|Varchar2(4)| |
|[PROVIDE_INTERNAL_SERVICE]|Varchar2(4)| |
|[SUPERVISORY]|Varchar2(4)| |
|[BURDEN_METHOD]|Varchar2(30)| |
|[BURDEN_PERCENT]|Number(18)| |
|[LONG_TERM_ASSIGNMENT]|Varchar2(4)| |
|[REQUIRES_TIME_SHEET]|Varchar2(4)| |
|[JOB_PROFILE_CODE]|Varchar2(16)| |
|[WORK_CALENDAR_CODE]|Varchar2(16)| |
|[WEB_PAY_STUB_ONLY]|Varchar2(4)| |
|[PREMIUM_CODE]|Varchar2(16)| | 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)| | Validation: If provided, must be one of the fixed lexicon values from [X_RATE_BASIS]
|[PREMIUM_RATE]|Number(18)| |
|[SPLIT_SEQUENCE]|Number(5)| |
|[DISTRIBUTION_CODE]|Varchar2(50)| | Validation: The [DISTRIBUTION_MASK] is validated against the [DISTRIBUTION_FORMAT] specified for the GLCOMPANY that is associated with the [ENTITY_CODE_SUB_DIVISION|ENTITY_CODE]
|[SPLIT_RULE]|Varchar2(30)| | Validation: If provided, must be one of the fixed lexicon values from [X_SPLIT_RULE]
|[SPLIT_PERCENT]|Number(5)| |
|[SPLIT_AMOUNT]|Number(18)| |
|[ADDITIONAL]|Varchar2(4)| |
|[START_DATE]|Date()| |
|[END_DATE]|Date()| |
|[GL_FUND_CODE]|Varchar2(16)| |
|[USER_PERCENT]|Number(5)| |
|[USER_FIELD_VALUE_01|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EAS01 defined on [IMUF]
|[USER_FIELD_VALUE_02|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EAS02 defined on [IMUF]
|[USER_FIELD_VALUE_03|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EAS03 defined on [IMUF]
|[USER_FIELD_VALUE_04|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EAS04 defined on [IMUF]
|[USER_FIELD_VALUE_05|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EAS05 defined on [IMUF]
|[USER_FIELD_VALUE_06|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EAS06 defined on [IMUF]
|[USER_FIELD_VALUE_07|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EAS07 defined on [IMUF]
|[USER_FIELD_VALUE_08|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EAS08 defined on [IMUF]
|[USER_FIELD_VALUE_09|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EAS09 defined on [IMUF]
|[USER_FIELD_VALUE_10|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EAS10 defined on [IMUF]
|[USER_FIELD_VALUE_11|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EAS11 defined on [IMUF]
|[USER_FIELD_VALUE_12|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EAS12 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_ASSIGNMENTS]
[{InsertPage page='Internal.INF_CV_ASSIGNMENTS' default='Click to create a new notes page'}]
This page (revision-19) was last changed on 26-Nov-2021 10:22 by rforbesTop