!!!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|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|ENTITY_CODE].
|[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)| | Four character alphanumeric field used to enter additional information. 
|[START_DATE]|Date()| |
|[END_DATE]|Date()| |
|[GL_FUND_CODE]|Varchar2(16)| |
|[USER_PERCENT]|Number(5)| |
|[USER_FIELD_VALUE_01|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DJB01 defined on [IMUF]
|[USER_FIELD_VALUE_02|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DJB02 defined on [IMUF]
|[USER_FIELD_VALUE_03|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DJB03 defined on [IMUF]
|[USER_FIELD_VALUE_04|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DJB04 defined on [IMUF]
|[USER_FIELD_VALUE_05|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DJB05 defined on [IMUF]
|[USER_FIELD_VALUE_06|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DJB06 defined on [IMUF]
|[USER_FIELD_VALUE_07|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DJB07 defined on [IMUF]
|[USER_FIELD_VALUE_08|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DJB08 defined on [IMUF]
|[USER_FIELD_VALUE_09|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for DJB09 defined on [IMUF]
|[USER_FIELD_VALUE_10|USER_FIELD_VALUE_nn]|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)| |


----
![Notes|Edit:Internal.INF_CV_JOBS] 	
[{InsertPage page='Internal.INF_CV_JOBS' default='Click to create a new notes page'}]