Table: Submissions Status History
Primary Key: Submission
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Submission Status History ID | Long | 4 | ✓ | |
| Submission ID | Long | 4 | ||
| Submission Status ID | Long | 4 | ||
| Submission Status Notes | Text | 255 | ||
| Date Status Changed | DateTime | 8 | ||
| Status Modified By | Text | 255 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Submissions Status History$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Submissions Status History$Submission ID
- Submissions Status History$Submission Status ID