Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
MATCHING_CLAIM_ACTIVE_IND	Determines whether the matching claim is active.	NUMBER	MATCHING_CLAIM_EXPRESSIONS	MATCHING_CLAIM_ACTIVE_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MATCHING CLAIM
MATCHING_CLAIM_ACTIVE_IND_LD	Matching claim active indicator long description.	VARCHAR2(255)	MATCHING_CLAIM_EXPRESSIONS	MATCHING_CLAIM_ACTIVE_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MATCHING CLAIM
MATCHING_CLAIM_ACTIVE_IND_SD	Matching claim active indicator short description.	VARCHAR2(255)	MATCHING_CLAIM_EXPRESSIONS	MATCHING_CLAIM_ACTIVE_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MATCHING CLAIM
MATCHING_CLAIM_KEY		NUMBER				NO
MATCHING_CLAIM_PAID_STATUS	Banner values for matching claim paid status are (MP) - match partially paid, (MF) match fully paid, (MN) match not paid. Advance defaults (MN) as the paid status.	VARCHAR2(63)	MATCHING_CLAIM_EXPRESSIONS	MATCHING_CLAIM_PAID_STATUS_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MATCHING CLAIM
MATCHING_CLAIM_PAID_STATUS_LD	Matching claim paid status long description.	VARCHAR2(255)	MATCHING_CLAIM_EXPRESSIONS	MATCHING_CLAIM_PAID_STATUS_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MATCHING CLAIM
MATCHING_CLAIM_PAID_STATUS_SD	Matching claim paid status short description.	VARCHAR2(255)	MATCHING_CLAIM_EXPRESSIONS	MATCHING_CLAIM_PAID_STATUS_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MATCHING CLAIM
MATCHING_CLAIM_STATUS	Banner matching claim statuses are (W)aiting, no payment, (P)aid in full, wa(I)ting, partial payment, (N)o payment expected. Advance can have any value in here such as check received, request denied, electronic claim submitted, form submitted, and qualifies/no form.	VARCHAR2(63)	MATCHING_CLAIM_EXPRESSIONS	MATCHING_CLAIM_STATUS_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MATCHING CLAIM
MATCHING_CLAIM_STATUS_LD	Matching claim status long description.	VARCHAR2(255)	MATCHING_CLAIM_EXPRESSIONS	MATCHING_CLAIM_STATUS_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MATCHING CLAIM
MATCHING_CLAIM_STATUS_SD	Matching claim status short description.	VARCHAR2(255)	MATCHING_CLAIM_EXPRESSIONS	MATCHING_CLAIM_STATUS_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MATCHING CLAIM
MATCH_CLAIM_FORM_RCVD_IND	Determines whether a matching gift form has been received for this anticipated matching gift.	NUMBER	MATCHING_CLAIM_EXPRESSIONS	MATCH_CLAIM_FORM_RCVD_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MATCHING CLAIM
MATCH_CLAIM_FORM_RCVD_IND_LD	Matching claim form received indicator long description.	VARCHAR2(255)	MATCHING_CLAIM_EXPRESSIONS	MATCH_CLAIM_FORM_RCVD_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MATCHING CLAIM
MATCH_CLAIM_FORM_RCVD_IND_SD	Matching claim form received indicator short description.	VARCHAR2(255)	MATCHING_CLAIM_EXPRESSIONS	MATCH_CLAIM_FORM_RCVD_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MATCHING CLAIM
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'MATCHING_CLAIM_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