GreenshadesOnline Integration Help
dbo.GO_EmployeeTimeOffBalances View
| SQL Objects Database > dbo Schema : dbo.GO_EmployeeTimeOffBalances View |
| Creation Date | 7/17/2015 10:23 AM |
| Is Schema Bound |  |
| Encrypted | |
| Ansi Nulls |  |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| Balance | Stores the time off balance as of the current check | decimal | 9 (28,12) |  | |||
| DateObservedUTC | This should be the check date corresponding to the check number | datetime | 4 | | |||
| TimeOffCode | This field uniquely identifies the time off type, e.g. VAC, SCK, HOL | varchar | 10 | ||||
| EmployeeID | Stores the unique identifier of a specific employee | char | 15 | ||||
| Parent_EmployeeID | Same as EmployeeID | char | 15 |