ZenotiHelp

Donations Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide

Consolidated fact table storing donation transactions including donation amounts, payment details, guest information, and center attributes.

Columns

Column Name Data Type Nullable Description
organization name VARCHAR(512) YES Name of the organization. Sourced from DimOrganization.organization_name.
organization account name VARCHAR(256) YES Account name of the organization. Sourced from DimOrganization.organization_account_name.
zone name VARCHAR(800) YES Name of the zone. Sourced from DimZone.zone_name.
center name VARCHAR(128) YES Name of the center. Sourced from DimCenter.center_name.
center city VARCHAR(128) YES City where the center is located. Sourced from DimCenter.center_city.
center state name VARCHAR(4096) YES State where the center is located. Sourced from DimCenter.center_state_name.
center zip VARCHAR(32) YES ZIP/postal code of the center. Sourced from DimCenter.center_zip.
country name VARCHAR(4096) YES Country where the center is located. Sourced from DimCenter.country_name.
center time zone VARCHAR(128) YES Time zone of the center. Sourced from DimCenter.center_time_zone.
center company name VARCHAR(200) YES Company name associated with the center. Sourced from DimCenter.center_company_name.
center code VARCHAR(40) YES Code assigned to the center. Sourced from DimCenter.center_code.
guest first name VARCHAR(160) YES First name of the guest. Sourced from DimUser.firstname.
guest middle name VARCHAR(128) YES Middle name of the guest. Sourced from DimUser.middlename.
guest last name VARCHAR(256) YES Last name of the guest. Sourced from DimUser.lastname.
guest anniversary date TIMESTAMP YES Anniversary date of the guest. Sourced from DimUser.anniversarydate.
guest dob TIMESTAMP YES Date of birth of the guest. Sourced from DimUser.dob.
guest base center VARCHAR(256) YES Base center assigned to the guest. Sourced from DimUser.guest_base_center.
guest city VARCHAR(128) YES City of the guest. Sourced from DimUser.city.
guest state VARCHAR(4096) YES State of the guest. Sourced from DimUser.statedispname.
guest country name VARCHAR(4096) YES Country of the guest. Sourced from DimUser.countrydname.
guest zipcode VARCHAR(128) YES ZIP/postal code of the guest. Sourced from DimUser.zipcode.
guest code VARCHAR(128) YES Code assigned to the guest. Sourced from DimUser.usercode.
guest gender VARCHAR(14) YES Gender of the guest. Sourced from DimUser.gender.
guest phone code INTEGER YES Phone country code of the guest. Sourced from DimUser.phonecode.
guest mobile phone VARCHAR(64) YES Mobile phone number of the guest. Sourced from DimUser.mobilephone.
guest home phone VARCHAR(64) YES Home phone number of the guest. Sourced from DimUser.homephone.
guest email VARCHAR(256) YES Email address of the guest. Sourced from DimUser.email.
guest referral source VARCHAR(1600) YES Referral source of the guest. Sourced from DimUser.guestreferralsource.
guest tags VARCHAR(65535) YES Tags associated with the guest. Sourced from DimUser.usertags.
guest type name VARCHAR(128) YES Type classification of the guest. Sourced from DimUser.usertypename.
is guest inactive BOOLEAN YES Indicates whether the guest is inactive. Sourced from DimUser.void.
invoice id VARCHAR(36) YES Unique identifier of the associated invoice.
donation name VARCHAR(256) YES Name of the donation.
donation amount DECIMAL(19,4) YES Amount of the donation.
donation description VARCHAR(4096) YES Description of the donation.
payment type VARCHAR(100) YES Type of payment used for the donation.
payment option type VARCHAR(40) YES Payment option used for the donation.
transaction id VARCHAR(36) YES Unique identifier of the payment transaction.
donation collected date and time TIMESTAMP YES Date and time when the donation was collected.
donation collected date DATE YES Date when the donation was collected.
Invoice No VARCHAR(160) YES Invoice number associated with the donation.

Primary Key

No explicit primary key defined. Combination of invoice id and transaction id uniquely identifies a record.

Foreign Keys

  • Guest columns reference DimUser
  • Center columns reference DimCenter
  • invoice id references FactInvoice

Enumerator Values

Column Name Known Values
guest gender Male, Female, Other
payment type Cash, Credit Card, Check, Custom
payment option type Payment option type values

Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.

Was this article helpful?
Your feedback helps us improve our documentation.