Users
Talent Management Users directly relate to Costpoint’s Employees.
Below is how the data is mapped to Talent Management:
Talent Management Destination | Description | Required (Y/N) | Costpoint Source |
|---|---|---|---|
user_id | Talent Management's unique user id (Should be sent to HRIS first through new hire export) | N | N/A (Assigned in Talent Management) |
user_email | User email | Y | IF EMPL.email_id is not NULL THEN populate with the EMPL.email_id ELSE (IF EMPL.home_email_id is NOT NULL) THEN populate with the EMPL.home_email_id |
user_firstname | User's first name | Y | EMPL.first_name |
user_middlename | User's middle name/initial | N | EMPL.mid_name |
user_lastname | User's last name | Y | EMPL.last_name |
user_employee_id | User's employee ID - user's unique identifier | N | EMPL.empl_id |
user_login | User’s unique username (typically the email) | Y | IF EMPL.email_id is not NULL THEN populate with the EMPL.email_id ELSE (IF EMPL.home_email_id is NOT NULL) THEN populate with the EMPL.home_email_id |
user_lockedout | Alias for the user_lockedout field | N | N/A |
user_password | User’s password to login | N | N/A |
user_address_one | User's home address - line 1 | N | EMPL.ln_1_adr |
user_address_two | User's home address - line 2 | N | EMPL.ln_2_adr |
user_address_three | User's home address - line 3 | N | EMPL.ln_3_adr |
user_city | User's home city | N | EMPL.city_name |
user_state | User's state or province abbreviation | N | EMPL.mail_state_dc |
user_zipcode | User's home postal code | N | EMPL.postal_cd |
user_country | User's home country | N | IF the employee’s EMPL.country_cd is NULL and the EMPL.ssn_id != ‘999999999’ THEN populate with ‘US’ ELSE IF the employee’s EMPL.country_cd is not NULL THEN populate with the COUNTRY.iso2_cd where EMPL.country_cd = COUNTRY.country_cd END |
phone_work | User's work phone number | N | EMPL_PHONE.phone_id where phone_type_dc = 'WORK' |
phone_data | User's phone data | N | N/A |
phone_home | User's home phone number | N | EMPL_PHONE.phone_id where phone_type_dc = 'HOME' |
phone_mobile | User's mobile phone number | N | EMPL_PHONE.phone_id where phone_type_dc = 'MOBILE' |
phone_pager | User's pager number | N | EMPL_PHONE.phone_id where phone_type_dc = 'PAGER' |
phone_fax | User's fax phone number | N | EMPL_PHONE.phone_id where phone_type_dc = 'FAX' |
user_hire_date | User's hire date | N | EMPL.orig_hire_dt |
user_dob | User’s date of birth | N | EMPL.birth_dt |
user_location | User’s work location | N |
<EE Location>+’_COMPANY_’+ <EMPL.company_id.> EE Location — This value comes from Employee's EMPL_LAB_INFO.lab_loc_cd where effect_dt <= System Date and end_dt >= System Date. |
user_status | User's exemption status | N | Based on EMPL_LAB_INFO.exmpt_fl where effect_dt <= System Date and end_dt >= System Date If EMPL_LAB_INFO.exmpt_fl = 'Y' Populate with 'EXEMPT' Otherwise Populate with 'NON-EXEMPT |
user_org_level | Org level (Company/Division/Department) assigned to the user | N | EMPL_LAB_INFO.org_id where effect_dt <= System Date and end_dt >= System Date |
job_code | Job of the employee | N | EMPL_LAB_INFO.detl_job_cd where effect_dt <= System Date and end_dt >= System Date |
position_code | Current position assigned to the employee | N | N/A |
user_manager | User’s manager (employee ID) | N | EMPL_LAB_INFO.mgr_empl_id where effect_dt <= System Date and end_dt >= System Date |
user_peer_appraisers | User’s peer appraiser that is associated with their appraisal (employee ID) | N | N/A |
user_matrix_managers | User’s matrix manager/appraiser that is associated with their appraisal (employee ID) | N | N/A |
user_approvers | Approver associated with this appraisal. For example, HRdepartment. (employee ID) | N | IF the client is licensed for Costpoint HR and the Manager Defaulting Method from the Configure Personnel Settings screen = 'Company-Wide Organization' and am HR Representative is assigned to the Home Organization in the Manage Managers/HR Reps by Organization table Populate this field with the HR Representative assigned to the Home Org (ORG_MGR_DFLT.hr_rep_empl_id where home_org_id = employee's Home Org) IF the client is licensed for Costpoint HR and the Manager Defaulting Method from the Configure Personnel Settings screen = 'HR Organization' and an HR Representative is assigned to the HR Organization in the Manage Managers/HR Reps by HR Organization table Populate this field with the HR Representative assigned to the HR Org (HR_ORG_MGR_DFLT.hr_rep_empl_id where hr_org_id = employee's HR Org) |
hrbps | HR Business Partner for a user. It will add the listed ones under this column to the HRBP group and make them HRBP for the user in the related record. (employee ID) | N | N/A |
user_group | Assigned user group name. For multiple groups, this value is comma-separated without spaces around commas. For example, "Manager, Employee,Recruiter". | Y | N/A |
active/inactive | This field will be used to indicate if the user is active or inactive. If inactive the user will not be able to log into the HRsmart system. | Y | If EMPL.s_empl_status_cd = 'ACT' or 'FML' Populate with 'A' Otherwise populate with 'I' |
national_identifier | National Identifier (SSN, CPF, PIN, NINO, ID NUMBER,SIN) | N | If EMPL.ssn = 999999999 N/A Else Populate with EMPL.ssn_id |
last_working_date | Date when an employee was terminated. Any value here will deactivate the user. This populates the user termination date in Talent Management. | N | EMPL.term_dt |
user_time_zone | User's time zone code | N | N/A |
user_rehire_eligibility_id | Rehire eligibility of employee being terminated | Y | IF employee's EMPL.term_dt is not NULL THEN get the employee's Rehire Eligibility Code (EMPLOYMENT_HISTORY.rehire_eligibility_cd) where the EMPLOYMENT_HISTORY.term_dt = the EMPL.term_dt Populate with the REHIRE_ELIGIBIILTY.eligible_for_rehire value linked to the employee's Rehire Eligibility Code ELSE THEN do not populate this field END IF |
user_termination_reason | Defines the separation type | Y | IF employee's EMPL.term_dt is not NULL THEN populate with the employee's Termination Type (EMPLOYMENT_HISTORY.term_type) where the EMPLOYMENT_HISTORY.term_dt = the EMPL.term_dt ELSE THEN do not populate this field END IF |
user_separation_reasons | Comma separated values of the reasons for employee termination. This should match values defined in HUA. | N | IF employee's EMPL.term_dt is not NULL THEN get the employee's Termination Reason codes (EMPLOYMENT_HISTORY.term_reason_cd) where the EMPLOYMENT_HISTORY.term_dt = the EMPL.term_dt For each Termination Reason, get the Termination Reason Description (TERM_REASON.term_reason_desc) ELSE THEN do not populate this field END IF |
user_original_email | Employee’s external email address which will be used as the jobseeker's account. | N | IF employee's EMPL.term_dt is not NULL THEN populate with the employee's E-mail Address (EMPLOYMENT_HISTORY.personal_email_id) where the EMPLOYMENT_HISTORY.term_dt = the EMPL.term_dt ELSE THEN do not populate this field END IF |
user_separation_comments | Any comments for employee being offboarded | N | IF employee's EMPL.term_dt is not NULL THEN populate with the employee's Termination Comments (EMPLOYMENT_HISTORY.term_comments) where the EMPLOYMENT_HISTORY.term_dt = the EMPL.term_dt ELSE THEN do not populate this field END IF |
wizard_target_id | HUA_user_id of the recruiter who will complete the offboarding wizard for the user being terminated | N | blank |
user_terminated | The employee's last working day. This populates the user separation date in Talent Management. | N | EMPL.last_day_dt |