Reporting View Target: SUPPLEMENTAL_DATA

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Common Reporting View Reports

Banner Operational Data Store
Reporting View Target: SUPPLEMENTAL_DATA_SLOT

Description Uses data from the MGT_SDE_DATA composite table. Displays up to 10 supplemental values based on the defined display rule(s) with an internal group of SDE.
Key & Frequency Union of Discriminator and non discriminator attribute values.
Recommended Search Columns TABLE_NAME
PARENT_TABLE_PRIMARY_KEY
ATTRIBUTE_NAME

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target

ACTIVITY_DATE Date record was inserted or updated. DATE
NA

SYSDATE

NO
NO

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

NA

NO
NO

ATTRIBUTE1 Attribute Name: The name of the attribute. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_NAME

NO
NO

ATTRIBUTE10 Attribute Name: The name of the attribute. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_NAME

NO
NO

ATTRIBUTE2 Attribute Name: The name of the attribute. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_NAME

NO
NO

ATTRIBUTE3 Attribute Name: The name of the attribute. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_NAME

NO
NO

ATTRIBUTE4 Attribute Name: The name of the attribute. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_NAME

NO
NO

ATTRIBUTE5 Attribute Name: The name of the attribute. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_NAME

NO
NO

ATTRIBUTE6 Attribute Name: The name of the attribute. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_NAME

NO
NO

ATTRIBUTE7 Attribute Name: The name of the attribute. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_NAME

NO
NO

ATTRIBUTE8 Attribute Name: The name of the attribute. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_NAME

NO
NO

ATTRIBUTE9 Attribute Name: The name of the attribute. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_NAME

NO
NO

DISCRIMINATED_ATTRIBUTE Discriminated attribute name. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_NAME

NO
NO

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

NA

NO
NO

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

NA

NO
NO

PARENT_TABLE_PK_COL1 Primary Key Parent Table: First column of the composite Primary key of of the record in the Parent table. VARCHAR2(512)
CALCULATION

SUBSTR(GORSDAV_PK_PARENTTAB,)

NO
NO

PARENT_TABLE_PK_COL2 Primary Key Parent Table: Second column of the composite Primary key of of the record in the Parent table. VARCHAR2(512)
CALCULATION

SUBSTR(GORSDAV_PK_PARENTTAB,)

NO
NO

PARENT_TABLE_PK_COL3 Primary Key Parent Table: Third column of the composite Primary key of of the record in the Parent table. VARCHAR2(512)
CALCULATION

SUBSTR(GORSDAV_PK_PARENTTAB,)

NO
NO

PARENT_TABLE_PK_COL4 Primary Key Parent Table: Fourth column of the composite Primary key of of the record in the Parent table. VARCHAR2(512)
CALCULATION

SUBSTR(GORSDAV_PK_PARENTTAB,)

NO
NO

PARENT_TABLE_PK_COL5 Primary Key Parent Table: Fifth column of the composite Primary key of of the record in the Parent table. VARCHAR2(512)
CALCULATION

SUBSTR(GORSDAV_PK_PARENTTAB,)

NO
NO

PARENT_TABLE_PK_COL6 Primary Key Parent Table: Sixth column of the composite Primary key of of the record in the Parent table. VARCHAR2(512)
CALCULATION

SUBSTR(GORSDAV_PK_PARENTTAB,)

NO
NO

PARENT_TABLE_PRIMARY_KEY Primary Key Parent Table: The Primary key of of the record in the Parent table. VARCHAR2(512)
GORSDAV

GORSDAV_PK_PARENTTAB

NO
NO

PRIMARY_KEY_COLUMNS Primary Key Dynamic SQL: The SQL to generate the record ID from ROWID in Banner Table Name. VARCHAR2(2000)
GOBSDTB

GOBSDTB_PK_DYNSQL

NO
NO

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

NA

NO
NO

PROFILE_CODE This BUSNIESS PROFILE code is stored as MGRSDAX_PROFILE_CODE column and is used to set up display rules specific to an institution office or role. This may be used to define security for the rows of data available to a reporting user, or to select data through a reporting tool selection criteria. VARCHAR2(63)
MGRSDAX

MGRSDAX_PROFILE_CODE

NO
NO

TABLE_NAME Table Name: The name of the table supplemented by the attribute. VARCHAR2(30)
GORSDAV

