ZenotiHelp

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.