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