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.