GreenshadesOnline Integration Help
dbo.GO_EmployeePayRecordBenefits View
| SQL Objects Database > dbo Schema : dbo.GO_EmployeePayRecordBenefits 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 | ||||
| Code | varchar | 50 |  | ||||
| CodeDescription | Stores the description of the benefit in question | varchar | 100 | | |||
| StartDate | Stores the benefit start date | datetime | 4 | ||||
| EndDate | Stores the benefit end date, if applicable | datetime | 4 | ||||
| BenefitAmount | Stores the amount (Decimal) of the benefit for the check in question | numeric | 9 (19,5) | ||||
| BenefitAmountYTD | int | 4 | |||||
| UserDefined1 | int | 4 | | ||||
| UserDefined2 | int | 4 | | ||||
| RowID | int | 4 | |||||
| Parent_PayRecordRowID | int | 4 |