User dimension table
bi_dimuser
Field | Description | Field Type | Primary Key |
|---|---|---|---|
acceptedtandc | integer | ||
additionalfield1 | The details in 'Additional Field1' for the corresponding employee. | varchar ( 8000 ) | |
additionalfield2 | The details in 'Additional Field2' for the corresponding employee. | varchar ( 8000 ) | |
address1 | Guest's address 1 details. | varchar ( 65535 ) | |
address2 | Guest's address 2 details. | varchar ( 65535 ) | |
anniversarydate | Marriage anniversary date of the guest. This is a non-mandatory value and it can be blank. | timestamp without time zone | |
centerid | varchar ( 36 ) | ||
city | The city to which the guest belongs. This is a non-mandatory value and it can be blank. | varchar ( 128 ) | |
countrydname | The country to which the guest belongs. This is a non-mandatory value and it can be blank. | varchar ( 4096 ) | |
countrysname | varchar ( 4096 ) | ||
creationdt | The date on which the profile of the guest was created. | timestamp without time zone | |
ctetllastupdatedon | timestamp without time zone | ||
culturecode | varchar ( 4096 ) | ||
culturedispname | varchar ( 4096 ) | ||
customerapplogin | integer | ||
date1 | timestamp without time zone | ||
date2 | timestamp without time zone | ||
dob | Date of Birth of the guest. This is a non-mandatory value and it can be blank. | timestamp without time zone | |
dob_incompleteyear | varchar ( 20 ) | ||
Email ID of the guest. This is a mandatory value and it cannot be blank. | varchar ( 512 ) | ||
emailstate | Staus of the guest email based on email delivery status. | integer | |
employeecode | Unique code of the corresponding employee. This is the code taken from the employee's profile in Zenoti. | varchar ( 512 ) | |
employeetags | Tags associated with the employee. | varchar ( 65535 ) | |
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 | |
firstname | First name of the employee/guest/therapist. | varchar ( 256 ) | |
gender | The gender of the employee/ guest. | integer | |
guestreferralsource | The source from where the guest got to know about the organization. | varchar ( 3200 ) | |
homecountrydname | varchar ( 4096 ) | ||
homecountrysname | varchar ( 4096 ) | ||
homephone | The guest's home phone number. | varchar ( 64 ) | |
jobcode | Unique code associated with the Job of the employee. | varchar ( 8000 ) | |
jobname | Job name associated with the employee. | varchar ( 1020 ) | |
langcode | varchar ( 4096 ) | ||
langdispname | varchar ( 4096 ) | ||
lastdate | The date on which the corresponding employee stopped working for the organization. | timestamp without time zone | |
lastlogin | timestamp without time zone | ||
lastname | Last name of the employee/guest/therapist. | varchar ( 256 ) | |
mandatorybreaktimeperday | The mandatory break time (in mins) given to the employee every day. This field is populated only when the 'record name' is 'Break'. | integer | |
middlename | Middle name of the employee/guest/therapist. | varchar ( 256 ) | |
mobilecountrydname | varchar ( 4096 ) | ||
mobilecountrysname | varchar ( 4096 ) | ||
mobilephone | Mobile number of the guest/ employee. | varchar ( 64 ) | |
nationalityfk | integer | ||
nosalecomments | The comments that the front desk staff enters when the sale of an intended service, membership, or package does not take place. | varchar ( 65535 ) | |
organizationid | varchar ( 36 ) | ||
otherpreferences | varchar ( 65535 ) | ||
passwordupdatedon | timestamp without time zone | ||
phonecode | Phone country code of the guest. This is a mandatory value and it cannot be blank. | integer | |
podname | varchar ( 20 ) | ||
preferedcenerid | varchar ( 36 ) | ||
preferredroom | varchar ( 36 ) | ||
preferredtherapist | varchar ( 36 ) | ||
receivemarketingemail | A flag that indicates whether the guest opted for marketing emails. - True: Opted. - False: Not opted. | boolean | |
receivemarketingsms | A flag that indicates whether the guest opted for marketing SMSs. - True: Opted. - False: Not opted. | boolean | |
receivetransactionalemail | A flag that indicates whether the guest opted for transactional emails. - True: Opted. - False: Not opted. | boolean | |
receivetransactionalsms | A flag that indicates whether the guest opted for transactional SMSs. - True: Opted. - False: Not opted. | boolean | |
referralsourceid | varchar ( 36 ) | ||
referredby | The user id of the person who referred the guest. | varchar ( 36 ) | |
registrationsource | integer | ||
relationshipmanager | varchar ( 36 ) | ||
roomno | varchar ( 80 ) | ||
startdate | The date on which the corresponding employee started working for the organization. | timestamp without time zone | |
statecode | varchar ( 40 ) | ||
statedispname | The state to which the guest belongs. This is a non-mandatory value and it can be blank. | varchar ( 4096 ) | |
stateother | varchar ( 128 ) | ||
stateshortname | varchar ( 4096 ) | ||
unsubscribetomarketingemail | boolean | ||
unsubscribetotransactionalemail | boolean | ||
usercode | A unique identifier for the guest/ employee. This is a non-mandatory value and it can be blank. This maps to the guest code in a guest's profile in Zenoti. Even when an employee's profile is created, Zenoti automatically creates his/ her guest profile. | varchar ( 128 ) | |
userid | A unique identifier for the guest. This is a non-blank value that is generated in the core system for every guest. | varchar ( 36 ) | |
username | varchar ( 512 ) | ||
userpk | numeric | ||
usertags | The tags associated with the guest. | varchar ( 65535 ) | |
usertypeid | varchar ( 36 ) | ||
usertypename | An indicator of whether the guest is indeed a guest or an employee. | varchar ( 128 ) | |
userwid | bigint | ||
void | A flag indicating if the guest/ employee is inactive. A guest/ employee is considered inactive if his/her profile has been removed from the system. - True indicates that the guest/ employee is inactive. - False indicates that the guest/ employee is active. | boolean | |
workcountrydname | varchar ( 4096 ) | ||
workcountrysname | varchar ( 4096 ) | ||
workphone | varchar ( 64 ) | ||
zipcode | The zipcode of the guest. This is a non-mandatory value and it can be blank. | varchar ( 128 ) | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |
TenureStartDate | TIMESTAMP | Indicates actual tenure start date of employee after probation | |
nationality | Indicates the nationality of the user | VARCHAR(4096) |