RETURN TO DIMENSION TABLE REPORTS LIST
Institution Star  Prospective Student Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_GEOGRAPHIC_REGION

Description Contains all data that is common to an institution.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
GEOGRAPHIC_DIVISION Institution defined geographic division associated with the institution. VARCHAR2(63)

GEOGRAPHIC_REGION_INSTITUTION

GEOGRAPHIC_DIVISION

NO

NO INSTITUTION, PROSPECTIVE STUDENT
GEOGRAPHIC_DIVISION_LD Geographic division code long description. VARCHAR2(255)

GEOGRAPHIC_REGION_INSTITUTION

GEOGRAPHIC_DIVISION_DESC

NO

NO INSTITUTION, PROSPECTIVE STUDENT
GEOGRAPHIC_DIVISION_SD Geographic division code short description. VARCHAR2(255)

GEOGRAPHIC_REGION_INSTITUTION

GEOGRAPHIC_DIVISION_DESC

NO

NO INSTITUTION, PROSPECTIVE STUDENT
GEOGRAPHIC_REGION Institution defined geographic region associated with the institution. VARCHAR2(63)

GEOGRAPHIC_REGION_INSTITUTION

GEOGRAPHIC_REGION

NO

NO INSTITUTION, PROSPECTIVE STUDENT
GEOGRAPHIC_REGION_KEY Key of the institution dimension. NUMBER

ETL GENERATED

NA

NO

NO INSTITUTION, PROSPECTIVE STUDENT
GEOGRAPHIC_REGION_LD Geographic region code long description. VARCHAR2(255)

GEOGRAPHIC_REGION_INSTITUTION

GEOGRAPHIC_REGION_DESC

NO

NO INSTITUTION, PROSPECTIVE STUDENT
GEOGRAPHIC_REGION_SD Geographic region code short description. VARCHAR2(255)

GEOGRAPHIC_REGION_INSTITUTION

GEOGRAPHIC_REGION_DESC

NO

NO INSTITUTION, PROSPECTIVE STUDENT
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO INSTITUTION, PROSPECTIVE STUDENT
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO INSTITUTION, PROSPECTIVE STUDENT


Ver: 8.1