Center dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column | |
Bi_DimCenter_s3 | organizationID | VARCHAR(36) | ||||
Bi_DimCenter_s3 | OrganizationName | NVARCHAR(512) | ||||
Bi_DimCenter_s3 | orgAccountName | NVARCHAR(256) | ||||
Bi_DimCenter_s3 | orgNoShowRefundValue | FLOAT | ||||
Bi_DimCenter_s3 | orgEnableAnalytics | BOOLEAN | ||||
Bi_DimCenter_s3 | orgCountryDispName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | orgCountryShortName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | orgCountryCode | NVARCHAR(40) | ||||
Bi_DimCenter_s3 | orgstateDispName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | orgstateShortName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | orgstateCode | NVARCHAR(40) | ||||
Bi_DimCenter_s3 | orgcultureDispName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | orgcultureCode | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | orgcurrencyCode | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | orgcurrDispName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | orgcurrSymbol | NVARCHAR(1024) | ||||
Bi_DimCenter_s3 | orgcurrNumber | INT | ||||
Bi_DimCenter_s3 | zoneID | VARCHAR(36) | ||||
Bi_DimCenter_s3 | zonename | NVARCHAR(800) | ||||
Bi_DimCenter_s3 | zonedesc | NVARCHAR(8000) | ||||
Bi_DimCenter_s3 | centerid | VARCHAR(36) | PK | |||
Bi_DimCenter_s3 | centerName | NVARCHAR(512) | ||||
Bi_DimCenter_s3 | centerCity | NVARCHAR(128) | ||||
Bi_DimCenter_s3 | centerStateOther | NVARCHAR(128) | ||||
Bi_DimCenter_s3 | centerzip | NVARCHAR(32) | ||||
Bi_DimCenter_s3 | centerisHotel | BOOLEAN | ||||
Bi_DimCenter_s3 | centerTgtRevenue | DECIMAL(19,4) | ||||
Bi_DimCenter_s3 | centerCompanyName | NVARCHAR(200) | ||||
Bi_DimCenter_s3 | centerRectPrefix | NVARCHAR(24) | ||||
Bi_DimCenter_s3 | centerTallyCenter | NVARCHAR(256) | ||||
Bi_DimCenter_s3 | centerisVendor | BOOLEAN | ||||
Bi_DimCenter_s3 | centerisClinic | BOOLEAN | ||||
Bi_DimCenter_s3 | centerCommission | FLOAT | ||||
Bi_DimCenter_s3 | centerCommDate | TIMESTAMP | ||||
Bi_DimCenter_s3 | centerEmailid | NVARCHAR(200) | ||||
Bi_DimCenter_s3 | centerBiometricFlag | BOOLEAN | ||||
Bi_DimCenter_s3 | centerGuestSearchAcrossCntrs | BOOLEAN | ||||
Bi_DimCenter_s3 | centerGoLiveDate | TIMESTAMP | ||||
Bi_DimCenter_s3 | centerPayable | BOOLEAN | ||||
Bi_DimCenter_s3 | centerStartDate | TIMESTAMP | ||||
Bi_DimCenter_s3 | centergeolatitude | FLOAT | ||||
Bi_DimCenter_s3 | centerGeoLongitude | FLOAT | ||||
Bi_DimCenter_s3 | centerinfo | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | centerEnableAnalytics | BOOLEAN | ||||
Bi_DimCenter_s3 | CenterDisplayName | NVARCHAR(128) | ||||
Bi_DimCenter_s3 | centerAdoptionlevel | INT | ||||
Bi_DimCenter_s3 | centerEnableOtp | BOOLEAN | ||||
Bi_DimCenter_s3 | centerEnableAlerts | BOOLEAN | ||||
Bi_DimCenter_s3 | centerCode | NVARCHAR(40) | ||||
Bi_DimCenter_s3 | centerEndDate | TIMESTAMP | ||||
Bi_DimCenter_s3 | centerCanBook | BOOLEAN | ||||
Bi_DimCenter_s3 | centerEnableOffline | BOOLEAN | ||||
Bi_DimCenter_s3 | centerEnableWebStore | BOOLEAN | ||||
Bi_DimCenter_s3 | centerTZDispName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | centerTZStdName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | cntrcurrencyCode | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | cntrcurrDispName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | cntrcurrSymbol | NVARCHAR(1024) | ||||
Bi_DimCenter_s3 | cntrcurrNumber | INT | ||||
Bi_DimCenter_s3 | cntrcultureDispName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | cntrcultureCode | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | cntrCountryDispName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | cntrCountryShortName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | cntrCountryCode | NVARCHAR(40) | ||||
Bi_DimCenter_s3 | cntrstateDispName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | cntrstateShortName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | cntrstateCode | NVARCHAR(40) | ||||
Bi_DimCenter_s3 | cntrLangDispName | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | cntrLangCode | NVARCHAR(4096) | ||||
Bi_DimCenter_s3 | cntrBusTypeName | NVARCHAR(80) | ||||
Bi_DimCenter_s3 | UtilizationFactor | NVARCHAR(MAX) | ||||
Bi_DimCenter_s3 | centerAddress | NVARCHAR(256) | ||||
Bi_DimCenter_s3 | centerPhone | NVARCHAR(64) | ||||
Bi_DimCenter_s3 | void | BOOLEAN | ||||
Bi_DimCenter_s3 | IsFranchise | BOOLEAN | ||||
Bi_DimCenter_s3 | CSTNum | NVARCHAR(64) | ||||
Bi_DimCenter_s3 | TINNum | NVARCHAR(64) | ||||
Bi_DimCenter_s3 | TOTNum | NVARCHAR(64) | ||||
Bi_DimCenter_s3 | ServiceTaxNum | NVARCHAR(64) | ||||
Bi_DimCenter_s3 | VATNumber | NVARCHAR(80) | ||||
Bi_DimCenter_s3 | LuxuryTaxNum | NVARCHAR(128) | ||||
Bi_DimCenter_s3 | FSRBasedOnMembershipListPrice | INT | ||||
Bi_DimCenter_s3 | EtlLastUpdatedOn | TIMESTAMP | ||||
Bi_DimCenter_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||||
Bi_DimCenter_s3 | PodName | VARCHAR(20) | ||||
Bi_DimCenter_s3 | centerpk | INT | ||||
Bi_DimCenter_s3 | CTEtlLastUpdatedOn | TIMESTAMP | ||||
Bi_DimAgent_s3 | groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||