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.