Multiple employee appointment fact table
Bi_FactAppointmentMultipleEmp
Field | Field Type | Primary Key |
|---|---|---|
FactSegmentWID | BIGINT IDENTITY NOT NULL | Yes |
FactSegmentId | bigint | |
AppGroupID | VARCHAR(36) | |
AppointmentID | VARCHAR(36) | |
TherapistWID | BIGINT | |
ServiceWID | BIGINT | |
CenterWID | BIGINT | |
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 | BIGINT | |
GroupId | BIGINT | |
EtlCreatedDate | TIMESTAMP | |
void | INT | |
podname | VARCHAR(100) | |
EtlLastUpdatedOn | TIMESTAMP DEFAULT convert_timezone('UTC',sysdate) |
|
EtlLastUpdatedBy | VARCHAR(50) DEFAULT current_user |
|