Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describs Advance Standings |
Implementation/DBA Data: | Not implemented in this database |
SELECT HGP.PARTY_NUMBER
, HGP.PARTY_NAME
, AVS.COURSE_CD
, AVS.VERSION_NUMBER
, CRV.TITLE
, AVS.EXEMPTION_INSTITUTION_CD
, HGP1.PARTY_NAME
, AVS.TOTAL_EXMPTN_APPROVED
, AVS.TOTAL_EXMPTN_GRANTED
, AVS.TOTAL_EXMPTN_PERC_GRNTD
, AVS.PERSON_ID
, AVS.CREATED_BY
, AVS.CREATION_DATE
, AVS.LAST_UPDATED_BY
, AVS.LAST_UPDATE_DATE
FROM IGS_AV_ADV_STANDING_ALL AVS
, HZ_PARTIES HGP
, IGS_PS_VER_ALL CRV
, HZ_PARTIES HGP1
, IGS_PE_HZ_PARTIES IPZ
WHERE AVS.PERSON_ID = HGP.PARTY_ID
AND AVS.COURSE_CD = CRV.COURSE_CD
AND AVS.VERSION_NUMBER = CRV.VERSION_NUMBER
AND AVS. EXEMPTION_INSTITUTION_CD = IPZ.OSS_ORG_UNIT_CD
AND IPZ.PARTY_ID = HGP1.PARTY_ID WITH READ ONLY