Integrations TPW HR Portal
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
This will be getting upgraded in June 2025, when the Workday platform is implemented. It will include Performance tracking too.
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 also set everyone who is new in Knack as "Staff"
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.
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.