Skip to main content

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