Table: People Training Modules
Primary Key: People
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| People Training Module ID | Long | 4 | ✓ | |
| People ID | Long | 4 | ||
| Job Code Training Module ID | Long | 4 | ||
| Training Version | Text | 255 | ||
| Date Scheduled | DateTime | 8 | ||
| Date Completed | DateTime | 8 | ||
| Quiz Score | Long | 4 | ||
| Assessment Score | Long | 4 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ | |
| People Training Module Status ID | Long | 4 |
Indexes
- People Training Modules$Job Code Training Module ID
- People Training Modules$People ID
- People Training Modules$People Training Module ID
- People Training Modules$PrimaryKey [PRIMARY KEY] [UNIQUE]