Deleted appointments fact table
This table lists the fact table columns used for the deleted appointment data model.
Bi_FactDeletedAppointment
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
AppointmentId | VARCHAR(36) | A unique identifier for each appointment. If the appointment is a segment, this is the segment id. | |||
AppointmentPK | integer | Unique indentifier of each deleted appointment. | |||
centerwid | bigint | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter centerwid | ||
Comments | NVARCHAR(65535) | Comments that are entered while deleting the appointment. | |||
CreatedBywid | bigint | A unique identifier of the employee who created the invoice(bi_dimuser). | Bi_DimUser userwid | ||
CreatedDateInCenter | DATE | Date on which the appointment was created. | |||
CreatedDateTimeInCenter | TIMESTAMP | Date and time at which the appointment was created. | |||
EndDateInCenter | DATE | Date on which the appointment was scheduled to end. | |||
EndDateTimeInCenter | TIMESTAMP | Date and time at which the appointment was scheduled to end. | |||
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. | |||
FactSegmentId | INT | A unique identifier(integer value) for each record generated in the fact table. | PK | ||
factsegmentwid | bigint | A unique identifier(integer value) for each record generated in the fact table. | |||
Invoice_no | NVARCHAR(160) | Unique identifier for the invoice (unique within the center). This is the invoice associated with the corresponding appointment. | |||
InvoiceId | VARCHAR(36) | The unique identifier for the invoice within the organization. | |||
InvoiceItemId | VARCHAR(36) | Unique identifier for each line item within the invoice. This is the invoice item ID associated with the corresponding appointment. | |||
ModifiedBywid | bigint | A code that identifies the User that modified the record.(Bi_DimUser) | |||
ModifiedDateInCenter | DATE | Date on which the appointment was deleted. | |||
ModifiedDateTimeInCenter | TIMESTAMP | Date and time at which the appointment was deleted. | |||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter OrganizationId | ||
PODID | integer | 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 | A unique identifier for a Service, generated in Service dimension(Bi_DimService). | Bi_DimService ServicewID | ||
StartDateInCenter | DATE | Date on which the appointment was scheduled to start. | |||
StartDateTimeInCenter | TIMESTAMP | Date and time at which the appointment was scheduled to start. | |||
Therapistwid | bigint | Unique identifier for each employee who is scheduled to service the guest. This is generated in analytics and it does not exist in core.(Bi_DimUser) | Bi_DimUser userwid | ||
Userwid | bigint | A unique identifier for the guest, generated in User dimension(Bi_DimUser). | 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 | |||