Table: Applications
Primary Key: Application
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Application ID | Long | 4 | ✓ | |
| Import ID | Long | 4 | ||
| People ID | Long | 4 | ||
| Position ID | Long | 4 | ||
| Application Status ID | Long | 4 | ||
| Application Status Notes | Text | 255 | ||
| Date Status Changed | DateTime | 8 | ||
| Last Modified By | Text | 255 | ||
| Application Date | DateTime | 8 | ||
| How Heard About Position | Text | 255 | ||
| Application Notes | Text | 255 | ||
| Regret Reason ID | Long | 4 | ||
| CV Not Suitable Reason ID | Long | 4 | ||
| Telephone Interviewer | Text | 255 | ||
| Telephone Interview Date | DateTime | 8 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Applications$Application Status ID
- Applications$Import ID
- Applications$People ID
- Applications$Position ID
- Applications$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Applications$Regret Reason ID
- Applications$Regret Reason ID1