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

ACTIVITY_DATE Date record was inserted or updated. DATE
NA

SYSDATE

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

NA

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

DISCRIMINATED_ATTRIBUTE Discriminated attribute name. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_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

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,)

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,)

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,)

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,)

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,)

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,)

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

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

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

NA

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

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

GORSDAV_TABLE_NAME

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

GORSDAV_VALUE

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

GORSDAV_VALUE

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

GORSDAV_VALUE

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

GORSDAV_VALUE

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

GORSDAV_VALUE

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

GORSDAV_VALUE

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

GORSDAV_VALUE

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

GORSDAV_VALUE

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

GORSDAV_VALUE

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

GORSDAV_VALUE

Ver: 9.1

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
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	SYSDATE
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ATTRIBUTE1	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE10	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE2	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE3	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE4	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE5	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE6	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE7	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE8	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE9	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
DISCRIMINATED_ATTRIBUTE	Discriminated attribute name.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_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
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,)
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,)
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,)
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,)
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,)
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,)
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
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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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
TABLE_NAME	Table Name: The name of the table supplemented by the attribute.	VARCHAR2(30)	GORSDAV	GORSDAV_TABLE_NAME
VALUE1	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE10	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE2	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE3	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE4	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE5	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE6	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE7	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE8	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE9	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE