Table: People Awards
Primary Key: People
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| People Awards ID | Long | 4 | ✓ | |
| People ID | Long | 4 | ||
| Date Captured | DateTime | 8 | ||
| Quarter | Text | 255 | ||
| Quarter Year | Long | 4 | ||
| Award Name | Text | 255 | ||
| Forum | Text | 255 | ||
| Award Value | Double | 8 | ||
| Notes | Text | 255 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- People Awards$People ID
- People Awards$People Training Module ID
- People Awards$PrimaryKey [PRIMARY KEY] [UNIQUE]