RETURN TO BANNER EDW META DATA REPORTS LIST
Advancement Degree Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ADVANCEMENT_INSTITUTION

Description Advancement institution dimension table provides information the institution from which a constituent earned a degree, either your institution or another institution. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ADMISSION_STATUS Entity���������s admission status when applying to this institution for the degree. VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
ADMISSION_STATUS_LD Admission status long description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
ADMISSION_STATUS_SD Admission status short description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
ADVANCEMENT_INSTITUTION Institution at which the constituent earned the degree. VARCHAR2(63)

APRADEG

APRADEG_SBGI_CODE

NO

NO ADVANCEMENT DEGREE
ADVANCEMENT_INSTITUTION_KEY Advancement Institution KEY. NUMBER       NO
ADVANCEMENT_INSTITUTION_LD Institution long description. VARCHAR2(255)

STVSBGI

STVSBGI_DESC

NO

NO ADVANCEMENT DEGREE
ADVANCEMENT_INSTITUTION_SD Institution short description. VARCHAR2(255)

STVSBGI

STVSBGI_DESC

NO

NO ADVANCEMENT DEGREE
CASE_CODE Case code for the institution. VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
CASE_CODE_LD Case code long description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
CASE_CODE_SD Case code short description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
FICE_CODE FICE code for the institution. VARCHAR2(63)

STVSBGI

STVSBGI_FICE

NO

NO ADVANCEMENT DEGREE
FICE_CODE_LD FICE code long description. VARCHAR2(255)

STVSBGI

STVSBGI_FICE

NO

NO ADVANCEMENT DEGREE
FICE_CODE_SD FICE code short description. VARCHAR2(255)

STVSBGI

STVSBGI_FICE

NO

NO ADVANCEMENT DEGREE
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

SYSTEM_LOAD_PROCESS

'ADVANCEMENT_INSTITUTION_D1B'

NO

NO ADVANCEMENT DEGREE
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO


Ver: 9.0