Employee membership commissions fact table
bi_factemployeemembershipcommissions
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
centerwid | bigint | Unique identifier for the center | Bi_DimCenter centerwid | ||
commpercentvalue | varchar(80) | percentage or value of commission employee earns for the sale of membership | |||
employeemembershipcommissionwid | bigint | Unique identifier for the row | |||
employeewid | bigint | Unique identifier for employee. Unique across organization | Bi_DimUser userwid | ||
empmembershippk | bigint | Unique identifier for the row. Primary key for the table | yes | ||
etlcreateddate | timestamp | unique identfier in Table. Exists only in Analytics | |||
itemwid | bigint | item for which commission value is set | Bi_DimItems itemwid | ||
organizationid | varchar(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter 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 | |||
void | boolean | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||