Donations Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing donation program definitions including suggested donation amounts, effective date ranges, and subscriber-level configurations.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| donationwid | BIGINT IDENTITY | No | Surrogate warehouse key for the donation record |
| donationid | VARCHAR(36) | Yes | Unique identifier (GUID) for the donation program |
| name | NVARCHAR(256) | Yes | Display name of the donation program |
| code | NVARCHAR(256) | Yes | Code assigned to the donation program |
| description | NVARCHAR(2000) | Yes | Detailed description of the donation program |
| startdate | DATE | Yes | Start date when the donation program becomes active |
| enddate | DATE | Yes | End date when the donation program expires |
| isdefault | BOOLEAN | Yes | Indicates whether this is the default donation program |
| suggesteddonation1 | DECIMAL(19,4) | Yes | First suggested donation amount |
| suggesteddonation2 | DECIMAL(19,4) | Yes | Second suggested donation amount |
| suggesteddonation3 | DECIMAL(19,4) | Yes | Third suggested donation amount |
| subscriberlevel | INT | Yes | Level of the subscriber (e.g., organization or center level) for which this donation is configured |
| subscriberid | VARCHAR(36) | Yes | Unique identifier (GUID) of the subscriber (organization or center) |
| void | SMALLINT | Yes | Indicates whether the record has been voided/soft-deleted |
| createdby | VARCHAR(36) | Yes | Unique identifier (GUID) of the user who created the donation program |
| createdon | TIMESTAMP | Yes | Timestamp when the donation program was created |
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
donationwid
Foreign Keys
| Column | References |
|---|---|
| subscriberid | a subscriber entity (organization or center) in the source system |
| createdby | a user entity in the source system |
| OrganizationId | an organization entity in the source system |
Enumerator Values
| Column | Values |
|---|---|
| void | 0 = Active, 1 = Voided |
| isdefault | FALSE = Not Default, TRUE = Default |
| subscriberlevel | 1 = Organization 2 = Center |
Was this article helpful?
Your feedback helps us improve our documentation.