RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: APRADEG Advancement Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: APRADEG

Source Column Source Form Target Type Target Target Column Calculation Formula
APRADEG_ACYR_CODE APAADEG

REPORTING VIEW

DEGREE_SLOT

COMBINED_ACADEMIC_OUTCOME

DEGREE_SLOT

DEGREE_SLOT

DEGREE

ACADEMIC_YEAR_2

ACADEMIC_YEAR_GRADUATION

ACADEMIC_YEAR_1

ACADEMIC_YEAR_3

ACADEMIC_YEAR

NA
APRADEG_ACYR_CODE_BULLETIN APAADEG

REPORTING VIEW

DEGREE

BULLETIN_YEAR

NA
APRADEG_CAMP_CODE APAADEG

REPORTING VIEW

DEGREE

CAMPUS

NA
APRADEG_COLL_CODE APAADEG

REPORTING VIEW

DEGREE_SLOT

DEGREE_SLOT

DEGREE

DEGREE_SLOT

COLLEGE_3

COLLEGE_2

COLLEGE

COLLEGE_1

NA
APRADEG_COMMENTS APAADEG

REPORTING VIEW

DEGREE

COMBINED_ACADEMIC_OUTCOME

DEGREE_COMMENT

DEGREE_COMMENT

NA
APRADEG_DATE APAADEG

REPORTING VIEW

DEGREE

DEGREE_SLOT

DEGREE_SLOT

DEGREE_SLOT

COMBINED_ACADEMIC_OUTCOME

DEGREE_DATE

DEGREE_DATE_3

DEGREE_DATE_2

DEGREE_DATE_1

DEGREE_DATE

NA
APRADEG_DEGC_CODE APAADEG

REPORTING VIEW

DEGREE_SLOT

DEGREE

DEGREE_SLOT

DEGREE_SLOT

DEGREE_1

DEGREE

DEGREE_2

DEGREE_3

NA
APRADEG_DEPT_CODE APAADEG

REPORTING VIEW

DEGREE

DEPARTMENT1

NA
APRADEG_DEPT_CODE_2 APAADEG

REPORTING VIEW

DEGREE

DEPARTMENT2

NA
APRADEG_HOND_CODE_1 APAADEG

REPORTING VIEW

DEGREE

DEPARTMENT_HONOR1

NA
APRADEG_HOND_CODE_2 APAADEG

REPORTING VIEW

DEGREE

DEPARTMENT_HONOR2

NA
APRADEG_HOND_CODE_3 APAADEG

REPORTING VIEW

DEGREE

DEPARTMENT_HONOR3

NA
APRADEG_HOND_CODE_4 APAADEG

REPORTING VIEW

DEGREE

DEPARTMENT_HONOR4

NA
APRADEG_HOND_CODE_5 APAADEG

REPORTING VIEW

DEGREE

DEPARTMENT_HONOR5

NA
APRADEG_HONR_CODE APAADEG

REPORTING VIEW

DEGREE_SLOT

DEGREE

DEGREE_SLOT

DEGREE_SLOT

HONOR1_1

HONOR1

HONOR1_2

HONOR1_3

NA
APRADEG_HONR_CODE_2 APAADEG

REPORTING VIEW

DEGREE

HONOR2

NA
APRADEG_HONR_CODE_3 APAADEG

REPORTING VIEW

DEGREE

HONOR3

NA
APRADEG_HONR_CODE_4 APAADEG

REPORTING VIEW

DEGREE

HONOR4

NA
APRADEG_HONR_CODE_5 APAADEG

REPORTING VIEW

DEGREE

HONOR5

NA
APRADEG_MAJR_CODE_CONC_1 APAADEG

REPORTING VIEW

DEGREE

FIRST_CONCENTRATION

NA
APRADEG_MAJR_CODE_CONC_2 APAADEG

REPORTING VIEW

DEGREE

SECOND_CONCENTRATION

NA
APRADEG_MAJR_CODE_CONC_3 APAADEG

REPORTING VIEW

DEGREE

THIRD_CONCENTRATION

NA
APRADEG_MAJR_CODE_CONC_4 APAADEG

REPORTING VIEW

DEGREE

SECOND_MAJOR_CONC_1

NA
APRADEG_MAJR_CODE_CONC_5 APAADEG

REPORTING VIEW

DEGREE

SECOND_MAJOR_CONC_2

NA
APRADEG_MAJR_CODE_CONC_6 APAADEG

REPORTING VIEW

DEGREE

SECOND_MAJOR_CONC_3

NA
APRADEG_MAJR_CODE_MINR_1 APAADEG

REPORTING VIEW

DEGREE

FIRST_MINOR

NA
APRADEG_MAJR_CODE_MINR_2 APAADEG

REPORTING VIEW

DEGREE

SECOND_MINOR

NA
APRADEG_PIDM NA

REPORTING VIEW

DEGREE_SLOT

DEGREE

COMBINED_ACADEMIC_OUTCOME

PERSON_UID

PERSON_UID

PERSON_UID

NA
APRADEG_SBGI_CODE APAADEG

REPORTING VIEW

DEGREE_SLOT

COMBINED_ACADEMIC_OUTCOME

DEGREE

DEGREE_SLOT

DEGREE_SLOT

INSTITUTION_1

INSTITUTION

INSTITUTION

INSTITUTION_2

INSTITUTION_3

NA
APRADEG_SEQ_NO APAADEG

REPORTING VIEW

DEGREE

COMBINED_ACADEMIC_OUTCOME

DEGREE_NUMBER

OUTCOME_NUMBER

NA


Ver: 3.1