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 Name Business Definition Database Data Type Source Name Source Column

ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE
NA

SYSDATE

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

NA

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

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

GORSDAV_ATTR_NAME

DISCRIMINATED_ATTRIBUTE Discriminated attribute Discriminated attribute name. VARCHAR2(255)
GORSDAV

GORSDAV_ATTR_NAME

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

NA

MULTI_SOURCE_DESC Multi Source Description 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 value 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 column list 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 Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

PROFILE_CODE 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 Supplemental table name Table Name: The name of the table supplemented by the attribute. VARCHAR2(30)
GORSDAV

GORSDAV_TABLE_NAME

VALUE1 ATTRIBUTE VALUE 1 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

VALUE10 ATTRIBUTE VALUE 10 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

VALUE2 ATTRIBUTE VALUE 2 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

VALUE3 ATTRIBUTE VALUE 3 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

VALUE4 ATTRIBUTE VALUE 4 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

VALUE5 ATTRIBUTE VALUE 5 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

VALUE6 ATTRIBUTE VALUE 6 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

VALUE7 ATTRIBUTE VALUE 7 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

VALUE8 ATTRIBUTE VALUE 8 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

VALUE9 ATTRIBUTE VALUE 9 Value: The Attribute Value. VARCHAR2(4000)
GORSDAV

GORSDAV_VALUE

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 Name	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE	NA	SYSDATE
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ATTRIBUTE1	ATTRIBUTE 1	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE10	ATTRIBUTE 10	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE2	ATTRIBUTE 2	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE3	ATTRIBUTE 3	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE4	ATTRIBUTE 4	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE5	ATTRIBUTE 5	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE6	ATTRIBUTE 6	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE7	ATTRIBUTE 7	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE8	ATTRIBUTE 8	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
ATTRIBUTE9	ATTRIBUTE 9	Attribute Name: The name of the attribute.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
DISCRIMINATED_ATTRIBUTE	Discriminated attribute	Discriminated attribute name.	VARCHAR2(255)	GORSDAV	GORSDAV_ATTR_NAME
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	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 value	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 column list	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 Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROFILE_CODE	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	Supplemental table name	Table Name: The name of the table supplemented by the attribute.	VARCHAR2(30)	GORSDAV	GORSDAV_TABLE_NAME
VALUE1	ATTRIBUTE VALUE 1	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE10	ATTRIBUTE VALUE 10	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE2	ATTRIBUTE VALUE 2	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE3	ATTRIBUTE VALUE 3	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE4	ATTRIBUTE VALUE 4	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE5	ATTRIBUTE VALUE 5	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE6	ATTRIBUTE VALUE 6	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE7	ATTRIBUTE VALUE 7	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE8	ATTRIBUTE VALUE 8	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE
VALUE9	ATTRIBUTE VALUE 9	Value: The Attribute Value.	VARCHAR2(4000)	GORSDAV	GORSDAV_VALUE