Reporting View Target: EM

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Banner Relationship Management Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: EM_VALIDATION

Description This view contains a number of the EM Relationship source systems' validation table records. This view was meant to be used with reporting tools to create list of values as well as for cleansing purposes in the Enterprise Data Warehouse.
Key & Frequency Multiple rows per table name, value, status, and valid from and to dates.
Recommended Search Columns TABLE_NAME

Target Column Business Definition Database Data Type Source Name Source Column

QUALIFIER This is the code associated with the value that helps make the record unique. VARCHAR2(100)
NA

NA

QUALIFIER_DESCRIPTION This is the description for the code associated with the value that helps make the record unique. VARCHAR2(2000)
NA

NA

Ver: 8.4.1

Description	This view contains a number of the EM Relationship source systems' validation table records. This view was meant to be used with reporting tools to create list of values as well as for cleansing purposes in the Enterprise Data Warehouse.
Key & Frequency	Multiple rows per table name, value, status, and valid from and to dates.
Recommended Search Columns	TABLE_NAME

Target Column	Business Definition	Database Data Type	Source Name	Source Column
QUALIFIER	This is the code associated with the value that helps make the record unique.	VARCHAR2(100)	NA	NA
QUALIFIER_DESCRIPTION	This is the description for the code associated with the value that helps make the record unique.	VARCHAR2(2000)	NA	NA