• 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