el_lookup_appointment_types
This lookup table resolves an Appointment Type GUID to an Appointment Type name.
GUID will be stored as a foreign key on the Appointment record.
el_lookup_appointment_types
11 rows
| Column | Description | Data Type |
|---|---|---|
| subdom | Partner school instance identifier. | VARCHAR |
| type_guid | The unique identifier and primary key of the Appointment Type. Appears as foreign key on the Appointment. | VARCHAR |
| field_guid | Foreign key identifier for the set of fields that are used by this Appointment Type. | VARCHAR |
| created_at | The date and time the Appointment Type was created. | TIMESTAMP_NTZ |
| category_guid | Foreign key identifier for the category to which this Type belongs. | VARCHAR |
| src | The JSON document of the Type. | VARIANT |
| id | A unique identifier for the appointment type document, only used by database. | VARCHAR |
| etl_loaded_at | The date and time the Appointment Type was synced to Snowflake. | TIMESTAMP_NTZ |
| public | Indicates whether the Type is publicly viewable on the Appointment Site or by invite only. | BOOLEAN |
| type_name | The name of the Appointment Type. | VARCHAR |
| updated_at | The date and time the Appointment Type was last updated. | TIMESTAMP_NTZ |
Was this page helpful?