Employee item level commissions fact table
bi_factemployeeitemlevelcommissions
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 | varchar(256) | if commission is set at category level, then category name is mentioned here | |||
centerwid | bigint | Unique identifier for the center | Bi_DimCenter centerwid | ||
commpercentvalue | varchar(80) | tells how much commission employee earns for the item. Value can be absolute amount or a percentage | |||
employeeitemcommissionwid | bigint | Row number in the table | |||
employeeitemid | varchar(36) | Unique identifier for the table. Primary key | Yes | ||
employeewid | bigint | Unique identifier for employee. Unique across organization | Bi_DimUser userwid | ||
etlcreateddate | timestamp | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
iscategory | boolean | Indicates if item is a category or not: true - category, false- not a category | |||
itemwid | bigint | Unique identifier for Item sold. Item can product/service/package/etc. | Bi_DimItems itemwid | ||
labourcost | varchar(120) | commission employee has to pay to center for providing a service/ selling a product | |||
newguestcost | varchar(80) | 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 OrganizationID | ||
parentcategoryname | varchar(256) | parent for category in "category" field | |||
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 | |||
pricescalingfactor | varchar(80) | 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 | integer | Ideal time taken to complete a service (in minutes), as set up in Zenoti | |||
shopcost | varchar(120) | 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 | |||