Turnaways fact table
Bi_FactTurnAways_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
FactSegmentId | INT | Unique identifier for row in the table | Yes | ||
CenterId | VARCHAR(36) | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter_s3 CenterId | ||
TurnAwayId | VARCHAR(36) | Unique identifier for the waitlist/turnaway record | |||
UserId | VARCHAR(36) | Unique identifier of the guest. Unique for a guest across the organization | Bi_Dimuser_s3 userid | ||
AppointmentStartTimeInCenter | TIMESTAMP | date and time on which appointment started | |||
AppointmentStartDateInCenter | DATE | date on which appointment is started | |||
AppointmentEndTimeInCenter | TIMESTAMP | date and time on which appointment ended | |||
AppointmentEndDateInCenter | DATE | date on which appointment ended | |||
TurnAwayReasonId | VARCHAR(36) | Unique code assigned to each turnaway reason. This is only populated when the turnaway status value of the request is Turnaway. | Bi_DimReasons_s3 ReasonId | ||
Comments | NVARCHAR(65535) | Comments entered by the employee when the waitlist/turnaway entry is created | |||
CreatedBy | VARCHAR(36) | Unique code of the employee who created the waitlist/turnaway entry | |||
TurnAwayStatus | NVARCHAR(MAX) | Current status of the record. Possible values: - WaitList - Converted - TurnAway | |||
TurnAwayDateTimeInCenter | TIMESTAMP | Date and time at which the turnaway status value of the record is changed from either Waitlist to Converted or from Waitlist to Turnaway | |||
TurnAwayDateInCenter | DATE | Date on which the turnaway status value of the record is changed from either Waitlist to Converted or from Waitlist to Turnaway | |||
AppointmentId | VARCHAR(36) | Appointment ID associated with a request when it gets converted to a confirmed appointment. This is only populated when the turnaway status value of the request is Converted | |||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 OrganizationId | ||
EtlCreatedBy | DECIMAL(19,0) | ETL system admin user who inserted or updated the corresponding record in this table. | |||
EtlCreatedDate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
createddatetimeincenter | TIMESTAMP | Date and time at which the waitlist/turnaway entry is created | |||
createddateincenter | DATE | Date when the waitlist/turnaway entry is created | |||
ServiceId | VARCHAR(36) | Uniue identifier for the service provided. | Bi_DimService_s3 ServiceID | ||
TherapistId | VARCHAR(36) | Unique identifier of the Therapist. Unique for a guest across the organization | Bi_Dimuser_s3 userid | ||
ServicePrice | FLOAT | List price of the service | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||