GreenshadesOnline Integration Help
dbo.GO_EmployeeSUTAWages View
| SQL Objects Database > dbo Schema : dbo.GO_EmployeeSUTAWages View |
| Creation Date | 7/17/2015 10:23 AM |
| Is Schema Bound |  |
| Encrypted | |
| Ansi Nulls |  |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| EmployeeID | Stores the unique identifier of a specific employee | varchar | 50 |  | |||
| State | State where SUTA is being reported | varchar | 3 | | |||
| QuarterlySutaWages | money | 8 | | ||||
| QuarterlyTaxableWages | money | 8 | | ||||
| QuarterlySutaExcessWages | money | 8 | | ||||
| SutaTax | money | 8 | | ||||
| AnnualSutaWages | money | 8 | | ||||
| AnnualTaxableWages | money | 8 | | ||||
| AnnualSutaExcessWages | money | 8 | | ||||
| WeeksWorked | numeric | 9 (17,6) | | ||||
| HoursWorked | numeric | 9 (17,6) | | ||||
| ReportingDate | The last day of the reporting period for which the unemployment report is for. | datetime | 4 | | |||
| Type | SUTA | varchar | 4 | ||||
| RanDate | datetime | 4 | |||||
| SutaWageBase | SUTA wage base for each state | money | 8 | | |||
| SutaTaxRate | SUTA Tax Rate for each state (decimal)
| money | 8 | | |||
| ReportingPeriodBeginDate | datetime | 4 | | ||||
| Parent_EmployeeID | varchar | 50 | |