HR Integration

Owned by Chris Smith
Last updated: Jul 11, 2019

RAS integrates with the PeopleSoft HR system to receive hire/job change/termination events, which it uses to automatically configure permissions for certain jobs and departments.


Data Flow

Data is pushed from PeopleSoft HR into the RAS database via a SnapLogic pipeline on a nightly schedule. A SQL script then runs on the RAS server which reads these events, looks up the associated job codes in a mapping table, and assigns the proper permissions within RAS based on those mappings.

The HR feed also contains employee termination events, for which the SQL script will deactivate the associated RAS user.



Database Tables

Job Code Mapping Table

The Job Code Mapping Table (TUHR_JOB_UNIT_PERM_MAPPING) maps a combination of job code and home unit to a set of RAS permissions. The schema and example contents of this table are below.

  • HOME_UNIT is the department ID that the mapping applies to. This can be a direct unit number or a wildcard expression ("C%" matches all departments starting with 'C'). The script also takes the unit hierarchy into account, so setting a school's unit number here will also match all departments within that school.
  • The *_PERM columns reflect the permissions that should apply to this job code + department combination. 
  • The PERM_UNIT is the unit number for which the permissions will be applied. This is not always the same as the HOME_UNIT – for example, users with a HOME_UNIT of C% (Central departments) will be assigned permissions for the entire University (000001). And within the Medical school, users within specific departments are granted access to other specific departments.


Position Changes Table

The TUHR_POSITION_CHANGES table is the table which receives HR events directly from the PeopleSoft HR system. The schema of this table is displayed below.

Many of these columns are not used by the logic of the SQL script, and are just there for informative/debugging purposes. The key fields for actually processing the HR events are:

  • USER_ID (this is the UTLN)
  • ACTION_TYPE (Hire, Termination, etc)
  • EFFECTIVE_DATE
  • SEQUENCE_NUMBER
  • JOB_CODE_NEW
  • JOB_FAMILY_CODE_NEW
  • DEPT_ID_NEW


Notifications

Notifications will go to the elist ras-support@elist.tufts.edu. A typical notification will show all of the events processed during that run of the script, with details about what new permissions were set up or what other actions were taken. Errors such as an unrecognized UTLN or other data that cannot be processed will generated a separate error notification. 


Source

The scripts for the HR feed are located in the kc-scripts GitLab repository at: https://gitlab.it.tufts.edu/ras/kc-scripts/tree/master/Maintenance%20Scripts/kuali/hr-feed

Information on the Tufts IT Knowledgebase is intended for IT Professionals at Tufts.
If you have a question about a Tufts IT service or computer/account support, please contact your IT support group.