Composite View Target: AG_GEOGRAPHIC_REGION

Go To View:	RETURN TO BANNER COMP META DATA 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 Name Business Definition Database Data Type Domain Value Source Name Source Column

CURRENT_DATE Current Date System current date (sysdate) or date the data was extracted. DATE
NA

SYSDATE

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

NA

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

GORSGEO_GEOD_CODE

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

GOKODSF.F_GET_DESC

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

GORSGEO_GEOR_CODE

GEOGRAPHIC_REGION_DESC Geographic Region Description Geographic region code description. VARCHAR2(30)
STVGEOR

STVGEOR_DESC

GEOGRAPHIC_REGION_STATUS 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 Geographic region status description. VARCHAR2(30)
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(6)
GORSGEO

GORSGEO_SBGI_CODE

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

NA

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

NA

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

NA

Ver:

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
GEOGRAPHIC_DIVISION	Geographic Division	Institution defined geographic division associated with the institution.	VARCHAR2(10)	GORSGEO	GORSGEO_GEOD_CODE
GEOGRAPHIC_DIVISION_DESC	Geographic Division Description	Geographic division code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
GEOGRAPHIC_REGION	Geographic Region	Institution defined geographic region associated with the institution.	VARCHAR2(10)	GORSGEO	GORSGEO_GEOR_CODE
GEOGRAPHIC_REGION_DESC	Geographic Region Description	Geographic region code description.	VARCHAR2(30)	STVGEOR	STVGEOR_DESC
GEOGRAPHIC_REGION_STATUS	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	Geographic region status description.	VARCHAR2(30)	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(6)	GORSGEO	GORSGEO_SBGI_CODE
MIF_DESC	Mif Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Mif Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA