Skip to main content

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)