Alias: IVDPS#

(INF_CV_POSITIONS)
Holds Date Effective information about a position.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
POSITION_CODEVarchar2(16)CODEY
STANDINGVarchar2(30)VARCHAR30
GENERIC_CODEVarchar2(4)VARCHAR4
POSITION_CODE_GROUPINGVarchar2(16)CODE
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRY
CHANGE_CODEVarchar2(16)CODE
UNIT_CODEVarchar2(16)CODE
DEPARTMENT_CODEVarchar2(16)CODE
LOCATION_CODEVarchar2(16)CODE
GROUP_CODEVarchar2(16)CODE
JOB_CODEVarchar2(16)CODE
PERSON_CODEVarchar2(16)CODE
RANGE_CODEVarchar2(16)CODE
WORK_RULE_CODEVarchar2(16)CODE
POSITION_CODE_REPORTING_TOVarchar2(16)CODE
AUTHORIZATION_CODEVarchar2(16)CODE
SCALE_CODEVarchar2(16)CODE
STEP_CODEVarchar2(16)CODE
POSITION_TITLEVarchar2(50)DESCRIPTION
DESCRIPTION_1Varchar2(50)DESCRIPTION
DESCRIPTION_2Varchar2(50)DESCRIPTION
POSITION_TYPEVarchar2(30)VARCHAR30
WCB_CLASSVarchar2(30)VARCHAR30
LANGUAGE_CLASSVarchar2(30)VARCHAR30
ORG_CHART_LEVELVarchar2(30)VARCHAR30
RESPONSIBILITY_LEVELVarchar2(30)VARCHAR30
STD_HOURS_PER_DAYNumber(9)AMT5V4
STD_HOURS_PER_WEEKNumber(9)AMT5V4
STD_HOURS_PER_PAYNumber(9)AMT5V4
POSITION_POINTSNumber(5)NUMBER5
USE_FTE_WAGESVarchar2(4)VARCHAR4
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(30)VARCHAR30
OVERTIME_EXEMPTVarchar2(4)VARCHAR4
DIRECT_CHARGEVarchar2(4)VARCHAR4
ASSIGNMENT_REQUIREDVarchar2(4)VARCHAR4
POSITION_STATUSVarchar2(30)VARCHAR30
BUDGET_RULEVarchar2(30)VARCHAR30
AUTHORIZED_FTENumber(9)AMT5V4
FTE_OVERRIDE_RULEVarchar2(30)VARCHAR30
APPROVED_DATEDate()DATE
APPROVED_BYVarchar2(50)VARCHAR50
LAST_REVIEW_DATEDate()DATE
SUSPENDED_DATEDate()DATE
ABOLISHED_DATEDate()DATE
LEGISLATIONVarchar2(30)VARCHAR30
OCCUPATION_GROUPVarchar2(30)VARCHAR30
OCCUPATION_CODEVarchar2(16)CODE
INDUSTRY_CODEVarchar2(16)CODE
DEFAULT_FTENumber(9)AMT5V4
JOB_PROFILE_CODEVarchar2(16)CODE
PROVIDE_PUBLIC_SERVICEVarchar2(4)VARCHAR4
PROVIDE_INTERNAL_SERVICEVarchar2(4)VARCHAR4
SUPERVISORYVarchar2(4)VARCHAR4
PAYDEST_LOCATION_CODEVarchar2(16)CODE
PREMIUM_CODEVarchar2(16)CODE
PREMIUM_RATE_BASISVarchar2(30)VARCHAR30
PREMIUM_RATENumber(18)AMT12V6
SPLIT_SEQUENCENumber(5)NUMBER5
DISTRIBUTION_CODEVarchar2(50)DISTRIBUTION
SPLIT_RULEVarchar2(30)VARCHAR30
SPLIT_PERCENTNumber(5)PERCENT
SPLIT_AMOUNTNumber(18)AMT12V6
ADDITIONALVarchar2(4)VARCHAR4
START_DATEDate()DATE
END_DATEDate()DATE
GL_FUND_CODEVarchar2(16)CODE
USER_PERCENTNumber(5)PERCENT
USER_FIELD_VALUE_01Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_02Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_03Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_04Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_05Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_06Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_07Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_08Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_09Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_10Varchar2(2000)VARCHAR2000
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30