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_ORGANIZATION

Description Source composite view contains information for all em organization that may be attached to an interaction.
Key & Frequency One row per organization used with the associated hierarchy of levels defined for that organization.
Recommended Search Columns EM_ORGANIZATION

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

EM_ORGANIZATION EM Organization associated with the Interaction. VARCHAR2(63)
REL_ORGANIZATION

PRIMARY_KEY

EM_ORGANIZATION_LD Long description for the EM Organization. VARCHAR2(255)
REL_ORGANIZATION

DESCRIPTION

EM_ORGANIZATION_LEVEL_1 EM Organization Level 1 (Root Organization) associated with the Interaction. VARCHAR2(63)
REL_ORGANIZATION

PRIMARY_KEY

EM_ORGANIZATION_LEVEL_1_LD Long description for the EM Organization. VARCHAR2(255)
REL_ORGANIZATION

DESCRIPTION

EM_ORGANIZATION_LEVEL_1_SD Short description for the EM Organization. VARCHAR2(255)
REL_ORGANIZATION

NAME

EM_ORGANIZATION_LEVEL_2 EM Organization Level 2 (Level below the Root Organization) associated with the Interaction. VARCHAR2(63)
REL_ORGANIZATION

PRIMARY_KEY

EM_ORGANIZATION_LEVEL_2_LD Long description for the EM Organization. VARCHAR2(255)
REL_ORGANIZATION

DESCRIPTION

EM_ORGANIZATION_LEVEL_2_SD Short description for the EM Organization. VARCHAR2(255)
REL_ORGANIZATION

NAME

EM_ORGANIZATION_LEVEL_3 EM Organization Level 3 (two levels below the Root Organization) associated with the Interaction. VARCHAR2(63)
REL_ORGANIZATION

PRIMARY_KEY

EM_ORGANIZATION_LEVEL_3_LD Long description for the EM Organization. VARCHAR2(255)
REL_ORGANIZATION

DESCRIPTION

EM_ORGANIZATION_LEVEL_3_SD Short description for the EM Organization. VARCHAR2(255)
REL_ORGANIZATION

NAME

EM_ORGANIZATION_LEVEL_4 EM Organization Level 4 (three levels below the Root Organization) associated with the Interaction. VARCHAR2(63)
REL_ORGANIZATION

PRIMARY_KEY

EM_ORGANIZATION_LEVEL_4_LD Long description for the EM Organization. VARCHAR2(255)
REL_ORGANIZATION

DESCRIPTION

EM_ORGANIZATION_LEVEL_4_SD Short description for the EM Organization. VARCHAR2(255)
REL_ORGANIZATION

NAME

EM_ORGANIZATION_LEVEL_5 EM Organization Level 5 (four levels below the Root Organization) associated with the Interaction. VARCHAR2(63)
REL_ORGANIZATION

PRIMARY_KEY

EM_ORGANIZATION_LEVEL_5_LD Long description for the EM Organization. VARCHAR2(255)
REL_ORGANIZATION

DESCRIPTION

EM_ORGANIZATION_LEVEL_5_SD Short description for the EM Organization. VARCHAR2(255)
REL_ORGANIZATION

NAME

EM_ORGANIZATION_SD Short description for the EM Organization. VARCHAR2(255)
REL_ORGANIZATION

NAME

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

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

NA

Ver: 8.4.1

Description	Source composite view contains information for all em organization that may be attached to an interaction.
Key & Frequency	One row per organization used with the associated hierarchy of levels defined for that organization.
Recommended Search Columns	EM_ORGANIZATION

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
EM_ORGANIZATION	EM Organization associated with the Interaction.	VARCHAR2(63)	REL_ORGANIZATION	PRIMARY_KEY
EM_ORGANIZATION_LD	Long description for the EM Organization.	VARCHAR2(255)	REL_ORGANIZATION	DESCRIPTION
EM_ORGANIZATION_LEVEL_1	EM Organization Level 1 (Root Organization) associated with the Interaction.	VARCHAR2(63)	REL_ORGANIZATION	PRIMARY_KEY
EM_ORGANIZATION_LEVEL_1_LD	Long description for the EM Organization.	VARCHAR2(255)	REL_ORGANIZATION	DESCRIPTION
EM_ORGANIZATION_LEVEL_1_SD	Short description for the EM Organization.	VARCHAR2(255)	REL_ORGANIZATION	NAME
EM_ORGANIZATION_LEVEL_2	EM Organization Level 2 (Level below the Root Organization) associated with the Interaction.	VARCHAR2(63)	REL_ORGANIZATION	PRIMARY_KEY
EM_ORGANIZATION_LEVEL_2_LD	Long description for the EM Organization.	VARCHAR2(255)	REL_ORGANIZATION	DESCRIPTION
EM_ORGANIZATION_LEVEL_2_SD	Short description for the EM Organization.	VARCHAR2(255)	REL_ORGANIZATION	NAME
EM_ORGANIZATION_LEVEL_3	EM Organization Level 3 (two levels below the Root Organization) associated with the Interaction.	VARCHAR2(63)	REL_ORGANIZATION	PRIMARY_KEY
EM_ORGANIZATION_LEVEL_3_LD	Long description for the EM Organization.	VARCHAR2(255)	REL_ORGANIZATION	DESCRIPTION
EM_ORGANIZATION_LEVEL_3_SD	Short description for the EM Organization.	VARCHAR2(255)	REL_ORGANIZATION	NAME
EM_ORGANIZATION_LEVEL_4	EM Organization Level 4 (three levels below the Root Organization) associated with the Interaction.	VARCHAR2(63)	REL_ORGANIZATION	PRIMARY_KEY
EM_ORGANIZATION_LEVEL_4_LD	Long description for the EM Organization.	VARCHAR2(255)	REL_ORGANIZATION	DESCRIPTION
EM_ORGANIZATION_LEVEL_4_SD	Short description for the EM Organization.	VARCHAR2(255)	REL_ORGANIZATION	NAME
EM_ORGANIZATION_LEVEL_5	EM Organization Level 5 (four levels below the Root Organization) associated with the Interaction.	VARCHAR2(63)	REL_ORGANIZATION	PRIMARY_KEY
EM_ORGANIZATION_LEVEL_5_LD	Long description for the EM Organization.	VARCHAR2(255)	REL_ORGANIZATION	DESCRIPTION
EM_ORGANIZATION_LEVEL_5_SD	Short description for the EM Organization.	VARCHAR2(255)	REL_ORGANIZATION	NAME
EM_ORGANIZATION_SD	Short description for the EM Organization.	VARCHAR2(255)	REL_ORGANIZATION	NAME
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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(63)	NA	NA