RETURN TO BANNER EDW META DATA REPORTS LIST
Committee Star  Geographic Region Star  Institution Star  Post Secondary School Star  Prospective Student Star  Student Star  Student Progress Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_GEOGRAPHIC_REGION

Description Geographic Region dimension table contains all data related to institution defined divisions of geographic groups and regions. These may be the same across the institution or different as identified by different divisions of the institution. Institutions define a load parameter to determine the data by data warehouse product.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
GEOGRAPHIC_DIVISION Institution defined geographic division used to group together a set of geographic regions. VARCHAR2(63)

GEOGRAPHIC_REGION

GEOGRAPHIC_DIVISION

NO

NO STUDENT, STUDENT PROGRESS
GEOGRAPHIC_DIVISION_LD Long Description for the Geographic Division. VARCHAR2(255)

GEOGRAPHIC_REGION

GEOGRAPHIC_DIVISION_DESC

NO

NO STUDENT, STUDENT PROGRESS
GEOGRAPHIC_DIVISION_SD Short Description for the Geographic Division. VARCHAR2(255)

GEOGRAPHIC_REGION

GEOGRAPHIC_DIVISION_DESC

NO

NO STUDENT, STUDENT PROGRESS
GEOGRAPHIC_REGION Institution defined geographic region associated with a geographic division that will be associated with the institution to group them and report those within a geographic location. VARCHAR2(63)

GEOGRAPHIC_REGION

GEOGRAPHIC_REGION

NO

NO STUDENT, STUDENT PROGRESS
GEOGRAPHIC_REGION_KEY Key to the geographic region dimension. NUMBER

ETL_GENERATED

NA

NO

NO STUDENT PROGRESS
GEOGRAPHIC_REGION_LD Long description for the geographic region. VARCHAR2(255)

GEOGRAPHIC_REGION

GEOGRAPHIC_REGION_DESC

NO

NO STUDENT, STUDENT PROGRESS
GEOGRAPHIC_REGION_SD Short description for the geographic region. VARCHAR2(255)

GEOGRAPHIC_REGION

GEOGRAPHIC_REGION_DESC

NO

NO STUDENT, STUDENT PROGRESS
SYSTEM_LOAD_PROCESS   VARCHAR2(30)

ETL GENERATED

ETL_GENERATED

NA

NA

NO

NO

NO INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS 

STUDENT PROGRESS

SYSTEM_LOAD_TMSTMP   DATE

ETL GENERATED

ETL_GENERATED

NA

NA

NO

NO

NO INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS 

STUDENT PROGRESS



Ver: 9.0