Registration fact table
Bi_FactRegistration_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
AEPK | DECIMAL(19,0) | 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 | DECIMAL(19,0) | Unique identfier for the appoinment | |||
AppointmentSource | INT | A unique identifier that indicates the source of appointment, generated in status dimension(Bi_DimItemSource) | Bi_DimItemSource_s3 SourceNum | ||
appointmentstatus | INT | A unique identifier that signifies the status of the Appointment | Bi_DimStatus_s3 StatusValue | ||
AppointmentVoid | BOOLEAN | 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 | |||
CenterID | VARCHAR(36) | Unique identifier for the center | Bi_DimCenter_s3 centerid | ||
CheckinDt | TIMESTAMP | The date and time when the appointment status was changed to 'Checkin'. | |||
EndTimeInCenter | TIMESTAMP | date and time on which appointment ended | |||
FactSegmentId | DECIMAL(19,0) | 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 | BOOLEAN | A flag indicating if the booking is a direct booking | |||
IsFromWaitlist | BOOLEAN | A flag indicating if the guest is from waitlist | |||
IsWebBooking | BOOLEAN | A flag indicating if the booking is from the web | |||
membershipversionid | VARCHAR(36) | 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 | DECIMAL(19,0) | 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_s3 organizationId | ||
packageversionid | VARCHAR(36) | 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 | DECIMAL(19,0) | 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. | |||
RegistrationStatus | INT | The current status of the registration | Bi_DimStatus_s3 StatusValue | ||
SessionFK | DECIMAL(19,0) | The unique code of the session that the guest registered for | Bi_DimSession_s3 sessionpk | ||
StartTimeinCenter | TIMESTAMP | The date on which the appointment is scheduled to start. | |||
TrackFK | DECIMAL(19,0) | The unique code of the workshop track for which the guest registered | Bi_DimWorkshop_s3 trackpk | ||
TrackSessionFK | DECIMAL(19,0) | This is track session foreign key from the core system | Bi_DimSession_s3 sessionpk | ||
TransferRegFK | DECIMAL(19,0) | A unique registration fk created for the transferred guest | |||
TransferUserID | 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_s3 userid | ||
userid | VARCHAR(36) | A unique identifier for the guest | Bi_Dimuser_s3 userid | ||
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. | |||