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:
- P2K_CM_JOBS (first record for each job code only)
- P2K_CM_JOB_DETAILS (first record and subsequent effective splits)
- P2K_SA_PREMIUM_USAGES (one record for each premium code defined)
- P2K_CM_DISTRIBUTIONS (one record for each distribution split defined)
Table Columns#
Column name | Data Type / Size | Mand. | Notes |
---|---|---|---|
ID | Number(10) | Used internally to define a unique identification for the record. This field would not be loaded. | |
ENTITY_CODE | Varchar2(16) | Y | Validation: Must be a valid entity code defined on P2K_CM_ENTITIES. |
UNIT_CODE | Varchar2(16) | Y | Validation: Must be a valid unit code defined on P2K_CM_UNITS |
JOB_CODE | Varchar2(16) | Y | Validation: Must be a unique job for this unit. |
STANDING | Varchar2(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_CODE | Varchar2(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_GROUPING | Varchar2(16) | ||
EFFECTIVE | Date() | Y | Validation: 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. |
EXPIRY | Date() | 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_CODE | Varchar2(16) | Validation: The Change Code provided must be defined on P2K_CM_CHANGE_REASONS | |
JOB_TITLE | Varchar2(50) | ||
OCCUPATION_CODE | Varchar2(16) | Validation: Must be a valid occupation code defined on P2K_CM_OCCUPATIONS | |
RANGE_CODE | Varchar2(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_CODE | Varchar2(16) | Validation: Must be a valid scale code defined on P2K_SA_WAGE_SCALES | |
STEP_CODE | Varchar2(16) | Validation: Must be a valid step for the scale code defined on P2K_SA_WAGE_SCALES | |
DESCRIPTION_1 | Varchar2(50) | ||
DESCRIPTION_2 | Varchar2(50) | ||
JOB_TYPE | Varchar2(30) | Validation: Must be either a valid lexicon code, or a valid lexicon description from X_JOB_TYPE | |
JOB_CLASS | Varchar2(30) | Validation: Must be either a valid lexicon code, or a valid lexicon description from X_JOB_CLASS. | |
WCB_CLASS | Varchar2(30) | Validation: Must be either a valid lexicon code, or a valid lexicon description from X_WCB_CLASS | |
EEO_CATEGORY | Varchar2(30) | Validation: If provided, must be one of the lexicon values from X_EEO_CATEGORY | |
STD_HOURS_PER_DAY | Number(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_WEEK | Number(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_PAY | Number(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_POINTS | Number(5) | ||
WAGE_RATE | Number(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_BASIS | Varchar2(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_EXEMPT | Varchar2(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_CHARGE | Varchar2(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_REQUIRED | Varchar2(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_CODE | Varchar2(16) | ||
PROFILE_USER_NAME | Varchar2(30) | ||
PREMIUM_CODE | Varchar2(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_BASIS | Varchar2(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_RATE | Number(18) | ||
SPLIT_SEQUENCE | Number(5) | ||
DISTRIBUTION_CODE | Varchar2(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_RULE | Varchar2(30) | Validation: Must be either a valid lexicon code, or a valid lexicon description from X_SPLIT_RULE | |
SPLIT_PERCENT | Number(5) | ||
SPLIT_AMOUNT | Number(18) | ||
ADDITIONAL | Varchar2(4) | ||
START_DATE | Date() | ||
END_DATE | Date() | ||
GL_FUND_CODE | Varchar2(16) | ||
USER_PERCENT | Number(5) | ||
USER_FIELD_VALUE_01 | Varchar2(2000) | Looking for DJB01 defined on IMUF | |
USER_FIELD_VALUE_02 | Varchar2(2000) | Looking for DJB02 defined on IMUF | |
USER_FIELD_VALUE_03 | Varchar2(2000) | Looking for DJB03 defined on IMUF | |
USER_FIELD_VALUE_04 | Varchar2(2000) | Looking for DJB04 defined on IMUF | |
USER_FIELD_VALUE_05 | Varchar2(2000) | Looking for DJB05 defined on IMUF | |
USER_FIELD_VALUE_06 | Varchar2(2000) | Looking for DJB06 defined on IMUF | |
USER_FIELD_VALUE_07 | Varchar2(2000) | Looking for DJB07 defined on IMUF | |
USER_FIELD_VALUE_08 | Varchar2(2000) | Looking for DJB08 defined on IMUF | |
USER_FIELD_VALUE_09 | Varchar2(2000) | Looking for DJB09 defined on IMUF | |
USER_FIELD_VALUE_10 | Varchar2(2000) | Looking for DJB10 defined on IMUF | |
CREATE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
CREATE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
CHANGE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
CHANGE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
JOB_TITLE_TRANS | VARCHAR2(4000) | ||
TRANS_LANGUAGE | VARCHAR2(30) |