S3_Tips payout center settings dimension table
bi_dimtipspayoutcentersettings_s3
Field | Description | Field type | Primary key |
|---|---|---|---|
dimtipspayoutcentersettingspk | Unique identifier within Zenoti. Internal to Zenoti | BIGINT | Yes |
integrationsettingpk | Unique identifier within Zenoti. Internal to Zenoti | BIGINT | |
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) | |
syncdelay | Indicates the delay between tips earned date and tips payout date. | INTEGER | |
syncstartdate | Date on which center is onboarded onto Tips Payout | TIMESTAMP | |
active | Indicates if center is active on this feature | BOOLEAN | |
activestartdate | Date on which "Active" flag is changed | TIMESTAMP | |
activeenddate | Date till which "active" flag is applicable as defined in column "active" | TIMESTAMP | |
void | Indicates if row is void. 1- void, 0- not void | BOOLEAN | |
voidstartdate | Start date of void status as mentioned in column "void" | TIMESTAMP | |
voidendddate | End date of void status as mentioned in column "void" | TIMESTAMP | |
accumulationstatus | Indicates if accumulation flag is set On or Off for the center. 0 - Off, 1- On | BOOLEAN | |
accumulationstatusstartdate | date on which accumulation status is set on/off | TIMESTAMP | |
accumulationstatusenddate | date till which accumulation status is maintained as on/off | TIMESTAMP | |
lastupdatedby | latest user who updated the row | VARCHAR(36) | |
currentrecord | Indicates if the row is current status of the center or not | BOOLEAN | |
lastupdateddate | date on which this row is last updated | TIMESTAMP | |
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 | |
SyncEarningStartDate | Center level start date for tips payout feature implementation | TIMESTAMP | |
AccumulationEarningStartDate | Center level start date for accumulation of tips to be paid through Myzen TipsPayout | TIMESTAMP | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |