Alias: IVDPS#
(INF_CV_POSITIONS)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 | 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. | |
| 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 | Varchar2(2000) | ||
| USER_FIELD_VALUE_02 | Varchar2(2000) | ||
| USER_FIELD_VALUE_03 | Varchar2(2000) | ||
| USER_FIELD_VALUE_04 | Varchar2(2000) | ||
| USER_FIELD_VALUE_05 | Varchar2(2000) | ||
| USER_FIELD_VALUE_06 | Varchar2(2000) | ||
| USER_FIELD_VALUE_07 | Varchar2(2000) | ||
| USER_FIELD_VALUE_08 | Varchar2(2000) | ||
| USER_FIELD_VALUE_09 | Varchar2(2000) | ||
| USER_FIELD_VALUE_10 | Varchar2(2000) | ||
| 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. |