GORSDAV_TABLE_NAME

NO
NO

VALUE1 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

NO
NO

VALUE10 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

NO
NO

VALUE2 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

NO
NO

VALUE3 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

NO
NO

VALUE4 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

NO
NO

VALUE5 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

NO
NO

VALUE6 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

NO
NO

VALUE7 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

NO
NO

VALUE8 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

NO
NO

VALUE9 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

NO
NO

Ver: 9.2

Description	Uses data from the MGT_SDE_DATA composite table. Displays up to 10 supplemental values based on the defined display rule(s) with an internal group of SDE.
Key & Frequency	Union of Discriminator and non discriminator attribute values.
Recommended Search Columns	TABLE_NAME PARENT_TABLE_PRIMARY_KEY ATTRIBUTE_NAME

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	SYSDATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ATTRIBUTE1	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME	NO	NO
ATTRIBUTE10	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME	NO	NO
ATTRIBUTE2	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME	NO	NO
ATTRIBUTE3	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME	NO	NO
ATTRIBUTE4	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME	NO	NO
ATTRIBUTE5	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME	NO	NO
ATTRIBUTE6	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME	NO	NO
ATTRIBUTE7	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME	NO	NO
ATTRIBUTE8	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME	NO	NO
ATTRIBUTE9	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME	NO	NO
DISCRIMINATED_ATTRIBUTE	Discriminated attribute name.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PARENT_TABLE_PK_COL1	Primary Key Parent Table: First column of the composite Primary key of of the record in the Parent table.	VARCHAR2(512)	CALCULATION	SUBSTR(GORSDAV_PK_PARENTTAB,)	NO	NO
PARENT_TABLE_PK_COL2	Primary Key Parent Table: Second column of the composite Primary key of of the record in the Parent table.	VARCHAR2(512)	CALCULATION	SUBSTR(GORSDAV_PK_PARENTTAB,)	NO	NO
PARENT_TABLE_PK_COL3	Primary Key Parent Table: Third column of the composite Primary key of of the record in the Parent table.	VARCHAR2(512)	CALCULATION	SUBSTR(GORSDAV_PK_PARENTTAB,)	NO	NO
PARENT_TABLE_PK_COL4	Primary Key Parent Table: Fourth column of the composite Primary key of of the record in the Parent table.	VARCHAR2(512)	CALCULATION	SUBSTR(GORSDAV_PK_PARENTTAB,)	NO	NO
PARENT_TABLE_PK_COL5	Primary Key Parent Table: Fifth column of the composite Primary key of of the record in the Parent table.	VARCHAR2(512)	CALCULATION	SUBSTR(GORSDAV_PK_PARENTTAB,)	NO	NO
PARENT_TABLE_PK_COL6	Primary Key Parent Table: Sixth column of the composite Primary key of of the record in the Parent table.	VARCHAR2(512)	CALCULATION	SUBSTR(GORSDAV_PK_PARENTTAB,)	NO	NO
PARENT_TABLE_PRIMARY_KEY	Primary Key Parent Table: The Primary key of of the record in the Parent table.	VARCHAR2(512)	GORSDAV	GORSDAV_PK_PARENTTAB	NO	NO
PRIMARY_KEY_COLUMNS	Primary Key Dynamic SQL: The SQL to generate the record ID from ROWID in Banner Table Name.	VARCHAR2(2000)	GOBSDTB	GOBSDTB_PK_DYNSQL	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PROFILE_CODE	This BUSNIESS PROFILE code is stored as MGRSDAX_PROFILE_CODE column and is used to set up display rules specific to an institution office or role. This may be used to define security for the rows of data available to a reporting user, or to select data through a reporting tool selection criteria.	VARCHAR2(63)	MGRSDAX	MGRSDAX_PROFILE_CODE	NO	NO
TABLE_NAME	Table Name: The name of the table supplemented by the attribute.	VARCHAR2(30)	GORSDAV	GORSDAV_TABLE_NAME	NO	NO
VALUE1	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE	NO	NO
VALUE10	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE	NO	NO
VALUE2	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE	NO	NO
VALUE3	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE	NO	NO
VALUE4	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE	NO	NO
VALUE5	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE	NO	NO
VALUE6	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE	NO	NO
VALUE7	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE	NO	NO
VALUE8	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE	NO	NO
VALUE9	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE	NO	NO