GreenshadesOnline Integration Help
dbo Schema
SQL Objects Database : dbo Schema
Tables
TableDescription
dbo.GS_ActiveEmployees 
dbo.GS_EEAddressTrackerResults 
dbo.GS_EEAddressTrackerResultSuggestions 
dbo.GS_EEGeocodeTrackerResultJurisdictions 
dbo.GS_EEGeocodeTrackerResults 
dbo.GS_EEGeocodeTrackerResultSuggestions 
dbo.GS_EEGeocodeTrackerResultUncertainPossibilities 
dbo.GS_SSNVTrackerResults 
dbo.GS_TrackerTaxRateResultsTaxTable 
dbo.GS_TrackerTaxRatesResults 
Views
ViewDescription
dbo.GO_Company941Reports 
dbo.GO_CompanyBenefitsThis Table is required for Paystub only integration.
dbo.GO_CompanyDeductionsThis Table is required for Paystub only integration.
dbo.GO_CompanyDepartmentsThis Table is required for Paystub only integration.
dbo.GO_CompanyFringeBenefits 
dbo.GO_CompanyLiabilities 
dbo.GO_CompanyLocalTaxCodes 
dbo.GO_CompanyLocationsThis Table is required for Paystub only integration.
dbo.GO_CompanyPayCodesThis Table is required for Paystub only integration.
dbo.GO_CompanyPositionsThis Table is required for Paystub only integration.
dbo.GO_CompanyStateW2Ids 
dbo.GO_CompanySUTARates 
dbo.GO_CompanyTimeOffCodesThis Table is required for Paystub only integration.
dbo.GO_EmployeeAdditionalFields 
dbo.GO_EmployeeAddressesThis Table is required for Paystub only integration.
dbo.GO_EmployeeAnnualSalaries 
dbo.GO_EmployeeContacts 
dbo.GO_EmployeeDDAInfo 
dbo.GO_EmployeeDeductions 
dbo.GO_EmployeeDependents 
dbo.GO_EmployeeFederalWithholdingExemptions 
dbo.GO_EmployeeFringeBenefitElectedCoverages 
dbo.GO_EmployeeFringeBenefitEnrolledDependents 
dbo.GO_EmployeeI9s 
dbo.GO_EmployeeLocalTaxCodesThis Table is required for Paystub only integration.
dbo.GO_EmployeePayCodeAssignments 
dbo.GO_EmployeePayRecordBenefitsThis Table is required for Paystub only integration.
dbo.GO_EmployeePayRecordDeductionsThis Table is required for Paystub only integration.
dbo.GO_EmployeePayRecordDirectDepositHistoryThis Table is required for Paystub only integration.
dbo.GO_EmployeePayRecordEarningsThis Table is required for Paystub only integration.
dbo.GO_EmployeePayRecordsThis Table is required for Paystub only integration.
dbo.GO_EmployeePayRecordTaxesThis Table is required for Paystub only integration.
dbo.GO_EmployeePayRecordTimeOffBalancesThis Table is required for Paystub only integration.
dbo.GO_EmployeesThis Table is required for Paystub only integration.
dbo.GO_EmployeeStateWithholdingExemptionsThis Table is required for Paystub only integration.
dbo.GO_EmployeeSUTAWages 
dbo.GO_EmployeeTimeOffBalances 
dbo.GO_EmployeeW4s 
Stored Procedures
Stored ProcedureDescription
dbo.GS_EEGeocodeTrackerClearCache 
dbo.GS_RefreshEEAddressTrackerResults 
dbo.GS_RefreshEEGeocodeTrackerResults 
dbo.GS_RefreshSSNVTrackerResults 
See Also

Related Objects

SQL Objects Database

 

 

© 2015 All Rights Reserved.

Send comments on this topic.