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

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

NA

NA

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

GORSDAV

GORSDAV_ATTR_NAME

ATTRIBUTE_VALUE   Value: The Attribute Value. VARCHAR2(4000)

CALCULATION

CASE SYS.ANYDATA.GETTYPENAME(GORSDAV_VALUE)

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

GORSDAV

GORSDAV_DISC

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

GORSDAM

GORSDAM_SDDC_CODE

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

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 for the record 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

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

GORSDAV

GORSDAV_TABLE_NAME

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

GORSDAV

GORSDAV_USER_ID



Ver: 9.2