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.  


;[ID|ID]|:
;[|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]
;[|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]
;[|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]:
;[|SCALE_CODE]|Varchar2(16)| |Validation:	Must be a valid scale code defined on [P2K_SA_WAGE_SCALES]
;[|STEP_CODE]
;[|POSITION_TITLE]:
;[|DESCRIPTION_1]|Varchar2(50)| |
;[|DESCRIPTION_2]|Varchar2(50)| |
;[|POSITION_TYPE]
;[|WCB_CLASS]
;[|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]:
;[|STD_HOURS_PER_WEEK]:
;[|STD_HOURS_PER_PAY]:
;[|POSITION_POINTS]:
;[|USE_FTE_WAGES]:
;[|WAGE_RATE]:
;[|RATE_BASIS]:
;[|OVERTIME_EXEMPT]:
;[|DIRECT_CHARGE]:
;[|ASSIGNMENT_REQUIRED]:
;[|POSITION_STATUS]:
;[|BUDGET_RULE]:
;[|AUTHORIZED_FTE]:
;[|FTE_OVERRIDE_RULE]:
;[|APPROVED_DATE]:
;[|APPROVED_BY]:
;[|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]:
;[|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]:
;[|SPLIT_RULE]:
;[|SPLIT_PERCENT]:
;[|SPLIT_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]:
;[|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]


[{If var='loginstatus' contains 'authenticated'

----
![Discussion|Edit:Internal.IVDPS] 	
[{InsertPage page='Internal.IVDPS' default='Click to create a new discussion page'}] 	

}]