Table: Job Code Training Modules
Primary Key: Job
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Job Code Training Module ID | Long | 4 | ✓ | |
| Job ID | Long | 4 | ||
| Training Type ID | Long | 4 | ||
| Training Course ID | Long | 4 | ||
| Training Module ID | Long | 4 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ | |
| Sort Order | Long | 4 |
Indexes
- Job Code Training Modules$Application Status ID
- Job Code Training Modules$Course ID
- Job Code Training Modules$Job Code Application Step ID
- Job Code Training Modules$Job ID
- Job Code Training Modules$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Job Code Training Modules$Training Type ID