Table: Positions
Primary Key: Position
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Position ID | Long | 4 | ✓ | |
| Import ID | Long | 4 | ||
| Position Status ID | Long | 4 | ||
| Position Effective Date | DateTime | 8 | ||
| Start Date | DateTime | 8 | ||
| Termination Date | DateTime | 8 | ||
| Date Eliminated | DateTime | 8 | ||
| Date Suspended | DateTime | 8 | ||
| Training Approver ID | Long | 4 | ||
| Second Training Approver ID | Long | 4 | ||
| Organisational ID | Long | 4 | ||
| Job ID | Long | 4 | ||
| Pay Point ID | Long | 4 | ||
| Company ID | Long | 4 | ||
| Reporting To ID | Long | 4 | ||
| Employment Status | Text | 255 | ||
| Last Modified By | Text | 255 | ||
| Date Modified | DateTime | 8 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Positions$Delivery Location ID
- Positions$Import ID
- Positions$Job ID
- Positions$Organisational ID
- Positions$Pay Point ID
- Positions$Position Status ID
- Positions$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Positions$Reporting To ID
- Positions$Second Training Approver ID