Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT OU.ROW_ID
, OU.ORG_UNIT_CD
, OU.START_DT
, PSPO.PRG_CAL_TYPE
, PSPO.PRG_CI_SEQUENCE_NUMBER
, PSPO.COURSE_TYPE
, ESPA.COURSE_CD
, ESPA.VERSION_NUMBER
, ESPA.LOCATION_CD
, ESPA.ATTENDANCE_MODE
, OU.CREATED_BY
, OU.CREATION_DATE
, OU.LAST_UPDATED_BY
, OU.LAST_UPDATE_DATE
, OU.LAST_UPDATE_LOGIN
FROM IGS_OR_UNIT OU
, IGS_PR_STDNT_PR_OU_V PSPO
, IGS_EN_STDNT_PS_ATT ESPA
WHERE OU.ORG_STATUS IN (SELECT OS.ORG_STATUS
FROM IGS_OR_STATUS OS
WHERE OS.S_ORG_STATUS = 'ACTIVE')
AND PSPO.COURSE_CD=ESPA.COURSE_CD
AND PSPO.VERSION_NUMBER=ESPA.VERSION_NUMBER
AND PSPO.PERSON_ID=ESPA.PERSON_ID