Turnaways fact table
Bi_FactTurnAways
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
AppointmentEndDateInCenter | DATE | date on which appointment ended | |||
AppointmentEndTimeInCenter | TIMESTAMP | date and time on which appointment ended | |||
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 | |||
AppointmentStartDateInCenter | DATE | date on which appointment is started | |||
AppointmentStartTimeInCenter | TIMESTAMP | date and time on which appointment started | |||
Centerwid | bigint | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter Centerwid | ||
Comments | varchar(16000) | Comments entered by the employee when the waitlist/turnaway entry is created | |||
CreatedBywid | bigint | Unique code of the employee who created the waitlist/turnaway entry | |||
createddateincenter | DATE | Date when the waitlist/turnaway entry is created | |||
createddatetimeincenter | TIMESTAMP | Date and time at which the waitlist/turnaway entry is created | |||
EtlCreatedBy | bigint | 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. | |||
FactSegmentId | bigint | Unique identifier for row in the table | |||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter OrganizationId | ||
Podid | bigint | Internal to the ETL, says from which POD data is being synced the table | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
Servicewid | bigint | Uniue identifier for the service provided. | Bi_DimService Servicewid | ||
ServicePrice | FLOAT | List price of the service | |||
Therapistwid | bigint | Unique identifier of the Therapist. Unique for a guest across the organization | Bi_Dimuser userwid | ||
TurnAwayDateInCenter | TIMESTAMP | Date on which the turnaway status value of the record is changed from either Waitlist to Converted or from Waitlist to 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 | |||
TurnAwayId | VARCHAR(36) | Unique identifier for the waitlist/turnaway record | |||
TurnAwayReasonwid | bigint | Unique code assigned to each turnaway reason. This is only populated when the turnaway status value of the request is Turnaway. | Bi_DimReasons Reasonwid | ||
TurnAwayStatus | varchar(30) | Current status of the record. Possible values: - WaitList - Converted - TurnAway | |||
turnawaywid | bigint | Unique identifier for the row. Primary key | yes | ||
Userwid | bigint | Unique identifier of the guest. Unique for a guest across the organization | Bi_Dimuser userwid | ||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||