ZenotiHelp

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
email 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.