GreenshadesOnline Integration Help
dbo.GO_EmployeeAnnualSalaries View
| SQL Objects Database > dbo Schema : dbo.GO_EmployeeAnnualSalaries 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 | ||||
| PayCode | Paycode associated to employees annual salary | varchar | 50 |  | |||
| AnnualHoursWorked | Hours worked in a year | int | 4 | | |||
| PayRate | Employee’s per unit Pay Rate | numeric | 9 (19,5) | ||||
| PayRateFrequency | Frequency at which the employee is paid. Example: (coming soon) | varchar | 12 | ||||
| Parent_EmployeeID | char | 15 |