[Home] [Help]
View: IGSFV_PROGRAM_OFFERINGS
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This is a full view, which describes an offerings of a university program within a calendar type. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT OFR.COURSE_CD
, OFR.VERSION_NUMBER
, OFR.CAL_TYPE
, '_DF:IGS:IGS_PS_PRG_OFR_FLEX:OFR'
, VE.TITLE
, TY.DESCRIPTION
, OFR.CREATED_BY
, OFR.CREATION_DATE
, OFR.LAST_UPDATED_BY
, OFR.LAST_UPDATE_DATE
FROM IGS_PS_OFR_ALL OFR
, IGS_CA_TYPE TY
, IGS_PS_VER_ALL VE
WHERE OFR.CAL_TYPE = TY.CAL_TYPE
AND OFR.COURSE_CD = VE.COURSE_CD
AND OFR.VERSION_NUMBER =VE.VERSION_NUMBER WITH READ ONLY
Columns
| Name |
| PROGRAM_CODE |
| VERSION_NUMBER |
| CALENDAR_TYPE |
| "_DF" |
| PROGRAM_TITLE |
| CALENDAR_DESCRIPTION |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |