Table: People Disciplinary Warning Letters
Primary Key: People
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| People Disciplinary Warning Letter ID | Long | 4 | ✓ | |
| People ID | Long | 4 | ||
| Date Issued | DateTime | 8 | ||
| Issued By | Text | 255 | ||
| Reason | Text | 255 | ||
| Warning Level | Text | 255 | ||
| Validity | Text | 255 | ||
| Expiry Date | DateTime | 8 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- People Disciplinary Warning Letters$People ID
- People Disciplinary Warning Letters$People Training Module ID
- People Disciplinary Warning Letters$PrimaryKey [PRIMARY KEY] [UNIQUE]