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_V

Product:	IGS - Student System (Obsolete)
Description:	View of the program offering pattern table. Required for program offering pattern LOV in ADMF1200
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT COP.COURSE_CD
, COP.VERSION_NUMBER
, COP.CAL_TYPE
, COP.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, CI.CAL_STATUS
, COP.LOCATION_CD
, COP.ATTENDANCE_MODE
, COP.ATTENDANCE_TYPE
, COP.ENTRY_POINT_IND
, COP.ADM_CONTACT_PERSON_ID
, COP.ADM_ASS_OFFICER_PERSON_ID
, CRV.TITLE
, CRV.COURSE_STATUS
, CRV.COURSE_TYPE
, CRV.STD_FT_COMPLETION_TIME
, CRV.STD_PT_COMPLETION_TIME
, CRV.CREDIT_POINTS_REQUIRED
, CRV.STD_ANNUAL_LOAD
, CRV.COURSE_TOTAL_EFTSU
, 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 CI
, IGS_PS_VER CRV
WHERE COP.CAL_TYPE = CI.CAL_TYPE
AND COP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND CRV.COURSE_CD = COP.COURSE_CD
AND CRV.VERSION_NUMBER = COP.VERSION_NUMBER

Columns

Name
COURSE_CD
VERSION_NUMBER
ACAD_CAL_TYPE
ACAD_CI_SEQUENCE_NUMBER
ALTERNATE_CODE
START_DT
END_DT
CAL_STATUS
LOCATION_CD
ATTENDANCE_MODE
ATTENDANCE_TYPE
ENTRY_POINT_IND
ADM_CONTACT_PERSON_ID
ADM_ASS_OFFICER_PERSON_ID
COURSE_TITLE
COURSE_STATUS
COURSE_TYPE
STD_FT_COMPLETION_TIME
STD_PT_COMPLETION_TIME
CREDIT_POINTS_REQUIRED
STD_ANNUAL_LOAD
COURSE_TOTAL_EFTSU
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN