Table: Temp Entrepreneur Companies for Opal Scorecard
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Entrepreneur Company ID | Long | 4 | ||
| Entrepreneur Company Programme Years ID | Long | 4 | ||
| Entrepreneur Company Principal Project ID | Long | 4 | ||
| Company Status ID During Range | Long | 4 | ||
| Date Status Changed During Range | DateTime | 8 | ||
| Contract Ending Within Range | Boolean | 1 |
Indexes
- Entrepreneur Company ID
- Entrepreneur Company Programme Years ID
- Entrepreneur Principal Project ID
- Process Status ID During Range