Table: People Payroll Information
Primary Key: People
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| People Payroll Information ID | Long | 4 | ✓ | |
| People ID | Long | 4 | ||
| Date Captured | DateTime | 8 | ||
| Payroll Item | Text | 255 | ||
| Payroll Period Month | Text | 255 | ||
| Payroll Period Year | Long | 4 | ||
| Notes | Text | 255 | ||
| Actioned | Long | 4 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- People Payroll Information$People ID
- People Payroll Information$People Training Module ID
- People Payroll Information$PrimaryKey [PRIMARY KEY] [UNIQUE]