Table: People Three Plus One ISP Contract
Primary Key: People
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| People ISP Contract ID | Long | 4 | ✓ | |
| People Three Plus One ID | Long | 4 | ||
| Key Performance Area | Text | 255 | ||
| KPA Weighting | Double | 8 | ||
| Key Performance Indicator | Text | 255 | ||
| KPI Weighting | Double | 8 | ||
| KPI Score | Double | 8 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- People Three Plus One ISP Contract$Key Performance Area
- People Three Plus One ISP Contract$Key Performance Indicator
- People Three Plus One ISP Contract$People ISP Contract ID
- People Three Plus One ISP Contract$People Three Plus One ID
- People Three Plus One ISP Contract$PrimaryKey [PRIMARY KEY] [UNIQUE]