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 (Field) | Varchar2(16) | Validation: Must be a Work Rule Code defined on P2K_CM_WORK_RULES. Derivation: If not provided, WORK_RULE (Field) 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 (Field). 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 (Field). 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 (Field). 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) | Four character alphanumeric field used to enter additional information. | |
| START_DATE | Date() | ||
| END_DATE | Date() | ||
| GL_FUND_CODE | Varchar2(16) | ||
| USER_PERCENT | Number(5) | ||
| USER_FIELD_VALUE_01 | Varchar2(2000) | Looking for DPS01 defined on IMUF | |
| USER_FIELD_VALUE_02 | Varchar2(2000) | Looking for DPS02 defined on IMUF | |
| USER_FIELD_VALUE_03 | Varchar2(2000) | Looking for DPS03 defined on IMUF | |
| USER_FIELD_VALUE_04 | Varchar2(2000) | Looking for DPS04 defined on IMUF | |
| USER_FIELD_VALUE_05 | Varchar2(2000) | Looking for DPS05 defined on IMUF | |
| USER_FIELD_VALUE_06 | Varchar2(2000) | Looking for DPS06 defined on IMUF | |
| USER_FIELD_VALUE_07 | Varchar2(2000) | Looking for DPS07 defined on IMUF | |
| USER_FIELD_VALUE_08 | Varchar2(2000) | Looking for DPS08 defined on IMUF | |
| USER_FIELD_VALUE_09 | Varchar2(2000) | Looking for DPS09 defined on IMUF | |
| USER_FIELD_VALUE_10 | 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. |
Notes #
Click to create a new notes pageScreen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation