Declare tips fact table
This page describes fact table columns of bi_factemployeedeclaretips used for storing declared tips for the day.
Bi_FactEmployeeDeclareTips
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
Centerwid | big | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter centerwid | ||
DeclaredDate | DATE | date for which tip is declared | |||
DeclaredTip | numeric(19,4) | amount declared by employee as tip received for the day | |||
Employeewid | VARCHAR(36) | A unique identifier for an employee(Bi_Dimuser). | Bi_DimUser userwid | ||
etlCreatedBy | numeric(19) | 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. | |||
FactDeclareTipid | numeric(19) | Unique id for each record of table. Generated within Analytics | |||
factemployeedeclaretipswid | bigint | Unique id for each record of table. Generated within Analytics | Yes | ||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter Organizationwid | ||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||