ZenotiHelp

Forms Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide

Consolidated fact table capturing form submissions and field-level data including guest, therapist, reviewer details, associated services, appointment information, and form field values.

Columns

Column Name Data Type Nullable Description
formwid BIGINT Yes Warehouse identifier for the form dimension.
fact form id BIGINT Yes Fact form record identifier.
form id VARCHAR(36) Yes Unique identifier (UUID) of the form submission.
guestwid BIGINT Yes Warehouse identifier for the guest. Sourced from DimGuest.guest_wid.
guest id VARCHAR(36) Yes Unique identifier (UUID) of the guest. Sourced from DimGuest.guest_id.
guest first name VARCHAR(160) Yes First name of the guest. Sourced from DimGuest.first_name.
guest last name VARCHAR(256) Yes Last name of the guest. Sourced from DimGuest.last_name.
guest middle name VARCHAR(128) Yes Middle name of the guest. Sourced from DimGuest.middle_name.
guest gender VARCHAR(14) Yes Gender of the guest. Sourced from DimGuest.gender.
therapistwid BIGINT Yes Warehouse identifier for the therapist. Sourced from DimEmployee.employee_wid.
therapist id VARCHAR(36) Yes Unique identifier (UUID) of the therapist. Sourced from DimEmployee.employee_id.
therapist first name VARCHAR(160) Yes First name of the therapist. Sourced from DimEmployee.first_name.
therapist last name VARCHAR(256) Yes Last name of the therapist. Sourced from DimEmployee.last_name.
therapist middle name VARCHAR(128) Yes Middle name of the therapist. Sourced from DimEmployee.middle_name.
therapist gender VARCHAR(14) Yes Gender of the therapist. Sourced from DimEmployee.gender.
reviewedbywid BIGINT Yes Warehouse identifier for the reviewer. Sourced from DimEmployee.employee_wid.
reviewer id VARCHAR(36) Yes Unique identifier (UUID) of the reviewer. Sourced from DimEmployee.employee_id.
reviewer first name VARCHAR(160) Yes First name of the reviewer. Sourced from DimEmployee.first_name.
reviewer last name VARCHAR(256) Yes Last name of the reviewer. Sourced from DimEmployee.last_name.
reviewer middle name VARCHAR(128) Yes Middle name of the reviewer. Sourced from DimEmployee.middle_name.
reviewer gender VARCHAR(14) Yes Gender of the reviewer. Sourced from DimEmployee.gender.
appointmentid VARCHAR(36) Yes Associated appointment identifier (UUID).
centerwid BIGINT Yes Warehouse identifier for the center. Sourced from DimCenter.center_wid.
organization name VARCHAR(512) Yes Name of the organization. Sourced from DimOrganization.organization_name.
organization account name VARCHAR(256) Yes Account name of the organization. Sourced from DimOrganization.organization_account_name.
zone name VARCHAR(800) Yes Zone name of the center. Sourced from DimCenter.zone_name.
center name VARCHAR(128) Yes Name of the center. Sourced from DimCenter.center_name.
center time zone VARCHAR(128) Yes Timezone of the center. Sourced from DimCenter.time_zone.
center city VARCHAR(128) Yes City of the center. Sourced from DimCenter.city.
center zip VARCHAR(32) Yes Zip code of the center. Sourced from DimCenter.zip.
servicewid BIGINT Yes Warehouse identifier for the service. Sourced from DimService.service_wid.
service name VARCHAR(512) Yes Name of the service. Sourced from DimService.service_name.
service length INTEGER Yes Duration of the service in minutes. Sourced from DimService.service_length.
service category VARCHAR(256) Yes Category of the service. Sourced from DimService.category.
service parent category VARCHAR(256) Yes Parent category of the service. Sourced from DimService.parent_category.
service businessunit VARCHAR(200) Yes Business unit of the service. Sourced from DimService.businessunit.
is service inactive BOOLEAN Yes Indicates whether the service is inactive. Sourced from DimService.is_inactive.
service tags VARCHAR(65535) Yes Tags associated with the service. Sourced from DimService.tags.
reviewed on TIMESTAMP Yes Date and time when the form was reviewed.
submitted date TIMESTAMP Yes Date and time when the form was submitted.
start date TIMESTAMP Yes Start date and time of the form/appointment.
is form submitted BOOLEAN Yes Indicates whether the form has been submitted.
form type VARCHAR(36) Yes Type of the form.
form source VARCHAR(36) Yes Source of the form (e.g., Appointment, Walk-in).
field name VARCHAR(65535) Yes Name of the form field.
value1 DOUBLE PRECISION Yes Numeric value of the form field.
value2 TIMESTAMP Yes Date/time value of the form field.
value3 BOOLEAN Yes Boolean value of the form field.
value4 VARCHAR(65535) Yes Text value of the form field.
data type description VARCHAR(36) Yes Description of the data type of the field value.
pointer INTEGER Yes Pointer/index of the form field.
void INTEGER Yes Indicates whether the form record is voided.
formappointmentstatus INTEGER Yes Status code of the form appointment.
appointmentnoshoworcancel INTEGER Yes Indicates no-show or cancellation for the appointment.
isappointmentvoided BOOLEAN Yes Indicates whether the associated appointment is voided.
formexpirydate TIMESTAMP Yes Expiry date of the form.
reviewneeded BOOLEAN Yes Indicates whether the form needs review.
form name VARCHAR(2048) Yes Name of the form template.
dim form wid BIGINT Yes Warehouse identifier for the form dimension.
LastUpdatedDate TIMESTAMP Yes Date and time of the last update to the form record.
Center Code VARCHAR(40) Yes Code of the center. Sourced from DimCenter.center_code.

Primary Key

No explicit primary key is defined. form id combined with field name and pointer serves as a logical key. fact form id is used as a surrogate identifier.

Foreign Keys

  • guest id, guestwid references DimGuest
  • therapist id, therapistwid references DimEmployee (therapist)
  • reviewer id, reviewedbywid references DimEmployee (reviewer)
  • center name, centerwid, Center Code references DimCenter
  • service name, servicewid references DimService
  • appointmentid references DimAppointment
  • form name, formwid, dim form wid references DimForm

Enumerator Values

Column Name Known Values
form type Custom form type identifiers
form source Appointment, Walk-in, Online, etc.
data type description Text, Number, Date, Boolean, etc.
void 0 = Active, 1 = Voided
formappointmentstatus -2 = No Show
appointmentnoshoworcancel 0 = Attended
guest gender Male, Female, etc.

Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.

Was this article helpful?
Your feedback helps us improve our documentation.