# 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.&#x20;

{% hint style="warning" %}
This will be getting upgraded in June 2025, when the Workday platform is implemented. It will include Performance tracking too.&#x20;
{% endhint %}

### Script README.md lives here

{% embed url="<https://github.com/cityofaustin/atd-knack-banner>" %}

## 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.&#x20;
