Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: REL_INTERACTIONLOG Banner Relationship Management Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: REL_INTERACTIONLOG - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
AUTH_SOURCE_REFKEY NA

REPORTING VIEW

EM_INTERACTION

EM_INTERACTION

INTERACTION_SOURCE

AUTHORATATIVE_SOURCE_KEY

 
AUTH_SOURCE_TYPE NA

REPORTING VIEW

EM_INTERACTION

EM_INTERACTION

INTERACTION_SOURCE_LD

AUTHORATATIVE_SOURCE_TYPE

 
CATEGORY_KEY NA

REPORTING VIEW

EM_INTERACTION

INTERACTION_CATEGORY

 
INTERACTION_TIME NA

REPORTING VIEW

EM_INTERACTION

EM_INTERACTION

INTERACTION_DATE

INTERACTION_TIME

 
NAME TBD        
PARTY_KEY NA        
PRIMARY_KEY NA

REPORTING VIEW

EM_INTERACTION

EM_INTERACTION

EM_INTERACTION

EM_INTERACTION

EM_INTERACTION

EM_INTERACTION

EM_INTERACTION

EM_INTERACTION

EM_INTERACTION

LAST_ORGANIZATION_INT_KEY

FIRST_INTERACTION_KEY

LAST_ORG_CATEGORY_TYPE_INT_KEY

PERSON_INTERACTION_KEY

LAST_CATEGORY_TYPE_INT_KEY

PERSON_UID

LAST_INTERACTION_KEY

LAST_CATEGORY_INT_KEY

LAST_ORG_CATEGORY_INT_KEY

 
SOURCE NA

REPORTING VIEW

EM_INTERACTION

INTERACTION_SOURCE_SD

 
SUBJECT_LINE NA

REPORTING VIEW

EM_INTERACTION

SUBJECT_LINE

 
TYPE_KEY NA

REPORTING VIEW

EM_INTERACTION

INTERACTION_TYPE

 


Ver: 8.4.1