Reporting View Target: GEOGRAPHIC_REGION

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

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 Definition Database Data Type Source Name Source Column Local Source Local Target

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

NA

NO
NO

GEOGRAPHIC_DIVISION Institution defined geographic division used to group together a set of geographic regions. VARCHAR2(63)
GORSGEO

GORSGEO_GEOD_CODE

NO
NO

GEOGRAPHIC_DIVISION_DESC Geographic division code description. VARCHAR2(255)
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(63)
GORSGEO

GORSGEO_GEOR_CODE

NO
NO

GEOGRAPHIC_REGION_DESC Geographic region code description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

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

NO
NO

GEOGRAPHIC_REGION_STATUS_DESC Geographic region status description. VARCHAR2(255)
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(63)
GORSGEO

GORSGEO_SBGI_CODE

NO
NO

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

NA

NO
NO

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

NA

NO
NO

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

STVSBGI_DESC

NO
NO

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

NA

NO
NO

Ver: 9.2

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 Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
GEOGRAPHIC_DIVISION	Institution defined geographic division used to group together a set of geographic regions.	VARCHAR2(63)	GORSGEO	GORSGEO_GEOD_CODE	NO	NO
GEOGRAPHIC_DIVISION_DESC	Geographic division code description.	VARCHAR2(255)	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(63)	GORSGEO	GORSGEO_GEOR_CODE	NO	NO
GEOGRAPHIC_REGION_DESC	Geographic region code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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')	NO	NO
GEOGRAPHIC_REGION_STATUS_DESC	Geographic region status description.	VARCHAR2(255)	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(63)	GORSGEO	GORSGEO_SBGI_CODE	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Source/background institution name.	VARCHAR2(63)	STVSBGI	STVSBGI_DESC	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO