PayStub
| PayStubID | Unique ID for a pay stub | BigID | 12 | ||||||
| EmpUID | Employee Unique ID | BigID | 12 | ||||||
| CompanyID | Company Identifier | SmallID | 12 | ||||||
| PayDate | Date | 32 | |||||||
| StartDate | Starting Date | SmallDate | 32 | ||||||
| EndDate | End of a period | Date | 32 | ||||||
| CheckNumber | Check number on the paystub | Varchar | 20 | ||||||
| CheckType | (Check | Voucher) | Enum | 1 |
|
|||||
| LockSeqNbr | *SYSTEM* Row Sequence Nbr | Long | 12 |