[Home] [Help]
View: IGS_PR_ACAD_YEAR_V
Product: | IGS - Student System (Obsolete) |
Description: | This view contains the details of a Student Program Attempt within a Year of Program with earned credit point values. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT P.PARTY_NUMBER PERSON_NUMBER
, SPA.PERSON_ID
, SPA.COURSE_CD
, US.UNIT_SET_CD
, US.VERSION_NUMBER UNIT_SET_CD_VERSION
, HES.GRAD_SCH_GRADE
, HES.MARK
, SUM(NVL(IGS_PR_ACAD_DETAILS.GET_SUA_EARNED_CP( SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.UNIT_ATTEMPT_STATUS
, NULL
, SUA.UOO_ID)
, 0)) EARNED_CP
FROM HZ_PARTIES P
, IGS_EN_STDNT_PS_ATT SPA
, IGS_EN_SU_ATTEMPT SUA
, IGS_AS_SU_SETATMPT SUSA
, IGS_EN_UNIT_SET US
, IGS_EN_UNIT_SET_CAT USC
, IGS_HE_EN_SUSA HES
WHERE P.PARTY_ID = SUA.PERSON_ID
AND SUA.PERSON_ID = SPA.PERSON_ID
AND SUA.COURSE_CD = SPA.COURSE_CD
AND SPA.PERSON_ID = SUSA.PERSON_ID
AND SPA.COURSE_CD = SUSA.COURSE_CD
AND (IGS_EN_GEN_015.GET_EFFECTIVE_CENSUS_DATE( NULL
, NULL
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER) BETWEEN SUSA.SELECTION_DT
AND NVL(SUSA.RQRMNTS_COMPLETE_DT
, NVL(SUSA.END_DT
, FND_DATE.CANONICAL_TO_DATE('9999/12/31'))))
AND SUSA.UNIT_SET_CD = US.UNIT_SET_CD
AND US.UNIT_SET_CAT = USC.UNIT_SET_CAT
AND USC.S_UNIT_SET_CAT = 'PRENRL_YR'
AND SUSA.PERSON_ID = HES.PERSON_ID(+)
AND SUSA.COURSE_CD = HES.COURSE_CD(+)
AND SUSA.UNIT_SET_CD = HES.UNIT_SET_CD(+)
AND SUSA.US_VERSION_NUMBER = HES.US_VERSION_NUMBER(+)
AND SUSA.SEQUENCE_NUMBER = HES.SEQUENCE_NUMBER(+) GROUP BY P.PARTY_NUMBER
, SPA.PERSON_ID
, SPA.COURSE_CD
, US.UNIT_SET_CD
, US.VERSION_NUMBER
, HES.GRAD_SCH_GRADE
, HES.MARK
Columns
Name |
PERSON_NUMBER |
PERSON_ID |
COURSE_CD |
UNIT_SET_CD |
UNIT_SET_CD_VERSION |
GRAD_SCH_GRADE |
MARK |
EARNED_CP |