Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Common Composite View Reports

Banner Operational Data Store
Composite View Target: AG_ALTERNATIVE_ID

Description Source composite view contains non Banner alternative IDs used to support cross reference of the Banner ID to another system identification. These may be other government IDs or alternative agency identification assigned to the person.
Key & Frequency One row per entity per alternative ID. Per alternative ID type

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ALTERNATIVE_ID Alternative ID that may be used to cross reference the Banner ID to another system identification. VARCHAR2(50)

GORADID

GORADID_ADDITIONAL_ID

NO

NO
ALTERNATIVE_ID_ACTIVITY_DATE Date the last change were made to this record. DATE

GORADID

GORADID_ACTIVITY_DATE

NO

NO
ALTERNATIVE_ID_DATA_ORIGIN Source system that created or updated the row VARCHAR2(30)

GORADID

GORADID_DATA_ORIGIN

NO

NO
ALTERNATIVE_ID_TYPE Institution defined code that identifies the type or source for this alternative ID. VARCHAR2(4)

GORADID

GORADID_ADID_CODE

NO

NO
ALTERNATIVE_ID_TYPE_DESC Alternative ID type description. VARCHAR2(30)

GTVADID

GTVADID_DESC

NO

NO
ALTERNATIVE_ID_USER_ID User who made the last updated to this record. VARCHAR2(30)

GORADID

GORADID_USER_ID

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

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

NA

NA

NO

NO
ENTITY_UID   NUMBER       NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
PERSON_UID System generated, unique, internal identification number assigned to this person or organization. NUMBER

GORADID

GORADID_PIDM

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: