VIEW: APPS.IGSFV_PERSON_ACAD_TRANSCRIPTS

Source

View Text - Preformatted

SELECT '_LA:ATR.TRANSCRIPT_TYPE:IGS_LOOKUP_VALUES:TRANSCRIPT_TYPE:MEANING', '_LA:ATR.TRANSCRIPT_STATUS:IGS_LOOKUP_VALUES:TRANSCRIPT_STATUS:MEANING', ATR.DATE_OF_ISSUE, ATR.DATE_OF_RECEIPT, ATR.ENTERED_GPA, ATR.CONV_GPA CONVERTED_GPA, ATR.CORE_CURRICULUM_VALUE, '_LA:ATR.TERM_TYPE:IGS_LOOKUP_VALUES:TERM_TYPE:MEANING', ATR.RANK_IN_CLASS, ATR.CLASS_SIZE, ATR.APPROXIMATE_RANK APPROXIMATE_RANK_INDICATOR, ATR.WEIGHTED_RANK WEIGHTED_RANK_INDICATOR, ATR.DECILE_RANK, ATR.QUARTILE_RANK, ATR.QUINTILE_RANK, ATR.PERCENTILE_RANK, ATR.OVERRIDE OVERRIDE_INDICATOR, ATR.OVERRIDE_DATE, HP1.PARTY_NUMBER PERSON_NUMBER, HP2.PARTY_NAME INSTITUTION_NAME, CC1.NAME ENTERED_GRADE_SCALE_TYPE, CC1.DESCRIPTION ENTERED_GRADE_SCALE_TYPE_DESC, CC2.NAME TRANSCRIPT_SOURCE, CC2.DESCRIPTION TRANSCRIPT_SOURCE_DESC, HP3.PARTY_NUMBER OVERRIDE_PERSON_NUMBER, CC3.NAME CONVERTED_GRADE_SCALE_TYP, CC3.DESCRIPTION CONVERTED_GRADE_SCALE_TYP_DESC, ATR.TRANSCRIPT_ID, ATR.EDUCATION_ID, ATR.ENTERED_GS_ID, ATR.TRANSCRIPT_SOURCE, ATR.OVERRIDE_ID, ATR.CONV_GS_ID, ATR.CREATED_BY, ATR.CREATION_DATE, ATR.LAST_UPDATED_BY, ATR.LAST_UPDATE_DATE FROM IGS_AD_TRANSCRIPT ATR, HZ_EDUCATION HE, HZ_PARTIES HP1, HZ_PARTIES HP2, HZ_PARTIES HP3, IGS_AD_CODE_CLASSES CC1, IGS_AD_CODE_CLASSES CC2, IGS_AD_CODE_CLASSES CC3 WHERE ATR.EDUCATION_ID = HE.EDUCATION_ID AND HE.PARTY_ID = HP1.PARTY_ID AND HE.SCHOOL_PARTY_ID = HP2.PARTY_ID AND ATR.OVERRIDE_ID = HP3.PARTY_ID(+) AND ATR.ENTERED_GS_ID = CC1.CODE_ID AND ATR.TRANSCRIPT_SOURCE = CC2.CODE_ID AND ATR.CONV_GS_ID = CC3.CODE_ID WITH READ ONLY

View Text - HTML Formatted

SELECT '_LA:ATR.TRANSCRIPT_TYPE:IGS_LOOKUP_VALUES:TRANSCRIPT_TYPE:MEANING'
, '_LA:ATR.TRANSCRIPT_STATUS:IGS_LOOKUP_VALUES:TRANSCRIPT_STATUS:MEANING'
, ATR.DATE_OF_ISSUE
, ATR.DATE_OF_RECEIPT
, ATR.ENTERED_GPA
, ATR.CONV_GPA CONVERTED_GPA
, ATR.CORE_CURRICULUM_VALUE
, '_LA:ATR.TERM_TYPE:IGS_LOOKUP_VALUES:TERM_TYPE:MEANING'
, ATR.RANK_IN_CLASS
, ATR.CLASS_SIZE
, ATR.APPROXIMATE_RANK APPROXIMATE_RANK_INDICATOR
, ATR.WEIGHTED_RANK WEIGHTED_RANK_INDICATOR
, ATR.DECILE_RANK
, ATR.QUARTILE_RANK
, ATR.QUINTILE_RANK
, ATR.PERCENTILE_RANK
, ATR.OVERRIDE OVERRIDE_INDICATOR
, ATR.OVERRIDE_DATE
, HP1.PARTY_NUMBER PERSON_NUMBER
, HP2.PARTY_NAME INSTITUTION_NAME
, CC1.NAME ENTERED_GRADE_SCALE_TYPE
, CC1.DESCRIPTION ENTERED_GRADE_SCALE_TYPE_DESC
, CC2.NAME TRANSCRIPT_SOURCE
, CC2.DESCRIPTION TRANSCRIPT_SOURCE_DESC
, HP3.PARTY_NUMBER OVERRIDE_PERSON_NUMBER
, CC3.NAME CONVERTED_GRADE_SCALE_TYP
, CC3.DESCRIPTION CONVERTED_GRADE_SCALE_TYP_DESC
, ATR.TRANSCRIPT_ID
, ATR.EDUCATION_ID
, ATR.ENTERED_GS_ID
, ATR.TRANSCRIPT_SOURCE
, ATR.OVERRIDE_ID
, ATR.CONV_GS_ID
, ATR.CREATED_BY
, ATR.CREATION_DATE
, ATR.LAST_UPDATED_BY
, ATR.LAST_UPDATE_DATE
FROM IGS_AD_TRANSCRIPT ATR
, HZ_EDUCATION HE
, HZ_PARTIES HP1
, HZ_PARTIES HP2
, HZ_PARTIES HP3
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
, IGS_AD_CODE_CLASSES CC3
WHERE ATR.EDUCATION_ID = HE.EDUCATION_ID
AND HE.PARTY_ID = HP1.PARTY_ID
AND HE.SCHOOL_PARTY_ID = HP2.PARTY_ID
AND ATR.OVERRIDE_ID = HP3.PARTY_ID(+)
AND ATR.ENTERED_GS_ID = CC1.CODE_ID
AND ATR.TRANSCRIPT_SOURCE = CC2.CODE_ID
AND ATR.CONV_GS_ID = CC3.CODE_ID WITH READ ONLY