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

Banner Operational Data Store
Reporting View Target: SUPPLEMENTAL_DATA

Description Contains supplemental data in the system.
Key & Frequency One row per attribute and discriminator of each table.
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 ACTIVITY DATE: The date that the information for the row was inserted or updated in the GORSDAV table. DATE

GORSDAV

GORSDAV_ACTIVITY_DATE

NO

NO
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
ATTRIBUTE_NAME Attribute Name: The name of the attribute. VARCHAR2(30)

GORSDAV

GORSDAV_ATTR_NAME

NO

NO
ATTRIBUTE_VALUE Value: The Attribute Value. VARCHAR2(4000)

CALCULATION

CASE SYS.ANYDATA.GETTYPENAME(GORSDAV_VALUE)

NO

NO
DISCRIMINATOR Discriminator: The discriminator value for multiple valued attributes. VARCHAR2(64)

GORSDAV

GORSDAV_DISC

NO

NO
DISCRIMINATOR_CODE Discriminator Code: The Discriminator associated with this Attribute. VARCHAR2(255)

GORSDAM

GORSDAM_SDDC_CODE

NO

NO
DISCRIMINATOR_METHOD Discrimination Method: The method used to discriminate. I for Index, S for Select Statement, U for user defined in table GORSDDV. VARCHAR2(255)

GOBSDDC

GOBSDDC_METHOD

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

GORSDAV

GORSDAV_TABLE_NAME

NO

NO
USER_ID USER IDENTIFICATION: The unique identification of the user. VARCHAR2(30)

GORSDAV

GORSDAV_USER_ID

NO

NO


Ver: 9.2