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

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_CONTACT_REPORT_CREDIT

Description Contact report credit fact table provides measures for all contacts made with a constituent or prospect for which a fundraiser will receive credit. How many overall contact credits, how many visit contact credits, which credit recipient is the contact author, contact date and credit recipient ID.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
CONTACT_AUTHOR_IND Primary author or originator of the contact. NUMBER

CONSTANT

1

NO

NO CONTACT REPORT CREDIT
CONTACT_CREDIT_COUNT Contact credit count. NUMBER

EXPRESSION_0

CONTACT_CREDIT_COUNT_EXPRESSION

NO

NO CONTACT REPORT CREDIT
CONTACT_DATE Number of prospects contacted by the contact author. DATE

AMRCONT

AMRCONT_CONTACT_DATE

NO

NO CONTACT REPORT CREDIT
CONTACT_REPORT_CREDIT_KEY   NUMBER

CLN_CONTACT_REPORT_CREDIT

CONTACT_REPORT_CREDIT_KEY

NO

NO CONTACT REPORT CREDIT
CONTACT_REPORT_KEY   NUMBER

CLN_CONTACT_REPORT

CONTACT_REPORT_KEY

NO

NO CONTACT REPORT CREDIT
CONT_REP_CREDIT_GROUP_KEY   NUMBER

EXPRESSION_0

CONT_REP_CREDIT_GROUP_KEY_EXPRESSION

NO

NO CONTACT REPORT CREDIT
CREDIT_RECIPIENT_ID ID or Iden code for staff person receiving credit for this contact. VARCHAR2(255)

AMRCONT

AMRCONT_IDEN_CODE

NO

NO CONTACT REPORT CREDIT
CREDIT_RECIPIENT_STAFF_KEY   NUMBER

CLN_STAFF

STAFF_KEY

NO

NO CONTACT REPORT CREDIT
MULTI_SOURCE_KEY   NUMBER

CLN_MULTI_SOURCE

MULTI_SOURCE_KEY

NO

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

CONSTANT

'CONTACT_REPORT_CREDIT_F1B'

NO

NO CONTACT REPORT CREDIT
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

NO SOURCE

NO SOURCE

NO

NO
UNIT_KEY   NUMBER

CONSTANT

0

NO

NO CONTACT REPORT CREDIT
USER_MEASURE_01   NUMBER

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_02   NUMBER

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_03   NUMBER

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_04   NUMBER

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_05   NUMBER

NO SOURCE

NO SOURCE

NO

NO
VISIT_CREDIT_COUNT Visit credit count. For Advance: a visit is classified by the contact credit type-report activity type. For Banner: a visit is classified by the Contact Activity Type extract parameter. NUMBER

EXPRESSION_0

VISIT_CREDIT_COUNT_EXPRESSION

NO

NO CONTACT REPORT CREDIT


Ver: 9.0