Tips and SSG data fact table
This table lists the fact table columns used for the Tips and SSG data model.
Bi_FactEmployeeTipsAndSSGDetails
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
centerwid | bigint | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter centerwid | ||
Employeewid | bigint | A unique identifier for an employee(Bi_Dimuser). | Bi_DimUser userwid | ||
EmployeeSSGPercent | FLOAT | The percentage of SSG that the employee is eligible for. This is a setting in the core system. This has to be applied on the 'SSG' field to get the final SSG that the employee receives. | |||
EtlCreatedBy | DECIMAL(19,0) | ETL system admin user who inserted or updated the corresponding record in this table. | |||
EtlCreatedDate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
FactSegmentId | INT | A unique identifier(integer value) for each record generated in the fact table. | Yes | ||
InvoiceId | VARCHAR(36) | The unique identifier for the invoice within the organization. | |||
InvoiceItemId | VARCHAR(36) | The unique identifier for each line item within the invoice. | |||
IsSplitTip | INT | A flag that indicates whether the tip was generated using the split tips feature in Zenoti. - True: Tip was generated using the Split Tips feature. - False: Tip was not generated using the Split Tips feature. | |||
Itemwid | bigint | A unique identifier for the Item(Bi_DimItems). | Bi_DimItems itemwid | ||
LastUpdated | TIMESTAMP | The date of payment of the tip or SSG. If the tip or SSG get adjusted after the date of payment, this field contains the date of the adjustment. | |||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter OrganizationId | ||
PaymentCenterwid | bigint | A unique identifier of the centre where the payment was made.(Bi_DimCenter) | Bi_DimCenter centerwid | ||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
PODID | integer | Internal to the ETL, says from which POD data is being synced the table | |||
SSG | FLOAT | The SSG amount for the corresponding employee and invoice item. The 'employee SSG percent' field has to be applied on this to get the final SSG that the employee receives. | |||
Tip | FLOAT | The tip amount for the corresponding employee and invoice item. | |||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
transactionid | varchar(36) | Transactionid for tip/ssg received | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||
InvoiceNo | VARCHAR(160) | Invoice number that helps in identifying and tracking the invoice. | |||