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.

 

mceclip0.png

 

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

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share