Unemployment Tracker Integration

Overview

Unemployment Tracker helps staffing companies track, handle, and fight unemployment claims, allowing their team to focus their time, money, and resources not on employees of yesterday – but on the team they have today and the one they are building for tomorrow.

Unemployment Tracker and Avionte partnered to create an integration that was built to increase efficiencies and decrease manual effort by automatically syncing employee, assignment, message, and payroll data between Avionte and Unemployment Tracker.

Printer Friendly version

Integration Details
    Employee File
    Assignment File
    Placement Notes File – BOLD Only
    Message File
    Payroll File
Data Mapping
    Employee Export Field Mapping
    Assignment Export Field Mapping
    Placement Note Export Field Mapping
    Message Export Field Mapping
    Payroll Export Field Mapping

Integration Details

Employee File

• The first file sent to Unemployment Tracker will contain all employee records
• Subsequent files will only include new employee and updated employee records
• File is being sent every Tuesday at 10:00 pm CT
  
  

Assignment File

• The first file sent to Unemployment Tracker will contain all assignment records
• Subsequent files will only include new assignment and updated assignment records
• File is being sent every Tuesday at 10:00 pm CT
  
  

Placement Notes File – BOLD Only

• The file sent to Unemployment Tracker will contain:
  • Placement Notes for newly created placements where the notes field is not NULL 
  • Placement Notes that have been updated
• File is being sent every Tuesday at 10:00 pm CT
  
  

Message File

• The first file sent to Unemployment Tracker will contain message records linked to employees and assignments that were created within the last 3 months
• Subsequent files will only include new message and updated message records linked to employees and assignments
• File is being sent every Tuesday at 10:00 pm CT
  
  

Payroll File

• The first file sent to Unemployment Tracker will contain paycheck records with a check date within the last 18 months
• Subsequent files will only include paycheck records that were processed for the previous account period where the accounting period is closed
  • If the accounting period isn’t closed by the time the payroll file is generated, the paycheck records will get picked up on the next file
• File is being sent every Tuesday at 10:00 pm CT

Back to Top

Data Mapping

Employee Export Field Mapping

Data	Avionte Field	Notes
Employee ID	Employee > EmployeeID	EmployeeID from Classic
Employee First Name	Employee > First Name
Employee Last Name	Employee > Last Name
Employee SSN	Employee > SSN
Employee Branch	Employee > Branch
Employee Status	Employee > Status

Back to Top

Assignment Export Field Mapping

Data	Avionte Field	Notes
Assignment ID	Assignment > AssignmentID	AssignmentID from Classic
Employee ID	Employee > EmployeeID	EmployeeID from Classic
Assignment Job Title	Assignment > Job Title
Assignment Start Date	Assignment > Start Date
Assignment End Date	Assignment > End Date
Assignment End Reason	Assignment > End Reason
Assignment Performance Code	Assignment > Performance
Assignment Entered By Username	Assignment > User > Entered By
Assignment Customer Name	Assignment > Customer
Assignment Branch	Assignment > Branch
Assignment Department Name	Assignment > Department
Customer Branch	Customer > Branch Name
Placement ID		PlacementID from BOLD

Back to Top

Placement Note Export Field Mapping

Data	Avionte Field	Notes
PlacementID		req_hired_id from BOLD db
PerformanceNote	Hired Details > Notes

Back to Top

Message Export Field Mapping

Data	Avionte Field	Notes
Message ID		StaffingActionFKGUID from Classic db
Action Type	Message > Action Type
Subject	Message > Subject
Message	Message > Message
Created Date	Message > Date
Entered By User	Message > User
Customer Name	Customer > Customer Name	Customer associated to the assignment the message is linked to
EmployeeID	Employee > EmployeeID	Employee the message is linked to
AssignmentID	Assignment > AssignmentID	Assignment the message is linked to

Back to Top

Payroll Export Field Mapping

Data	Avionte Field	Notes
Employee ID	Employee > EmployeeID	Employee that the paycheck is associate with
Check Date	Employee > Pay History > Check Date
Check Number	Employee > Pay History > Check Number
Supplier	Employee > Pay History > Supplier
PayTotalHours	Employee > Pay History > Transaction > PayUnit
Gross Wages	Employee > Pay History > Gross Pay
Net Pay	Employee > Pay History > Net Amount
Week Start Date		Calculated value – 6 days prior to the Week End Date
Week End Date	Employee > Pay History > Week End Date

Back to Top