ZenotiHelp

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 id references DimGuest (registered guest)
  • transfer user id references DimGuest (transfer guest)
  • center name, Center Code references DimCenter
  • instructor user id, instructor employee code references DimEmployee (current instructor)
  • inital instructor user id, inital instructor employee code references DimEmployee (initial instructor)
  • dim session wid, session name references DimSession
  • class name, class code references DimClass
  • dim workshop wid, workshop name references DimWorkshop
  • invoice id, invoice item id references invoice entity
  • appointment id, appointment pk references DimAppointment
  • package version wid references DimPackageVersion
  • membership version wid references 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.