Donations dimension table
bi_dimdonations
Field | Description | Field Type | Primary Key |
---|---|---|---|
code | varchar ( 256 ) | ||
createdby | varchar ( 36 ) | ||
createdon | timestamp without time zone | ||
description | varchar ( 2000 ) | ||
donationid | varchar ( 36 ) | PK | |
donationwid | bigint | ||
enddate | date | ||
etllastupdatedby | varchar ( 50 ) | ||
etllastupdatedon | timestamp without time zone | ||
isdefault | boolean | ||
name | varchar ( 256 ) | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
startdate | date | ||
subscriberid | varchar ( 36 ) | ||
subscriberlevel | integer | ||
suggesteddonation1 | numeric | ||
suggesteddonation2 | numeric | ||
suggesteddonation3 | numeric | ||
void | smallint | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |