eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_AV_STND_UNIT_CREDIT_V

Product:	IGS - Student System (Obsolete)
Description:	Describes the amount of credit granted by different institutions for advanced standing units and unit levels. It also indicates version number of the program against the advanced standing that is approved or granted.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ASU.PERSON_ID
, ASU.AS_COURSE_CD
, ASU.AS_VERSION_NUMBER
, ASU.S_ADV_STND_TYPE
, ASU.EXEMPTION_INSTITUTION_CD
, SUM(UV.ACHIEVABLE_CREDIT_POINTS) CREDIT
, ASU.CREATED_BY
, ASU.CREATION_DATE
, ASU.LAST_UPDATED_BY
, ASU.LAST_UPDATE_DATE
, ASU.LAST_UPDATE_LOGIN
, ASU.DEG_AUD_DETAIL_ID
FROM IGS_AV_STND_UNIT ASU
, IGS_PS_UNIT_VER UV
WHERE ASU.UNIT_CD = UV.UNIT_CD
AND ASU.VERSION_NUMBER = UV.VERSION_NUMBER
AND ASU.S_ADV_STND_RECOGNITION_TYPE = 'CREDIT' /*
AND ASU.CREDIT_PERCENTAGE = 100 */
AND ASU.S_ADV_STND_GRANTING_STATUS = 'GRANTED' GROUP BY ASU.PERSON_ID
, ASU.AS_COURSE_CD
, ASU.AS_VERSION_NUMBER
, ASU.S_ADV_STND_TYPE
, ASU.EXEMPTION_INSTITUTION_CD
, ASU.CREATED_BY
, ASU.CREATION_DATE
, ASU.LAST_UPDATED_BY
, ASU.LAST_UPDATE_DATE
, ASU.LAST_UPDATE_LOGIN
, ASU.DEG_AUD_DETAIL_ID UNION SELECT ASULE.PERSON_ID
, ASULE.AS_COURSE_CD
, ASULE.AS_VERSION_NUMBER
, ASULE.S_ADV_STND_TYPE
, ASULE.EXEMPTION_INSTITUTION_CD
, SUM(ASULE.CREDIT_POINTS)
, TO_NUMBER(ASULE.CREATED_BY)
, ASULE.CREATION_DATE
, TO_NUMBER(ASULE.LAST_UPDATED_BY)
, ASULE.LAST_UPDATE_DATE
, TO_NUMBER(ASULE.LAST_UPDATE_LOGIN)
, ASULE.DEG_AUD_DETAIL_ID
FROM IGS_AV_STND_UNIT_LVL ASULE
WHERE ASULE.S_ADV_STND_GRANTING_STATUS = 'GRANTED' GROUP BY ASULE.PERSON_ID
, ASULE.AS_COURSE_CD
, ASULE.AS_VERSION_NUMBER
, ASULE.S_ADV_STND_TYPE
, ASULE.EXEMPTION_INSTITUTION_CD
, ASULE.CREATED_BY
, ASULE.CREATION_DATE
, ASULE.LAST_UPDATED_BY
, ASULE.LAST_UPDATE_DATE
, ASULE.LAST_UPDATE_LOGIN
, ASULE.DEG_AUD_DETAIL_ID

Columns

Name
PERSON_ID
COURSE_CD
VERSION_NUMBER
S_ADV_STND_TYPE
EXEMPTION_INSTITUTION_CD
CREDIT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
DEG_AUD_DETAIL_ID