!!!Alias: IVDPS (INF_CV_POSITIONS) \\ Holds Date Effective information about a position. !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]| | |[ENTITY_CODE]|Varchar2(16)|[CODE]|Y| |[POSITION_CODE]|Varchar2(16)|[CODE]|Y| |[STANDING]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[GENERIC_CODE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[POSITION_CODE_GROUPING]|Varchar2(16)|[CODE]| | |[EFFECTIVE]|Date()|[EFFECTIVE]|Y| |[EXPIRY]|Date()|[EXPIRY]| | |[CHANGE_CODE]|Varchar2(16)|[CODE]| | |[UNIT_CODE]|Varchar2(16)|[CODE]| | |[DEPARTMENT_CODE]|Varchar2(16)|[CODE]| | |[LOCATION_CODE]|Varchar2(16)|[CODE]| | |[GROUP_CODE]|Varchar2(16)|[CODE]| | |[JOB_CODE]|Varchar2(16)|[CODE]| | |[PERSON_CODE]|Varchar2(16)|[CODE]| | |[RANGE_CODE]|Varchar2(16)|[CODE]| | |[WORK_RULE_CODE]|Varchar2(16)|[CODE]| | |[POSITION_CODE_REPORTING_TO]|Varchar2(16)|[CODE]| | |[AUTHORIZATION_CODE]|Varchar2(16)|[CODE]| | |[SCALE_CODE]|Varchar2(16)|[CODE]| | |[STEP_CODE]|Varchar2(16)|[CODE]| | |[POSITION_TITLE]|Varchar2(50)|[DESCRIPTION]| | |[DESCRIPTION_1]|Varchar2(50)|[DESCRIPTION]| | |[DESCRIPTION_2]|Varchar2(50)|[DESCRIPTION]| | |[POSITION_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[WCB_CLASS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[LANGUAGE_CLASS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[ORG_CHART_LEVEL]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[RESPONSIBILITY_LEVEL]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[STD_HOURS_PER_DAY]|Number(9)|[AMT5V4|AMTnn]| | |[STD_HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| | |[STD_HOURS_PER_PAY]|Number(9)|[AMT5V4|AMTnn]| | |[POSITION_POINTS]|Number(5)|[NUMBER5|NUMBERn]| | |[USE_FTE_WAGES]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| | |[RATE_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[OVERTIME_EXEMPT]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[DIRECT_CHARGE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[ASSIGNMENT_REQUIRED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[POSITION_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[BUDGET_RULE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[AUTHORIZED_FTE]|Number(9)|[AMT5V4|AMTnn]| | |[FTE_OVERRIDE_RULE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[APPROVED_DATE]|Date()|[DATE]| | |[APPROVED_BY]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[LAST_REVIEW_DATE]|Date()|[DATE]| | |[SUSPENDED_DATE]|Date()|[DATE]| | |[ABOLISHED_DATE]|Date()|[DATE]| | |[LEGISLATION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[OCCUPATION_GROUP]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[OCCUPATION_CODE]|Varchar2(16)|[CODE]| | |[INDUSTRY_CODE]|Varchar2(16)|[CODE]| | |[DEFAULT_FTE]|Number(9)|[AMT5V4|AMTnn]| | |[JOB_PROFILE_CODE]|Varchar2(16)|[CODE]| | |[PROVIDE_PUBLIC_SERVICE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[PROVIDE_INTERNAL_SERVICE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[SUPERVISORY]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[PAYDEST_LOCATION_CODE]|Varchar2(16)|[CODE]| | |[PREMIUM_CODE]|Varchar2(16)|[CODE]| | |[PREMIUM_RATE_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[PREMIUM_RATE]|Number(18)|[AMT12V6|AMTnn]| | |[SPLIT_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| | |[DISTRIBUTION_CODE]|Varchar2(50)|[DISTRIBUTION]| | |[SPLIT_RULE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[SPLIT_PERCENT]|Number(5)|[PERCENT]| | |[SPLIT_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[ADDITIONAL]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[START_DATE]|Date()|[DATE]| | |[END_DATE]|Date()|[DATE]| | |[GL_FUND_CODE]|Varchar2(16)|[CODE]| | |[USER_PERCENT]|Number(5)|[PERCENT]| | |[USER_FIELD_VALUE_01]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[USER_FIELD_VALUE_02]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[USER_FIELD_VALUE_03]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[USER_FIELD_VALUE_04]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[USER_FIELD_VALUE_05]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[USER_FIELD_VALUE_06]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[USER_FIELD_VALUE_07]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[USER_FIELD_VALUE_08]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[USER_FIELD_VALUE_09]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[USER_FIELD_VALUE_10]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]| | |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CHANGE_DATE]|Date()|[DATE]| | |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |