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_PR_ACAD_TRANS_CREDIT_V

Product:	IGS - Student System (Obsolete)
Description:	This view contains the details of credit granted through advanced standing based on the Person Transcript Units structure. The credit is shown only as an aggregated summary figure.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SPA.PERSON_ID
, PE.PARTY_NUMBER PERSON_NUMBER
, SPA.COURSE_CD PROGRAM_CD
, AHV.INSTITUTION_CODE
, AHV.INSTITUTION_NAME
, AHV.INSTITUTION_TYPE
, HZ.CITY INSTITUTION_CITY
, HZ.STATE INSTITUTION_STATE
, HZ.POSTAL_CODE INSTITUTION_POSTAL_CODE
, AHV.START_DATE
, AHV.END_DATE
, AHV.PROGRAM_TYPE_ATTEMPTED
, AHV.PROGRAM_TYPE_EARNED
, AHV.PROGRAM_CODE
, AHV.TITLE
, AHV.EDUCATION_ID
, SUM(ADV.CREDIT_POINTS) CREDIT_POINTS
FROM IGS_EN_STDNT_PS_ATT_ALL SPA
, HZ_PARTIES PE
, HZ_PARTIES HZ
, IGS_AD_ACAD_HISTORY_V AHV
, ( SELECT ASU.PERSON_ID
, ATH.EDUCATION_ID
, ASU.AS_COURSE_CD
, ASU.ACHIEVABLE_CREDIT_POINTS CREDIT_POINTS
FROM IGS_AV_STND_UNIT_ALL ASU
, IGS_AD_TERM_UNITDTLS ATUD
, IGS_AD_TERM_DETAILS ATD
, IGS_AD_TRANSCRIPT ATH
WHERE ASU.PREV_UNIT_CD IS NOT NULL
AND ASU.S_ADV_STND_GRANTING_STATUS = 'GRANTED'
AND ASU.S_ADV_STND_RECOGNITION_TYPE = 'CREDIT'
AND ATUD.UNIT_DETAILS_ID = ASU.UNIT_DETAILS_ID
AND ATD.TERM_DETAILS_ID = ATUD.TERM_DETAILS_ID
AND ATH.TRANSCRIPT_ID = ATD.TRANSCRIPT_ID UNION ALL SELECT ASUL.PERSON_ID
, ATH.EDUCATION_ID
, ASUL.AS_COURSE_CD
, ASUL.CREDIT_POINTS
FROM IGS_AV_STND_UNIT_LVL_ALL ASUL
, IGS_AD_TERM_UNITDTLS ATUD
, IGS_AD_TERM_DETAILS ATD
, IGS_AD_TRANSCRIPT ATH
WHERE ASUL.PREV_UNIT_CD IS NOT NULL
AND ASUL.S_ADV_STND_GRANTING_STATUS = 'GRANTED'
AND ATUD.UNIT_DETAILS_ID = ASUL.UNIT_DETAILS_ID
AND ATD.TERM_DETAILS_ID = ATUD.TERM_DETAILS_ID
AND ATH.TRANSCRIPT_ID = ATD.TRANSCRIPT_ID ) ADV
, IGS_PE_HZ_PARTIES IPZ
WHERE AHV.PERSON_ID = SPA.PERSON_ID
AND PE.PARTY_ID = SPA.PERSON_ID
AND ADV.PERSON_ID = SPA.PERSON_ID
AND ADV.EDUCATION_ID = AHV.EDUCATION_ID
AND IPZ.OSS_ORG_UNIT_CD(+) = AHV.INSTITUTION_CODE
AND IPZ.PARTY_ID = HZ.PARTY_ID(+)
AND ADV.AS_COURSE_CD = SPA.COURSE_CD GROUP BY SPA.PERSON_ID
, PE.PARTY_NUMBER
, SPA.COURSE_CD
, AHV.INSTITUTION_CODE
, AHV.INSTITUTION_NAME
, AHV.INSTITUTION_TYPE
, HZ.CITY
, HZ.STATE
, HZ.POSTAL_CODE
, AHV.START_DATE
, AHV.END_DATE
, AHV.PROGRAM_TYPE_ATTEMPTED
, AHV.PROGRAM_TYPE_EARNED
, AHV.PROGRAM_CODE
, AHV.TITLE
, AHV.EDUCATION_ID

Columns

Name
PERSON_ID
PERSON_NUMBER
PROGRAM_CD
INSTITUTION_CODE
INSTITUTION_NAME
INSTITUTION_TYPE
INSTITUTION_CITY
INSTITUTION_STATE
INSTITUTION_POSTAL_CODE
START_DATE
END_DATE
PROGRAM_TYPE_ATTEMPTED
PROGRAM_TYPE_EARNED
PROGRAM_CODE
TITLE
EDUCATION_ID
CREDIT_POINTS