| CompPlanID
|
Unique identifier for a compensation plan. |
BigID |
12 |
|
| CompanyID
|
Company Identifier |
SmallID |
12 |
|
| SalaryType
|
Salary Type (E, N, H, X) |
Enum |
1 |
|
 ENUM
| E | Salary Exempt |
| H | Hourly Non-Exempt |
| N | Salary Non-Exempt |
| X | Hourly Exempt |
|
| Name
|
|
Varchar |
80 |
|
| Notes
|
Comments |
Text |
16000 |
|
| StartDate
|
Starting Date |
SmallDate |
32 |
|
| StopDate
|
Ending Date |
Date |
32 |
|
| CurrencyType
|
Indicates the windows currency type |
Long |
12 |
|
| HoursPerWk
|
Hours Per Week |
Number |
22 |
|
| PayPeriod
|
Pay Period |
Enum |
1 |
|
ENUM
| D | Daily |
| W | Weekly |
| B | Bi-Weekly |
| S | Semi-Monthly |
| M | Monthly |
|
| Period
|
Period |
Long |
12 |
|
| LstModDate
|
Last Modified Date |
Date |
32 |
|
| LstModBy
|
Last Modified By Name |
Varchar |
40 |
|
| LockSeqNbr
|
*SYSTEM* Row Sequence Nbr |
Long |
12 |
|