Reporting View Target: GEOGRAPHIC_REGION

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

SGHE Banner Operational Data Store
Reporting View Target: GEOGRAPHIC_REGION_INSTITUTION

Description Contains the geographic regions and geographic divisions defined that are associated with the address of the background institution.
Key & Frequency One row per institution per geographic region per geographic division.
Recommended Search Columns INSTITUTION
GEOGRAPHIC_REGION
GEOGRAPHIC_DIVISION

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

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

NA

GEOGRAPHIC_DIVISION Geographic Division Institution defined geographic division associated with the institution. VARCHAR2(63)
GORSGEO

GORSGEO_GEOD_CODE

GEOGRAPHIC_DIVISION_DESC Geographic Division Description Geographic division code description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

GEOGRAPHIC_REGION Georgraphic Region Institution defined geographic region associated with the institution. VARCHAR2(63)
GORSGEO

GORSGEO_GEOR_CODE

GEOGRAPHIC_REGION_DESC Geographic Region Description Geographic region code description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

GEOGRAPHIC_REGION_STATUS Geographic Region Status Identifies the geographic region/division as active or inactive for the institution address. VARCHAR2(63)
CALCULATION

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

GEOGRAPHIC_REGION_STATUS_DESC Geographic Region Status Description Geographic region status description. VARCHAR2(255)
CALCULATION

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

GEOGRAPHIC_SOURCE_USER_IND Geographic Source User Indicator 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 Institution Source/background institution code. VARCHAR2(63)
GORSGEO

GORSGEO_SBGI_CODE

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NAME Institution Name Source/background institution name. VARCHAR2(63)
STVSBGI

STVSBGI_DESC

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

Ver: 9.0

Description	Contains the geographic regions and geographic divisions defined that are associated with the address of the background institution.
Key & Frequency	One row per institution per geographic region per geographic division.
Recommended Search Columns	INSTITUTION GEOGRAPHIC_REGION GEOGRAPHIC_DIVISION

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
GEOGRAPHIC_DIVISION	Geographic Division	Institution defined geographic division associated with the institution.	VARCHAR2(63)	GORSGEO	GORSGEO_GEOD_CODE
GEOGRAPHIC_DIVISION_DESC	Geographic Division Description	Geographic division code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
GEOGRAPHIC_REGION	Georgraphic Region	Institution defined geographic region associated with the institution.	VARCHAR2(63)	GORSGEO	GORSGEO_GEOR_CODE
GEOGRAPHIC_REGION_DESC	Geographic Region Description	Geographic region code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
GEOGRAPHIC_REGION_STATUS	Geographic Region Status	Identifies the geographic region/division as active or inactive for the institution address.	VARCHAR2(63)	CALCULATION	DECODE(GORSGEO_STATUS_IND,NULL,'A','I')
GEOGRAPHIC_REGION_STATUS_DESC	Geographic Region Status Description	Geographic region status description.	VARCHAR2(255)	CALCULATION	DECODE(GORSGEO_STATUS_IND,NULL,'ACTIVE','INACTIVE')
GEOGRAPHIC_SOURCE_USER_IND	Geographic Source User Indicator	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	Institution	Source/background institution code.	VARCHAR2(63)	GORSGEO	GORSGEO_SBGI_CODE
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Institution Name	Source/background institution name.	VARCHAR2(63)	STVSBGI	STVSBGI_DESC
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA