ZenotiHelp

Employee Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide

Dimension table storing employee profile information including demographic details, contact information, job attributes, and center assignment. Populated from the user/employee data, providing a center-specific view where each employee-center combination is a unique record.

Columns

Column Name Data Type Nullable Description
employeeuniquewid BIGINT IDENTITY No Surrogate warehouse key for the employee dimension, auto-generated
employeeuniqueid VARCHAR(36) Yes Unique identifier (GUID) for the employee-center combination
employeewid BIGINT Yes Warehouse key referencing the employee in Bi_DimUser
usertypeid VARCHAR(36) Yes Identifier for the user type classification
creationdt TIMESTAMP Yes Timestamp when the employee record was created
centerwid BIGINT Yes Warehouse key referencing the center the employee is assigned to
lastlogin TIMESTAMP Yes Timestamp of the employee's most recent login
gender INTEGER Yes Gender code of the employee (enumerated integer value)
dob TIMESTAMP Yes Date of birth of the employee
preferredtherapist VARCHAR(36) Yes Identifier of the employee's preferred therapist
preferredroom VARCHAR(36) Yes Identifier of the employee's preferred room
otherpreferences VARCHAR(32000) Yes Additional preferences stored as text/JSON
referralsourceid VARCHAR(36) Yes Identifier of the referral source
referredby VARCHAR(36) Yes Identifier of the person who referred this employee
anniversarydate TIMESTAMP Yes Work anniversary date
preferedcenerid VARCHAR(36) Yes Identifier of the employee's preferred center
registrationsource INTEGER Yes Enumerated value indicating how the employee was registered
customerapplogin INTEGER Yes Flag/count indicating customer app login activity
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 employee's state/province
stateshortname VARCHAR(4096) Yes Short/abbreviated name of the employee's state/province
countrydname VARCHAR(4096) Yes Full display name of the employee's country
countrysname VARCHAR(4096) Yes Short/abbreviated name of the employee's country
receivetransactionalsms BOOLEAN Yes Whether the employee has opted in to receive transactional SMS
receivemarketingsms BOOLEAN Yes Whether the employee 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 employee has unsubscribed from transactional emails
unsubscribetomarketingemail BOOLEAN Yes Whether the employee has unsubscribed from marketing emails
passwordupdatedon TIMESTAMP Yes Timestamp when the employee's password was last updated
receivetransactionalemail BOOLEAN Yes Whether the employee has opted in to receive transactional emails
receivemarketingemail BOOLEAN Yes Whether the employee has opted in to receive marketing emails
acceptedtandc INTEGER Yes Flag indicating whether the employee accepted terms and conditions
nationalityfk INTEGER Yes Foreign key reference to the nationality lookup
jobcode VARCHAR(8000) Yes Code identifier for the employee's job role
jobname VARCHAR(1020) Yes Name of the employee's job role
jobdesc VARCHAR(8000) Yes Description of the employee's job role
startdate TIMESTAMP Yes Employment start date at the assigned center
lastdate TIMESTAMP Yes Employment end/last active date at the assigned center
mandatorybreaktimeperday INTEGER Yes Mandatory break time in minutes per day
podid INTEGER Yes Identifier of the source pod/shard
void BOOLEAN Yes Soft-delete flag; TRUE indicates the record is voided/inactive
middlename VARCHAR(512) Yes Employee's middle name
city VARCHAR(512) Yes City of the employee's address
stateother VARCHAR(512) Yes Free-text state field when state is not in the standard list
usertypename VARCHAR(512) Yes Display name of the user type
usercode VARCHAR(512) Yes Unique user code assigned in the source system
firstname VARCHAR(640) Yes Employee's first name
dob_incompleteyear VARCHAR(80) Yes Date of birth with incomplete year information
lastname VARCHAR(512) Yes Employee's last name
address1 VARCHAR(1024) Yes Primary address line
address2 VARCHAR(1024) Yes Secondary address line
email VARCHAR(1024) Yes Employee's email address
username VARCHAR(1024) Yes Employee's login username
zipcode VARCHAR(128) Yes Postal/ZIP code
statecode VARCHAR(160) Yes State/province code for the employee's address
homephone VARCHAR(256) Yes Home phone number
mobilephone VARCHAR(256) Yes Mobile phone number
workphone VARCHAR(256) Yes Work phone number
roomno VARCHAR(320) Yes Room number
employeecode VARCHAR(128) Yes Employee code identifier

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

employeeuniquewid

Foreign Keys

Column References
employeewid Bi_DimUser.userwid
centerwid Bi_DimCenter.centerwid
organizationid Bi_DimCenter
referredby another user 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
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.