JOB PROFILES INTERFACE FILE#
The Job Profiles Interface File screen is used to import job profile records into the software data structures.
Job Profiles Interface File data is maintained on the INF_CV_JOBPROFILES table.
- ID
- This field uniquely identifies the job profile record within the data base.
- Entity
- Job Profile
- Profile Title
- Profile Status
- Profile Type
- Category
- Last Reviewed On
- Profile In Use
- Auto Posting
- Job Profile
- This field holds the code that identifies a job profile within a company. Job_Profile_Code is a mandatory 16-character alphanumeric field you must enter manually.
- Title
- This field displays the specific title of the job profile. Job_Profile_Title is a mandatory 50-character alphanumeric field you must enter manually.
- Entity
- This field identifies the entity to which the job profile belongs. Entity from IDEN (P2K_CM_ENTITIES) is a mandatory field you must fill through the LOV (F9).
Job Profile tab#
The definition data for the Job Profile tab can be found on the
P2K_RE_JOB_PROFILES table.
- Type
- This field displays the nature of the job profile. Job_Profile_Type is an optional field you may fill with the fixed lexicon X_JOB_PROFILE_TYPE.
- Category
- This field allows you to further categorize the job profile. Job_Category is an optional field you may fill from the user-defined lexicon X_JOB_CATEGORY.
- Status
- This field will display the status of the job profile. Job_Profile_Status is a mandatory field you must fill using the fixed lexicon X_JOB_PROFILE_STATUS.
- Last Review Date
- This field displays the latest date the job profile was reviewed. Last_Review_Date is an optional date field that you may manually enter or use the calendar (F9).
- Auto Application
- If the toggle is ON, the system will allow an application to be automatically generated. If the toggle is OFF, then no application will be generated. Auto_Application is an optional toggle field.
- Auto Posting
- If the toggle is ON, then a posting will be allowed to be automatically generated. If the toggle is OFF, then no posting will be generated. Auto_Posting is an optional toggle field.
- Profile in Use
- If the toggle is ON, then the job profile will indicate that is in use. If the toggle is OFF, then the job profile will not indicate that it is use. Profile_In_Use is an optional toggle field.
- Days
- This field indicates the number of days this profile is valid. Auto_Look_Back_Days is an optional 5-character numeric field that you may manually enter.
- Job Purpose
- This field has been provided to allow you to describe the purpose of the job within the company. Job_Purpose_Text is an optional 4000-character alphanumeric field that may be manually entered by you.
- Job Function
- The Job Function field allows you to describe the function of and services provided by the job within the company. Job_Function_Text is an optional 4000-character alphanumeric field that may be manually entered by you.
- Prerequisites
- This field allows you to describe the required skills and experience needed for this profile. Prerequisites_Text is an optional 4000-character alphanumeric field that may be manually entered by you.
- Compensation
- This field allows you to define the compensation associated with this profile, such as salary, wage step, benefits, etc. Compensation_Text is an optional 4000-character alphanumeric field that you may manually enter.
- How to Apply
- This field allows you to describe the process by which a candidate to this job would apply. How_To_Apply_Text is an optional 4000-character alphanumeric field that you may manually enter.
- Environment
- This field describes the work environment this job profile is situation in. Work_Environment_Text is an optional 4000-character alphanumeric field that you may manually enter.
- Work Eligibility
- This field will describe any work eligibility restrictions associated with this job profile.
e.g. Must be eligible to work in United States
Work_Eligibility_Text is an optional 4000-character alphanumeric field that you may manually enter.
- EEO Statement
- This field allows you to include an equal employment opportunity statement with the posting for this work profile. EEO_Statement_Text is an optional 4000-character alphanumeric field that you may manually enter.
Requirements tab#
The definition data for the Requirements tab can be found on the
P2K_RE_REQUIREMENTS table.
- Type
- This field allows you to define the nature of the qualification being defined. Qualification_Type is a mandatory field you must fill using the fixed lexicon X_QUALIFICATION_TYPE.
- Description
- This field provides a short description of the requirement being defined. Description is an optional 50-character alphanumeric field you may manually enter.
- Category
- This field allows you to further categorize the requirement. Qualification_Category is an optional field you must fill using the user-defined lexicon X_QUALIFICATION_CATEGORY.
- Start Date
- If the requirement is time sensitive, the first valid date of the requirement will be displayed here. Requirement_Start_Date is an optional date field you may manually enter or use the calendar (F9).
- End Date
- If the requirement is time sensitive, the last date that the requirement is needed will be displayed here. Requirement_End_Date is an optional date field you may manually enter or use the calendar (F9).
- Priority
- This field allows you to rank the requirements in order of priority for this job profile. Requirement_Priority is an optional field you must fill using the fixed lexicon X_REQUIREMENT_PRIORITY.
- Desired Proficiency
- This field displays the level of proficiency desired for this requirement. Desired_Proficiency is an optional field you must fill using the fixed lexicon X_PROFICIENCY.
- Essential Proficiency
- This field displays the level of proficiency essential for this requirement. Essential_Proficiency is an optional field you must fill using the fixed lexicon X_PROFICIENCY.
- Requirement Text
- This field allows you to provided further details and information about the requirement being defined. Requirement_Text is an optional 4000-character alphanumeric field that may be manually entered.
Stages tab#
The definition data for the Stages tab can be found on the
P2K_RE_RECRUITING_STAGES
table.
Recruiting Stages
Recruiting Stages are the individual parts of the recruiting procedure for this job profile.
- Seq
- The field will define the sequential order of the recruiting stages. Stage_Sequence is a mandatory 5-character numeric field you must enter manually.
- Description
- The field allows you to provide a short description of the stage. Description is an optional 50-character alphanumeric field that may be manually entered by you.
- Recruiting Stages Text
- This field allows you to supply a more in-depth explanation of the stage. Recruiting_Stage_Text is an optional 4000-character alphanumeric field that may be manually entered by you.
Recruiting Steps
Recruiting Steps are the procedures that comprise individual recruiting stages.
- Seq
- The field will define the sequential order of the recruiting steps. Step_Sequence is a mandatory 5-character numeric field you must manually enter.
- Description
- The field allows you to provide a short description of the step. Description is an optional 4000-character alphanumeric field that may be manually entered by you.
- Assessment
- This field will display any assessment associated with this recruiting step. Assessment from IRAS (P2K_RE_ASSESSMENTS) is an optional field you may fill through the LOV (F9).
- Weighting
- This field will display the weighting this step holds within the entire stage. Weighting is an optional 5-character numeric field you must enter manually.
- Desired Points
- This field displays desired amount of points the candidate should achieve in this assessment. Desired_Points is an optional 5-character numeric field you must enter manually.
- Essential Points
- This field displays minimum amount of points the candidate should achieve in this assessment. Essential_Points is an optional 5-character numeric field you must manually enter.
- Recruiting Step Text
- This field allows you to supply a more in-depth explanation of the step. Recruiting_Step_Text is an optional 4000-character alphanumeric field that may be manually entered by you.
Recruiters tab#
The definition data for the Recruiters tab can be found on the
P2K_RE_RECRUITERS and
P2K_RE_RECRUITER_USAGES table. The form to add
recruiters is Define Recruiters
(IRRE).
- Seq #
- The field will define the sequential order in which the recruiters will be employed. Recruiter_Usage_Sequence is a mandatory 5-character numeric field you must manually enter.
- Recruiter
- This field allows you to identify the recruiters to be used in a search to fill this job profile. Recruiter from IRRE (P2K_RE_RECRUITERS) is a mandatory field you must fill through the LOV(F9).
- Description
- This field allows you to provide a short description about the recruiter. Description is an optional 50-character alphanumeric field that may be manually entered by you.
- Status
- This field displays the job profile’s status with the recruiter. This field is tied to a mandatory fixed lexicon X_RECRUITER_USAGE_STATUS that may be chosen from the LOV (F9).
The remaining fields in this tab will be automatically completed by the system once the recruiter is chosen. The remaining fields are for viewing purposes only; you may not edit the data.
- Type
- This field will identify the type of recruiter being defined.
- Category
- This field further classifies the recruiter into a specific ‘group’.
- Company
- This field displays the name of the company of the recruiter.
- Contact
- This field displays a contact name for the recruiter.
- Phone #
- This field displays a phone number for the recruiter.
- Phone Ext.
- If there is a phone extension for the recruiter, that number will be displayed in this field.
- Email
- This field shows the email address of the recruiter.
Jobs tab#
This will display any jobs associated with this
job profile.
You may not add jobs directly to this screen. In order to associate a job to a job profile, you must first create the job profile and then link that profile with a job through the Maintain Jobs (IDJB) screen. Once the IDJB screen is saved, the job information will appear in the Jobs tab of IRJP.
- Job
- The job code is the short name, reference code, or number that uniquely identifies this job within the organization.
- Job Title
- This is the formal title by which the organization knows this job.
- Unit
- This is the unit to which the job belongs.
- Occupation
- Occupation is a user-definable occupation code.
- Description 1
- This field allows you to provide additional text or title information about the job.
- Description 2
- This field allows you to provide further comments about the job.
- Type
- This field identifies the nature of the job type.
- WCB Class
- This field displays the Workers’ Compensation classification used to determine the WC category for reporting.
- EEO Category
- The Employment Equity Opportunity category is a code used to tie the job to a particular EEO category.
Positions tab#
This will display any positions associated with this job profile.
You may not add positions directly to this screen. In order to associate a position to a job profile, you must first create the job profile and then link that profile with a position through the Maintain Position (IDPS) screen. Once the IDPS screen is saved, the position information will appear in the Position tab of IRJP.
- Position
- The position code is the number, reference code or abbreviation that uniquely identifies this position within the organization.
- Position Title
- This is the official or formal title of the position.
- Unit
- This field displays the name of the unit to which this position belongs.
- Job
- This field displays the job on which the position is based.
- Department
- This field displays the department in which the tasks take place.
- Location
- This is the location where the tasks are being performed.
- Description 1
- This field allows you to give a brief description of the position including any details other than the title.
- Description 2
- This field provides a space for further information about the position.
- Position Type
- This field shows the nature (i.e. executive, management, supervisory, etc.) of position being defined.
- WCB Class
- This field displays the Workers’ Compensation classification used to determine the WC category for reporting.
- Responsibility Level
- This field displays the responsibility level of this position, for example, staff, supervisor, or executive.
- Status
- Indicates whether the position is approved, not approved or obsolete.
- Budget Rule
- Indicates whether the position is budgeted, not budgeted or encumbered.
- Authorized FTE
- The number of full time equivalent positions for which a commitment has been made by the organization.
Postings tab#
This will display any postings associated with this Job Profile.
You may not add postings directly to this screen. In order to associate a posting to a job profile, you must first create the job profile and then link that profile with a posting through the Maintain Posting (IRPO) screen. Once the IRPO screen is saved, the posting information will appear in the Posting tab of IRJP.
- Date Opened
- This field displays the date the posting was opened.
- Posting
- The posting code is the number, reference code or abbreviation that uniquely identifies this position within the organization.
- Posting Title
- This is the official or formal title of the posting.
- Status
- This field shows the status of the posting (e.g. Open, Offer Made, Completed).
- Source
- The source of the posting (e.g., New Position, Vacant Position) will be shown here.
- Type
- This field shows if the positing is internal, external or both.
- Category
- This field allows you to group the posting into different classifications.
- Priority
- This field will indicate the priority of the posting, e.g. high or low.
- Required FTE
- This field will identify the amount of Full Time Equivalent needed for this posting.
- Entity
- This displays the entity associated with this posting.
- Department
- This displays the department associated with this posting.
- Location
- This displays the location associated with this posting.
- Unit
- This displays the unit associated with this posting.
- Group
- This displays the group associated with this posting.
- Managed By
- This field will show the manager for this posting.
Competence tab#
This will record the competencies required for this
job profile. The definition data for the
Competence tab can be found on the
P2K_CP_COMPETENCE_USAGES table.
- Category/Competence/Level
- This field identifies competencies associated with the job profile along with the competency category and level for the individual competency. Competence_Category from ICCC (P2K_CP_COMPETENCE_CATEGORIES and P2K_CP_CORE_COMPETENCIES) is a mandatory field you must fill through the LOV (F9).
- Competence Group
- This field further classifies the competency. This field will automatically fill once the Category field has been filled.
- Weighting
- This field indicates the value of the competency level within the entity. This field will automatically fill once the Level field has been filled.
- Confirmed Status
- This field will indicate the status of confirmation for the competency for this job profile. Confirmed_Status is an optional field you must fill using the fixed lexicon X_CONFIRMED_STATUS.
- Date Confirmed
- This field will indicate the date the competency was confirmed for this job profile. Date_Confirmed is an optional date field that you may manually enter or use the calendar (F9).
- Start Date
- If the competency is time sensitive for this job profile, this field displays the first day of the time period. Start_Date is an optional date field that you may manually enter or use the calendar (F9).
- End Date
- If the requirement is time sensitive for this job profile, this field displays the last day of the time period. End_Date is an optional date field that you may manually enter or use the calendar (F9).
- Confirmed by
- This field allows you to indicate who confirmed the competency for this profile and any other additional information about the competency. Confirmed_By is an optional 4000-character alphanumeric field that you may be entered manually.
Training Needs tab#
The definition data for the Training Needs tab can be found on the
P2K_CP_TRAINING_NEEDS table.
- Description
- This field allows you to provide a short description of the training need required for this job profile. Description is an optional 50-character alphanumeric field that you may enter manually.
- Type
- This field allows you to classify the training need to a specific activity type. Activity_Type is an optional field you must fill using the fixed lexicon X_ACTIVITY_TYPE.
- Program
- This field will indicate the program associated with this training need. This field from ICDP (P2K_CP_DEVELOPMENT_PROGRAMS) is an optional field you may fill through the LOV (F9).
- Course
- This field will indicate the course associated with this training need. Course from ICRS (P2K_CP_COURSES) is an optional field you may fill through the LOV (F9).
- Assessment
- This field will indicate the assessment associated with this training need. Assessment from IRAS (P2K_RE_ASSESSMENTS) is an optional field you may fill through the LOV (F9).
- Repeat Interval
- This field will indicate the assessment associated with this training need. Repeat_Interval is an optional 7-character numeric field you may enter manually.
- Repeat Basis
- This field will define the basis for the repeat time interval defined. Repeat_Basis is an optional field you must fill using the fixed lexicon X_PERIOD_BASIS.
- Mandatory
- If this toggle is on, the training need is mandatory for the job profile. Mandatory is an optional toggle field.
- Training Need Text
- This field allows you to provide additional information about the training need. Training_Need_Text is an optional 4000-character alphanumeric field you may fill manually.