!!!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|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.INF_CV_POSITIONS] [{InsertPage page='Internal.INF_CV_POSITIONS' default='Click to create a new discussion page'}] }]