ZenotiHelp

Registration Fact Table

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Stores class/workshop registration details including scheduling, cancellations, no-shows, check-ins, waitlisting, and transfer information.

Columns

Column Name Data Type Nullable Description
factregistrationwid BIGINT IDENTITY NOT NULL Surrogate key and primary key for the registration record.
factsegmentid BIGINT NOT NULL Source system segment identifier for the registration.
aepk BIGINT YES Accounting ETL primary key.
invoiceid VARCHAR(36) YES GUID of the associated invoice.
invoiceitemid VARCHAR(36) YES GUID of the associated invoice item.
centerwid BIGINT YES Foreign key to the center dimension (Bi_DimCenter.centerwid).
userwid BIGINT YES Foreign key to the guest/user dimension (Bi_DimUser.userwid).
dimworkshopwid BIGINT YES Foreign key to the workshop dimension.
dimsessionwid BIGINT YES Foreign key to the session dimension.
registrationfk BIGINT YES Foreign key to the source registration record.
registrationdt TIMESTAMP YES Date/time of the registration.
appointmentid VARCHAR(36) YES GUID of the associated appointment.
starttimeincenter TIMESTAMP YES Session start time in center local time.
endtimeincenter TIMESTAMP YES Session end time in center local time.
cancellationdt TIMESTAMP YES Date/time the registration was cancelled.
noshowdt TIMESTAMP YES Date/time the guest was marked as a no-show.
transferuserwid VARCHAR(36) YES GUID of the user the registration was transferred to.
transferregfk BIGINT YES Foreign key to the transfer registration record.
multipleregistrationfk BIGINT YES Foreign key linking multiple registrations.
packageversionwid BIGINT YES Foreign key to the package version dimension.
membershipversionwid BIGINT YES Foreign key to the membership version dimension.
appointmentpk BIGINT YES Source system primary key for the appointment.
void BOOLEAN YES Soft-delete flag indicating the record is logically deleted.
checkindt TIMESTAMP YES Date/time of guest check-in for the session.
waitlistdt TIMESTAMP YES Date/time the guest was added to the waitlist.
isfromwaitlist INT YES Flag indicating whether the registration came from a waitlist.
appointmentsourcewid BIGINT YES Foreign key to the appointment source dimension.
appstatuswid BIGINT YES Foreign key to the appointment status dimension.
appointmentvoid INT YES Flag indicating whether the associated appointment is voided.
regstatuswid BIGINT YES Foreign key to the registration status dimension.
iswebbooking INT YES Flag indicating if the registration was made via web booking.
isdirectbooking INT YES Flag indicating if the registration was a direct booking.
registrationguid VARCHAR(36) YES GUID for the registration record.
tracksessionfk BIGINT YES Foreign key to the track session.
invoicestatus INT YES Status code of the associated invoice.
invoicevoid BOOLEAN YES Flag indicating whether the invoice is voided.
utmsource NVARCHAR(128) YES UTM source tracking parameter.
utmmedium NVARCHAR(128) YES UTM medium tracking parameter.
invoiceno NVARCHAR(160) YES Human-readable invoice number.

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

factregistrationwid

Foreign Keys

Column References
userwid Bi_DimUser.userwid
centerwid Bi_DimCenter.centerwid
endtimeincenter Bi_DimDate.datewid
starttimeincenter Bi_DimDate.datewid

Enumerator Values

Column Values
isfromwaitlist 1 = from waitlist; 0 = direct registration.
iswebbooking 1 = web booking; 0 = non-web booking.
isdirectbooking 1 = direct booking; 0 = indirect booking.
appointmentvoid 1 = voided; 0 = active.
invoicestatus 0 = Open
1 = Open
2 = Open
3 = Open
4 = Closed
void TRUE if the record is soft-deleted; FALSE otherwise.
invoicevoid TRUE if the invoice is voided; FALSE otherwise.
Was this article helpful?
Your feedback helps us improve our documentation.