el_lookup_appointment_categories
This lookup table resolves an Appointment Category GUID to an Appointment Category name.
GUID will be stored as a foreign key on the Appointment Type record.
el_lookup_appointment_categories
7 rows
| Column | Description | Data Type |
|---|---|---|
| subdom | Partner school instance identifier. | VARCHAR |
| category_name | The name of the Appointment Category. | VARCHAR |
| guid | The unique identifier and primary key of the Appointment Category. Appears as foreign key on the Appointment Type. | VARCHAR |
| src | The JSON document of the Category. | VARIANT |
| updated_at | The date and time the Appointment Category was last updated. | TIMESTAMP_NTZ |
| created_at | The date and time the Appointment Category was created. | TIMESTAMP_NTZ |
| etl_loaded_at | The date and time the Appointment Category was synced to Snowflake. | TIMESTAMP_NTZ |
Was this page helpful?