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