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_DA_XML_ORIGINALCOURSE_V

Product:	IGS - Student System (Obsolete)
Description:	XML element OriginalCourseType (child of CourseType). Gets the original Unit/(course) information for Units Transferred from other institutions.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT IGS_DA_XML_PKG.GET_COURSE_ABBR_NUM(ADTU.UNIT
, 'A')
, IGS_DA_XML_PKG.GET_COURSE_ABBR_NUM(ADTU.UNIT
, 'N')
, ADTU.UNIT_NAME
, ADTD.TERM
, ADTU.CP_ATTEMPTED
, ADTU.CP_EARNED
, DECODE(ADTU.CP_EARNED
, TO_NUMBER('')
, TO_NUMBER('')
, ADTU.CP_EARNED)
, ADTU.UNIT_GRADE_POINTS
, ADTU.GRADE
, ''
, 'N'
, ''
, ''
, ''
, DR.BATCH_ID
, ASU.PERSON_ID
, ASU.EXEMPTION_INSTITUTION_CD
, ASU.AV_STND_UNIT_ID
FROM IGS_AD_TERM_DETAILS ADTD
, IGS_AD_TERM_UNITDTLS ADTU
, IGS_AV_STND_UNIT_ALL ASU
, IGS_DA_RQST DR
WHERE ASU.UNIT_DETAILS_ID = ADTU.UNIT_DETAILS_ID
AND ADTD.TERM_DETAILS_ID = ADTU.TERM_DETAILS_ID

Columns

Name
COURSE_SUBJECT_ABBREVIATION
COURSE_NUMBER
COURSE_TITLE
COURSE_SESSION
COURSE_CREDIT_VALUE
COURSE_CREDIT_EARNED
COURSE_GPA_CREDIT_HOURS
COURSE_QUALITY_POINTS_EARNED
COURSE_ACADEMIC_GRADE
COURSE_OUTCOME
COURSE_REPEAT_INDICATOR
COURSE_PSUEDO_CODE
COURSE_ATTRIBUTE_CODE
COURSE_FLAG_CODE
BATCH_ID
PERSON_ID
INSTITUTION_CD
AV_STND_UNIT_ID