Table: vwPurpleReportRAG
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Principal Project Pillar ID | Long | 4 | ||
| Principal Project Status ID | Long | 4 | ||
| Lump Sum Allocation | Boolean | 1 | ||
| Principal Project ID | Long | 4 | ✓ | |
| Principal | Text | 255 | ||
| Project Name | Text | 255 | ||
| BBBEE Pillar | Text | 255 | ||
| Brief Date | DateTime | 8 | ||
| Number of Companies Required | Double | 8 | ||
| Entrepreneur Delivery Date | DateTime | 8 | ||
| Amount Sponsored | Double | 8 | ||
| Total Sponsorship Amt | Double | 8 | ||
| Number Exited Companies | Long | 4 | ||
| Unallocated Companies | Long | 4 | ||
| Number of Replacements Needed | Long | 4 | ||
| Number Active Allocated Companies | Long | 4 |