Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Contains Person transcript details |
Implementation/DBA Data: | Not implemented in this database |
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