Multiple employee commission fact table
Bi_FactMultipleEmployeeCommission_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
AppointmentId | VARCHAR(36) | unique identifier for an appointment | |||
CenterId | VARCHAR(36) | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter_s3 CenterId | ||
Commission | DECIMAL(19,4) | commission percentage | |||
EmpCommissionId | VARCHAR(36) | unique identifier for the row in the table (GUID) | |||
EmpCommissionPK | DECIMAL(19,0) | unique identifier for the row in the table | Yes | ||
EmployeeId | VARCHAR(36) | Unique identifier for the employee | Bi_Dimuser_s3 userid | ||
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 | ||
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 | |||
empcommissionwid | |||||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||