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

Banner Operational Data Store
Composite View Target: AG_GEOGRAPHIC_REGION_INST

Description Source composite view contains source institution and the geographic regions and geographic divisions associated with the institution.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
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
GEOGRAPHIC_DIVISION Institution defined geographic division used to group together a set of geographic regions. VARCHAR2(10)

GORSGEO

GORSGEO_GEOD_CODE

NO

NO
GEOGRAPHIC_DIVISION_DESC Geographic division code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
GEOGRAPHIC_REGION Institution defined geographic region associated with a geographic division that will be associated with persons and institutions to group report those within a geographic location. VARCHAR2(10)

GORSGEO

GORSGEO_GEOR_CODE

NO

NO
GEOGRAPHIC_REGION_DESC Geographic region code description. VARCHAR2(30)

STVGEOR

STVGEOR_DESC

NO

NO
GEOGRAPHIC_REGION_STATUS Identifies the geographic region/division as active or inactive for the institution address. VARCHAR2(1)

CALCULATION

DECODE(GORSGEO_STATUS_IND,NULL,'A','I')

NO

NO
GEOGRAPHIC_REGION_STATUS_DESC Geographic region status description. VARCHAR2(30)

CALCULATION

DECODE(GORSGEO_STATUS_IND,NULL,'ACTIVE','INACTIVE')

NO

NO
GEOGRAPHIC_SOURCE_USER_IND Indicates whether the source for the geographic region/division was a user manual entry or assigned by the system using institution rules. VARCHAR2(1)

CALCULATION

DECODE(GORSGEO_SOURCE_IND,'S','N','Y')

NO

NO
INSTITUTION Source/background institution code. VARCHAR2(6)

GORSGEO

GORSGEO_SBGI_CODE

NO

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
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: