Integrations TPW HR Portal

TPW HR Portal: Is the system were our TPW HR staff manage HR forms and SSPRs

COA Banner System (BANNER): Is the system where COA & TPW HR Staff enter employee information in.

Script README.md lives here

About the script (BANNER and Knack)

This script synchronizes employee records between the enterprise Banner system and TPW's HR Knack application.

The script uses the Employee ID field to identify new vs existing employees. If an employee ID in Banner does not exist in Knack, a new employee record will be created.

As well, if any of the following data in Banner is different from data in Knack, the Knack record will be updated to match Banner.

  • Temporary vs Full-time status

  • Job title

  • Email address

  • Division name

  • Employee name

  • Position number

  • Hire date

Script sets User Role

  • Script also set everyone who is new in Knack as "Staff"

Script sets "User Status"

  • If an employee ID is present in Knack but not in Banner, the employee record will be marked as Inactive in Knack.

  • If an employee ID is present in Banner, but Inactive in Knack, the employee record will be set to Active in Knack.

  • And if an employee ID is present in Knack but marked as "Separated" in Knack, the script will not change the user's status.

Exempt "Class"

  • We set the SBO Time & Attendance accounts to "Class: Contractor" the script, will not take any action on these accounts. We did not want these accounts to be inactivated every day, hence this work around.

Last updated

Was this helpful?