Center dimension table
bi_dimcenter
Field | Description | Field Type | Primary Key |
|---|---|---|---|
centeraddress | address of the center | varchar ( 1024 ) | |
centeradoptionlevel | integer | ||
centerbiometricflag | boolean | ||
centercanbook | boolean | ||
centercity | The city where the center is located. | varchar ( 128 ) | |
centercode | The unique code associated with the center. | varchar ( 40 ) | |
centercommdate | timestamp without time zone | ||
centercommission | Employees may receive commissions when their center achieves a given target or newly-opened centers may want to boost morale by offering a commission to all employees for the first three months after opening. This is called a center-based commission. This field populates the total Center Commission for the employee in the pay period. | double precision | |
centercompanyname | The name with which the center is registered. | varchar ( 200 ) | |
centerdisplayname | display name of the center | varchar ( 128 ) | |
centeremailid | email id of the center | varchar ( 200 ) | |
centerenablealerts | indicates if center had enabled alerts in the product | boolean | |
centerenableanalytics | indicates if analytics is enabled for the center | boolean | |
centerenableoffline | boolean | ||
centerenableotp | boolean | ||
centerenablewebstore | boolean | ||
centerenddate | timestamp without time zone | ||
centergeolatitude | geo latitude of the center | double precision | |
centergeolongitude | geo longitude of the center | double precision | |
centergolivedate | go live date of the center | timestamp without time zone | |
centerguestsearchacrosscntrs | indicates if a center can search guests across other centers | boolean | |
centerid | unique identifier for the center . | varchar ( 36 ) | |
centerinfo | varchar ( 4096 ) | ||
centerisclinic | indicates if center is a clinic | boolean | |
centerishotel | boolean | ||
centerisvendor | indicates if center is vendor for inventory | boolean | |
centername | The name of the center. | varchar ( 128 ) | |
centerpayable | boolean | ||
centerphone | phone number of the center | varchar ( 256 ) | |
centerpk | unique identifier for center in core system | bigint | |
centerrectprefix | varchar ( 32 ) | ||
centerstartdate | start date of the center | timestamp without time zone | |
centerstateother | varchar ( 128 ) | ||
centertallycenter | varchar ( 256 ) | ||
centertgtrevenue | numeric | ||
centertzdispname | varchar ( 4096 ) | ||
centertzstdname | The time zone in which the center is located. | varchar ( 4096 ) | |
centerwid | A unique identifier for the center. This is generated in Analytics, it does not exist in the core system. | bigint | |
centerzip | The zipcode of the center's location. | varchar ( 32 ) | |
cntrbustypename | varchar ( 80 ) | ||
cntrcountrycode | varchar ( 40 ) | ||
cntrcountrydispname | varchar ( 4096 ) | ||
cntrcountryshortname | varchar ( 4096 ) | ||
cntrculturecode | varchar ( 4096 ) | ||
cntrculturedispname | varchar ( 4096 ) | ||
cntrcurrdispname | varchar ( 4096 ) | ||
cntrcurrencycode | varchar ( 4096 ) | ||
cntrcurrnumber | integer | ||
cntrcurrsymbol | varchar ( 1024 ) | ||
cntrlangcode | varchar ( 4096 ) | ||
cntrlangdispname | varchar ( 4096 ) | ||
cntrstatecode | varchar ( 40 ) | ||
cntrstatedispname | The state where the center is located. | varchar ( 4096 ) | |
cntrstateshortname | varchar ( 4096 ) | ||
cstnum | The center's Central Sales Tax (CST) number. | varchar ( 80 ) | |
ctetllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in CT table. Internal to Zenoti | timestamp without time zone | |
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
fsrbasedonmembershiplistprice | double precision | ||
isfranchise | This flag indicates whether the center is a franchisee. - True: Indicates that it is a franchisee. - False: Indicates it is not a franchisee. | boolean | |
luxurytaxnum | The center's Luxury Tax number. | varchar ( 80 ) | |
orgaccountname | The domain name of the organization in Zenoti. | varchar ( 256 ) | |
organizationid | Unique identifier for the organization | varchar ( 36 ) | |
organizationname | The formal name of the organization. | varchar ( 512 ) | |
orgcountrycode | country code in which organization resides | varchar ( 40 ) | |
orgcountrydispname | The country where the center is located. | varchar ( 4096 ) | |
orgcountryshortname | abbrevated name of the organization | varchar ( 4096 ) | |
orgculturecode | varchar ( 4096 ) | ||
orgculturedispname | varchar ( 4096 ) | ||
orgcurrdispname | name to display to indicate currency used in transaction at center | varchar ( 4096 ) | |
orgcurrencycode | currency code in which center performs transactions | varchar ( 4096 ) | |
orgcurrnumber | integer | ||
orgcurrsymbol | symbol of currency used in transaction at center | varchar ( 1024 ) | |
orgenableanalytics | indicates if analytics is enabled for the organization | boolean | |
orgnoshowrefundvalue | double precision | ||
orgstatecode | code of the state in which center is located | varchar ( 40 ) | |
orgstatedispname | state in which center is located | varchar ( 4096 ) | |
orgstateshortname | abbrevated name of the state in which center is located | varchar ( 4096 ) | |
podname | varchar ( 20 ) | ||
servicetaxnum | The center's Service Tax number. | varchar ( 80 ) | |
tinnum | The center's Taxpayer’s Identification Number (TIN). | varchar ( 80 ) | |
totnum | The center's Transient Occupancy Tax (TOT) number. | varchar ( 80 ) | |
utilizationfactor | This field describes whether the employee's utilization should be calculated based on scheduled hours or attendance hours. This is a center-level setting in Zenoti. Possible values: - Schedule - Attendance | varchar ( 65535 ) | |
vatnumber | The center's Value-Added Tax (VAT) number. | varchar ( 80 ) | |
void | A flag that indicates whether the center is operational. - True indicates operational - False indicates not operational | boolean | |
zonedesc | description of zone | varchar ( 65535 ) | |
zoneid | unique identifier for zone in the organization | varchar ( 36 ) | |
zonename | The zone that the center belongs to. | varchar ( 800 ) | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |