Appointments
- Paolo Lencioni
Owned by Paolo Lencioni
| 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 |