System administrator
System Maintenance
Scheduled Messages
Modify message
Create message
Scheduled messages
Message frequency options
Report selection
Email settings and troubleshooting
Send one-time message
T&A Web
UK & IRE time change instructions
T&A instructions for UK & IRE Time Change - March 2025
FES Instructions for UK & IRE Summer Time Change – March 2025
Dashboard Maintenance
Profile maintenance
Tab maintenance
Dashboard maintenance
Reports widget
Widget maintenance
Widget public URLs
Themes and Dashboard
Modifying and deleting a created Theme
Dashboard background
Creating a Theme
Custom login logos
Active Themes
Progress Indicator
Theme
Calendar Maintenance
Create calendar
Calendar profiles
Calendar data types page
Calendar maintenance
Creating a Calendar data type
Payslip Management
Kiosk
Kiosk details
Kiosk Configuration
Modify action
Kiosk site planner
Kiosk log
Modify Kiosk preferences
Preparing to install Kiosk
Terminal Site Planner
Deactivate and Reactivate the terminal webpage
Upgrade Terminal Firmware on 900 series or Access Control Unit via Web Service
Terminal upgrades
Terminal Site Planner
Poller preferences
Terminal Actions
Job Scheduler
Poller log
SAML Authentication
Licensing
Licensing upload errors
Upload T&A 8 License Instructions
Temporary Licence
Version Number Mismatch
Licensing
Request a Licence
Upload a Licence
OneAdvanced Identity
Employee License
Messages Received
Enroller
Language Maintenance
Profile language
Importing and Exporting phrases
T&A Error phrases
Language maintenance
Culture maintenance
Advanced T&A Products Minimum IT Specifications
Configuring T&A for use with Microsoft Exchange Online
Support Knowledge Base
Clearing Anomalies - Start a New Period End
T&A 8 licence expiry and renewal
Adding and changing Users in WINTMS
Full Rights for New User
AutoID Badge designer
Delete a Finger Template
Need to Create a Report With a Date Prompt
T&A - European Working Time Directive Features
How to Change the Name Displayed on the Terminal
Client Install instructions
How to Download an Employee to the Terminals
Create New User
Changing the IP Address on a Mitrefinch 900 Series clock or Access control unit.
Employee in TMS but not in HR Manager
GPS clocking location from a mobile phone
Report That Shows if the Employee Has a Photo
Obtaining "500 internal server error" details
Spring Time Change - North America
How to Unlock a User
Support is Evolving
Data Assurance Module - Identifying and preventing the accidental deletion of data (TMS versions 8.33.0.0 and below)
.NET Framework 4.8 for T&A (version 8.35.0+)
'Use Only Once' Checkbox on Book Absence Screen
Changing the OT Threshold for OT Hours Calculation
Poller Keeps Going Down
Help with Australian ADP Export Coding
The Basics
Change Culture
Supervisor Basic Operations
Apply assumed clocks
Changes to hierarchical Security
Adding an additional day of credit
Invalid Login
T&A Entitlement Year End Procedure
Logging in and out as an Employee
Apache Log4j CVE-2021-44228 "Log4Shell" vulnerability
Employee basic operations
TMS Apps
Logging in: the Help button
Adding a keyed absence
Logging in as a Supervisor
Error tGlb.GetPkg
General navigation
COVID 19 - How to manage staff working from home
SAML Authentication in TMS 7
Auto-Rostering - User Admin/Supervisors
Auto-Rostering overview
What data is synced from Time & Attendance to Auto-Rostering?
Schedule Setup
Manage Schedules
Solving a Schedule
Schedule Approval
Employee and User Management
Reporting
Employee Confirmations
Dashboards
Frequently asked questions - Auto-Rostering
Onsite Report – OneAdvanced’s Liability Statement
Supervisor
The Supervisor View
Employee <undefined>
The Supervisor dashboard
Supervisor toolbar
Selecting Employees
Selection options
Employee and Group functions as a Supervisor
Change Supervisor password
Supervisor Functions
Clocking In and Out
Clocking in and out as a Supervisor
Clocking TAS
Location mapping for Clockings
SMS Clocking with Esendex
Make a T&A clocking
Absences
Employee Security
Invalid Credentials
Locking and unlocking an employee's account
Changing an Employee's PIN
Self service password reset
Password Expiry for Employees
Employee passwords
Timesheets
Payslip Management
Calendars
Restart Employee
Employee Maintenance
Availability
Supervisor Group Functions
On-site List
On-site list profile maintenance
Maintain On-site list
On-site list (Supervisor)
Maintain current watches
Modify On-site list
On-site system preferences
On-site list options
Diary
Group Planner
Rosters
Copy periods action
Create named roster action
Group planner preferences
Shift actions
Shift Lock To
Create personal rosters action
Group planner
Group Clock Card
Group Skills
Letters
Group Absence Profile
Find Cover
Job Planner
Group Messages
Hours Approval
Mass Change
Anomalies
Editing work records to correct Anomalies
Authorising in the Anomalies page
Review Anomalies as Supervisor
Group Badge List
Requests List
Adding Additional Payments
Budgeting
Reports
Reports overview
Supervisor Access to Reports
Default Reports
Report profiles
Creating a New Report
Adding additional columns to a Report
Report tasks
Reports employee selection
Bradford factor report
Running a Report
WinTMS User Guide
Employee
The Employee Dashboard
Employee Functions
Requests
Visitor Booking
On-site List
Employee Planner
Calendars
Clock Card
Clock card
Work record
Clockings Panel
Premium bands panel
Hours bands panel
Additional payments panel
Worked hours panel
Check Anomalies as Employee
Clocking T&A
Actual Lateness
Recent clockings
Employee Details
Timesheets
Reports
Payslips
Group Absence Profile
Availability
Availability
Availability details
Add Availability
Copy Availability
Delete availability
Availability errors
Absences
Employee Documents
Planned Shifts
Employee Messages
Skills
Employee Security
Auto-Rostering - Employees
Release Notes
Upgrading Time and Attendance
Release Reports
T&A 8.45 General Release - 9th July 2025
OneAdvanced People mobile app 1.3 release - 4th June 2025
T&A 8.44.0.0 General Release - 29th May 2025
OneAdvanced People mobile app launch - 20th March 2025
T&A 8.43.0.0 Controlled Release - 12th March 2025
T&A 8.42.0.0 General Release - 5th February 2025
T&A 8.41.2.0 General Release - 13th December 2024
T&A 8.41.1.0 General Release - 4th December 2024
T&A 8.41.0.0 General Release - 6th November 2024
T&A 8.39.0.1 Controlled Release - 17th July 2024
T&A 8.38.5.2 Controlled Release - 1st May 2024
T&A 8.39.0.0 Controlled Release - 19th June 2024
T&A 8.38.5.1 General Release - 16th February 2024
T&A 8.38.5.0 Controlled Release - 29th November 2023
T&A 8.38.4.1 Controlled Release - 2nd November 2023
T&A 8.38.4.0 Controlled Release - 1st September 2023
T&A 8.38.3.0 Controlled Release - 27th July 2023
T&A 8.38.1.0 Controlled Release - 2nd May 2023
T&A 8.38.0.0 Controlled Release - 20th March 2023
T&A 8.38.2.0 Controlled Release - 9th June 2023
T&A 8.37.4.2 General Release - 17th February 2023
T&A 8.37.4.0 Controlled Release - 20th January 2023
T&A 8.37.3.0 Controlled Release - 2nd December 2022
T&A 8.37.2.0 Controlled Release - 21st October 2022
T&A 8.37.1.0 Controlled Release - 1st September 2022
T&A 8.37.0.0 Controlled Release - 22nd July 2022
T&A 8.37.0.1 General Release - 23rd August 2022
T&A 8.36.10 Controlled Release - 9th June 2022
T&A 8.36.9.0 Controlled Release - 28th April 2022
T&A 8.36.8.1 General Release - 28th March 2022
T&A 8.36.7.1 General Release - 17th February 2022
T&A 8.36.7.0 General Release - 3rd February 2022
T&A 8.36.6.0 General Release - 16th December 2021
Contents
- All categories
- System administrator
- Auto-Rostering - User Admin/Supervisors
- What data is synced from Time & Attendance to Auto-Rostering?
What data is synced from Time & Attendance to Auto-Rostering?
Updated
by Kellie Oxley
Time & Attendance to Auto-Rostering
The following data is synchronised from your Time & Attendance application to Auto-Rostering.
Employees
Every Time & Attendance employee which is selected in the Time & Attendance Auto-Rostering setup wizard is created in Auto-Rostering (Provisioned) and the following data is synchronised from Time & Attendance into Auto-Rostering.
T&A entity | Events | Comments |
Employee | Created Updated Deleted | Employee deletion is a hard delete and will be removed from Time & Attendance and Auto-Rostering. |
Employee-contract | Updated | eg; Employee Leave date changed |
Employee-organisation | Updated | eg; Employee Department changed |
Employee-job | Updated | eg; Employee Job title changed |
Employee Data (Lookups)
Every T&A Organisation-lookup (LOCATION) is provisioned and the following synced:
T&A entity | T&A DB field | Rostering field | Events | Comments |
Organisation-lookup (LOCATION) | LUORG.Code + LUORG.Description | Location value | Created Updated Deleted | Every T&A Organisation-Lookup (LOCATION) is provisioned to Auto-Rostering |
Organisation-lookup (DEPARTMENT) | LUORG.Code + LUORG.Description | Department value | Created Updated Deleted | Every T&A Organisation-lookup (DEPARTMENT) is provisioned. |
Organisation-lookup (COSTCODE) | LUORG.Code + LUORG.Description | Costcode value | Created Updated Deleted | Every T&A Organisation-lookup (COSTCODE) is provisioned |
Organisation-lookup (DIVISION) | LUORG.Code + LUORG.Description | Division value | Created Updated Deleted | Every T&A Organisation-lookup (DIVISION) is provisioned |
Loopup (JOBTITLE) | LOOKUP.Code + LOOKUP.Description | Job Title | Created Updated Deleted | Every T&A Lookup (JOBTITLE) is provisioned |
Employee details
Rostering field | T&A entity | T&A DB field | Comments |
Username | Employee | TMSEMP.EmpRef | Required, unique |
First Name | Employee | TMSEMP.FirstNames | Required |
Last Name | Employee | TMSEMP.Surname | Required |
Employee | TMSEMP.Email | Required, unique | |
Start Date | Employee-contract | CE.StartDate | Required, must be before leave date |
Leave Date | Employee-contract | CE.LeaveDate | - |
Location | Employee-organisation | OD.Location | [Employee Data (Lookups) entity mapping] |
Department | Employee-job | JD.JobTitle | Job Titles linked to Per.UseJobAndJobDef preference are not supported. [Employee Data (Lookups) entity mapping] |
Weekly hours | Employee-contract | CE.WeeklyHours | - |
Absence Codes
Every T&A Absence-hours-code is provisioned to Auto-Rostering.
Rostering field | T&A entity | T&A BD field | Comments |
Name | Absence-hours-code | TMSAC.Descrip | Required, unique |
Colour | Absence-hours-code | Hardcoded as #dc4405 (red-orange) |
Employee Absences
From T&A employee planned absence, the following are provisioned and synced:
Rostering field | T&A entity | Event | T&A BD field | Comments |
Absence Code | Employee-planned-absence | Created Deleted | TMSFC.Code | Required. [Absence Code entity mapping] |
Absence Start | Employee-planned-absence | Created Deleted | TMSFC.StartDate | Required. |
Absence Start Time | Employee-planned-absence | Created Deleted | TMSFC.StartTime | If using T&A Non-rostered absence functionality |
Absence End | Employee-planned-absence | Created Deleted | TMSFC.EndDate | Required. |
Absence End Time | Employee-planned-absence | Created Deleted | TMSFC.EndTime | If using T&A Non-rostered absence functionality |
Absence Hours | Employee-planned-absence | Created Deleted | TMSFC.Hours |
From T&A general absence instance for employee, the following are provisioned:
Rostering field | T&A entity | T&A BD field | Comments |
Absence Code | General-absence | Code | Required. [Absence Code entity mapping] |
Absence Start | General-absence | StartDate | Required |
Absence End | General-absence | EndDate | Required |
Absence Hours | General-absence | Hours |
Skill Codes
Every T&A Skill-code is provisioned and the following events synced:
Rostering field | T&A entity | Events | T&A BD field | Comments |
Name | Skill-Code | Created Updated Deleted | TMSCSKLL.Code | Required, Unique |
Description | Skill-Code | Created Updated Deleted | TMSCSKLL.Descrip |
Employee Skills
From T&A skill, the following are provisioned and synced:
All Employee-skills are provisioned
Rostering field | T&A entity | Events | T&A BD field | Comments |
Skill Code | Employee-skill | Created Deleted | TMSEMPSK.SkillCode | Required [Skill Code entity mapping] |
From T&A qualification (dependent on configuration) the following are provisioned:
All Employee-qualifications are provisioned
Rostering field | T&A entity | T&A BD field | Comments |
Skill Code | Employee-qualification | QUAL. * | [Skill Code entity mapping] |
From T&A training record (dependent on configuration) the following are provisioned:
All Employee-training-record are provisioned
Rostering field | T&A entity | T&A BD field | Comments |
Skill Code | Employee-training-record | ** | [Skill Code entity mapping] |
Shifts (shift definitions)
Every T&A ‘named shift’ is provisioned (personalised shifts are not provisioned) and synced as follows:
Rostering field | T&A entity | Events | T&A BD field | Comments |
Group | Shift | Created Updated Deleted | - | Hardcoded as 'T&A' |
Code | Shift | Created Updated Deleted | TMSWS.Ref | Required |
Description | Shift | Created Updated Deleted | TMSWS.Descrip | |
Start Time | Shift | Created Updated Deleted | TMSWS.StartDay | Required. No time zone offset applied |
End Time | Shift | Created Updated Deleted | TMSWS.EndDay | Required. No time zone offset applied |
Hours | Shift | Created Updated Deleted | TMSWS.StdHours | Required |
Auto-Rostering to Time & Attendance
Nothing is provisioned from Auto-Rostering to Time & Attendance, however the following details below highlight the on going transfer of data that is synchronised from Auto-Rostering to Time & Attendance in response to certain events.
Rostering entity | Event | Example | Comments |
Schedule publish | Created | User selects 'Publish' for date range within a schedule | Created event is triggered and schedule sync request is created with state 'Pending' |
Created Event:
- Any previously created planned shifts for the same Auto-Rostering schedule within the Schedule publish date range are deleted in T&A.
- For each job assignment in the Schedule publish;
- An employee planned shift (read-only) is created in T&A and every field in the relevant Field mapping table is populated.
- An error is logged if employee planned shift cannot be created in T&A.
- An info message is logged if employee planned shift is successfully created in T&A.
- If a ‘Rostered job’ TAS category (unvalidated type) is defined for ‘Job Type’, then a planned rostered job is created for the duration of the Shift, as per Field mapping table.
- For each custom data value for the job;
- If a ‘Rostered job’ TAS category (lookup type) is defined for matching lookup, then a planned rostered job is created for the duration of the Shift, as per Field mapping table.
- An error is logged if Rostered job cannot be created in T&A.
- Result is sent back to Auto-Rostering containing;
- The status of the Schedule publish - 'Success' or 'Error'.
- A message for each job assignment with status 'Error' including a message
Schedule publish (Job assignments)
Assignment for job shift selected ('Shift job') are provisioned:
Rostering field | T&A entity | T&A BD field | Comments |
Employee | Employee-planned-shift | TMSFC.EmpRef | [Employee entity mapping] |
Shift | Employee-planned-shift | TMFC.Code | [Shift entity mapping] |
Start Date | Employee-planned-shift | TMSFC.StartDate |
Assignment for job without shift selected ('Time job') are provisioned:
Rostering field | T&A entity | T&A BD field | Comments |
- | Shift (personalised) | TMSWS.Ref | Generated |
Start Time | Shift (personalised) | TMSWS.StartDay | |
End Time | Shift (personalised) | TMSWS.EndDay | |
Hours | Shift (personalised) | TMSWS.StdHours | |
Employee | Employee-planned-shift | TMSFC.EmpRef | [Employee entity mapping] |
- | Employee-planned-shift | TMSFC.Code | Matching generated TMSWS.Ref |
Start Date | Employee-planned-shift | TMSFC.StartDate |
Job Type for job (optional) are provisioned:
Rostering field | T&A entity | T&A BD field | Comments |
- | Rostered-job | TMSWSJOBS.EmpRef | As per TMSFC.EmpRef for Employee-planned-shift |
- | Rostered-job | TMSWSJOBS.WsRef | As per TMSFC.Code for Employee-planned-shift |
- | Rostered-job | TMSWSJOBS.WsDate | As per TMSFC.StartDate for Employee-planned-shift |
- | Rostered-job | TMSWSJOBS.TasCode | Mapped to unvalidated TAS category selected for Job Type from Time & Attendance 'rostered jobs' configuration in Auto-Rostering setup wizard |
Job Type | Rostered-job | TMSWSJOBS.TasValue | Text description of Job Type from Auto-Rostering |
Custom data value for job (optional) are provisioned:
Rostering field | T&A entity | T&A BD field | Comments |
- | Rostered-job | TMSWSJOBS.EmpRef | As per TMSFC.EmpRef for Employee-planned-shift |
- | Rostered-job | TMSWSJOBS.WsRef | As per TMSFC.Code for Employee-planned-shift |
- | Rostered-job | TMSWSJOBS.WsDate | As per TMSFC.StartDate for Employee-planned-shift |
Custom data type | Rostered-job | TMSWSJOBS.TasCode | Mapped to TAS category with matching lookup from Time & Attendance 'rostered jobs' configuration in Auto-Rosrering setup wizard |