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: IGSFV_PGM_OFR_PATTERN_ADM_PERD

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT COP.COURSE_CD
, COP.VERSION_NUMBER
, PSV.TITLE
, COP.CAL_TYPE
, COP.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, COP.LOCATION_CD
, L.DESCRIPTION
, COP.ATTENDANCE_MODE
, ATM.DESCRIPTION
, COP.ATTENDANCE_TYPE
, ATT.DESCRIPTION
, COP.COO_ID
, '_LA:COP.OFFERED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:COP.ENTRY_POINT_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APAPC.ADM_CAL_TYPE
, APAPC.ADM_CI_SEQUENCE_NUMBER
, CI1.DESCRIPTION
, APAPC.ADMISSION_CAT
, AC.DESCRIPTION
, '_LA:APAPC.S_ADMISSION_PROCESS_TYPE:IGS_LOOKUP_VALUES:ADMISSION_PROCESS_TYPE:MEANING'
, COP.CREATED_BY
, COP.CREATION_DATE
, COP.LAST_UPDATED_BY
, COP.LAST_UPDATE_DATE
FROM IGS_PS_OFR_PAT COP
, IGS_CA_INST_REL CIR
, IGS_PS_VER_ALL PSV
, IGS_AD_PRD_AD_PRC_CA APAPC
, IGS_AD_LOCATION_ALL L
, IGS_EN_ATD_MODE_ALL ATM
, IGS_EN_ATD_TYPE_ALL ATT
, IGS_AD_CAT_ALL AC
, IGS_CA_INST_ALL CI
, IGS_CA_INST_ALL CI1
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 = PSV.COURSE_CD
AND COP.VERSION_NUMBER = PSV.VERSION_NUMBER
AND COP.CAL_TYPE = CI.CAL_TYPE
AND COP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND APAPC.ADM_CAL_TYPE = CI1.CAL_TYPE
AND APAPC.ADM_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER
AND APAPC.ADMISSION_CAT = AC.ADMISSION_CAT
AND COP.ATTENDANCE_MODE = ATM.ATTENDANCE_MODE
AND COP.ATTENDANCE_TYPE = ATT.ATTENDANCE_TYPE
AND COP.LOCATION_CD = L.LOCATION_CD
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' WITH READ ONLY

Columns

Name
PROGRAM_CODE
PROGRAM_VERSION_NUMBER
PROGRAM_TITLE
ACADEMIC_CALENDAR_TYPE
ACADEMIC_CI_SEQUENCE_NUMBER
ACADEMIC_CALENDAR_DESC
LOCATION_CODE
LOCATION_DESC
ATTENDANCE_MODE
ATTENDANCE_MODE_DESC
ATTENDANCE_TYPE
ATTENDANCE_TYPE_DESC
PROG_OFFERING_OPTION_ID
"_LA:OFFERED_IND_FLAG"
"_LA:ENTRY_POINT_IND"
ADMISSION_CALENDAR_TYPE
ADMISSION_CI_SEQUENCE_NUMBER
ADMISSION_CALENDAR_DESC
ADMISSION_CATEGORY
ADMISSION_CATEGORY_DESC
"_LA:ADM_PROCESS_TYPE_MEANING"
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE