Table: vwGarnetRptAllocationExportGraduatedCompanies
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Entrepreneur ID | Long | 4 | ||
| Entrepreneur Company ID | Long | 4 | ✓ | |
| Division ID | Long | 4 | ||
| Company Status ID | Long | 4 | ||
| Company Programme Year Status ID | Long | 4 | ||
| Programme Year Status | Text | 255 | ||
| Date Graduate | DateTime | 8 | ||
| Contract Start Date | DateTime | 8 | ||
| Contract End Date | DateTime | 8 | ||
| Allocation ID | Long | 4 | ||
| Student ID | Text | 255 | ||
| Company Name | Text | 255 | ||
| Status | Text | 255 | ||
| Entrepreneur | Memo | - | ✓ | |
| Identity Number | Text | 255 | ||
| Industry | Text | 255 | ||
| Category | Memo | - | ✓ | |
| Product | Text | 255 | ||
| Programme Year | Text | 10 | ||
| Total Programme Amount | Double | 8 | ||
| Company Delivery Location | Text | 255 | ||
| Principal | Text | 255 | ||
| Principal Project | Memo | - | ✓ | |
| Total Allocated Amt | Double | 8 | ||
| Years in Business | Text | 255 | ||
| Percentage Black Owned | Double | 8 | ||
| Percentage Women Black Owned | Double | 8 | ||
| Ignition Date | DateTime | 8 |