GreenshadesOnline Integration Help
dbo.GO_EmployeeW4s View
| SQL Objects Database > dbo Schema : dbo.GO_EmployeeW4s 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 | ||||
| W4Year | int | 4 |  | ||||
| W4FirstName | varchar | 15 | | ||||
| W4MiddleInitial | varchar | 1 | | ||||
| W4LastName | varchar | 21 | | ||||
| W4Address | char | 61 | |||||
| W4City | char | 35 | |||||
| W4State | varchar | 2 | |||||
| W4ZipCode | char | 11 | |||||
| W4SocialSecurityNumber | varchar | 15 | | ||||
| W4FilingMaritalStatus | Married Single MarriedFilingSingle Exempt | varchar | 19 | ||||
| W4LastNameDiffersFromCard | bit | 1 | | ||||
| W4AdditionalAmount | decimal | 9 (10,4) | | ||||
| W4Allowances | int | 4 | | ||||
| W4Exemption | varchar | 6 | |||||
| Active | bit | 1 | | ||||
| Parent_EmployeeID | char | 15 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | dbo.GO_EmployeeAddresses | View | This Table is required for Paystub only integration. | 1 |