Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Common Composite View Reports

SGHE 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
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

NA

NA

GEOGRAPHIC_DIVISION Institution defined geographic division associated with the institution. VARCHAR2(10)

GORSGEO

GORSGEO_GEOD_CODE

GEOGRAPHIC_DIVISION_DESC Geographic division code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

GEOGRAPHIC_REGION Institution defined geographic region associated with the institution. VARCHAR2(10)

GORSGEO

GORSGEO_GEOR_CODE

GEOGRAPHIC_REGION_DESC Geographic region code description. VARCHAR2(30)

STVGEOR

STVGEOR_DESC

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')

GEOGRAPHIC_REGION_STATUS_DESC Geographic region status description. VARCHAR2(30)

CALCULATION

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

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')

INSTITUTION Source/background institution code. VARCHAR2(6)

GORSGEO

GORSGEO_SBGI_CODE

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

NA

NA

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

NA

NA

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

NA

NA



Ver: 8.0