| Field | Type | Length | Unique | Required | Format | Description |
|---|
| identifier | varchar | 18 | yes | yes |
| Unique identifier in source system ID |
| name | varchar | 80 | no | no |
| Any name given to the appointment |
| reason | varchar | 80 | no | no |
| Reason for appointment |
| scheduled_start_time__c | timestamp |
| no | yes |
| start time |
| scheduled_end_time__c | timestamp | 8 | no | yes |
| end time |
| client_key | varchar | 256 | no | yes |
| unique identifier of customer/patient |
| cancelled__c | boolean | 8 | no | no | true/false | is appointment cancelled |
| location__c | varchar | 80 | no | yes |
| location of appointment for multi-site |
| staff_code | varchar | 80 | no | yes |
| staff member who appointment is booked for |