Registration Fact Consolidated
ZTZenoti Docs Team Updated April 10, 2026 6 min readGuide
Consolidated fact table capturing class/session/workshop registration events including registration status, check-in, cancellation, no-show, waitlist, transfer details, and associated instructor/guest/session/workshop information.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| registration fk | BIGINT | Yes | Foreign key to the registration record. |
| registration date | TIMESTAMP | Yes | Date and time of the registration. |
| organization account name | VARCHAR(256) | Yes | Account name of the organization. Sourced from DimOrganization.organization_account_name. |
| center name | VARCHAR(128) | Yes | Name of the center. Sourced from DimCenter.center_name. |
| user id | VARCHAR(36) | Yes | Unique identifier (UUID) of the guest. Sourced from DimGuest.user_id. |
| guest first name | VARCHAR(256) | 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(256) | Yes | Middle name of the guest. Sourced from DimGuest.middle_name. |
| guest base center | VARCHAR(128) | Yes | Base center assigned to the guest. Sourced from DimGuest.base_center. |
| guest tags | VARCHAR(65535) | Yes | Tags associated with the guest. Sourced from DimGuest.tags. |
| is guest inactive | BOOLEAN | Yes | Indicates whether the guest is inactive. Sourced from DimGuest.is_inactive. |
| dim session wid | BIGINT | Yes | Warehouse identifier for the session dimension. Sourced from DimSession.session_wid. |
| session name | VARCHAR(256) | Yes | Name of the session. Sourced from DimSession.session_name. |
| session code | VARCHAR(32) | Yes | Code of the session. Sourced from DimSession.session_code. |
| session start date | TIMESTAMP | Yes | Start date and time of the session. Sourced from DimSession.start_date. |
| session end date | TIMESTAMP | Yes | End date and time of the session. Sourced from DimSession.end_date. |
| session capacity | INTEGER | Yes | Maximum capacity of the session. Sourced from DimSession.capacity. |
| session duration in mins | INTEGER | Yes | Duration of the session in minutes. Sourced from DimSession.duration_in_mins. |
| is session inactive | BOOLEAN | Yes | Indicates whether the session is inactive. Sourced from DimSession.is_inactive. |
| session status | VARCHAR(100) | Yes | Status of the session. Sourced from DimSession.status. |
| class name | VARCHAR(128) | Yes | Name of the class. Sourced from DimClass.class_name. |
| class code | VARCHAR(32) | Yes | Code of the class. Sourced from DimClass.class_code. |
| is class inactive | BOOLEAN | Yes | Indicates whether the class is inactive. Sourced from DimClass.is_inactive. |
| instructor user id | VARCHAR(36) | Yes | Unique identifier (UUID) of the instructor. Sourced from DimEmployee.employee_id. |
| instructor first name | VARCHAR(256) | Yes | First name of the instructor. Sourced from DimEmployee.first_name. |
| instructor last name | VARCHAR(256) | Yes | Last name of the instructor. Sourced from DimEmployee.last_name. |
| instructor middle name | VARCHAR(256) | Yes | Middle name of the instructor. Sourced from DimEmployee.middle_name. |
| is instructor inactive | BOOLEAN | Yes | Indicates whether the instructor is inactive. Sourced from DimEmployee.is_inactive. |
| instructor tags | VARCHAR(65535) | Yes | Tags associated with the instructor. Sourced from DimEmployee.tags. |
| instructor job name | VARCHAR(1020) | Yes | Job title of the instructor. Sourced from DimEmployee.job_name. |
| instructor job code | VARCHAR(8000) | Yes | Job code of the instructor. Sourced from DimEmployee.job_code. |
| instructor start date | TIMESTAMP | Yes | Start date of the instructor assignment. Sourced from DimEmployee.start_date. |
| instructor last date | TIMESTAMP | Yes | Last active date of the instructor. Sourced from DimEmployee.last_date. |
| instructor additional field1 | VARCHAR(8000) | Yes | Custom additional field 1 for the instructor. Sourced from DimEmployee.additional_field_1. |
| instructor additional field2 | VARCHAR(8000) | Yes | Custom additional field 2 for the instructor. Sourced from DimEmployee.additional_field_2. |
| instructor employee code | VARCHAR(128) | Yes | Employee code of the instructor. Sourced from DimEmployee.employee_code. |
| inital instructor user id | VARCHAR(36) | Yes | Unique identifier (UUID) of the initially assigned instructor. Sourced from DimEmployee.employee_id. |
| inital instructor first name | VARCHAR(256) | Yes | First name of the initial instructor. Sourced from DimEmployee.first_name. |
| inital instructor last name | VARCHAR(256) | Yes | Last name of the initial instructor. Sourced from DimEmployee.last_name. |
| inital instructor middle name | VARCHAR(256) | Yes | Middle name of the initial instructor. Sourced from DimEmployee.middle_name. |
| is inital instructor inactive | BOOLEAN | Yes | Indicates whether the initial instructor is inactive. Sourced from DimEmployee.is_inactive. |
| inital instructor tags | VARCHAR(65535) | Yes | Tags associated with the initial instructor. Sourced from DimEmployee.tags. |
| inital instructor job name | VARCHAR(1020) | Yes | Job title of the initial instructor. Sourced from DimEmployee.job_name. |
| inital instructor job code | VARCHAR(8000) | Yes | Job code of the initial instructor. Sourced from DimEmployee.job_code. |
| inital instructor start date | TIMESTAMP | Yes | Start date of the initial instructor assignment. Sourced from DimEmployee.start_date. |
| inital instructor last date | TIMESTAMP | Yes | Last active date of the initial instructor. Sourced from DimEmployee.last_date. |
| inital instructor additional field1 | VARCHAR(8000) | Yes | Custom additional field 1 for the initial instructor. Sourced from DimEmployee.additional_field_1. |
| inital instructor additional field2 | VARCHAR(8000) | Yes | Custom additional field 2 for the initial instructor. Sourced from DimEmployee.additional_field_2. |
| inital instructor employee code | VARCHAR(128) | Yes | Employee code of the initial instructor. Sourced from DimEmployee.employee_code. |
| dim workshop wid | BIGINT | Yes | Warehouse identifier for the workshop dimension. Sourced from DimWorkshop.workshop_wid. |
| track name | VARCHAR(128) | Yes | Name of the track within the workshop. |
| track code | VARCHAR(32) | Yes | Code of the track. |
| track start date | TIMESTAMP | Yes | Start date and time of the track. |
| track end date | TIMESTAMP | Yes | End date and time of the track. |
| track duration in mins | INTEGER | Yes | Duration of the track in minutes. |
| is track inactive | BOOLEAN | Yes | Indicates whether the track is inactive. |
| workshop name | VARCHAR(128) | Yes | Name of the workshop. Sourced from DimWorkshop.workshop_name. |
| workshop code | VARCHAR(32) | Yes | Code of the workshop. Sourced from DimWorkshop.workshop_code. |
| is workshop inactive | BOOLEAN | Yes | Indicates whether the workshop is inactive. Sourced from DimWorkshop.is_inactive. |
| invoice id | VARCHAR(36) | Yes | Unique identifier (UUID) of the associated invoice. |
| invoice item id | VARCHAR(36) | Yes | Unique identifier (UUID) of the invoice item. |
| cancellation date | TIMESTAMP | Yes | Date and time of registration cancellation. |
| no show date | TIMESTAMP | Yes | Date and time of a no-show event. |
| transfer user id | VARCHAR(36) | Yes | User ID of the guest the registration was transferred to. Sourced from DimGuest.user_id (transfer). |
| transfer guest first name | VARCHAR(256) | Yes | First name of the transfer guest. Sourced from DimGuest.first_name (transfer). |
| transfer guest last name | VARCHAR(256) | Yes | Last name of the transfer guest. Sourced from DimGuest.last_name (transfer). |
| transfer guest middle name | VARCHAR(256) | Yes | Middle name of the transfer guest. Sourced from DimGuest.middle_name (transfer). |
| is transfer guest inactive | BOOLEAN | Yes | Indicates whether the transfer guest is inactive. Sourced from DimGuest.is_inactive (transfer). |
| transfer registration fk | BIGINT | Yes | Foreign key to the transfer registration record. |
| multiple registration fk | BIGINT | Yes | Foreign key for multiple registrations (linked registrations). |
| package version wid | BIGINT | Yes | Warehouse identifier for the associated package version. |
| membership version wid | BIGINT | Yes | Warehouse identifier for the associated membership version. |
| check in date | TIMESTAMP | Yes | Date and time when the guest checked in. |
| waitlist date | TIMESTAMP | Yes | Date and time when the guest was placed on the waitlist. |
| is from waitlist | INTEGER | Yes | Indicates whether the registration originated from a waitlist (1 = Yes, 0 = No). |
| registration status | VARCHAR(100) | Yes | Current status of the registration. |
| is web booking | INTEGER | Yes | Indicates whether the registration was made via web (1 = Yes, 0 = No). |
| is direct booking | INTEGER | Yes | Indicates whether the registration was a direct booking (1 = Yes, 0 = No). |
| minutes to add | INTEGER | Yes | Timezone offset in minutes for the center. |
| appointment id | VARCHAR(36) | Yes | Associated appointment identifier (UUID). |
| appointment pk | BIGINT | Yes | Primary key of the associated appointment. |
| appointment source | VARCHAR(128) | Yes | Source of the appointment booking. |
| appointment void | INTEGER | Yes | Indicates whether the associated appointment is voided (1 = Yes, 0 = No). |
| factregistrationwid | BIGINT | Yes | Warehouse identifier for the registration fact record. |
| utm source | NVARCHAR(128) | Yes | UTM source parameter for marketing attribution. |
| utm medium | NVARCHAR(128) | Yes | UTM medium parameter for marketing attribution. |
| Center Code | VARCHAR(40) | Yes | Code of the center. Sourced from DimCenter.center_code. |
| Invoice No | VARCHAR(160) | Yes | Invoice number associated with the registration. |
Primary Key
No explicit primary key is defined. registration fk serves as the logical key. factregistrationwid is a surrogate warehouse identifier.
Foreign Keys
user idreferences DimGuest (registered guest)transfer user idreferences DimGuest (transfer guest)center name,Center Codereferences DimCenterinstructor user id,instructor employee codereferences DimEmployee (current instructor)inital instructor user id,inital instructor employee codereferences DimEmployee (initial instructor)dim session wid,session namereferences DimSessionclass name,class codereferences DimClassdim workshop wid,workshop namereferences DimWorkshopinvoice id,invoice item idreferences invoice entityappointment id,appointment pkreferences DimAppointmentpackage version widreferences DimPackageVersionmembership version widreferences DimMembershipVersion
Enumerator Values
| Column Name | Known Values |
|---|---|
| registration status | Registered, Cancelled, No-Show, Checked-In, Waitlisted, etc. |
| session status | Active, Inactive, Completed, Cancelled, etc. |
| is from waitlist | 0 (No), 1 (Yes) |
| is web booking | 0 (No), 1 (Yes) |
| is direct booking | 0 (No), 1 (Yes) |
| appointment void | 0 (Active), 1 (Voided) |
| appointment source | Web, Mobile, Walk-in, 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.