GreenshadesOnline Integration Help
dbo.GO_CompanyDeductions View
| SQL Objects Database > dbo Schema : dbo.GO_CompanyDeductions View |
| Creation Date | 7/17/2015 10:23 AM |
| Is Schema Bound |  |
| Encrypted | |
| Ansi Nulls |  |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| DeductionCodeID | Unique payroll deduction code or ID | varchar | 50 |  | |||
| Description | Description of the Deduction | varchar | 100 | | |||
| Active | Indicates whether this deduction is active or not | bit | 1 | | |||
| BeginDate | The effective date for this deduction | datetime | 4 | ||||
| EndDate | The ending date for this deduction, if applicable | datetime | 4 | ||||
| ShelteredFromFuta | Indicates whether the deduction is sheltered from federal unemployment tax | bit | 1 | | |||
| TaxShelteredAnnuity | Indicates whether this is a tax-sheltered annuity | bit | 1 | | |||
| ShelteredFromFederalTax | Indicates whether the deduction is sheltered from federal income tax | bit | 1 | | |||
| ShelteredFromFica | Indicates whether the deduction is sheltered from FICA | bit | 1 | | |||
| ShelteredFromStateTax | Indicates whether the deduction is sheltered from state tax | bit | 1 | | |||
| ShelteredFromLocalTax | Indicates whether the deduction is sheltered from local tax | bit | 1 | |