CompPlan
| CompPlanID | Unique identifier for a compensation plan. | BigID | 12 | ||||||||
| CompanyID | Company Identifier | SmallID | 12 | ||||||||
| Name | Varchar | 80 | |||||||||
| Notes | Comments | Text | 16000 | ||||||||
| StartDate | Starting Date | SmallDate | 32 | ||||||||
| StopDate | Ending Date | Date | 32 | ||||||||
| SalUnitType | Hourly, Daily, Annualizable | Enum | 1 | ENUM
|
|||||||
| ActiveFlag | A-Active, I-Inactive | Varchar | 1 | ||||||||
| LstModDate | Last Modified Date | Date | 32 | ||||||||
| LstModBy | Last Modified By Name | Varchar | 40 | ||||||||
| LockSeqNbr | *SYSTEM* Row Sequence Nbr | Long | 12 |