Table: Job Codes
Primary Key: Job
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Job ID | Long | 4 | ✓ | |
| Job | Text | 255 | ✓ | |
| Job Code | Text | 255 | ||
| DESCRIPTION | Memo | - | ||
| Management | Boolean | 1 | ||
| EE Job Category ID | Long | 4 | ||
| Job Profile File Name | Text | 255 | ||
| Active | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Job Codes$CODE
- Job Codes$ID [PRIMARY KEY] [UNIQUE]