RETURN TO BANNER EDW META DATA REPORTS LIST
Contact Report Credit Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_CONTACT_REPORT_CREDIT

Description Contact report credit dimension table provides attributes associated with all contacts made with a constituent or prospect for which a fundraiser will receive credit. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
CONTACT_CREDIT_ACTIVITY Type of activity associated with contact credit, values are 1 (Written), 2 (Phone), 3 (Visit), null (No Credit). This activity corresponds to the contact report type for the primary author/originator. VARCHAR2(63)

EXPRESSION

CONTACT_CREDIT_ACTIVITY_EXPRESSION

NO

NO CONTACT REPORT CREDIT
CONTACT_CREDIT_ACTIVITY_LD Credit Activity long description. VARCHAR2(255)

EXPRESSION

CONTACT_CREDIT_ACTIVITY_LD_EXPRESSION

NO

NO CONTACT REPORT CREDIT
CONTACT_CREDIT_ACTIVITY_SD Credit Activity short description. VARCHAR2(255)

EXPRESSION

CONTACT_CREDIT_ACTIVITY_SD_EXPRESSION

NO

NO CONTACT REPORT CREDIT
CONTACT_CREDIT_TYPE Contact credit type associated with this contact credit. VARCHAR2(63)

AMRCONT

AMRCONT_SCNT_CODE

NO

NO CONTACT REPORT CREDIT
CONTACT_CREDIT_TYPE_LD Contact Credit Type long description. VARCHAR2(255)

ATVSCNT

ATVSCNT_DESC

NO

NO CONTACT REPORT CREDIT
CONTACT_CREDIT_TYPE_SD Contact Credit Type short description. VARCHAR2(255)

ATVSCNT

ATVSCNT_DESC

NO

NO CONTACT REPORT CREDIT
CONTACT_REPORT_CREDIT_KEY   NUMBER       NO
CREDIT_PARTICIPATION Role the credit recipient played during the contact. i.e., attended, provided introduction, planned giving assist, etc. VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
CREDIT_PARTICIPATION_LD Credit Participation long description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
CREDIT_PARTICIPATION_SD Credit Participation short description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

SYSTEM_LOAD_PROCESS

'CONTACT_REPORT_CREDIT_D1B'

NO

NO CONTACT REPORT CREDIT
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