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

Description Source composite view contains the geographic regions for person addresses.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADDRESS_DESC Address type description.    

STVATYP

STVATYP_DESC

 
ADDRESS_SEQ_NO Sequence used to identify different addresses within the same address type.    

GORPGEO

GORPGEO_ADDR_SEQNO

 
ADDRESS_TYPE Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.    

GORPGEO

GORPGEO_ATYP_CODE

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

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

NA

NA

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

GORPGEO

GORPGEO_PIDM

 
GEOGRAPHIC_DIVISION Division code associated with the geographic region.    

GORPGEO

GORPGEO_GEOD_CODE

 
GEOGRAPHIC_DIVISION_DESC Geographic division code description.    

STVGEOD

STVGEOD_DESC

 
GEOGRAPHIC_REGION Geographic region code.    

GORPGEO

GORPGEO_GEOR_CODE

 
GEOGRAPHIC_REGION_DESC Geographic region code description.    

STVGEOR

STVGEOR_DESC

 
GEOGRAPHIC_REGION_END_DATE End date for this geographic region.    

GORPGEO

GORPGEO_TO_DATE

 
GEOGRAPHIC_REGION_START_DATE Start date for this geographic region.    

GORPGEO

GORPGEO_FROM_DATE

 
GEOGRAPHIC_REGION_STATUS_IND Code that indicates whether the geographic region/division is active (null) or inactive (1) for the identification number and address.    

GORPGEO

GORPGEO_STATUS_IND

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

NA

NA

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

NA

NA

 


Ver: 8.3