Employee item level commissions fact table
Bi_FactEmployeeItemLevelCommissions_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
Assigned | BOOLEAN | indicates if employee can provide this service or not. "true" indicates employee can provide service. "false" indicates employee is not authorised to provide the service | |||
CategoryId | VARCHAR(36) | if commission is set at category level, then category ID is mentioned here | |||
CategoryName | NVARCHAR(1024) | if commission is set at category level, then category name is mentioned here | |||
CenterId | VARCHAR(36) | Unique identifier for the center | Bi_DimCenter_s3 centerID | ||
commpercentvalue | NVARCHAR(32) | tells how much commission employee earns for the item. Value can be absolute amount or a percentage | |||
Employeeid | VARCHAR(36) | Unique identifier for employee. Unique across organization | Bi_DimUser_S3 userid | ||
EmployeeItemId | VARCHAR(36) | Unique identifier for the table. Primary key | Yes | ||
IsCategory | BOOLEAN | Indicates if item is a category or not: true - category, false- not a category | |||
Itemid | VARCHAR(36) | Unique identifier for Item sold. Item can product/service/package/etc. | Bi_DimItems_S3 itemid | ||
LabourCost | NVARCHAR(60) | commission employee has to pay to center for providing a service/ selling a product | |||
NewGuestCost | NVARCHAR(40) | commission employee has to pay to owner for providing service to new guest | |||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 OrganizationID | ||
ParentCategoryName | NVARCHAR(1024) | parent for category in "category" field | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
PriceScalingFactor | NVARCHAR(40) | indicates the price set at employee level. case 1: absolute value: If absolute value is set, service/product is sold at that price by the employee. Case 2: percentage: if percentage is set, service/product is sold at price set in product masters plus the percentage set in this field | |||
ServiceTime | INT | Ideal time taken to complete a service (in minutes), as set up in Zenoti | |||
ShopCost | NVARCHAR(60) | commission employee has to pay to center for utilising its space to provide service | |||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||