Deleted appointment fact table
Bi_FactDeletedAppointment_s3
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 | DECIMAL(19,0) | Unique indentifier of each deleted appointment. | |||
centerId | VARCHAR(36) | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter_s3 centerID | ||
Comments | NVARCHAR(65535) | Comments that are entered while deleting the appointment. | |||
CreatedBy | VARCHAR(36) | A unique identifier of the employee who created the invoice(bi_dimuser). | Bi_DimUser_s3 userid | ||
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 | ||
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. | |||
ModifiedBy | VARCHAR(36) | 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_s3 | OrganizationId | |
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
serviceid | VARCHAR(36) | A unique identifier for a Service, generated in Service dimension(Bi_DimService). | Bi_DimService_s3 | ServiceID | |
StartDateInCenter | DATE | Date on which the appointment was scheduled to start. | |||
StartDateTimeInCenter | TIMESTAMP | Date and time at which the appointment was scheduled to start. | |||
TherapistId | VARCHAR(36) | 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_s3 | userid | |
UserId | VARCHAR(36) | A unique identifier for the guest, generated in User dimension(Bi_DimUser). | Bi_DimUser_s3 | userid | |
void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||