Table: ProcessStatus
Primary Key: Process
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Process Status ID | Long | 4 | ✓ | |
| Step Number | Long | 4 | ||
| Progress Category ID | Long | 4 | ||
| Status | Text | 255 | ||
| Status Type | Text | 255 | ||
| Time Unit | Long | 4 | ||
| Active | Boolean | 1 | ||
| Sort Order | Double | 8 | ||
| Last Modified By | Text | 255 | ||
| Date Modified | DateTime | 8 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ | |
| Selection Type | Long | 4 |
Indexes
- ProcessStatus$PrimaryKey [PRIMARY KEY] [UNIQUE]
- ProcessStatus$Progress Category ID