INF_CV_POSITIONS
Back to current versionRestore this version

Alias: IVDPS#

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.

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation