Multiple employee appointment fact table
Bi_FactAppointmentMultipleEmp_S3
Field | Field Type |
---|---|
FactSegmentId | DECIMAL(19,0) |
AppGroupID | VARCHAR(36) |
AppointmentID | VARCHAR(36) |
TherapistID | VARCHAR(36) |
ServiceID | VARCHAR(36) |
CenterID | VARCHAR(36) |
OrganizationID | VARCHAR(36) |
InvoiceItemID | VARCHAR(36) |
InvoiceID | VARCHAR(36) |
ParentAppointmentID | VARCHAR(36) |
AppointmentStatusType | INT |
CancelOrNoShowStatus | INT |
PrimaryEmp | BOOLEAN |
Commission | FLOAT |
PackageType | INT |
ItemListPrice | FLOAT |
ServiceNewGuestCost | FLOAT |
ServiceShopCost | FLOAT |
ServiceLabourCost | FLOAT |
EmpServiceNewGuestCost | FLOAT |
EmpServiceShopCost | FLOAT |
EmpServiceLabourCost | FLOAT |
IsBundlePackage | BOOLEAN |
Quantity | INT |
EtlCreatedBy | DECIMAL(19,0) |
GroupId | DECIMAL(19,0) |
EtlCreatedDate | TIMESTAMP |
void | INT |
podname | VARCHAR(100) |
EtlLastUpdatedOn | TIMESTAMP |
EtlLastUpdatedBy | VARCHAR(50) |