...
The HR feed also contains employee termination events, for which the SQL script will deactivate the associated RAS user.
Database Tables
...
- 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
...
- 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