Registrations data fact table
This table lists the fact table columns used for the Registrations data model.
Bi_FactRegistration
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
AEPK | bigint | Unique identifier generated in the table internal to ETL | |||
AppointmentID | VARCHAR(36) | A unique identifier for the appointment. This is a non-blank value that gets populated for every appointment. Appointments get booked against each registration after the session is confirmed. | |||
AppointmentPK | bigint | Unique identfier for the appoinment | |||
AppointmentSourcewid | bigint | A unique identifier that indicates the source of appointment, generated in status dimension(Bi_DimItemSource) | Bi_DimItemSource SourceNum | ||
appstatuswid | bigint | A unique identifier that signifies the status of the Appointment | Bi_DimStatus StatusValue | ||
AppointmentVoid | int | A flag indicating if the appointment is inactive. An appointment is considered inactive if it has been removed from the system | |||
CancellationDt | TIMESTAMP | The date and time at which the guest cancelled the registration | |||
centerwid | bigint | Unique identifier for the center | Bi_DimCenter centerwid | ||
CheckinDt | TIMESTAMP | The date and time when the appointment status was changed to 'Checkin'. | |||
dimsessioswid | bigint | Unique identifier for session | bi_dimsession sessionwid | ||
dimworkshopwid | bigint | unique identifier for workshop | bi_dimworkshop dimworkshopwid | ||
EndTimeInCenter | TIMESTAMP | date and time on which appointment ended | |||
etllastupdatedBy | INT | ETL system admin user who inserted or updated the corresponding record in this table. | |||
etllastupdatedon | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
FactSegmentId | bigint | unique identifier for the row in the table | |||
factregistraionwid | bigint | unique identifier for the row in the table | Yes | ||
InvoiceID | VARCHAR(36) | Uniue identifier for the invoice generated. Unique within an organization | |||
InvoiceitemId | VARCHAR(36) | A unique identifier for each item in the Invoice. Unique within the organization | |||
InvoiceStatus | INT | This indicates whether the invoice is open or closed. | |||
InvoiceVoid | BOOLEAN | Indicates if the invoice is valid or void. | |||
IsDirectBooking | int | A flag indicating if the booking is a direct booking | |||
IsFromWaitlist | int | A flag indicating if the guest is from waitlist | |||
IsWebBooking | int | A flag indicating if the booking is from the web | |||
membershipversionwid | bigint | Unique identifier for each membership user id. This is generated in Analytics, it does not exist in the core system. This is populated if the registration is redeemed through a membership | |||
MultipleRegistrationFK | bigint | A unique identifier for multiple registrations. This will be same for all the registrations in that group | |||
NoShowDt | TIMESTAMP | The date and time at which the guest did not attend the class or workshop for which they registered | |||
OrganizationID | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter organizationId | ||
packageversionwid | bigint | A unique identifier for each package user id. This is generated in Analytics, it does not exist in the core system. This is populated if the registration is redeemed through a package | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
RegistrationDt | TIMESTAMP | The date and time at which the guest registered for a class or workshop | |||
RegistrationFK | bigint | A unique identifier for each registration. This is a non-blank value that gets populated for every registration | |||
RegistrationGuid | VARCHAR(36) | The GUID of the registration. | |||
regstatuswid | INT | The current status of the registration | Bi_DimStatus StatusValue | ||
StartTimeinCenter | TIMESTAMP | The date on which the appointment is scheduled to start. | |||
TrackSessionFK | bigint | This is track session foreign key from the core system | Bi_DimSession sessionpk | ||
TransferRegFK | bigint | A unique registration fk created for the transferred guest | |||
TransferUserwid | VARCHAR(36) | A unique identifier for the transfer guest. The transfer guest is the guest to whom the registration is transferred. This is a non-blank value that gets populated for every guest | Bi_Dimuser userwid | ||
userwid | VARCHAR(36) | A unique identifier for the guest | Bi_Dimuser userwid | ||
void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
WaitlistDt | TIMESTAMP | The date and time at which the guest got waitlisted for a class or workshop | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||
utmsource | NVARCHAR(128) | Helps you the identify the booking source (google, Facebook, Instagram) | |||
utmmedium | NVARCHAR(128) | Helps you the identify the booking source (google, Facebook, Instagram) | |||
InvoiceNo | VARCHAR(160) | Invoice number that helps in identifying and tracking the invoice. | |||