Center Dimension Table
ZTZenoti Docs Team Updated June 29, 2026 4 min readGuide
Dimension table storing center (location/branch) information including organization hierarchy, geographic details, currency/culture settings, and operational configuration. Populated from center and organization master data.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| centerwid | BIGINT IDENTITY | No | Surrogate warehouse key for the center dimension, auto-generated |
| organizationname | VARCHAR(512) | Yes | Name of the parent organization |
| orgaccountname | VARCHAR(256) | Yes | Account name of the organization |
| orgnoshowrefundvalue | DOUBLE PRECISION | Yes | Organization-level no-show refund value setting |
| orgenableanalytics | BOOLEAN | Yes | Whether analytics is enabled at the organization level |
| orgcountrydispname | VARCHAR(4096) | Yes | Full display name of the organization's country |
| orgcountryshortname | VARCHAR(4096) | Yes | Short/abbreviated name of the organization's country |
| orgcountrycode | VARCHAR(40) | Yes | Country code of the organization |
| orgstatedispname | VARCHAR(4096) | Yes | Full display name of the organization's state/province |
| orgstateshortname | VARCHAR(4096) | Yes | Short/abbreviated name of the organization's state/province |
| orgstatecode | VARCHAR(40) | Yes | State/province code of the organization |
| orgculturedispname | VARCHAR(4096) | Yes | Display name for the organization's culture/locale |
| orgculturecode | VARCHAR(4096) | Yes | Culture/locale code for the organization (e.g., en-US) |
| orgcurrencycode | VARCHAR(4096) | Yes | Currency code for the organization (e.g., USD) |
| orgcurrdispname | VARCHAR(4096) | Yes | Display name of the organization's currency |
| orgcurrsymbol | VARCHAR(1024) | Yes | Currency symbol for the organization (e.g., $) |
| orgcurrnumber | INTEGER | Yes | Numeric currency identifier for the organization |
| zoneid | VARCHAR(36) | Yes | Identifier of the zone/region the center belongs to |
| zonename | VARCHAR(800) | Yes | Name of the zone/region |
| zonedesc | VARCHAR(65535) | Yes | Description of the zone/region |
| centerid | VARCHAR(36) | Yes | Natural unique identifier (GUID) of the center from the source system |
| centername | VARCHAR(128) | Yes | Name of the center |
| centercity | VARCHAR(128) | Yes | City where the center is located |
| centerstateother | VARCHAR(128) | Yes | Free-text state field for the center when not in standard list |
| centerzip | VARCHAR(32) | Yes | Postal/ZIP code of the center |
| centerishotel | BOOLEAN | Yes | Whether the center is a hotel-type location |
| centertgtrevenue | NUMERIC(19,4) | Yes | Target revenue for the center |
| centercompanyname | VARCHAR(200) | Yes | Legal company name associated with the center |
| centerrectprefix | VARCHAR(32) | Yes | Receipt prefix used for transactions at this center |
| centertallycenter | VARCHAR(256) | Yes | Tally accounting center code |
| centerisvendor | BOOLEAN | Yes | Whether the center operates as a vendor |
| centerisclinic | BOOLEAN | Yes | Whether the center is a clinic-type location |
| centercommission | DOUBLE PRECISION | Yes | Default commission rate for the center |
| centercommdate | TIMESTAMP | Yes | Date from which the center commission is effective |
| centeremailid | VARCHAR(200) | Yes | Email address of the center |
| centerbiometricflag | BOOLEAN | Yes | Whether biometric authentication is enabled at the center |
| centerguestsearchacrosscntrs | BOOLEAN | Yes | Whether guest search across centers is enabled |
| centergolivedate | TIMESTAMP | Yes | Date when the center went live in the system |
| centerpayable | BOOLEAN | Yes | Whether the center is payable (participates in financial transactions) |
| centerstartdate | TIMESTAMP | Yes | Start date of center operations |
| centergeolatitude | DOUBLE PRECISION | Yes | Geographic latitude coordinate of the center |
| centergeolongitude | DOUBLE PRECISION | Yes | Geographic longitude coordinate of the center |
| centerinfo | VARCHAR(4096) | Yes | Additional informational text about the center |
| centerenableanalytics | BOOLEAN | Yes | Whether analytics is enabled at the center level |
| centerdisplayname | VARCHAR(128) | Yes | Display name of the center (may differ from centername) |
| centeradoptionlevel | INTEGER | Yes | Adoption level indicator for the center |
| centerenableotp | BOOLEAN | Yes | Whether OTP (one-time password) authentication is enabled |
| centerenablealerts | BOOLEAN | Yes | Whether alerts are enabled for the center |
| centercode | VARCHAR(40) | Yes | Short code identifier for the center |
| centerenddate | TIMESTAMP | Yes | End date of center operations (if decommissioned) |
| centercanbook | BOOLEAN | Yes | Whether online booking is enabled for the center |
| centerenableoffline | BOOLEAN | Yes | Whether offline mode is enabled for the center |
| centerenablewebstore | BOOLEAN | Yes | Whether the Webstore is enabled for the center |
| centertzdispname | VARCHAR(4096) | Yes | Display name of the center's timezone |
| centertzstdname | VARCHAR(4096) | Yes | Standard name of the center's timezone |
| cntrcurrencycode | VARCHAR(4096) | Yes | Currency code at the center level |
| cntrcurrdispname | VARCHAR(4096) | Yes | Display name of the center's currency |
| cntrcurrsymbol | VARCHAR(1024) | Yes | Currency symbol at the center level |
| cntrcurrnumber | INTEGER | Yes | Numeric currency identifier at the center level |
| cntrculturedispname | VARCHAR(4096) | Yes | Display name for the center's culture/locale |
| cntrculturecode | VARCHAR(4096) | Yes | Culture/locale code for the center |
| cntrcountrydispname | VARCHAR(4096) | Yes | Full display name of the center's country |
| cntrcountryshortname | VARCHAR(4096) | Yes | Short/abbreviated name of the center's country |
| cntrcountrycode | VARCHAR(40) | Yes | Country code of the center |
| cntrstatedispname | VARCHAR(4096) | Yes | Full display name of the center's state/province |
| cntrstateshortname | VARCHAR(4096) | Yes | Short/abbreviated name of the center's state/province |
| cntrstatecode | VARCHAR(40) | Yes | State/province code of the center |
| cntrlangdispname | VARCHAR(4096) | Yes | Display name of the center's language |
| cntrlangcode | VARCHAR(4096) | Yes | Language code for the center |
| cntrbustypename | VARCHAR(80) | Yes | Business type name of the center (e.g., spa, salon) |
| utilizationfactor | VARCHAR(65535) | Yes | Utilization factor configuration for the center |
| centeraddress | VARCHAR(1024) | Yes | Full address of the center |
| centerphone | VARCHAR(256) | Yes | Phone number of the center |
| void | BOOLEAN | Yes | Soft-delete flag; TRUE indicates the record is voided/inactive |
| isfranchise | BOOLEAN | Yes | Whether the center is a franchise location |
| cstnum | VARCHAR(80) | Yes | CST (Central Sales Tax) number |
| tinnum | VARCHAR(80) | Yes | TIN (Tax Identification Number) |
| totnum | VARCHAR(80) | Yes | TOT (Turnover Tax) number |
| servicetaxnum | VARCHAR(80) | Yes | Service tax registration number |
| vatnumber | VARCHAR(80) | Yes | VAT (Value Added Tax) number |
| luxurytaxnum | VARCHAR(80) | Yes | Luxury tax registration number |
| fsrbasedonmembershiplistprice | DOUBLE PRECISION | Yes | FSR (Full Service Revenue) calculation based on membership list price |
| centerpk | BIGINT | Yes | Primary key of the center from the source transactional system |
| CTEtlLastUpdatedOn | TIMESTAMP | Yes | Timestamp of the last cross-tenant ETL update |
| isavedaenabled | BOOLEAN | Yes | Whether Aveda-specific features are enabled for this center (added via ALTER) |
Note: All dimension tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlLastUpdatedOn,etlLastUpdatedBy) which are omitted from this reference for brevity.
Primary Key
centerwid
Foreign Keys
| Column | References |
|---|---|
| organizationid | the organization entity |
| zoneid | the zone/region entity |
Enumerator Values
| Column | Values |
|---|---|
| centeradoptionlevel | Integer representing the adoption level of the center |
Was this article helpful?
Your feedback helps us improve our documentation.