Table: Principal Project Pillars
Primary Key: Principal
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Principal Project Pillar ID | Long | 4 | ✓ | |
| Principal Project ID | Long | 4 | ||
| BBBEE Pillar | Text | 255 | ||
| Amount Sponsored | Double | 8 | ||
| Number of Companies Required | Double | 8 | ||
| Does Principal Approve Entrepreneurs | Boolean | 1 | ||
| Entrepreneur Delivery Date | DateTime | 8 | ||
| Principal Subsidise Assessment Fee | Long | 4 | ||
| Subsidised Assessment Amount | Double | 8 | ||
| Supply Chain Requirement | Text | 255 | ||
| Supporting Doc Affidavit (EME) | Boolean | 1 | ||
| Supporting Doc BEE Certificate | Boolean | 1 | ||
| Supporting Doc Certified ID Copy | Boolean | 1 | ||
| Supporting Doc CK1 Document | Boolean | 1 | ||
| Supporting Doc EMP201 | Boolean | 1 | ||
| Supporting Doc Employee Payslips | Boolean | 1 | ||
| Supporting Doc IRP5 | Boolean | 1 | ||
| Supporting Doc VAT Registration | Boolean | 1 | ||
| Supporting Doc Proof of Turnover | Boolean | 1 | ||
| Supporting Doc Tax Clearance Certificate | Boolean | 1 | ||
| Supporting Doc Other | Boolean | 1 | ||
| Supporting Doc Other Text | Text | 255 | ||
| Lump Sum Allocation | Boolean | 1 | ||
| Scout | Text | 255 | ||
| Marketing Campaign Required | Long | 4 | ||
| Principal Campaign Branded | Long | 4 | ||
| Launch Required | Long | 4 | ||
| Principal Launch Budget | Double | 8 | ||
| Raizcorp Launch Budget | Double | 8 | ||
| Who Arranges Launch | Long | 4 | ||
| PR Type | Text | 255 | ||
| Info Session Type | Text | 255 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ | |
| DEL Principal Project Pillar Urgency | Boolean | 1 | ✓ | |
| Principal Project Pillar Urgency | Byte | 1 | ✓ |
Indexes
- Principal Project Pillars$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Principal Project Pillars$Principal Project ID