GreenshadesOnline Integration Help
dbo.GO_EmployeePayRecordTaxes View
| SQL Objects Database > dbo Schema : dbo.GO_EmployeePayRecordTaxes 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 | char | 15 | ||||
| CheckDate | Stores the check date in datetime format | datetime | 4 | ||||
| CheckNumber | Stores the check number | char | 21 | ||||
| BatchCode | Batch code differentiates payroll batches | char | 13 | ||||
| JurisdictionType | The jurisdiction type. Excepted Values: Local State Federal | varchar | 7 | ||||
| Jurisdiction | Use Greenshades Jurisdiction Name: Accepted Abbreviations | varchar | 30 |  | |||
| TaxType | Stores the type of tax, e.g. Withholding, Unemployment | varchar | 50 | ||||
| SubType | Stores the subtype of the tax, e.g. Employee, Employer If it is a state withholding, it should be null and if it's a federal then it should be specified as Employee or Employer; Disability if it is SDI | varchar | 100 | ||||
| Code | Unique Identifier for a specific tax; when providing Federal Income, Social Security, and Medicare tax rows, you must use FED, SS, and MED as the Code Code must have a 1 to 1 relationship with a tax Type. Example: You may only assign one code to a specific locality withholding | varchar | 50 | | |||
| CodeDescription | Description of the specific tax | varchar | 150 | | |||
| StartDate | Stores the tax start date | datetime | 4 | ||||
| EndDate | Stores the tax end date | datetime | 4 | ||||
| TaxAmount | Stores the tax amount | numeric | 9 (20,5) | | |||
| TaxAmountYTD | int | 4 | |||||
| TaxAmoutJustOnTips | Stores the Tax amount just on tips | numeric | 9 (19,5) | ||||
| TaxableWages | Stores the taxable wages | numeric | 9 (19,5) | ||||
| UserDefined1 | varchar | 1 | |||||
| UserDefined2 | varchar | 1 | |||||
| EmployeeVisible | 1 visible to employee on paystubs, 0 not visible to employee on paystubs. | bit | 1 | | |||
| RowID | int | 4 | |||||
| Parent_PayRecordRowID | int | 4 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | dbo.GO_EmployeeAddresses | View | This Table is required for Paystub only integration. | 2 |
| dbo.GO_EmployeePayRecords | View | This Table is required for Paystub only integration. | 1 |