User Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide
Dimension table storing user profile information including guests, employees, and other user types. Populated from the core user data with demographic, contact, preference, and communication opt-in details.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| userwid | BIGINT IDENTITY | No | Surrogate warehouse key for the user dimension, auto-generated |
| userid | VARCHAR(36) | Yes | Natural unique identifier (GUID) of the user from the source system |
| usertypeid | VARCHAR(36) | Yes | Identifier for the user type classification (e.g., guest, employee) |
| creationdt | TIMESTAMP | Yes | Timestamp when the user record was created in the source system |
| centerid | VARCHAR(36) | Yes | Identifier of the center the user is associated with |
| lastlogin | TIMESTAMP | Yes | Timestamp of the user's most recent login |
| gender | INTEGER | Yes | Gender code of the user (enumerated integer value) |
| dob | TIMESTAMP | Yes | Date of birth of the user |
| preferredtherapist | VARCHAR(36) | Yes | Identifier of the user's preferred therapist |
| preferredroom | VARCHAR(36) | Yes | Identifier of the user's preferred room |
| referralsourceid | VARCHAR(36) | Yes | Identifier of the referral source through which the user was acquired |
| referredby | VARCHAR(36) | Yes | Identifier of the user who referred this user |
| anniversarydate | TIMESTAMP | Yes | Anniversary date for the user |
| preferedcenerid | VARCHAR(36) | Yes | Identifier of the user's preferred center |
| registrationsource | INTEGER | Yes | Enumerated value indicating how the user registered (e.g., walk-in, online) |
| customerapplogin | INTEGER | Yes | Flag/count indicating customer app login activity |
| receivetransactionalsms | BOOLEAN | Yes | Whether the user has opted in to receive transactional SMS |
| receivemarketingsms | BOOLEAN | Yes | Whether the user has opted in to receive marketing SMS |
| userpk | NUMERIC(19,0) | Yes | Primary key of the user from the source transactional system |
| unsubscribetotransactionalemail | BOOLEAN | Yes | Whether the user has unsubscribed from transactional emails |
| unsubscribetomarketingemail | BOOLEAN | Yes | Whether the user has unsubscribed from marketing emails |
| passwordupdatedon | TIMESTAMP | Yes | Timestamp when the user's password was last updated |
| receivetransactionalemail | BOOLEAN | Yes | Whether the user has opted in to receive transactional emails |
| receivemarketingemail | BOOLEAN | Yes | Whether the user has opted in to receive marketing emails |
| acceptedtandc | INTEGER | Yes | Flag indicating whether the user accepted terms and conditions |
| nationalityfk | INTEGER | Yes | Foreign key reference to the nationality lookup |
| void | BOOLEAN | Yes | Soft-delete flag; TRUE indicates the record is voided/inactive |
| employeetags | VARCHAR(65535) | Yes | Comma-separated or JSON tags associated with the user as an employee |
| usertags | VARCHAR(65535) | Yes | Comma-separated or JSON tags associated with the user |
| jobname | VARCHAR(1020) | Yes | Name of the user's job role (applicable for employees) |
| jobcode | VARCHAR(8000) | Yes | Code identifier for the user's job role |
| guestreferralsource | VARCHAR(3200) | Yes | Descriptive referral source name for guest users |
| emailstate | INTEGER | Yes | Enumerated value representing the state of the user's email (e.g., verified, bounced) |
| mandatorybreaktimeperday | INTEGER | Yes | Mandatory break time in minutes per day for employee users |
| phonecode | INTEGER | Yes | International phone/country dialing code |
| startdate | TIMESTAMP | Yes | Employment or membership start date |
| lastdate | TIMESTAMP | Yes | Employment or membership end/last active date |
| nosalecomments | VARCHAR(65535) | Yes | Comments recorded for no-sale transactions |
| statecode | VARCHAR(40) | Yes | State/province code for the user's address |
| culturecode | VARCHAR(4096) | Yes | Culture/locale code (e.g., en-US) |
| culturedispname | VARCHAR(4096) | Yes | Display name for the culture/locale |
| langcode | VARCHAR(4096) | Yes | Language code preference |
| langdispname | VARCHAR(4096) | Yes | Display name for the preferred language |
| mobilecountrydname | VARCHAR(4096) | Yes | Full country name for the mobile phone number |
| mobilecountrysname | VARCHAR(4096) | Yes | Short country name for the mobile phone number |
| workcountrydname | VARCHAR(4096) | Yes | Full country name for the work phone number |
| workcountrysname | VARCHAR(4096) | Yes | Short country name for the work phone number |
| homecountrydname | VARCHAR(4096) | Yes | Full country name for the home phone number |
| homecountrysname | VARCHAR(4096) | Yes | Short country name for the home phone number |
| statedispname | VARCHAR(4096) | Yes | Display name of the user's state/province |
| stateshortname | VARCHAR(4096) | Yes | Short/abbreviated name of the user's state/province |
| countrydname | VARCHAR(4096) | Yes | Full display name of the user's country |
| countrysname | VARCHAR(4096) | Yes | Short/abbreviated name of the user's country |
| homephone | VARCHAR(64) | Yes | Home phone number |
| mobilephone | VARCHAR(64) | Yes | Mobile phone number |
| workphone | VARCHAR(64) | Yes | Work phone number |
| roomno | VARCHAR(80) | Yes | Room number (relevant for hotel/spa guests) |
| middlename | VARCHAR(256) | Yes | User's middle name |
| city | VARCHAR(128) | Yes | City of the user's address |
| stateother | VARCHAR(128) | Yes | Free-text state field when state is not in the standard list |
| usertypename | VARCHAR(128) | Yes | Display name of the user type |
| usercode | VARCHAR(128) | Yes | Unique user code assigned in the source system |
| firstname | VARCHAR(256) | Yes | User's first name |
| otherpreferences | VARCHAR(65535) | Yes | Additional user preferences stored as text/JSON |
| dob_incompleteyear | VARCHAR(20) | Yes | Date of birth with incomplete year information (e.g., month-day only) |
| lastname | VARCHAR(256) | Yes | User's last name |
| address1 | VARCHAR(65535) | Yes | Primary address line |
| address2 | VARCHAR(65535) | Yes | Secondary address line |
| VARCHAR(512) | Yes | User's email address | |
| username | VARCHAR(512) | Yes | User's login username |
| zipcode | VARCHAR(128) | Yes | Postal/ZIP code |
| additionalfield1 | VARCHAR(8000) | Yes | Custom additional field 1 for organization-specific data |
| additionalfield2 | VARCHAR(8000) | Yes | Custom additional field 2 for organization-specific data |
| employeecode | VARCHAR(512) | Yes | Employee code identifier (applicable for employee users) |
| relationshipmanager | VARCHAR(36) | Yes | Identifier of the assigned relationship manager |
| date1 | TIMESTAMP WITHOUT TIME ZONE | Yes | Generic date field 1 for organization-specific use |
| date2 | TIMESTAMP WITHOUT TIME ZONE | Yes | Generic date field 2 for organization-specific use |
| CTEtlLastUpdatedOn | TIMESTAMP | Yes | Timestamp of the last cross-tenant ETL update |
| tenurestartdate | TIMESTAMP | Yes | Date when the user's tenure started |
| nationality | VARCHAR(4096) | Yes | Nationality description of the user |
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
userwid
Foreign Keys
| Column | References |
|---|---|
| centerid | Bi_DimCenter |
| organizationid | Bi_DimCenter |
| preferredtherapist | a user/employee ID |
| referredby | another user ID |
| relationshipmanager | a user/employee ID |
| preferedcenerid | a center ID |
Enumerator Values
| Column | Values |
|---|---|
| gender | -1 = Not Specified 0 = Female 1 = Male 3 = Other/Third Gender 4 = Multiple |
| registrationsource | 0 = Store 1 = Mobile 2 = Web 3 = Imports 4 = Offline 6 = Employee App 7 = Manager App 9 = BiometricApp 10 = SupportLogin |
| emailstate | 0 = Not Verified 1 = Verified 2 = Bounced |
| acceptedtandc | 0 = Not Accepted, 1 = Accepted |
| customerapplogin | 0 = No Login, 1 = Has Logged In |
Was this article helpful?
Your feedback helps us improve our documentation.