Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Student Program Attempts Term View |
Implementation/DBA Data: | Not implemented in this database |
SELECT SPAT.ROWID
, SPAT. TERM_RECORD_ID
, SPAT.PERSON_ID
, SPAT.PROGRAM_CD
, SPAT.PROGRAM_VERSION
, CV.COURSE_TYPE CAREER
, SPAT.COO_ID
, SPAT.ACAD_CAL_TYPE
, SPAT.TERM_CAL_TYPE
, SPAT.TERM_SEQUENCE_NUMBER
, CI.DESCRIPTION DESCRIPTION_TERM
, SPAT.KEY_PROGRAM_FLAG
, SPAT.LOCATION_CD
, SPAT.ATTENDANCE_MODE
, SPAT.ATTENDANCE_TYPE
, SPAT.FEE_CAT
, SPAT.CLASS_STANDING_ID
, PRCS.CLASS_STANDING
, CI.START_DT
, CI.END_DT
, SPAT.PLAN_SHT_STATUS
, SPAT.CREATED_BY
, SPAT.CREATION_DATE
, SPAT.LAST_UPDATED_BY
, SPAT.LAST_UPDATE_DATE
, SPAT.LAST_UPDATE_LOGIN
, SPAT.REQUEST_ID
, SPAT.PROGRAM_APPLICATION_ID
, SPAT.PROGRAM_ID
, SPAT.PROGRAM_UPDATE_DATE
, SPAT.ATTRIBUTE_CATEGORY
, SPAT.ATTRIBUTE1
, SPAT.ATTRIBUTE2
, SPAT.ATTRIBUTE3
, SPAT.ATTRIBUTE4
, SPAT.ATTRIBUTE5
, SPAT.ATTRIBUTE6
, SPAT.ATTRIBUTE7
, SPAT.ATTRIBUTE8
, SPAT.ATTRIBUTE9
, SPAT.ATTRIBUTE10
, SPAT.ATTRIBUTE11
, SPAT.ATTRIBUTE12
, SPAT.ATTRIBUTE13
, SPAT.ATTRIBUTE14
, SPAT.ATTRIBUTE15
, SPAT.ATTRIBUTE16
, SPAT.ATTRIBUTE17
, SPAT.ATTRIBUTE18
, SPAT.ATTRIBUTE19
, SPAT.ATTRIBUTE20
FROM IGS_EN_SPA_TERMS SPAT
, IGS_CA_INST CI
, IGS_PS_VER CV
, IGS_PR_CLASS_STD PRCS
WHERE SPAT.TERM_CAL_TYPE = CI.CAL_TYPE
AND SPAT.TERM_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND CV. COURSE_CD = SPAT.PROGRAM_CD
AND CV.VERSION_NUMBER = SPAT.PROGRAM_VERSION
AND PRCS.IGS_PR_CLASS_STD_ID(+) = SPAT.CLASS_STANDING_ID