INF_CV_JOBS
Back to current versionRestore this version

Alias: IVDJB#

(INF_CV_JOBS)

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.

Tables loaded:

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
ENTITY_CODEVarchar2(16)YValidation: Must be a valid entity code defined on P2K_CM_ENTITIES.
UNIT_CODEVarchar2(16)YValidation: Must be a valid unit code defined on P2K_CM_UNITS
JOB_CODEVarchar2(16)YValidation: Must be a unique job for this unit.
STANDINGVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from X_STANDING. Suggestion: Normally, you would only load active jobs, so you could populate this field with a constant value of “A”.
GENERIC_CODEVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True.
JOB_CODE_GROUPINGVarchar2(16)
EFFECTIVEDate()YValidation: Must be a valid date format. Suggestion: If you are not loading multiple date-effective records for the same job code, then populate this field with a constant ‘01-Jan-0001’ which represents the beginning of time.
EXPIRYDate() Validation: Must be a valid date format, with a date after the effective date. Suggestion: If you are not loading multiple date-effective records for the same job code, then populate this field with a constant ‘31-Dec-3999’ which represents the end of time.
CHANGE_CODEVarchar2(16) Validation: The Change Code provided must be defined on P2K_CM_CHANGE_REASONS
JOB_TITLEVarchar2(50)
OCCUPATION_CODEVarchar2(16) Validation: Must be a valid occupation code defined on P2K_CM_OCCUPATIONS
RANGE_CODEVarchar2(16) Validation: Must be a valid range code defined on P2K_SA_SALARY_RANGES
WORK_RULE (Field)Varchar2(16) Validation: Must be a Work Rule Code defined on P2K_CM_WORK_RULES.
SCALE_CODEVarchar2(16) Validation: Must be a valid scale code defined on P2K_SA_WAGE_SCALES
STEP_CODEVarchar2(16) Validation: Must be a valid step for the scale code defined on P2K_SA_WAGE_SCALES
DESCRIPTION_1Varchar2(50)
DESCRIPTION_2Varchar2(50)
JOB_TYPEVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from X_JOB_TYPE
JOB_CLASSVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from X_JOB_CLASS.
WCB_CLASSVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from X_WCB_CLASS
EEO_CATEGORYVarchar2(30) Validation: If provided, must be one of the lexicon values from X_EEO_CATEGORY
STD_HOURS_PER_DAYNumber(9) Validation: May not exceed 24. Derivation: This field will be derived from STD_HOURS_PER_DAY from P2K_CM_WORK_RULES for the WORK_RULE (Field) indicated, if it is specified
STD_HOURS_PER_WEEKNumber(9) Validation: May not exceed 168. Derivation: This field will be derived from STD_HOURS_PER_DAY from P2K_CM_WORK_RULES for the WORK_RULE (Field) indicated, if it is specified
STD_HOURS_PER_PAYNumber(9) Validation: May not exceed 744. Derivation: This field will be derived from STD_HOURS_PER_DAY from P2K_CM_WORK_RULES for the WORK_RULE (Field) indicated, if it is specified
JOB_POINTSNumber(5)
WAGE_RATENumber(18) Validation: May not be set to $0.00. Derivation: This field will be derived from the WAGE_RATE on the P2K_SA_WAGE_SCALES, if a SCALE_CODE and STEP_CODE are provided.
RATE_BASISVarchar2(30) Validation: If provided, must be one of the lexicon values from X_RATE_BASIS. Derivation: This field will be derived from the RATE_BASIS on the P2K_SA_WAGE_SCALES, if a SCALE_CODE and STEP_CODE are provided.
OVERTIME_EXEMPTVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True
DIRECT_CHARGEVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True.
ASSIGNMENT_REQUIREDVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True.
JOB_PROFILE_CODEVarchar2(16)
PROFILE_USER_NAMEVarchar2(30)
PREMIUM_CODEVarchar2(16) This field is required if you provide a PREMIUM_RATE_BASIS and PREMIUM_RATE value. Validation: Must be a valid premium defined on P2K_SA_PREMIUMS, and may not have already been defined for this job, effective at the same time.
PREMIUM_RATE_BASISVarchar2(30) This field is required if you provide a PREMIUM_RATE value. Validation: If provided, must be one of the fixed lexicon values from X_RATE_BASIS
PREMIUM_RATENumber(18)
SPLIT_SEQUENCENumber(5)
DISTRIBUTION_CODEVarchar2(50) Validation: The DISTRIBUTION_MASK is validated against the DISTRIBUTION_FORMAT specified for the GLCOMPANY that is associated with the ENTITY_CODE_SUB_DIVISION.
SPLIT_RULEVarchar2(30) Validation: Must be either a valid lexicon code, or a valid lexicon description from X_SPLIT_RULE
SPLIT_PERCENTNumber(5)
SPLIT_AMOUNTNumber(18)
ADDITIONALVarchar2(4) Four character alphanumeric field used to enter additional information.
START_DATEDate()
END_DATEDate()
GL_FUND_CODEVarchar2(16)
USER_PERCENTNumber(5)
USER_FIELD_VALUE_01Varchar2(2000) Looking for DJB01 defined on IMUF
USER_FIELD_VALUE_02Varchar2(2000) Looking for DJB02 defined on IMUF
USER_FIELD_VALUE_03Varchar2(2000) Looking for DJB03 defined on IMUF
USER_FIELD_VALUE_04Varchar2(2000) Looking for DJB04 defined on IMUF
USER_FIELD_VALUE_05Varchar2(2000) Looking for DJB05 defined on IMUF
USER_FIELD_VALUE_06Varchar2(2000) Looking for DJB06 defined on IMUF
USER_FIELD_VALUE_07Varchar2(2000) Looking for DJB07 defined on IMUF
USER_FIELD_VALUE_08Varchar2(2000) Looking for DJB08 defined on IMUF
USER_FIELD_VALUE_09Varchar2(2000) Looking for DJB09 defined on IMUF
USER_FIELD_VALUE_10Varchar2(2000) Looking for DJB10 defined on IMUF
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.


Notes #

Click to create a new notes page