!!!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|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)| | 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|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.
|[POSITION_TITLE_TRANS]|VARCHAR2(4000)| |
|[TRANS_LANGUAGE]|VARCHAR2(30)| |



----
![Notes|Edit:Internal.INF_CV_POSITIONS] 	
[{InsertPage page='Internal.INF_CV_POSITIONS' default='Click to create a new notes page'}]