ZenotiHelp

Status Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing status code definitions used across various entities in the system. Each record represents a unique status value within a status type, providing human-readable display values for coded status fields. Populated from the status/lookup master data.

Columns

Column Name Data Type Nullable Description
dimstatuswid BIGINT IDENTITY No Surrogate warehouse key for the status dimension, auto-generated
dimstatusid INTEGER Yes Source system identifier for the status record
statustypecode VARCHAR(100) Yes Code identifying the type/category of status (e.g., AppointmentStatus, InvoiceStatus)
statusdisplayvalue VARCHAR(100) Yes Human-readable display value for the status
statuscode VARCHAR(100) Yes Machine-readable code for the status
statusvalue INTEGER Yes Numeric value of the status within its type
void BOOLEAN Yes Soft-delete flag; TRUE indicates the record is voided/inactive

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

dimstatuswid

Foreign Keys

Column References
organizationid Bi_DimCenter

Enumerator Values

Column Values
statustypecode MembershipType
GuestStatus
MembershipStatus
AppointmentStatus
InvoiceStatus
PaymentType
AmountType
AccountingType
PaymentStatus
ClassStatus
RegistrationStatus
TimePeriod
RecurringCollectionsStatus
TherapistRequestType
VisitType
InvoiceLineType
statusvalue Integer code within a StatusTypeCode category; join to StatusDisplayValue for labels. See Bi_DimStatus for full mappings.
Was this article helpful?
Your feedback helps us improve our documentation.