Tips payout employee settings dimension table
bi_dimtipspayoutemployeesettings
Field | Description | Field type | Primary key |
|---|---|---|---|
tipspayoutemployeesettingswid | Unique identifier for the row. Primary key | BIGINT | Yes |
dimtipspayoutempsettingspk | Unique identifier within Zenoti. Internal to Zenoti | BIGINT | |
employeepk | Unique identifer for employee within Zenoti core system. Internal to Zenoti | BIGINT | |
employeeid | Unique identifer for employee. To be mapped with userwid in bi_dimuser | VARCHAR(36) | |
centerid | Unique identifier for a center. To be mapped with Centerwid in bi_dimcenter | VARCHAR(36) | |
organizationid | Unique identifier for an Organization. To be mapped with Organizationid in bi_dimcenter | VARCHAR(36) | |
optinstatus | Indicates if the employee opted for Tips Payout or not | INTEGER | |
optinstatusstartdate | Start date from which status in "optinstatus" column is considered | TIMESTAMP | |
optinstatusenddate | Last date on which status in "optinstatus" column is considered | TIMESTAMP | |
kycstatus | Indicates KYC status of the employee. | INTEGER | |
kycstatusstartdate | Date from which KYC status is changed | TIMESTAMP | |
kycstatusenddate | Date till which KYC status remained same as in column "kycstatus" | TIMESTAMP | |
void | Indicates if row is void. 1- void, 0- not void | BOOLEAN | |
currentrecord | Indicates if the row is current record or not | BOOLEAN | |
etllastupdatedon | date on which this row is last synced. Internal to Zenoti | TIMESTAMP | |
etllastupdatedby | system userid which last synced the data from core system. Internal to Zenoti | VARCHAR(128) | |
podname | Region in which customer is hosted. Internal to Zenoti | VARCHAR(20) | |
ctetllastupdatedon | Date on which this row is synced to materialised data source. Internal to Zenoti | TIMESTAMP | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |