ZenotiHelp

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.