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,guestwidreferences DimGuesttherapist id,therapistwidreferences DimEmployee (therapist)reviewer id,reviewedbywidreferences DimEmployee (reviewer)center name,centerwid,Center Codereferences DimCenterservice name,servicewidreferences DimServiceappointmentidreferences DimAppointmentform name,formwid,dim form widreferences 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.