Table: vwPurpleWeavePrincipalProjectPillarList
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Principal Project Pillar ID | Long | 4 | ✓ | |
| Principal Project ID | Long | 4 | ||
| Principal | Text | 255 | ||
| Project Name | Text | 255 | ||
| BBBEE Pillar | Text | 255 | ||
| Number of Companies Required | Double | 8 | ||
| Principal Project Status ID | Long | 4 | ||
| Status | Text | 255 | ||
| Scout | Text | 255 | ||
| Solutions Architect | Text | 255 | ||
| Principal Project Pillar Urgency | Byte | 1 | ✓ | |
| Amount Sponsored | Double | 8 | ||
| Unallocated Companies | Long | 4 | ||
| Number Exited Companies | Long | 4 | ||
| Number Active Allocated Companies | Long | 4 | ||
| Total Sponsorship Amt | Double | 8 | ||
| Number of Replacements Needed | Long | 4 | ||
| Key Account Manager | Text | 255 | ||
| Date Principal Requires Packs | DateTime | 8 | ||
| Lump Sum Allocation | Boolean | 1 |