Donations dimension table
Table Name | Column Name | Column Type | Primary Key |
|---|---|---|---|
bi_dimdonations_s3 | donationid | VARCHAR(36) | PK |
bi_dimdonations_s3 | name | NVARCHAR(256) | |
bi_dimdonations_s3 | code | NVARCHAR(256) | |
bi_dimdonations_s3 | description | NVARCHAR(2000) | |
bi_dimdonations_s3 | startdate | DATE | |
bi_dimdonations_s3 | enddate | DATE | |
bi_dimdonations_s3 | isdefault | BOOLEAN | |
bi_dimdonations_s3 | suggesteddonation1 | DECIMAL(19,4) | |
bi_dimdonations_s3 | suggesteddonation2 | DECIMAL(19,4) | |
bi_dimdonations_s3 | suggesteddonation3 | DECIMAL(19,4) | |
bi_dimdonations_s3 | subscriberlevel | INT | |
bi_dimdonations_s3 | subscriberid | VARCHAR(36) | |
bi_dimdonations_s3 | void | SMALLINT | |
bi_dimdonations_s3 | createdby | VARCHAR(36) | |
bi_dimdonations_s3 | createdon | TIMESTAMP | |
bi_dimdonations_s3 | etllastupdatedby | VARCHAR(50) | |
bi_dimdonations_s3 | etllastupdatedon | TIMESTAMP | |
bi_dimdonations_s3 | podname | VARCHAR(20) | |
bi_dimdonations_s3 | organizationid | VARCHAR(36) | |
bi_dimdonations_s3 | groupid | BIGINT |