RETURN TO BANNER EDW META DATA REPORTS LIST
Analyze Fundraising Star  Matching Claim Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_MATCHING_CLAIM_DETAIL

Description Matching claim detail dimension table provides attribute information about matching claims such as gift number and gift sequence.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
GIFT_NUMBER Gift transaction receipt number for this matching claim. VARCHAR2(63)

EXPRESSION

GIFT_NUMBER_EXPRESSION

NO

NO ANALYZE FUNDRAISING, MATCHING CLAIM
GIFT_SEQUENCE System generated one-up number uniquely identifying the gift record to be matched. This number must match the sequence number in the gift table for this receipt number and donor ID combination. NUMBER

CONSTANT

0

NO

NO ANALYZE FUNDRAISING, MATCHING CLAIM
MATCHING_CLAIM_DETAIL_KEY System generated, unique, internal primary key for a matching claim detail. NUMBER       NO
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

SYSTEM_LOAD_PROCESS

'MATCHING_CLAIM__DETAIL_D1B'

NO

NO ANALYZE FUNDRAISING, MATCHING CLAIM
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO


Ver: 9.0