Table: Application Status
Primary Key: Application
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Application Status ID | Long | 4 | ✓ | |
| Application Status | Text | 255 | ||
| Stage Number | Long | 4 | ||
| Sort Order | Long | 4 | ||
| Default Step | Boolean | 1 | ||
| Assessment Step | Boolean | 1 | ||
| Report Point | Boolean | 1 | ||
| Time Unit | Long | 4 | ||
| Active | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Application Status$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Application Status$Submission Status ID