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_PS_OFR_PAT_APCOO_V

Product:	IGS - Student System (Obsolete)
Description:	This view is used to display for the admission period program offering option - Program Offering LOV in form ADMF2M61.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT COP.COURSE_CD
, COP.VERSION_NUMBER
, COP.CAL_TYPE
, COP.LOCATION_CD
, COP.ATTENDANCE_MODE
, COP.ATTENDANCE_TYPE
, APAPC.ADM_CAL_TYPE
, APAPC.ADM_CI_SEQUENCE_NUMBER
, APAPC.ADMISSION_CAT
, APAPC.S_ADMISSION_PROCESS_TYPE
, COP.CREATED_BY
, COP.CREATION_DATE
, COP.LAST_UPDATED_BY
, COP.LAST_UPDATE_DATE
, COP.LAST_UPDATE_LOGIN
FROM IGS_PS_OFR_PAT COP
, IGS_CA_INST_REL CIR
, IGS_AD_PRD_AD_PRC_CA APAPC
WHERE CIR.SUP_CAL_TYPE = COP.CAL_TYPE
AND CIR.SUP_CI_SEQUENCE_NUMBER = COP.CI_SEQUENCE_NUMBER
AND APAPC.ADM_CAL_TYPE = CIR.SUB_CAL_TYPE
AND APAPC.ADM_CI_SEQUENCE_NUMBER = CIR.SUB_CI_SEQUENCE_NUMBER
AND ((COP.COURSE_CD
, COP.VERSION_NUMBER
, COP.CAL_TYPE) IN (SELECT COOAC.COURSE_CD
, COOAC.VERSION_NUMBER
, COOAC.CAL_TYPE FROM IGS_PS_OF_OPT_AD_CAT COOAC WHERE COOAC.COURSE_CD = COP.COURSE_CD
AND COOAC.VERSION_NUMBER = COP.VERSION_NUMBER
AND COOAC.CAL_TYPE = COP.CAL_TYPE
AND COOAC.LOCATION_CD = COP.LOCATION_CD
AND COOAC.ATTENDANCE_MODE = COP.ATTENDANCE_MODE
AND COOAC.ATTENDANCE_TYPE = COP.ATTENDANCE_TYPE
AND COOAC.ADMISSION_CAT = APAPC.ADMISSION_CAT))
AND COP.OFFERED_IND = 'Y'
AND COP.ENTRY_POINT_IND = 'Y'

Columns

Name
COURSE_CD
VERSION_NUMBER
ACAD_CAL_TYPE
LOCATION_CD
ATTENDANCE_MODE
ATTENDANCE_TYPE
ADM_CAL_TYPE
ADM_CI_SEQUENCE_NUMBER
ADMISSION_CAT
S_ADMISSION_PROCESS_TYPE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN