Reporting View Target: C_GEOGRAPHIC

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

SGHE Banner Operational Data Store
Reporting View Target: C_GEOGRAPHIC_REGION

Description Freeze event table. Contains data about the geographic regions associated with the addresses of an entity. All data in the view is caputured during the freeze event. This table is not currently being populated.
Key & Frequency One row per entity per address type per address number per geographic region per geographic division.
Recommended Search Columns ENTITY_UID, ADDRESS_TYPE, GEOGRAPHIC_REGION, GEOGRAPHIC_DIVISION
GEOGRAPHIC_REGION
GEOGRAPHIC_DIVISION

Target Column Business Definition Database Data Type Source Name Source Column

ADDRESS_NUMBER Sequence used to identify different addresses within the same address type. NUMBER
GORPGEO

GORPGEO_ADDR_SEQNO

ADDRESS_TYPE Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(63)
GORPGEO

GORPGEO_ATYP_CODE

ADDRESS_TYPE_DESC Address type description. VARCHAR2(255)
STVATYP

STVATYP_DESC

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

NA

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER
GORPGEO

GORPGEO_PIDM

GEOGRAPHIC_DIVISION Division code associated with the geographic region. VARCHAR2(63)
GORPGEO

GORPGEO_GEOD_CODE

GEOGRAPHIC_DIVISION_DESC Geographic division code description. VARCHAR2(255)
STVGEOD

STVGEOD_DESC

GEOGRAPHIC_REGION Geographic region code. VARCHAR2(63)
GORPGEO

GORPGEO_GEOR_CODE

GEOGRAPHIC_REGION_DESC Geographic region code description. VARCHAR2(255)
STVGEOR

STVGEOR_DESC

GEOGRAPHIC_REGION_END_DATE End date for this geographic region. DATE
GORPGEO

GORPGEO_TO_DATE

GEOGRAPHIC_REGION_START_DATE Start date for this geographic region. DATE
GORPGEO

GORPGEO_FROM_DATE

GEOGRAPHIC_REGION_STATUS_IND Indicates whether the geographic region/division is active (null) or inactive (1) for the identification number and address. VARCHAR2(1)
GORPGEO

GORPGEO_STATUS_IND

ID Person's or organization's current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NA

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

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NA

Ver: 8.5

Description	Freeze event table. Contains data about the geographic regions associated with the addresses of an entity. All data in the view is caputured during the freeze event. This table is not currently being populated.
Key & Frequency	One row per entity per address type per address number per geographic region per geographic division.
Recommended Search Columns	ENTITY_UID, ADDRESS_TYPE, GEOGRAPHIC_REGION, GEOGRAPHIC_DIVISION GEOGRAPHIC_REGION GEOGRAPHIC_DIVISION

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_NUMBER	Sequence used to identify different addresses within the same address type.	NUMBER	GORPGEO	GORPGEO_ADDR_SEQNO
ADDRESS_TYPE	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	GORPGEO	GORPGEO_ATYP_CODE
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	GORPGEO	GORPGEO_PIDM
GEOGRAPHIC_DIVISION	Division code associated with the geographic region.	VARCHAR2(63)	GORPGEO	GORPGEO_GEOD_CODE
GEOGRAPHIC_DIVISION_DESC	Geographic division code description.	VARCHAR2(255)	STVGEOD	STVGEOD_DESC
GEOGRAPHIC_REGION	Geographic region code.	VARCHAR2(63)	GORPGEO	GORPGEO_GEOR_CODE
GEOGRAPHIC_REGION_DESC	Geographic region code description.	VARCHAR2(255)	STVGEOR	STVGEOR_DESC
GEOGRAPHIC_REGION_END_DATE	End date for this geographic region.	DATE	GORPGEO	GORPGEO_TO_DATE
GEOGRAPHIC_REGION_START_DATE	Start date for this geographic region.	DATE	GORPGEO	GORPGEO_FROM_DATE
GEOGRAPHIC_REGION_STATUS_IND	Indicates whether the geographic region/division is active (null) or inactive (1) for the identification number and address.	VARCHAR2(1)	GORPGEO	GORPGEO_STATUS_IND
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA