ZenotiHelp

User Notes Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing notes associated with users/guests, including privacy settings, alert flags, and audit information.

Columns

Column Name Data Type Nullable Description
usernoteswid BIGINT IDENTITY No Surrogate warehouse key for the user note record
NoteId VARCHAR(36) Yes Unique identifier (GUID) for the note
UserId VARCHAR(36) Yes Unique identifier (GUID) of the user the note belongs to
CenterId VARCHAR(36) Yes Unique identifier (GUID) of the center associated with the note
ObjectId VARCHAR(36) Yes Unique identifier (GUID) of the related object (e.g., appointment, invoice)
NoteType VARCHAR(2048) Yes Type/category of the note
Privacytype VARCHAR(2048) Yes Privacy classification of the note
IsPrivate BOOLEAN Yes Indicates whether the note is marked as private
Note VARCHAR(MAX) Yes Full text content of the note
Alert BOOLEAN Yes Indicates whether the note triggers an alert
CreatedBy VARCHAR(512) Yes Name or identifier of the user who created the note
CreateDate TIMESTAMP Yes Timestamp when the note was created
UpdatedBy VARCHAR(512) Yes Name or identifier of the user who last updated the note
UpdatedOn TIMESTAMP Yes Timestamp when the note was last updated
Source VARCHAR(128) Yes Source system or module that created the note
Entity BIGINT Yes Entity type identifier associated with the note
Void BOOLEAN Yes Indicates whether the record has been voided/soft-deleted

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

usernoteswid

Foreign Keys

Column References
UserId a user/guest entity in the source system
CenterId a center entity in the source system
ObjectId a related business object in the source system
OrganizationId an organization entity in the source system

Enumerator Values

Column Values
Void FALSE = Active, TRUE = Voided
IsPrivate FALSE = Non-private, TRUE = Private Note
Alert FALSE = No Alert, TRUE = Alert Enabled
Entity 0 = Guest
1 = Employee
2 = Appointment
3 = Invoice
Was this article helpful?
Your feedback helps us improve our documentation.