Appointments
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 |