Employee membership commissions fact table
Bi_FactEmployeeMembershipCommissions_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
CenterId | VARCHAR(36) | Unique identifier for the center | Bi_DimCenter_s3 centerID | ||
commpercentvalue | NVARCHAR(80) | percentage or value of commission employee earns for the sale of membership | |||
Employeeid | VARCHAR(36) | Unique identifier for employee. Unique across organization | Bi_DimUser_S3 userid | ||
EmpMembershipPK | DECIMAL(19,0) | Unique identifier for the row. Primary key for the table | Yes | ||
Itemid | VARCHAR(36) | item for which commission value is set | Bi_DimItems_S3 itemid | ||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 OrganizationID | ||
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 | |||