RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: SHRDGMR Student Composite View Reports
SGHE Operational Data Store Composite View Source: SHRDGMR

Source Column Source Form Target Type Target Target Column Calculation Formula
SHRDGMR_ACYR_CODE SHADEGR COMPOSITE VIEW

AS_ACADEMIC_OUTCOME

ACADEMIC_YEAR_GRADUATION

NA
SHRDGMR_ACYR_CODE_BULLETIN SHADEGR COMPOSITE VIEW

AS_ACADEMIC_OUTCOME

BULLETIN_YEAR

NA
SHRDGMR_APPL_DATE SHADEGR COMPOSITE VIEW

AS_ACADEMIC_OUTCOME

OUTCOME_APPLICATION_DATE

NA
SHRDGMR_AUTHORIZED SHADEGR COMPOSITE VIEW

AS_ACADEMIC_OUTCOME

GRAD_AUTHORIZED_ADDS_CHGS

NA
SHRDGMR_CAMP_CODE SHADEGR       NA
SHRDGMR_CAMP_CODE_2 SHADEGR       NA
SHRDGMR_COLL_CODE_1 SHADEGR       NA
SHRDGMR_COLL_CODE_2 SHADEGR       NA
SHRDGMR_DEGC_CODE SHADEGR COMPOSITE VIEW

AS_OUTCOME_HONOR_INST

AS_OUTCOME_HONOR_DEPT

OUTCOME

OUTCOME

NA
SHRDGMR_DEGS_CODE SHADEGR COMPOSITE VIEW

AS_ACADEMIC_OUTCOME

STATUS

NA
SHRDGMR_DEPT_CODE SHADEGR       NA
SHRDGMR_DEPT_CODE_1_2 SHADEGR       NA
SHRDGMR_DEPT_CODE_2 SHADEGR       NA
SHRDGMR_DEPT_CODE_2_2 SHADEGR       NA
SHRDGMR_GRAD_DATE SHADEGR COMPOSITE VIEW

AS_ACADEMIC_OUTCOME

OUTCOME_GRADUATION_DATE

NA
SHRDGMR_GRST_CODE SHADEGR COMPOSITE VIEW

AS_ACADEMIC_OUTCOME

GRADUATION_STATUS

NA
SHRDGMR_LEVL_CODE SHADEGR       NA
SHRDGMR_MAJR_CODE_1 SHADEGR       NA
SHRDGMR_MAJR_CODE_1_2 SHADEGR       NA
SHRDGMR_MAJR_CODE_2 SHADEGR       NA
SHRDGMR_MAJR_CODE_2_2 SHADEGR       NA
SHRDGMR_MAJR_CODE_CONC_1 SHADEGR       NA
SHRDGMR_MAJR_CODE_CONC_121 SHADEGR       NA
SHRDGMR_MAJR_CODE_CONC_122 SHADEGR       NA
SHRDGMR_MAJR_CODE_CONC_123 SHADEGR       NA
SHRDGMR_MAJR_CODE_CONC_1_2 SHADEGR       NA
SHRDGMR_MAJR_CODE_CONC_1_3 SHADEGR       NA
SHRDGMR_MAJR_CODE_CONC_2 SHADEGR       NA
SHRDGMR_MAJR_CODE_CONC_221 SHADEGR       NA
SHRDGMR_MAJR_CODE_CONC_222 SHADEGR       NA
SHRDGMR_MAJR_CODE_CONC_223 SHADEGR       NA
SHRDGMR_MAJR_CODE_CONC_2_2 SHADEGR       NA
SHRDGMR_MAJR_CODE_CONC_2_3 SHADEGR       NA
SHRDGMR_MAJR_CODE_MINR_1 SHADEGR       NA
SHRDGMR_MAJR_CODE_MINR_1_2 SHADEGR       NA
SHRDGMR_MAJR_CODE_MINR_2 SHADEGR       NA
SHRDGMR_MAJR_CODE_MINR_2_2 SHADEGR       NA
SHRDGMR_PIDM NA COMPOSITE VIEW

AS_OUTCOME_HONOR_DEPT

AS_ACADEMIC_OUTCOME

AS_OUTCOME_HONOR_INST

PERSON_UID

PERSON_UID

PERSON_UID

NA
SHRDGMR_PROGRAM SHADEGR       NA
SHRDGMR_SEQ_NO SHADEGR COMPOSITE VIEW

AS_OUTCOME_HONOR_DEPT

AS_OUTCOME_HONOR_INST

AS_ACADEMIC_OUTCOME

OUTCOME_NUMBER

OUTCOME_NUMBER

OUTCOME_NUMBER

NA
SHRDGMR_TERM_CODE_COMPLETED SHADEGR COMPOSITE VIEW

AS_ACADEMIC_OUTCOME

GRAD_REQ_COMPLETED_APRD

NA
SHRDGMR_TERM_CODE_GRAD SHADEGR COMPOSITE VIEW

AS_ACADEMIC_OUTCOME

ACADEMIC_PERIOD_GRADUATION

NA
SHRDGMR_TERM_CODE_STUREC SHADEGR COMPOSITE VIEW

AS_ACADEMIC_OUTCOME

STUDENT_TERM

NA


Ver: 3.1