RETURN TO BANNER EDW META DATA REPORTS LIST
Advancement Degree Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ADVANCEMENT_DEGREE

Description Advancement degree dimension table provides information about a constituent's degree. 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
ADVANCEMENT_DEGREE_KEY Advancement Degree KEY. NUMBER       NO
DEGREE Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. VARCHAR2(63)

APRADEG

APRADEG_DEGC_CODE

NO

NO ADVANCEMENT DEGREE
DEGREE_AWARD_CATEGORGY Degree award category. VARCHAR2(63)

STVDEGC

STVDEGC_ACAT_CODE

NO

NO ADVANCEMENT DEGREE
DEGREE_AWARD_CATEGORGY_LD Degree award category long description. VARCHAR2(255)

STVACAT

STVACAT_DESC

NO

NO ADVANCEMENT DEGREE
DEGREE_AWARD_CATEGORGY_SD Degree award category short description. VARCHAR2(255)

STVACAT

STVACAT_DESC

NO

NO ADVANCEMENT DEGREE
DEGREE_CAMPUS Campus associated with this degree. VARCHAR2(63)

APRADEG

APRADEG_CAMP_CODE

NO

NO ADVANCEMENT DEGREE
DEGREE_CAMPUS_LD Campus long description. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

NO

NO ADVANCEMENT DEGREE
DEGREE_CAMPUS_SD Campus short description. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

NO

NO ADVANCEMENT DEGREE
DEGREE_CLASS_SECTION Class section associated with this degree. VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
DEGREE_CLASS_SECTION_LD Class section long description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
DEGREE_CLASS_SECTION_SD Class section short description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
DEGREE_COLLEGE   VARCHAR2(63)

APRADEG

APRADEG_COLL_CODE

NO

NO ADVANCEMENT DEGREE
DEGREE_COLLEGE_LD College long description. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

NO

NO ADVANCEMENT DEGREE
DEGREE_COLLEGE_SD College short description. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

NO

NO ADVANCEMENT DEGREE
DEGREE_DIVISION Division associated with this degree. VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
DEGREE_DIVISION_LD Division long description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
DEGREE_DIVISION_SD Division short description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
DEGREE_LD Degree long description. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

NO

NO ADVANCEMENT DEGREE
DEGREE_LEVEL Level associated with this degree (undergraduate, masters, post-doctoral, etc.). VARCHAR2(63)

STVDEGC

STVDEGC_DLEV_CODE

NO

NO ADVANCEMENT DEGREE
DEGREE_LEVEL_LD Degree level long description. VARCHAR2(255)

STVDLEV

STVDLEV_DESC

NO

NO ADVANCEMENT DEGREE
DEGREE_LEVEL_SD Degree level short description. VARCHAR2(255)

STVDLEV

STVDLEV_DESC

NO

NO ADVANCEMENT DEGREE
DEGREE_SD Degree short description. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

NO

NO ADVANCEMENT DEGREE
DEGREE_TYPE Identifies type of degree. VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
DEGREE_TYPE_LD Degree type long description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
DEGREE_TYPE_SD Degree type short description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

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

SYSTEM_LOAD_PROCESS

'ADVANCEMENT_DEGREE_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