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 idreferences 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.