Table: Purple Panels
Primary Key: Purple
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Purple Panel ID | Long | 4 | ✓ | |
| Purple Panel Date | DateTime | 8 | ||
| Purple Panel Time | DateTime | 8 | ||
| Entrepreneur Company ID | Long | 4 | ||
| Recommended Product | Text | 255 | ||
| Suitabe for Recommended Programme | Long | 4 | ||
| Recommend Suitable Programme | Text | 255 | ||
| Rubric ID | Long | 4 | ||
| Changed Rubric Switch | Boolean | 1 | ||
| Possible Score | Double | 8 | ||
| Average Score | Double | 8 | ||
| Strengths Summary | Memo | - | ||
| Developmental Areas Summary | Memo | - | ||
| Adjusted Average Score | Double | 8 | ||
| Reason for Score Adjustment | Text | 255 | ||
| Purple Panel Status ID | Long | 4 | ||
| Submitted | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ | |
| Panel Feedback to COO | Memo | - | ||
| Recommend Suitable Programme ID | Long | 4 | ||
| Recommended Programme NA | Boolean | 1 | ||
| EP Division ID | Long | 4 | ||
| EP Distribution Model ID | Long | 4 |
Indexes
- Purple Panels$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Purple Panels$Purple Panel ID
- Purple Panels$Rubric ID