Integration

Flat-File Templates

The following XLS templates are required to drive incoming data streams from integrated applications. Each template houses a ‘Documentation’ tab that lists the requirements for each column. Please see the sFTP guide for instructions on how to request a setup of flat-file recurring integrations. If you have additional questions, please get in touch with your customer service manager.

Template Name Flat File Coverage
Work Records Import only
Employees Both Import and Export
Employee Jobs Both Import and Export
Employee Shift Patterns From Library Both Import and Export
Employee Seniority Both Import and Export
Employee Permissions Group Both Import and Export
Employee Approval Managers Both Import and Export
Employee Secondary Locations Both Import and Export
Employee Secondary Positions Both Import and Export
Employee Qualifications And Proficiencies Both Import and Export
Employee Team Codes Both Import and Export
Employee Skill Codes Both Import and Export
Employee Overtimes Both Import and Export
Employee Notification Preferences Both Import and Export
Employee Schedule Export only
Daily Core Staffing Requirements Both Import and Export
Leave Requests Both Import and Export
Position (Rank) Codes Both Import and Export
Location (Unit) Codes Both Import and Export
Leave Account Yearly Allowances Both Import and Export
Leave Account Balances Both Import and Export
Time Entries Import only