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