Job Requisitions
Job Requisitions provide Talent Management with position requisition details that can be associated to new hires.
| Talent Management Destination | Description | Required (Y/N) | Costpoint Source |
|---|---|---|---|
| job_template_id | Costpoint job template ID | Y | H_POS_RQ_RQST.company_id + “|” H_POS_RQ_RQST.rq_no |
| job_template_name | Costpoint job template name | N | Job Title Description:
DETL_JOB_TITLES.detl_job_desc where DETL_JOB_TITLES.detl_job_cd = H_POS_RQ_RQST.detl_job_cd IF the Manager Default Method in the Login Company’s Configure Personnel Settings screen = ‘HR Organization' (H_PER_ADM_SETTINGS.s_mgr_dft_mthd_cd = 'H' where H_PER_ADM_SETTINGS.company_id = <Login Company>) and H_POS_RQ_RQST.hr_org_id is not NULL Org = H_POS_RQ_RQST.hr_org_id ELSE Org = H_POS_RQ_RQST.org_id END IF ELSE (IF client is not licensed for Costpoint HR) Job Title Description = H_POS_RQ_RQST.title_desc Org = H_POS_RQ_RQST.org_id END IF Costpoint Job Template Name: Org + “|” + Job Title Description |
| hires_needed | Number of people needed to fill the requisition | N | H_POS_RQ_RQST.no_openings |
| description | Job responsibilities | N | H_POS_RQ_RQST.job_response |
| job_code |
Same code that is used within user’s profile to indicate their job title (This must be unique) |
Y | H_POS_RQ_RQST.detl_job_cd
DETL_JOB_TITLES.DETL_JOB_CD + "_COMPANY_"+ company_id |
| location_code |
Unique identifier for location |
N | H_POS_RQ_RQST.lab_loc_cd |
| org_level_code |
Same code that is used in user’s file and Jobs file
|
N | H_POS_RQ_RQST.org_id
Top Level (Company) Populate with "COMPANY_" + ORG.company_id Lower Level(s) - Organization Populate with the Organization's Name (ORG.org_id) |
| recruiter_id |
The user ID for the recruiter |
N | H_POS_RQ_RQST.rq_empl_id |
| job_type | Job type | N | H_POS_RQ_RQST.s_empl_type_cd
HRsmart job_type = IF Costpoint Employee Type = 'R' THEN populate with 'Full-Time' ELSE IF Costpoint Employee Type = 'P' THEN populate with 'Part-Time' ELSE IF Costpoint Employee Type = 'T' THEN populate with 'Temporary' ELSE THEN send NULL value END IF |
| creator_id |
User ID of the owner of the record |
N | H_POS_RQ_RQST.rq_empl_id |
| hiring_manager |
User ID of hiring manager |
N | H_POS_RQ_RQST.rq_empl_id |