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.