Overview
Contact Us
Start Here
Prospective Client or Partner
New Client Integrator
New Partner Integrator
Integration Work Flow
Sync Application
Product Description
Features of the Sync Application
Self Updating
Support Tools
How To
Install the Sync Application
Set up a New Company
Use Command Line Options
Test Integration Files
Portal Integration
Portal Integration Options
Pass-Through Authentication
Overview
User Experience
Technical Work Flow
Example Code
Embedded iFrame
Data Integration Options
Data Format Options
Supported Formats
Flat Files
Employees
EmployeeAddresses
EmployeeCustomFields
CompanyLocations
CompanyPayrollEarningsCodes
CompanyPayrollDeductions
CompanyPayrollBenefits
EmployeePayRecords
EmployeePayRecordBenefits
EmployeePayRecordDeductions
EmployeePayRecordEarnings
EmployeePayRecordTaxes
EmployeeDeductions
EmployeePayRecordDirectDeposits
EmployeeStateExemptions
EmployeePayRecordTimeOffBalances
CompanyTimeOffCodes
CompanyFUTARates
CompanyStateW2Ids
CompanySUTARates
Company940Reports
Company941Reports
EmployeeSutaWages
XML File Format Schema
Overview
Elements
SyncDataSet Element
SQL Objects Database
Overview
Schemas
dbo Schema
Overview
Tables
dbo.GS_ActiveEmployees Table
dbo.GS_EEAddressTrackerResults Table
Indexes
PK__GS_EEAdd__CE9488702E77FACA Index
UQ__GS_EEAdd__7AD04FF016891628 Index
Relationships
FK__GS_EEAddr__Addre__48933A82 Relationship
dbo.GS_EEAddressTrackerResultSuggestions Table
Relationships
FK__GS_EEAddr__Addre__48933A82 Relationship
dbo.GS_EEGeocodeTrackerResultJurisdictions Table
Relationships
FK__GS_EEGeoc__Geoco__51288083 Relationship
dbo.GS_EEGeocodeTrackerResults Table
Indexes
PK__GS_EEGeo__0A076853BD4ED75F Index
UQ__GS_EEGeo__7AD04FF0CED73E17 Index
Relationships
FK__GS_EEGeoc__Geoco__4F403811 Relationship
FK__GS_EEGeoc__Geoco__51288083 Relationship
dbo.GS_EEGeocodeTrackerResultSuggestions Table
Indexes
PK__GS_EEGeo__A4303003C02138D6 Index
Relationships
FK__GS_EEGeoc__Geoco__4F403811 Relationship
FK__GS_EEGeoc__Geoco__5310C8F5 Relationship
dbo.GS_EEGeocodeTrackerResultUncertainPossibilities Table
Relationships
FK__GS_EEGeoc__Geoco__5310C8F5 Relationship
dbo.GS_SSNVTrackerResults Table
Indexes
PK__GS_SSNVT__99F5F91EC803779C Index
UQ__GS_SSNVT__7AD04FF05096AE34 Index
dbo.GS_TrackerTaxRateResultsTaxTable Table
Relationships
FK__GS_Tracke__Track__634730BE Relationship
dbo.GS_TrackerTaxRatesResults Table
Indexes
PK__GS_Track__20B3CEE0DD12966B Index
Relationships
FK__GS_Tracke__Track__634730BE Relationship
Views
dbo.GO_Company941Reports View
dbo.GO_CompanyBenefits View
dbo.GO_CompanyDeductions View
dbo.GO_CompanyDepartments View
dbo.GO_CompanyFringeBenefits View
dbo.GO_CompanyLiabilities View
dbo.GO_CompanyLocalTaxCodes View
dbo.GO_CompanyLocations View
dbo.GO_CompanyPayCodes View
dbo.GO_CompanyPositions View
dbo.GO_CompanyStateW2Ids View
dbo.GO_CompanySUTARates View
dbo.GO_CompanyTimeOffCodes View
dbo.GO_EmployeeAdditionalFields View
dbo.GO_EmployeeAddresses View
dbo.GO_EmployeeAnnualSalaries View
dbo.GO_EmployeeContacts View
dbo.GO_EmployeeDDAInfo View
dbo.GO_EmployeeDeductions View
dbo.GO_EmployeeDependents View
dbo.GO_EmployeeFederalWithholdingExemptions View
dbo.GO_EmployeeFringeBenefitElectedCoverages View
dbo.GO_EmployeeFringeBenefitEnrolledDependents View
dbo.GO_EmployeeI9s View
dbo.GO_EmployeeLocalTaxCodes View
dbo.GO_EmployeePayCodeAssignments View
dbo.GO_EmployeePayRecordBenefits View
dbo.GO_EmployeePayRecordDeductions View
dbo.GO_EmployeePayRecordDirectDepositHistory View
dbo.GO_EmployeePayRecordEarnings View
dbo.GO_EmployeePayRecords View
dbo.GO_EmployeePayRecordTaxes View
dbo.GO_EmployeePayRecordTimeOffBalances View
dbo.GO_Employees View
dbo.GO_EmployeeStateWithholdingExemptions View
dbo.GO_EmployeeSUTAWages View
dbo.GO_EmployeeTimeOffBalances View
dbo.GO_EmployeeW4s View
Stored Procedures
dbo.GS_EEGeocodeTrackerClearCache Stored Procedure
dbo.GS_RefreshEEAddressTrackerResults Stored Procedure
dbo.GS_RefreshEEGeocodeTrackerResults Stored Procedure
dbo.GS_RefreshSSNVTrackerResults Stored Procedure
Examples
SQL Examples
SQL Pay History Examples
SQL Benefits Self Service Examples
SQL Payroll Tax Service Examples
Flat File Examples
FF Pay History Example
FF Payroll Tax Service Example
XML Examples
XML Pay History Example
XML Benefits Self Service Example
XML Payroll Tax Service Example
Payroll Tax Service Jurisdiction Mappings
Payroll Tax Service State Jurisdiction Mappings
Payroll Tax Service Country Jurisdiction Mappings
Payroll Tax Service Local Reporting Jurisdiction Mappings