Reporting View Target: EM

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	(Banner EDW Source Report)
	Banner Relationship Management Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: EM_INTERACTION

Description Source composite view contains information for all interactions for a person including the type, category, source and date.
Key & Frequency One row per person for each communication recorded for a person.
Recommended Search Columns PERSON_INTERACTION_KEY,INTERACTION_SOURCE,��INTERACTION_CATEGORY,��INTERACTION_TYPE,��PERSON_UID,PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(63)
NA

NA

AUTHORATATIVE_SOURCE_KEY System generated, unique, internal primary key to content this interaction row to the authoratative source database table. NUMBER
REL_INTERACTIONLOG

AUTH_SOURCE_REFKEY

AUTHORATATIVE_SOURCE_TYPE Source type identified through the system entry for this interaction. VARCHAR2(255)
REL_INTERACTIONLOG

AUTH_SOURCE_TYPE

CREATOR_FIRST_NAME First name of the person who recorded the interaction. VARCHAR2(255)
REL_USER

FIRSTNAME

CREATOR_KEY Unique identifier for the user who created the interaction. NUMBER
REL_USER

PRIMARY_KEY

CREATOR_LAST_NAME Last name of the person who recorded the interaction. VARCHAR2(255)
REL_USER

LASTNAME

CREATOR_MIDDLE_NAME Middle name of the person who recorded the interaction. VARCHAR2(255)
REL_USER

MIDDLENAME

EM_ORGANIZATION Enrollment Management Organization descriptive name for the organization associated with the interaction. Manual interactions and communications may be associated with an organization at a level lower than the root organization. VARCHAR2(63)
REL_ORGANIZATION

DESCRIPTION

FIRST_INTERACTION_KEY Indicates this is the first interaction in this interaction for the person. NUMBER
REL_INTERACTIONLOG

PRIMARY_KEY

INTERACTION_CATEGORY Identifies the category associated with the interaction. VARCHAR2(63)
REL_INTERACTIONLOG

CATEGORY_KEY

INTERACTION_CATEGORY_LD Long description for the category of the interaction. VARCHAR2(255)
REL_INTERACTIONCATEGORY

NAME

INTERACTION_CATEGORY_SD Short description for the category of the interaction. VARCHAR2(255)
REL_INTERACTIONCATEGORY

NVL(INTERNAL_CODE,NAME)

INTERACTION_DATE Date the interaction was recorded. DATE
REL_INTERACTIONLOG

INTERACTION_TIME

INTERACTION_SOURCE Identifies the source of the interaction. VARCHAR2(63)
REL_INTERACTIONLOG

AUTH_SOURCE_REFKEY

INTERACTION_SOURCE_LD Long description for the source of the interaction. VARCHAR2(255)
REL_INTERACTIONLOG

AUTH_SOURCE_TYPE

INTERACTION_SOURCE_SD Short description for the source of the interaction. VARCHAR2(255)
REL_INTERACTIONLOG

SOURCE

INTERACTION_TIME Time stamp specifying when the interaction was recorded. DATE
REL_INTERACTIONLOG

INTERACTION_TIME

INTERACTION_TYPE Identifies the type of interaction. VARCHAR2(63)
REL_INTERACTIONLOG

TYPE_KEY

INTERACTION_TYPE_LD Long description for the type of the interaction. VARCHAR2(255)
REL_INTERACTIONTYPE

NAME

INTERACTION_TYPE_SD Short description for the type of the interaction. VARCHAR2(255)
REL_INTERACTIONTYPE

NVL(INTERNAL_CODE,NAME)

LAST_CATEGORY_INT_KEY Indicates this is the latest interaction in this interaction category for the person. NUMBER
REL_INTERACTIONLOG

PRIMARY_KEY

LAST_CATEGORY_TYPE_INT_KEY Indicates this is the latest interaction for the person of this interaction type and interaction category. NUMBER
REL_INTERACTIONLOG

PRIMARY_KEY

LAST_INTERACTION_KEY Indicates this is the latest interaction for the person. NUMBER
REL_INTERACTIONLOG

PRIMARY_KEY

LAST_ORGANIZATION_INT_KEY Indicates this is the latest interaction for the person associated with this organization. NUMBER
REL_INTERACTIONLOG

PRIMARY_KEY

LAST_ORG_CATEGORY_INT_KEY Indicates this is the latest interaction for the person with this organization and interaction category. NUMBER
REL_INTERACTIONLOG

PRIMARY_KEY

LAST_ORG_CATEGORY_TYPE_INT_KEY Indicates this is the latest interaction for the person with this organization, interaction category and interaction type. NUMBER
REL_INTERACTIONLOG

PRIMARY_KEY

MANUAL_INTERACTION_CONTENT Text or comment recorded for the person with this manual interaction. CLOB
FUNCTION

NA

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

PERSON_INTERACTION_KEY System generated, unique, internal primary key for the person interaction combination. NUMBER
REL_INTERACTIONLOG

PRIMARY_KEY

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER
REL_INTERACTIONLOG

PRIMARY_KEY

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(63)
NA

NA

SUBJECT_LINE Text line recorded by the system for system maintained for communication, campaign and PSP creation but entered by the user for the manual interaction. VARCHAR2(150)
REL_INTERACTIONLOG

SUBJECT_LINE

Ver: 8.4.1

