Table: Entrepreneur Company Principal Projects
Primary Key: Entrepreneur
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Entrepreneur Company Principal Project ID | Long | 4 | ✓ | |
| Date Allocation Created | DateTime | 8 | ||
| Entrepreneur Company Programme Years ID | Long | 4 | ||
| Principal Project Pillar ID | Long | 4 | ||
| Allocated Amount | Double | 8 | ||
| Monthly Allocated Amount | Double | 8 | ||
| Selection Fee | Double | 8 | ||
| Selection Fee Type | Text | 255 | ||
| Replacement Status | Text | 255 | ||
| Lump Sum Allocation | Boolean | 1 | ||
| Replacement For | Long | 4 | ||
| EP Replaced By | Long | 4 | ||
| EP Replacement For | Long | 4 | ||
| Contract Printed | Boolean | 1 | ||
| Date Contract Signed | DateTime | 8 | ||
| VA Packs Delivered | DateTime | 8 | ||
| Modified By | Text | 255 | ||
| Date Modified | DateTime | 8 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ | |
| Element Type | Text | 50 | ||
| Extra Sponsorship Amount | Double | 8 | ||
| Frequency of Payments | Text | 50 | ||
| Payment Amount | Double | 8 | ||
| VA Pack Audit Status ID | Long | 4 | ||
| Date VA Pack Audit Status Changed | DateTime | 8 | ||
| VA Pack Audit Status Changed By | Text | 255 | ||
| VA Pack Audit Score | Double | 8 | ||
| SA SDM Notified | Boolean | 1 |
Indexes
- Entrepreneur Company Principal Projects$Entrepreneur Company Pro
- Entrepreneur Company Principal Projects$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Entrepreneur Company Principal Projects$Principal Project Pillar