Wiki: IRPO

REQUISITIONS#

Requisitions are entered as postings through the Maintain Postings (IRPO) screen.

The definition data for the Maintain Requisitions screen is stored in the P2K_RE_POSTINGS, and P2K_RE_JOB_PROFILES, P2K_RE_RECRUITING_COSTS, P2K_RE_RECRUITER_USAGES, and P2K_RE_APPLICATIONS tables.

'Maintain Requisitions'#

Posting: This field displays a user-defined code that uniquely identifies the posting. Posting_Code is a mandatory 16-character alphanumeric field you must manually enter.

Job Profile: This field identifies the job profile for which the posting is being created. Job Profile from IRJP (P2K_RE_JOB_PROFILES) is a mandatory field you must fill through the LOV (F9).

Title: This field allows you to give the posting a descriptive title. Posting_Title is a mandatory 50-character alphanumeric field you must manually enter.

Manager: This field identifies the manager of this posting. Manager from IEAS (P2K_HR_ASSIGNMENTS) is an optional field you must fill through the LOV (F9).

Recruiter: You may use this field to identify the recruiter for this posting. Recruiter from IRRE (P2K_RE_RECRUITERS) is an optional field you must fill through the LOV (F9).

Entity: This field displays the entity that is generating the posting. Entity from IDEN {P2K_CM_ENTITIES)] is an optional field you must fill through the LOV (F9). \\ ---- !!Maintain Postings (IRPO) - Postings The definition data for the Maintain Requisitions screen is stored in the [P2K_RE_POSTINGS] table.\\ __The following fields will usually be automatically filled once the ‘Position’ field has been completed. These values, however, may be changed in this screen.__ ;[Status|POSTING_STATUS]:This field will display the status of the job posting. Posting_Status is a mandatory field you may fill with a selection from the fixed lexicon [X_Posting_Status]. ''i.e. Requisition, FTE Problem, Open Posting, Offer Made, Partially Filled, Completed, Not Approved, Suspended, Canceled etc. ;[Original Postings|ORIGINAL_POSTING]:If this posting has been derived from another positing, that original posting will be listed here. Original_Posting from [IRPO] ([P2K_RE_POSTING]) is an optional field you must fill through the LOV (F9). ;[Requisition Date|REQUISITION_DATE]:This field will display the date for this requisition was created. Requisition_Date is an optional field you may fill either manually or using the calendar (F9). ;[Posting Approved|POSTING_APPROVED]:If this toggle is ON, the posting has been approved. Posting_Approved is an optional toggle field. ;[Internal Opened|INTERNAL_OPENED]:This field will display the date the posting was open to internal candidates. Internal_Opened is an optional field you may fill either manually or using the calendar (F9). ;[General Opened|GENERAL_OPENED]:This field displays the date the posting was opened to external candidates. General_Opened is an optional field you may fill either manually or using the calendar (F9). ;[Posting Closed|POSTING_CLOSED]:This field displays the date the posting was closed to new applicants. Posting_Closed is an optional field you may fill either manually or using the calendar (F9). ;[Posting Filled|POSTING FILLED]:If the posting been filled, this field will display the date a candidate was hired. Posting_Filled is an optional field you may fill either manually or using the calendar (F9). ;[Source|POSTING_SOURCE]:This field provides a reason for the posting. Posting_Source is an optional field you may fill with a selection from the fixed lexicon [X_Posting_Source]. ''i.e. New Position, Vacant Position, Movement'' ;[Priority|POSTING_PRIORITY]:The priority of the posting will be shown in this field. Posting_Priority is an optional field you may fill with a selection from the fixed lexicon [X_Posting_Priority]. '' i.e. Low Priority, Medium Priority, High Priority'' ;[Type|POSTING_TYPE]:This field allows you to define the nature of the posting. Posting_Type is an optional field you may fill with a selection from the fixed lexicon [X_Posting_Type]. ''i.e. Internal Only, External Only, Internal or External'' ;[Category|POSTING_CATEGORY]:This field allows you to classify the posting into a specific group. Posting_Category is an optional field you may fill with a selection from the user-defined lexicon [X_Posting_Category]. ;[Req.FTE|REQUIRED_FTE]:This field will show the FTE required for this posting. Required_FTE is an optional 9-character numeric field you may enter manually. ;[Def.FTE|DEFAULT_FTE]:This field shows the default FTE for this position used for forecasting and costing. Default_FTE is an optional 9-character numeric field you may enter manually. ;[Filled FTE|FILLED_FTE]:If this posting has been filled, this field will show the amount of FTE that has been filled. Filled_FTE is an optional 9-character numeric field you may enter manually. ;[Position|P2K_CM_POSITION]:This field will display the position associated to this posting. Position from [IDPS] ([P2K_CM_POSITION]) is an optional field you must fill through the LOV (F9). ;[Unit|P2K_CM_UNITS]:This field will display the unit associated with this posting. Unit from [IDUN] ([P2K_CM_UNITS]) is an optional field you must fill through the LOV (F9). ;[Job|P2K_CM_JOBS]:This field will display the job associated with this posting. Job from [IDJB] ([P2K_CM_JOBS]) is an optional field you must fill through the LOV (F9). ;[Department|P2K_CM_DEPARTMENTS]:This field will display the department associated with this posting. Department from [IDDP] ([P2K_CM_DEPARTMENTS]) is an optional field you must fill through the LOV (F9). ;[Group|P2K_CM_GROUPS]:This field will display the group associated with this posting. Group from [IDGR] ([P2K_CM_GROUPS]) is an optional field you must fill through the LOV (F9). ;[Work Rule|P2K_CM_WORK_RULE]:This field will display the work rule associated with this posting. Work Rule from [IDWR] ([P2K_CM_WORK_RULE]) is an optional field you must fill through the LOV (F9). ;[Location|P2K_CM_LOCATIONS]:This field will display the location associated with this posting. Location from [IDLN] ([P2K_CM_LOCATIONS]) is an optional field you must fill through the LOV (F9). ;[Posting Text|POSTING_TEXT]:This field allows you to provide additional information about the posting. Posting_Text is an optional 4000-character alphanumeric field you may enter manually. ---- !!Maintain Postings (IRPO) - Assigment ;[Employment Type|EMPLOYMENT_TYPE]:This field allows you to define the type of the employment for the assignment. Employment_Type is an optional field you may fill with a selection from the fixed lexicon [X_Employment_Type]. ''i.e. COBRA Participant, Employee 3%%sup rd %%, Director, Board, Client, Volunteer, Employee, Contracts, Rehire, Survivor, Employee 2%%sup nd %%, Vendor, Applicant ;[Responsibility Level|RESPONSIBILITY_LEVEL]:This field identifies the level of responsibility for the assignment. Responsibility_Level is an optional field you may fill with a selection from the fixed lexicon [X_Responsibility_Level]. ''i.e. Not Specified, Trainee-Production, Trainee-White Collar, Trainee-Other, Staff, Supervisory, Management, Executive, Senior Executive ;[Language Class|LANGUAGE_CLASS]:This field identifies the language(s) used in this assignment. Language_Class is an optional field you may fill with a selection from the user-defined lexicon [X_Language_Class]. ;[Group Type|GROUP_TYPE]:This field displays the type of group for this assignment. Group_Type is an optional field you may fill with a selection from the fixed lexicon [X_Group_Type]. ''i.e. Full Time, Part Time, Temp FT, Temp PT, COBRA, Other, Casual, Student, Contractor, Retiree, Survivor ;[Work Type|WORK_TYPE]:This field further groups the assignment into work types. Work_Type is an optional field you may fill with a selection from the user-defined lexicon [X_Work_Type]. ;[WC Class|WC_CLASS]:This field identifies the workers compensation for this assignment. WC_Class is an optional field you may fill with a selection from the fixed lexicon [X_WC_Class]. ;[Assign. Start Date|ASSIGNMENT_START_DATE]:This field will show the date the assignment is to start. Assignment_Start_Date is mandatory field you may fill either manually or using the calendar (F9). ;[Assign. End Date]:If this assignment is date –sensitive, the last date of the assignment will be displayed here. Assignment_End_Date is mandatory field you may fill either manually or using the calendar (F9). ;[Hours Per Day|HOURS_PER_DAY]:This field shows the average daily hours associated with this assignment. Hours_Per_Day is an optional 9-character numeric field you may enter manually. ;[Hours Per Week|HOURS_PER_WEEK]:This field shows the average weekly hours associated with this assignment. Hours_Per_Week is an optional 9-character numeric field you may enter manually. ;[Range|P2K_SA_SALARY_RANGE]:This field will show the salary range for this assignment. Range from [ISSR] ([P2K_SA_SALARY_RANGES]) is an optional field you must fill through the LOV (F9). ;[Scale|P2K_SA_WAGE_SCALES]:This field will show the wage scale for this assignment. Scale from [ISWS] ([P2K_SA_WAGE_SCALES]) is an optional field you must fill through the LOV (F9). ;[Wage Rate|WAGE_RATE]:This field will show the wage rate for this assignment. Wage_Rate is an optional 18-character numeric field you may fill manually. ;[Rate Basis|RATE_BASIS]:This field shows the rate basis that the wage is expressed in. Rate_Basis is an optional field you may fill with a selection from the fixed lexicon [X_Rate_Basis]. ''i.e. YR, MO, SM, BW, WK, DY, HR, UN, CT, CL, $'' \\ ---- !!Maintain Postings (IRPO) - Job Profile The definition data for the Job Profiles screen is stored in the [P2K_RE_JOB_PROFILES] table.\\ __The following fields will usually be automatically filled once the ‘Job Profile’ field has been completed. These values CANNOT be changed in this screen.__ ;[Title|TITLE]:This field displays the specific title of the job profile. ;[Type|TYPE]:This field displays the nature of the job profile. ;[Status|STATUS]:This field will display the status of the job profile. ''i.e. Newly, Entered, Active, Frozen, Obsolete etc.'' ;[Job Purpose|JOB_PURPOSE]:This field has been provided to allow you to describe the purpose of the job within the company. ;[Job Function|JOB_FUNCTION]:This field allows you to describe the function of and services provided by the job within the company. ;[Prerequisites|PREREQUISITES]:This field allows you to describe the required skills and experience need for this profile. ;[Compensation|COMPENSATION]:This field allows you to define the compensation associated with this profile, such as salary, wage step, benefits, etc. ;[How to Apply|HOW_TO_APPLY]:This field allows you to describe the process by which a candidate to this job would apply. ;[Environment|ENVIRONMENT]:This field describes the work environment this job profile is situation in. ''i.e. office, factory, wheat field, etc.'' ;[Work Eligibility|WORK_ELIGIBILITY]:If the job profile is only open to a certain group(s), for example, only to unionized employees, that eligibility condition will be indicated here. ;[EEO Statement|EEO_STATEMENT]:This field allows you to include the equal employment opportunity statement with the posting for this work profile. ---- !!Maintain Postings (IRPO) - Requirements ;[Type|TYPE]:This field defines the nature of the requirement. ''i.e.Not Specified, Education, Experience, Certificate.'' ;[Description|DESCRIPTION]:This field displays a short description of the requirement being defined. ;[Category|CATEGORY]:This field further categorizes the requirement. ;[Start Date/End Date|START_DATE_END_DATE]:If the requirement is time sensitive, the first and last date needed will be displayed in these fields.\\ ''i.e. If the position must cover additional duties, such as word processing, for a year until another position for those duties can be created.'' ;[Priority|PRIORITY]:This field ranks the requirement in order of priority for this job profile. ;[Desired Prof.|DESIRED_PROFICIENCY]:This field displays the level of proficiency preferred for this requirement. ;[Essential Prof.|ESSENTIAL_PROFICIENCY]:This field displays the level of proficiency essential for this requirement. ;[Text|TEXT]:This field provides further details and information about the requirement being defined. ---- !!Maintain Postings (IRPO) - Costs The definition data for the Costs screen is stored in the [P2K_RE_RECRUITING_COSTS] table. ;[Cost Date|COST_DATE]:This field displays the date the recruiting related cost was incurred. Cost_Date is mandatory field you may fill either manually or using the calendar (F9). ;[Cost Item Category|COST_ITEM_CATEGORY]:This field allows you to classify the cost item into a specific category. For example, fees, books, travel, meals, etc. Cost_Item_Category is an optional field you may fill with a selection from the user-defined lexicon [X_Cost_Item_Category]. ;[Cost Amount|COST_AMOUNT]:This field displays the actual amount of the cost incurred. Cost_Amount is an optional 18-character numeric field you may enter manually. ;[Description|DESCRIPTION]:This field allows you to provide a short description of the cost. Description is an optional 50-character alphanumeric field you may enter manually. ;[Employer Percent|EMPLOYER_PERCENT]:This field will indicate the percentage of the cost that will be covered by the employer. Employer_Percent is an optional 5-character numeric field you may enter manually. ;[Cost Reference|COST_REFERENCE]:This field will indicate the percentage of the cost that will be covered by the employer. Employer_Percent is an optional 5-character numeric field you may enter manually. ;[Candidate|P2K_RE_CANDIDATES]:If the cost is related to a specific candidate, that individual may be identified in this field. Candidate from [IRCA] ([P2K_RE_CANDIDATES]) is an optional field you must fill through the LOV (F9). ;[Recruiter|P2K_RE_RECRUITERS]:If the cost is related to a specific recruiter, that recruiter may be identified in this field. Recruiters from [IRRE] ([P2K_RE_RECRUITERS]) is an optional field you must fill through the LOV (F9). ---- !!Maintain Postings (IRPO) - Recruiters The definition data for the Recruiters screen is stored in the [P2K_RE_RECRUITER_USAGES] table. ;[Sequence|SEQUENCE]:This field allows you to specify the order in which the recruiters will be employed for the posting. Sequence is a mandatory 5-character numeric field that you must manually enter. ;[Recruiter|P2K_RE_RECRUITERS]:This field identifies the recruiters used in this posting. Recruiter from [IRRE] ([P2K_RE_RECRUITERS]) is a mandatory field you must fill through the LOV (F9). ;[Status|RECRUITERS_STATUS]:This field indicates the status of the posting with the recruiter. Recruiters_Status is an optional field you may fill with a selection from the fixed lexicon [X_Recruiters_Status]. ''i.e. Not Specified, To Be Published, Published with Error, Unpublished, Consider Publishing, Published - Not Yet, Published - OK, Removed by Recruiter'' ;[Description|DESCRIPTION]:This field allows you to provide a short description of the recruiter. Description is an optional 50-character alphanumeric field you may enter manually. ;[Start Date|START_DATE]:This field indicates the date the posting was opened with the recruiter. Start_Date is an optional field you may fill either manually or using the calendar (F9). ;[End Date|END_DATE]:This field indicates the date the posting was closed with the recruiter. End_Date is an optional field you may fill either manually or using the calendar (F9). ;[External Entity ID|EXTERNAL_ENTITY_ID]:If the external recruiter has created an identification code for the entity, that code will be displayed in this field. External_Entity_ID is an optional 16-character alphanumeric field you may enter manually. ;[External Posting ID|EXTERNAL_POSTING_ID]:If the external recruiter has created an identification code for the posting, that code will be displayed in this field. External_Posting_ID is an optional 16-character alphanumeric field you may enter manually. ;[Placed By|P2K_HR_ASSIGNMENTS]:This field will identify, by assignment code, the employee who placed the posting with the recruiter. Placed_By from [IEAS] ([P2K_HR_ASSIGNMENTS]) is an optional field you must fill through the LOV (F9). ;[Recruiter Type|RECRUITER_TYPE]:This field allows you to classify the recruiter into specific types. Recruiter_Type is an optional field you may fill with a selection from the fixed lexicon [X_Recruiter_Type]. ''i.e. Not Specified, Internal Recruiting, Employer Web Site, Hiring Campaign, Job Board, Hiring Agency, Media'' ;[Category|CATEGORY]:This field allows you to further classify the recruiters. Category is an optional field you may fill with a selection from the user-defined lexicon [X_Recruiter_Category]. ;[Company Name|COMPANY_NAME]:This field displays the company name of the recruiter. Company_Name is an optional 50-character alphanumeric field you may fill manually. ;[Contact Name|CONTACT_NAME]:This field displays the contact name for the recruiter agency. Contact_Name is an optional 50-character alphanumeric field you may fill manually. ;[Phone|PHONE_NUMBER]:This field provides a phone number for the recruiter. Phone_Number is an optional 20-character alphanumeric field you may fill manually. ;[Extension|PHONE_EXTENSION]:This field provides a phone extension for the recruiter. Phone_Extension is an optional 16-character alphanumeric field you may fill manually. ;[Email Address|EMAIL_ADDRESS]:This field provides an email address for the recruiter. Email_Address is an optional 50-character alphanumeric field you may fill manually. ---- !!Maintain Postings (IRPO) - Applicants The definition data for the Applicants screen is stored in the [P2K_RE_APPLICATIONS] table. ;[Candidate|P2K_RE_CANDIDATES]:This field identifies the candidate submitting an application for the posting. Candidate from [IRCA] ([P2K_RE_CANDIDATES]) is a mandatory field you must fill through the LOV (F9). ;[Name|NAME]:This field displays the name of the candidate. Name is an optional 16-character alphanumeric code you may fill manually. ;[Application|APPLICATION_CODE]:This field displays a user-defined code that uniquely identifies the application. Application_Code is a mandatory 16-character alphanumeric field that you must manually enter. ;[Application Status|APPLICATION_STATUS]:This field displays the current status of the application. Application_Status is an optional field you may fill with a selection from the fixed lexicon [X_Application_Status]. ''i.e. Application Inquiry, New Application, Application Routed, Pre-Screening, Assessment, Intend to Hire, Approved for Hire, Offer Made, Offer Accepted, Offer Declined, Failed to Respond, Ready to Hire, Hire, Rehired, Rejected, Not Approved, On Hold, Canceled. ;[Stage|APPLICANT_STAGE]:This field lets you identify the status of the application, for example, ‘Application Received’ or ‘Hired, Complete’. Application_Stage is an optional field you may fill with a selection from the user-defined lexicon [X_Application_Stage]. ;[Application Opened|APPLICATION OPENED]:This field indicates when the recruiters received the application. Application_Opened is a mandatory field you must fill either manually or using the calendar (F9). ;[Application Closed|APPLICATION_CLOSED]:This field indicates when recruiters where finished with the application. Application_Closed is an optional field you may fill either manually or using the calendar (F9). ;[Application Rating|APPLICATION_RATING]:This field provides the rating of the application in the recruiting process. Application_Rating is an optional field you may fill with a selection from the fixed lexicon [X_Application_Rating]. ''i.e. 1%%sup st %% Preference, 2%%sup nd %% Preference, 3%%sup rd %% Preference, Short Listed, Preferred, Qualified, Rejected'' ;[Stage Desc|STAGE_DESC]:This field allows you to identify specific steps within the application stage. Stage_Desc is a mandatory field you must fill through the LOV (F9). Values for the LOV can be created and maintained on the Job Profile IRJP screen. ;[Application Approved|APPLICATION APPROVED]:If this toggle is ON, the application has been approved. Application_Approved is an optional toggle. ;[Offered Date|OFFERED_DATE]:If an offer of employment has been made, this field will display the date the offer was made. Offered_Date is an optional field you may fill either manually or using the calendar (F9). ;[Response Date|RESPONSE_DATE]:If an offer of employment has been made, this field will display the date a response from the candidate was received. Response_Date is an optional field you may fill either manually or using the calendar (F9). ;[Response Indication|RESPONSE_INDICATION]:This field will display the status of the candidate’s response. Response_Indication is an optional field you may fill with a selection from the fixed lexicon [X_Response_Indication . ''i.e. Response Required, Response Received, Response Overdue'' ;[Reason for Rejection|REASON_FOR_REJECTION]:This field allows you to provide a reason why the applicant was rejected for the posting. Reason_For_Rejection is an optional field you may fill with a selection from the fixed lexicon [X_Reason_For_Rejection]. ''i.e. Below Essential Pts, Failed Assessment, Over Qualified Unsuccessful'' ;[Reason for Decline|REASON_FOR_DECLINE]:If the applicant declined a job offer for the posting, you may identify a reason in this field. Reason_For_Decline is an optional field you may fill with a selection from the fixed lexicon [X_Reason_For_Decline]. ''i.e. Wages Too Low, Poor Benefits, Too Much Travel, Location, No Challenge, Another Job Offer, Under Qualified, Other'' ;[Assignment to Replace|P2K_HR_ASSIGNMENTS]:If the candidate to be hired has another assignment in the entity, that assignment is identified in this field. Assignment_To_Replace from [IEAS] ([P2K_HR_ASSIGNMENTS]) is an optional field you must fill through the LOV (F9). __The following fields will usually be automatically filled, however, these values may be changed in this screen.__ ;[Assignment Title|ASSIGNMENT_TITLE]:This field provides the title of the assignment this posting is recruiting for. Assignment_Title is an optional 50-character alphanumeric field you may enter manually. ;[Assignment Start Date|ASSIGNMENT_START_DATE]:If the assignment is date sensitive, the first date of the assignment will be indicated in this field. Assignment_Start_Date is an optional field you may fill either manually or using the calendar (F9). ;[Assignment End Date|ASSIGNMENT_END_DATE]:If the assignment is date sensitive, the last date of the assignment will be indicated in this field. Assignment_End_Date is an optional field you may fill either manually or using the calendar (F9). ;[FTE|FTE]:This field will show the full time equivalent associated with this assignment. FTE is an optional 9-character numeric field you may enter manually. ;[Hours Per Day|HOURS_PER_DAY]:This field shows the average daily hours associated with this assignment. Hours_Per_Day is an optional 9-character numeric field you may enter manually. ;[Hours Per Week|HOURS_PER_WEEK]:This field shows the average daily hours associated with this assignment. Hours_Per_Week is an optional 9-character numeric field you may enter manually. ;[Scale/Step|SCALE_STEP]:This field displays the wage scale for this assignment. Scale_Step from [ISWS] ([P2K_SA_WAGE_SCALES]) is an optional field you must fill through the LOV (F9). ;[Wage Rate|WAGE_RATE]:This field displays the wage rate for this assignment. Wage_Rate is an optional 18-character numeric field you may fill manually. ;[Rate Basis|RATE_BASIS]:This field displays the basis in which the wage rate is expressed. Rate_Basis is an optional field you may fill with a selection from the fixed lexicon [X_Rate_Basis]. ''i.e. YR MO SM BW WK DY HR UN CT CL$'' ;[Scale Overridden|SCALE_OVERRIDDEN]:If the toggle is ON, the displayed wage rate has been keyed manually, and is different from the rate on the wage scale table. If the toggle is OFF, either the wage rate has been derived from the wage scale table or wage scale tables are not being used. Scale_Overridden is an optional field. ;[Application Text|APPLICATION_TEXT]:This field will allow you to provide additional information about the applicant/application. Application_Text is an optional 4000-character alphanumeric field you may enter manually. ;[Hire|HIRE]:The ‘Hire’ button allows you to hire a candidate for the posting. ---- !!Maintain Postings (IRPO) - Recruiting Logs ;[Date/Time|RECRUITING_LOG_TIMESTAMP]:This field displays the day and time of the recruiting log. Recruiting_Log_Timestamp is a mandatory field you may fill either manually or using the calendar (F9). ;[Type|RECRUITING_LOG_TYPE]:This field identifies the nature of the recruitment log. Recruiting_Log_Type is an optional field you may fill with a selection from the fixed lexicon [X_Recruiting_Log_Type]. ''i.e. Not Specified, Manually Created Log, Computer Created Log, Letter To Be Sent, Letter Already Sent'' ;[Category|CATEGORY]:This field allows you to further classify the recruiting log into specific groups. Recruiting_Log_Category is an optional field you may fill with a selection from the user-defined lexicon [X_Recruiting_Log_Category]. ;[Candidate|P2K_RE_CANDIDATES]:This field displays the candidate associated with this recruiting log. Candidate from [IRCA] ([P2K_RE_CANDIDATES]) is an optional field you must fill through the LOV (F9). ;[Recruiter|P2K_RE_RECRUITERS]:This field displays the recruiter associated with this recruiting log. Recruiter from [IRRE] ([P2K_RE_RECRUITERS]) is an optional field you must fill through the LOV (F9). ;[Entered For|ENTERED_FOR]:This field allows you to indicate for whom or what (position, job profile, candidate) this log is entered. Entered_For is an optional 50-character alphanumeric field you may enter manually. ;[Description|DESCRIPTION]:This field allows you to provide a short description of the recruiting log. Description is an optional 50-character alphanumeric field you may enter manually. ;[Log Text|LOG_TEXT]:This field provides additional information about the recruiting log. Log_Text is an optional 4000-character alphanumeric field you may enter manually.