Description	Source composite view contains information for all interactions for a person including the type, category, source and date.
Key & Frequency	One row per person for each communication recorded for a person.
Recommended Search Columns	PERSON_INTERACTION_KEY,INTERACTION_SOURCE,��INTERACTION_CATEGORY,��INTERACTION_TYPE,��PERSON_UID,PERSON_UID

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(63)	NA	NA
AUTHORATATIVE_SOURCE_KEY	System generated, unique, internal primary key to content this interaction row to the authoratative source database table.	NUMBER	REL_INTERACTIONLOG	AUTH_SOURCE_REFKEY
AUTHORATATIVE_SOURCE_TYPE	Source type identified through the system entry for this interaction.	VARCHAR2(255)	REL_INTERACTIONLOG	AUTH_SOURCE_TYPE
CREATOR_FIRST_NAME	First name of the person who recorded the interaction.	VARCHAR2(255)	REL_USER	FIRSTNAME
CREATOR_KEY	Unique identifier for the user who created the interaction.	NUMBER	REL_USER	PRIMARY_KEY
CREATOR_LAST_NAME	Last name of the person who recorded the interaction.	VARCHAR2(255)	REL_USER	LASTNAME
CREATOR_MIDDLE_NAME	Middle name of the person who recorded the interaction.	VARCHAR2(255)	REL_USER	MIDDLENAME
EM_ORGANIZATION	Enrollment Management Organization descriptive name for the organization associated with the interaction. Manual interactions and communications may be associated with an organization at a level lower than the root organization.	VARCHAR2(63)	REL_ORGANIZATION	DESCRIPTION
FIRST_INTERACTION_KEY	Indicates this is the first interaction in this interaction for the person.	NUMBER	REL_INTERACTIONLOG	PRIMARY_KEY
INTERACTION_CATEGORY	Identifies the category associated with the interaction.	VARCHAR2(63)	REL_INTERACTIONLOG	CATEGORY_KEY
INTERACTION_CATEGORY_LD	Long description for the category of the interaction.	VARCHAR2(255)	REL_INTERACTIONCATEGORY	NAME
INTERACTION_CATEGORY_SD	Short description for the category of the interaction.	VARCHAR2(255)	REL_INTERACTIONCATEGORY	NVL(INTERNAL_CODE,NAME)
INTERACTION_DATE	Date the interaction was recorded.	DATE	REL_INTERACTIONLOG	INTERACTION_TIME
INTERACTION_SOURCE	Identifies the source of the interaction.	VARCHAR2(63)	REL_INTERACTIONLOG	AUTH_SOURCE_REFKEY
INTERACTION_SOURCE_LD	Long description for the source of the interaction.	VARCHAR2(255)	REL_INTERACTIONLOG	AUTH_SOURCE_TYPE
INTERACTION_SOURCE_SD	Short description for the source of the interaction.	VARCHAR2(255)	REL_INTERACTIONLOG	SOURCE
INTERACTION_TIME	Time stamp specifying when the interaction was recorded.	DATE	REL_INTERACTIONLOG	INTERACTION_TIME
INTERACTION_TYPE	Identifies the type of interaction.	VARCHAR2(63)	REL_INTERACTIONLOG	TYPE_KEY
INTERACTION_TYPE_LD	Long description for the type of the interaction.	VARCHAR2(255)	REL_INTERACTIONTYPE	NAME
INTERACTION_TYPE_SD	Short description for the type of the interaction.	VARCHAR2(255)	REL_INTERACTIONTYPE	NVL(INTERNAL_CODE,NAME)
LAST_CATEGORY_INT_KEY	Indicates this is the latest interaction in this interaction category for the person.	NUMBER	REL_INTERACTIONLOG	PRIMARY_KEY
LAST_CATEGORY_TYPE_INT_KEY	Indicates this is the latest interaction for the person of this interaction type and interaction category.	NUMBER	REL_INTERACTIONLOG	PRIMARY_KEY
LAST_INTERACTION_KEY	Indicates this is the latest interaction for the person.	NUMBER	REL_INTERACTIONLOG	PRIMARY_KEY
LAST_ORGANIZATION_INT_KEY	Indicates this is the latest interaction for the person associated with this organization.	NUMBER	REL_INTERACTIONLOG	PRIMARY_KEY
LAST_ORG_CATEGORY_INT_KEY	Indicates this is the latest interaction for the person with this organization and interaction category.	NUMBER	REL_INTERACTIONLOG	PRIMARY_KEY
LAST_ORG_CATEGORY_TYPE_INT_KEY	Indicates this is the latest interaction for the person with this organization, interaction category and interaction type.	NUMBER	REL_INTERACTIONLOG	PRIMARY_KEY
MANUAL_INTERACTION_CONTENT	Text or comment recorded for the person with this manual interaction.	CLOB	FUNCTION	NA
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PERSON_INTERACTION_KEY	System generated, unique, internal primary key for the person interaction combination.	NUMBER	REL_INTERACTIONLOG	PRIMARY_KEY
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	REL_INTERACTIONLOG	PRIMARY_KEY
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(63)	NA	NA
SUBJECT_LINE	Text line recorded by the system for system maintained for communication, campaign and PSP creation but entered by the user for the manual interaction.	VARCHAR2(150)	REL_INTERACTIONLOG	SUBJECT_LINE