Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Job Profiles

Talent Management Jobs directly relate to Costpoint’s Detail Job Titles and Positions.

This data only if licensed for Costpoint HR. Below is how the data is mapped to Talent Management:

Talent Management Destination Description Required (Y/N) Costpoint Source
job_code Unique identifier for a requisition Y <EE Detl Job Title>+’_COMPANY_’+ <EMPL.company_id.>

EE Detl Job Title — This value comes from EMPL_LAB_INFO.detl_job_cd where effect_dt <= System Date and end_dt >= System Date

job_title Title of the job that will be displayed to job seekers. Y DETL_JOB_TITLES.detl_job_desc
salary_grade Salary grade associated to the job N N/A
division Division code N IF Detail Job Title Position Exists with Org ID

Top Org level of H_DETL_POS_DESC.org_id where H_DETL_POS_DESC.detl_job_cd = DETL_JOB_TITLES.detl_job_cd

ELSE

N/A

company_code Company code N This is the 'COMPANY_'+<Company ID> from the Job Code.
job_family Job family name N N/A
Job_duration Number of months typically a person remains in this position before advancement N N/A
job_description Detailed description of the job Y IF Detail Job Position exists for Detail Job Code and result of this logic is not NULL, then populate with:

H_DETL_POS_DESC.short_desc where H_DETL_POS_DESC.detl_job_cd = DETL_JOB_TITLES.detl_job_cd + <space> + H_DETL_POS_DESC.duties_tx where H_DETL_POS_DESC.detl_job_cd = DETL_JOB_TITLES.detl_job_cd + <space> + H_DETL_POS_DESC.other_info_nt where H_DETL_POS_DESC.detl_job_cd = DETL_JOB_TITLES.detl_job_cd

ELSE

Populate with 'No job description available'

job_requirements Extra information about job N N/A (“::” passed so Talent Management knows not to overwrite)
external_job_title Value displayed on the external site as the job title (if used) N DETL_JOB_TITLES.ext_detl_job_title
education Education required N N/A
job_role Client specific grouping of jobs by role N N/A
job_function Function of the job N N/A
job_level Career level N N/A
cost_center Cost center N N/A
cost_center_code Cost center code N N/A
job_grade Job grade N N/A
job_key Key job N N/A
job_type Job type N Costpoint Employee Type =

IF the Costpoint Detail Job Title being exported exists in the Manage Detail Position Descriptions (H_DETL_POS_DESC) table

THEN Costpoint Employee Type = the

Position Type assigned to the Detail

Job Title in the Manage Detail Position

Descriptions table

(H_DETL_POS_DESC.s_empl_type_cd)

END IF

Talent Management 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

job_classification Job classification N N/A
eeoc_job_category EEOC job category N N/A
eeoc_job_group EEOC job group N N/A
travel Travel required N N/A
location_code Location of the job N N/A
location_group Location region assigned to the job N N/A
requisition_position_type Requisition position type name to assign to the job N N/A