GreenshadesOnline Integration Help
dbo.GO_CompanyBenefits View
| SQL Objects Database > dbo Schema : dbo.GO_CompanyBenefits View |
| Creation Date | 7/17/2015 10:23 AM |
| Is Schema Bound |  |
| Encrypted | |
| Ansi Nulls |  |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| BenefitCodeID | Stores the unique identifier to a specific benefit | varchar | 50 |  | |||
| Description | Description of the Benefit | varchar | 100 | | |||
| Active | Indicates whether this benefit is active or not | bit | 1 | | |||
| BeginDate | The effective date for this benefit | datetime | 4 | ||||
| EndDate | The ending date for this benefit, if applicable | datetime | 4 | ||||
| Taxable | Indicates whether this benefit is subject to taxation | bit | 1 | | |||
| SubjectToFederalTax | Indicates whether this benefit is subject to federal income tax | bit | 1 | | |||
| SubjectToSocialSecurity | Indicates whether this benefit is subject to FICA Social Security tax | bit | 1 | | |||
| SubjectToMedicare | Indicates whether this benefit is subject to FICA Medicare tax | bit | 1 | | |||
| SubjectToStateTax | Indicates whether this benefit is subject to state tax | bit | 1 | | |||
| SubjectToLocalTax | Indicates whether this benefit is subject to local tax | bit | 1 | | |||
| SubjectToFuta | Indicates whether this benefit is subject to federal unemployment tax | bit | 1 | | |||
| SubjectToSuta | Indicates whether this benefit is subject to state unemployment tax | bit | 1 | |