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