Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity describes the offerings for a program calendar containing details of Program Code, calendar instance details and minimum / guaranteed assessment score. |
Implementation/DBA Data: | Not implemented in this database |
SELECT UOP.COURSE_CD PROGRAM_CODE
, UOP.VERSION_NUMBER
, UOP.CAL_TYPE
, UOP.LOCATION_CD
, UOP.ATTENDANCE_MODE
, UOP.ATTENDANCE_TYPE
, UOP.FORCED_LOCATION_IND
, UOP.FORCED_ATT_MODE_IND
, UOP.FORCED_ATT_TYPE_IND
, UOP.TIME_LIMITATION
, UOP.ENR_OFFICER_PERSON_ID
, UOP.PROGRAM_LENGTH PROGRAM_LENGTH
, '_LA:PROGRAM_LENGTH_MEASUREMENT:IGS_LOOKUP_VALUES:IGS_PS_PROGRAM_LENGTH_MESR:MEANING' "_LA:PROGRAM_LENGTH_MEASURE"
, UOP.DELETE_FLAG DELETE_FLAG
, PSV.TITLE PROGRAM_TITLE
, CTY.DESCRIPTION CALENDAR_DESCRIPTION
, LOC.DESCRIPTION LOCATION_DESCRIPTION
, ATD.DESCRIPTION ATTENDANCE_TYPE_DESC
, ATM.DESCRIPTION ATTENDANCE_MODE_DESC
, UOP.COO_ID
, UOP.CREATED_BY
, UOP.CREATION_DATE
, UOP.LAST_UPDATED_BY
, UOP.LAST_UPDATE_DATE
FROM IGS_PS_OFR_OPT_ALL UOP
, IGS_PS_VER_ALL PSV
, IGS_CA_TYPE CTY
, IGS_AD_LOCATION_ALL LOC
, IGS_EN_ATD_TYPE_ALL ATD
, IGS_EN_ATD_MODE_ALL ATM
WHERE UOP.COURSE_CD = PSV.COURSE_CD
AND UOP.VERSION_NUMBER = PSV.VERSION_NUMBER
AND UOP.CAL_TYPE = CTY.CAL_TYPE
AND UOP.LOCATION_CD = LOC.LOCATION_CD
AND UOP.ATTENDANCE_TYPE=ATD.ATTENDANCE_TYPE
AND UOP.ATTENDANCE_MODE=ATM.ATTENDANCE_MODE WITH READ ONLY