SQL Table Exports
Database table exports for external processing and analysis.
Available SQL Table Query Exports
| Export | Description | Download |
|---|---|---|
| ACCRUALACTIVITY | Accrual activity records | Download Export |
| ARCHIVES | Archived data records | Download Export |
| BENEFITS | Employee benefits information | Download Export |
| BENHIST | Employee benefits history | Download Export |
| Covbudgets | Coverage budget data | Download Export |
| Coveragetypes | Coverage type definitions | Download Export |
| EMPLOYEEACTIVITY | Employee activity tracking | Download Export |
| EMPLOYEEHR | Employee HR records | Download Export |
| Employees | Core employee data | Download Export |
| EXCEPTIONS | Exception records | Download Export |
| Paydeshist | Pay designation history | Download Export |
| PAYDESIGNATIONS | Pay designation codes | Download Export |
| PAYPERIODINFO | Pay period information | Download Export |
| REASONS | Reason codes | Download Export |
| Schedules | Schedule data | Download Export |
| SUPEDITHIST | Supervisor edit history | Download Export |
| SUPEDITS | Supervisor edits | Download Export |
| TRANSACTIONS | Transaction records | Download Export |
| Unfulfilledschs | Unfulfilled schedules | Download Export |
| USERGROUP | User group assignments | Download Export |
| USERS | User account data | Download Export |
| Wg1 | Workgroup 1 data | Download Export |
| Wg2 | Workgroup 2 data | Download Export |
| Wg3 | Workgroup 3 data | Download Export |
| Wg4 | Workgroup 4 data | Download Export |
| Wg5 | Workgroup 5 data | Download Export |
| Wg6 | Workgroup 6 data | Download Export |
| Wg7 | Workgroup 7 data | Download Export |
| WORKGROUPTRANS | Workgroup transactions | Download Export |