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
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top