INF_CV_JOBS
Back to current versionRestore this version

Alias: IVDJB#

The INF_CV_JOBS table is used to import job codes and their attendant data into the software data structures. A job is used to describe a function, task or role that is a recognized requirement within the organization. A job is always associated with a unit which determines the employment rules applicable to the job. Jobs are usually generic in nature and the same job may be done by many different people.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
UNIT_CODEVarchar2(16)CODEY
JOB_CODEVarchar2(16)CODEY
STANDINGVarchar2(30)VARCHAR30
GENERIC_CODEVarchar2(4)VARCHAR4
JOB_CODE_GROUPINGVarchar2(16)CODE
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRY
CHANGE_CODEVarchar2(16)CODE
JOB_TITLEVarchar2(50)DESCRIPTION
OCCUPATION_CODEVarchar2(16)CODE
RANGE_CODEVarchar2(16)CODE
WORK_RULE_CODEVarchar2(16)CODE
SCALE_CODEVarchar2(16)CODE
STEP_CODEVarchar2(16)CODE
DESCRIPTION_1Varchar2(50)DESCRIPTION
DESCRIPTION_2Varchar2(50)DESCRIPTION
JOB_TYPEVarchar2(30)VARCHAR30
JOB_CLASSVarchar2(30)VARCHAR30
WCB_CLASSVarchar2(30)VARCHAR30
EEO_CATEGORYVarchar2(30)VARCHAR30
STD_HOURS_PER_DAYNumber(9)AMT5V4
STD_HOURS_PER_WEEKNumber(9)AMT5V4
STD_HOURS_PER_PAYNumber(9)AMT5V4
JOB_POINTSNumber(5)NUMBER5
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(30)VARCHAR30
OVERTIME_EXEMPTVarchar2(4)VARCHAR4
DIRECT_CHARGEVarchar2(4)VARCHAR4
ASSIGNMENT_REQUIREDVarchar2(4)VARCHAR4
JOB_PROFILE_CODEVarchar2(16)CODE
PROFILE_USER_NAMEVarchar2(30)VARCHAR30
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