Multiple employee commission fact table
bi_factmultipleemployeecommission
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | ||
|---|---|---|---|---|---|---|
appointmentid | varchar(36) | unique identifier for an appointment | ||||
centerwid | bigint | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter Centerwid | |||
commission | numeric(19,4) | commission percentage | ||||
empcommissionid | varchar(36) | unique identifier for the row in the table (GUID) | ||||
empcommissionpk | numeric(19) | unique identifier for the row in the table | ||||
empcommissionwid | bigint | unique identifier for the row in the table | PK | |||
employeewid | bigint | Unique identifier for the employee | Bi_Dimuser userwid | |||
invoiceitemid | varchar(36) | Displays the invoice id associated to sale, refund, or redemption transaction. | ||||
isvoid | boolean | Indicates if the commission is void or not | ||||
organizationid | varchar(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 OrganizationId | |||
podid | integer | Unique identifier for the POD on which customer data is hosted | ||||
podname | varchar(20) | Internal to the ETL, says from which POD data is being synced the table | ||||
primaryemp | boolean | Employee who provided the service. | ||||
updatedby | varchar(36) | Employee id of the employee who made an update | ||||
updatedon | timestamp | Date on which invoice is updated | ||||
void | boolean | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | ||||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | ||||