Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT T.ROWID ROW_ID
, T.TRANSCRIPT_ID TRANSCRIPT_ID
, T.EDUCATION_ID EDUCATION_ID
, T.TRANSCRIPT_STATUS TRANSCRIPT_STATUS
, L1.MEANING TRANSCRIPT_STATUS_MEANING
, T.TRANSCRIPT_SOURCE TRANSCRIPT_SOURCE
, CC3.NAME TRANSCRIPT_SOURCE_CODE
, T.TRANSCRIPT_TYPE TRANSCRIPT_TYPE
, L3.MEANING TRANSCRIPT_TYPE_MEANING
, T.DATE_OF_RECEIPT DATE_OF_RECEIPT
, T.TERM_TYPE TERM_TYPE
, L2.MEANING TERM_TYPE_MEANING
, T.RANK_IN_CLASS RANK_IN_CLASS
, T.CLASS_SIZE CLASS_SIZE
, T.WEIGHTED_RANK WEIGHTED_RANK
, T.APPROXIMATE_RANK APPROXIMATE_RANK
, T.PERCENTILE_RANK PERCENTILE_RANK
, T.DECILE_RANK DECILE_RANK
, T.QUARTILE_RANK QUARTILE_RANK
, T.QUINTILE_RANK QUINTILE_RANK
, T.ENTERED_GPA ENTERED_GPA
, T.ENTERED_GS_ID ENTERED_GS_ID
, CC1.NAME ENTERED_GRADING_SCALE
, T.CONV_GPA CONV_GPA
, T.CONV_GS_ID CONV_GS_ID
, CC2.NAME CONV_GRADING_SCALE
, T.CREATED_BY CREATED_BY
, T.CREATION_DATE CREATION_DATE
, T.LAST_UPDATED_BY LAST_UPDATED_BY
, T.LAST_UPDATE_DATE LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, T.REQUEST_ID REQUEST_ID
, T.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, T.PROGRAM_ID PROGRAM_ID
, T.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, T.OVERRIDE OVERRIDE
, T.OVERRIDE_ID OVERRIDE_ID
, T.OVERRIDE_DATE OVERRIDE_DATE
, T.DATE_OF_ISSUE DATE_OF_ISSUE
, T. CORE_CURRICULUM_VALUE CORE_CURRICULUM_VALUE FROM IGS_AD_TRANSCRIPT T
, IGS_LOOKUPS_VIEW L1
, IGS_LOOKUPS_VIEW L2
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
, IGS_AD_CODE_CLASSES CC3
, IGS_LOOKUPS_VIEW L3
WHERE T.TRANSCRIPT_STATUS = L1.LOOKUP_CODE AND L1.LOOKUP_TYPE = 'TRANSCRIPT_STATUS' AND T.TERM_TYPE = L2.LOOKUP_CODE AND L2.LOOKUP_TYPE = 'TERM_TYPE' AND T.ENTERED_GS_ID = CC1.CODE_ID AND T.CONV_GS_ID = CC2.CODE_ID AND T.TRANSCRIPT_SOURCE = CC3.CODE_ID AND T.TRANSCRIPT_TYPE = L3.LOOKUP_CODE
AND L3.LOOKUP_TYPE = 'TRANSCRIPT_TYPE'