Product: | IGS - Student System |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGS_AD_ACAD_HISTORY_V |
SELECT HE.ROWID
, HE.EDUCATION_ID
, HE.PARTY_ID
, HE.SCHOOL_PARTY_ID
, DECODE (HE.SCHOOL_PARTY_ID
, NULL
, NULL
, (SELECT OSS_ORG_UNIT_CD
FROM IGS_PE_HZ_PARTIES
WHERE HE.SCHOOL_PARTY_ID = PARTY_ID) ) INSTITUTION_CODE
, NVL (DECODE (HE.SCHOOL_PARTY_ID
, NULL
, NULL
, (SELECT PARTY_NAME
FROM HZ_PARTIES
WHERE HE.SCHOOL_PARTY_ID = PARTY_ID) )
, HE.SCHOOL_ATTENDED_NAME ) INSTITUTION_NAME
, DECODE (HE.SCHOOL_PARTY_ID
, NULL
, NULL
, (SELECT OI_INSTITUTION_TYPE
FROM IGS_PE_HZ_PARTIES
WHERE HE.SCHOOL_PARTY_ID = PARTY_ID
AND INST_ORG_IND = 'I') ) INSTITUTION_TYPE
, DECODE (HE.SCHOOL_PARTY_ID
, NULL
, NULL
, (SELECT OI_INST_CONTROL_TYPE
FROM IGS_PE_HZ_PARTIES
WHERE HE.SCHOOL_PARTY_ID = PARTY_ID
AND INST_ORG_IND = 'I') ) INST_CONTROL_TYPE
, HAH.CURRENT_INST
, HAH.TRANSCRIPT_REQUIRED TRANSCRIPT_REQUIRED
, NULL
, NULL
, HE.COURSE_MAJOR
, DECODE (HE.COURSE_MAJOR
, NULL
, NULL
, (SELECT TITLE
FROM IGS_PS_VER
WHERE COURSE_CD||'/'||VERSION_NUMBER = HE.COURSE_MAJOR) ) TITLE
, HAH.COMMENTS
, HE.START_DATE_ATTENDED
, HE.LAST_DATE_ATTENDED
, HAH.PLANNED_COMPLETION_DATE
, NULL
, NULL
, HAH.RECALC_TOTAL_CP_ATTEMPTED
, HAH.RECALC_TOTAL_CP_EARNED
, HAH.RECALC_TOTAL_UNIT_GP
, HAH.RECALC_TOT_GPA_UTS_ATTEMPTED
, HAH.RECALC_INST_GPA
, HAH.RECALC_GRADING_SCALE_ID
, DECODE (HAH.RECALC_GRADING_SCALE_ID
, NULL
, NULL
, (SELECT NAME
FROM IGS_AD_CODE_CLASSES
WHERE HAH.RECALC_GRADING_SCALE_ID = CODE_ID) ) RECALC_GRADING_SCALE
, HAH.SELFREP_TOTAL_CP_ATTEMPTED
, HAH.SELFREP_TOTAL_CP_EARNED
, HAH.SELFREP_TOTAL_UNIT_GP
, HAH.SELFREP_TOT_GPA_UTS_ATTEMP
, HAH.SELFREP_INST_GPA
, HAH.SELFREP_GRADING_SCALE_ID
, DECODE (HAH.SELFREP_GRADING_SCALE_ID
, NULL
, NULL
, (SELECT NAME
FROM IGS_AD_CODE_CLASSES
WHERE HAH.SELFREP_GRADING_SCALE_ID = CODE_ID) ) SELFREP_GRADING_SCALE
, HAH.SELFREP_WEIGHTED_GPA
, HAH.SELFREP_RANK_IN_CLASS
, HAH.SELFREP_CLASS_SIZE
, HAH.SELFREP_WEIGHED_RANK
, HE.TYPE_OF_SCHOOL
, HAH.ATTRIBUTE_CATEGORY
, HAH.ATTRIBUTE1
, HAH.ATTRIBUTE2
, HAH.ATTRIBUTE3
, HAH.ATTRIBUTE4
, HAH.ATTRIBUTE5
, HAH.ATTRIBUTE6
, HAH.ATTRIBUTE7
, HAH.ATTRIBUTE8
, HAH.ATTRIBUTE9
, HAH.ATTRIBUTE10
, HAH.ATTRIBUTE11
, HAH.ATTRIBUTE12
, HAH.ATTRIBUTE13
, HAH.ATTRIBUTE14
, HAH.ATTRIBUTE15
, HAH.ATTRIBUTE16
, HAH.ATTRIBUTE17
, HAH.ATTRIBUTE18
, HAH.ATTRIBUTE19
, HAH.ATTRIBUTE20
, HE.CREATED_BY
, HE.CREATION_DATE
, HE.LAST_UPDATED_BY
, HE.LAST_UPDATE_DATE
, HE.LAST_UPDATE_LOGIN
, HE.REQUEST_ID
, HE.PROGRAM_APPLICATION_ID
, HE.PROGRAM_ID
, HE.PROGRAM_UPDATE_DATE
, HE.STATUS
, ( SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE HE.STATUS = LOOKUP_CODE
AND LOOKUP_TYPE = 'REGISTRY_STATUS'
AND VIEW_APPLICATION_ID = 222
AND SECURITY_GROUP_ID = 0
AND LANGUAGE = USERENV('LANG') ) STATUS_MEANING
, HE.OBJECT_VERSION_NUMBER
, HAH.DEGREE_ATTEMPTED
, HE.DEGREE_RECEIVED
FROM HZ_EDUCATION HE
, IGS_AD_HZ_ACAD_HIST HAH
WHERE HE.EDUCATION_ID = HAH.EDUCATION_ID(+)
AND HE.STATUS IN ('A'
, 'I')