The INF_CV_POSITIONS table is used to import position codes and their attendant data into the software data structures. Positions identify the need for a specific job to be done in a particular place in the organization.
Tables loaded:
*[P2K_CM_POSITIONS] (first record for each position code only)
*[P2K_CM_POSITION_DETAILS] (first record and subsequent effective splits)
*[P2K_SA_PREMIUM_USAGES] (one record for each premium code defined)
*[P2K_CM_DISTRIBUTIONS] (one record for each distribution split defined)
!!Table Columns
\\
||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|Validation: Must be a valid entity code defined on [P2K_CM_ENTITIES]
|[POSITION_CODE]|Varchar2(16)|Y|Validation: Must be a unique position code for the entity specified
|[STANDING]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_STANDING]. Suggestion: Normally, you would only load active positions, so you could populate this field with a constant value of “A”.
|[GENERIC_CODE]|Varchar2(4)| |
|[POSITION_CODE_GROUPING]|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 position 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 position 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]
|[UNIT_CODE]|Varchar2(16)| |Validation: Must be a valid entity code defined on [P2K_CM_UNITS].
|[DEPARTMENT_CODE]|Varchar2(16)| |Validation: Must be a valid position code defined on [P2K_CM_DEPARTMENTS].
|[LOCATION_CODE]|Varchar2(16)| |Validation: Must be a valid LOCATION_CODE defined on [P2K_CM_LOCATIONS]. Derivation: This field is derived from the [LOCATION_CODE] on the [P2K_CM_DEPARTMENT_DETAILS] table for the [DEPARTMENT_CODE] specified.
|[GROUP_CODE]|Varchar2(16)| |Validation: Must be a valid [GROUP_CODE] defined on [P2K_CM_GROUPS]
|[JOB_CODE]|Varchar2(16)| |Validation: Must be a valid [JOB_CODE] defined on [P2K_CM_JOBS]
|[PERSON_CODE]|Varchar2(16)| |Validation: The [PERSON_CODE] must be for a valid employee currently entered on [P2K_HR_IDENTITIES].
|[RANGE_CODE]|Varchar2(16)| |Validation: Must be a valid range code defined on [P2K_SA_SALARY_RANGES]. Derivation: If not specified, this field will be derived from [RANGE_CODE] as specified on the [P2K_CM_JOB_DETAILS] record for the related job
|[WORK_RULE_CODE]|Varchar2(16)| |Validation: Must be a Work Rule Code defined on [P2K_CM_WORK_RULES]. Derivation: If not provided, [WORK_RULE_CODE] will be derived from the value found on the indicated group record [P2K_CM_GROUP_DETAILS].
|[POSITION_CODE_REPORTING_TO]|Varchar2(16)| |Validation: Must be a valid position code already defined on [P2K_CM_POSITIONS]. Derivation: This field will be derived from the Position Code (DPS_ID) found on the [P2K_CM_DEPARTMENT_DETAILS] table, reflecting the manager of the department that is indicated on this position.
|[AUTHORIZATION_CODE]|Varchar2(16)| |Validation: Must be a valid Authorization Code defined on [P2K_CM_AUTHORIZATION_AREAS]. Derivation: If not specified, this field is derived from the [AUTHORIZATION_AREAS] specified on [P2K_CM_DEPARTMENT_DETAILS] for the [DEPARTMENT_CODE] specified.
|[SCALE_CODE]|Varchar2(16)| |Validation: Must be a valid scale code defined on [P2K_SA_WAGE_SCALES]
|[STEP_CODE]|Varchar2(16)| |Validation: Must be a valid step for the scale code defined on [P2K_SA_WAGE_SCALES]. Derivation: If not specified, this field will be derived from the [STEP_CODE] specified on the [P2K_CM_JOB_DETAILS] record referenced by the [JOB_CODE]
|[POSITION_TITLE]|Varchar2(50)| |Derivation: If not specified, this field will be derived from the [JOB_TITLE] for the specified JOB.
|[DESCRIPTION_1]|Varchar2(50)| |
|[DESCRIPTION_2]|Varchar2(50)| |
|[POSITION_TYPE]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_POSITION_TYPE]
|[WCB_CLASS]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_WCB_CLASS]. Derivation: If not provided, [WCB_CLASS] will be derived from the value found on the indicated [SCALE_CODE] / [STEP_CODE].
|[LANGUAGE_CLASS]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_LANGUAGE_CLASS]
|[ORG_CHART_LEVEL]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_ORG_CHART_LEVEL]
|[RESPONSIBILITY_LEVEL]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_RESPONSIBILITY_LEVEL]
|[STD_HOURS_PER_DAY]|Number(9)| |Validation: May not exceed 24. Derivation: If not provided, [STD_HOURS_PER_DAY] will be derived from the value found on the indicated [WORK_RULE_CODE]. If this value is NULL, then the [STD_HOURS_PER_DAY] will be derived from the value found on the indicated [GROUP_CODE]. If this value is NULL, then the [STD_HOURS_PER_DAY] will be derived from the value found on the [JOB_CODE].
|[STD_HOURS_PER_WEEK]|Number(9)| |Validation: May not exceed 168. Derivation: If not provided, [STD_HOURS_PER_WEEK] will be derived from the value found on the indicated [WORK_RULE_CODE]. If this value is NULL, then the [STD_HOURS_PER_WEEK] will be derived from the value found on the indicated [GROUP_CODE]. If this value is NULL, then the [STD_HOURS_PER_WEEK] will be derived from the value found on the [JOB_CODE].
|[STD_HOURS_PER_PAY]|Number(9)| |Validation: May not exceed 744. Derivation: If not provided, [STD_HOURS_PER_PAY] will be derived from the value found on the indicated [WORK_RULE_CODE]. If this value is NULL, then the [STD_HOURS_PER_PAY] will be derived from the value found on the indicated [GROUP_CODE]. If this value is NULL, then the [STD_HOURS_PER_PAY] will be derived from the value found on the [JOB_CODE].
|[POSITION_POINTS]|Number(5)| |
|[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: If not specified, this field will be derived from [USE_FTE_WAGES] as specified on the [P2K_CM_GROUP_DETAILS] record for the related job.
|[WAGE_RATE]|Number(18)| |Validation: May not be set to $0.00. Derivation: This field will be derived from the [WAGE_RATE] on the [P2K_SA_WAGE_SCALES], if a [SCALE_CODE] and [STEP_CODE] are provided. If not specified, the [WAGE_RATE] will then be derived from the [P2K_CM_JOB_DETAILS] record.
|[RATE_BASIS]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_RATE_BASIS]. Derivation: If not provided, [RATE_BASIS] will be derived from the value found on the indicated [SCALE_CODE] / [STEP_CODE]. If this value is NULL, then the [RATE_BASIS] will be derived from the value found on the indicated [JOB_CODE]. If this value is NULL, then the [RATE_BASIS] will be derived from the value found on the [RANGE_CODE]. Suggestion: Do not provide a Rate_Basis without a Wage_Rate, as the derived rate basis may not be the one you intend.
|[OVERTIME_EXEMPT]|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: If not specified, this field will be derived from [OVERTIME_EXEMPT] as specified on the [P2K_CM_JOB_DETAILS] record for the related job.
|[DIRECT_CHARGE]|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: If not specified, this field will be derived from [DIRECT_CHARGE] as specified on the [P2K_CM_JOB_DETAILS] record for the related job.
|[ASSIGNMENT_REQUIRED]|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: If not specified, this field will be derived from [ASSIGNMENT_REQUIRED] as specified on the [P2K_CM_JOB_DETAILS] record for the related job.
|[POSITION_STATUS]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from {X_POSITION_STATUS].
|[BUDGET_RULE]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_BUDGET_RULE].
|[AUTHORIZED_FTE]|Number(9)| |
|[FTE_OVERRIDE_RULE]|Varchar2(30)| |
|[APPROVED_DATE]|Date()| |Validation: Must be a valid date.
|[APPROVED_BY]|Varchar2(50)| |Suggestion: If you enter a value for this field, you should also set the STANDING to “A” – Active and enter a value for the APPROVED_DATE
|[LAST_REVIEW_DATE]|Date()| |Validation: Must be a valid date.
|[SUSPENDED_DATE]|Date()| |Validation: Must be a valid date. Suggestion: If you enter a value for this field, you should also set the STANDING to “O” – Obsolete
|[ABOLISHED_DATE]|Date()| |Validation: Must be a valid date. Suggestion: If you enter a value for this field, you should also set the STANDING to “O” – Obsolete
|[LEGISLATION]|Varchar2(30)| |
|[OCCUPATION_GROUP]|Varchar2(30)| |
|[OCCUPATION_CODE]|Varchar2(16)| |
|[INDUSTRY_CODE]|Varchar2(16)| |
|[DEFAULT_FTE]|Number(9)| |
|[JOB_PROFILE_CODE]|Varchar2(16)| |
|[PROVIDE_PUBLIC_SERVICE]|Varchar2(4)| |
|[PROVIDE_INTERNAL_SERVICE]|Varchar2(4)| |
|[SUPERVISORY]|Varchar2(4)| |
|[PAYDEST_LOCATION_CODE]|Varchar2(16)| |
|[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|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_CODE] 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: Must be either a valid lexicon code, or a valid lexicon description from [X_SPLIT_RULE]
|[SPLIT_PERCENT]|Number(5)| |. This value should only be specified when you have a [SPLIT_RULE] set to “01” – Split by Percent
|[SPLIT_AMOUNT]|Number(18)| |This value should only be specified when you have a [SPLIT_RULE] set to “02” – Split by Amount
|[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 DPS01 defined on [IMUF]
|[USER_FIELD_VALUE_02|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS02 defined on [IMUF]
|[USER_FIELD_VALUE_03|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS03 defined on [IMUF]
|[USER_FIELD_VALUE_04|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS04 defined on [IMUF]
|[USER_FIELD_VALUE_05|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS05 defined on [IMUF]
|[USER_FIELD_VALUE_06|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS06 defined on [IMUF]
|[USER_FIELD_VALUE_07|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS07 defined on [IMUF]
|[USER_FIELD_VALUE_08|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS08 defined on [IMUF]
|[USER_FIELD_VALUE_09|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS09 defined on [IMUF]
|[USER_FIELD_VALUE_10|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DPS10 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.
[{If var='loginstatus' contains 'authenticated'
----
![Discussion|Edit:Internal.IVDPS]
[{InsertPage page='Internal.IVDPS' default='Click to create a new discussion page'}]
}]