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]

Table: IGS_PS_OFR_PAT

Product:	IGS - Student System
Description:	This entity describes the offering pattern of a program offering option. This is related to a calendar instance, nominating when each option is available.
Implementation/DBA Data:	IGS.IGS_PS_OFR_PAT

Primary Key: IGS_PS_OFR_PAT_PK

COURSE_CD
VERSION_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER
LOCATION_CD
ATTENDANCE_MODE
ATTENDANCE_TYPE

Primary Key: IGS_PS_OFR_PAT_UK1

COP_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_PS_OFR_PAT	IGS_PS_OFR_INST	IGS_PS_OFR_PAT.COURSE_CD IGS_PS_OFR_PAT.VERSION_NUMBER IGS_PS_OFR_PAT.CAL_TYPE IGS_PS_OFR_PAT.CI_SEQUENCE_NUMBER
IGS_PS_OFR_PAT	IGS_PS_OFR_OPT_ALL	IGS_PS_OFR_PAT.COURSE_CD IGS_PS_OFR_PAT.VERSION_NUMBER IGS_PS_OFR_PAT.CAL_TYPE IGS_PS_OFR_PAT.LOCATION_CD IGS_PS_OFR_PAT.ATTENDANCE_MODE IGS_PS_OFR_PAT.ATTENDANCE_TYPE
IGS_PS_OFR_PAT	IGS_PS_OFR_OPT_ALL	IGS_PS_OFR_PAT.COO_ID
IGS_PS_OFR_PAT	IGS_AS_GRD_SCHEMA	IGS_PS_OFR_PAT.GRADING_SCHEMA_CD IGS_PS_OFR_PAT.GS_VERSION_NUMBER
IGS_PS_OFR_PAT	HZ_PARTIES	IGS_PS_OFR_PAT.ADM_CONTACT_PERSON_ID
IGS_PS_OFR_PAT_NOTE	IGS_PS_OFR_PAT	IGS_PS_OFR_PAT_NOTE.COURSE_CD IGS_PS_OFR_PAT_NOTE.VERSION_NUMBER IGS_PS_OFR_PAT_NOTE.CAL_TYPE IGS_PS_OFR_PAT_NOTE.CI_SEQUENCE_NUMBER IGS_PS_OFR_PAT_NOTE.LOCATION_CD IGS_PS_OFR_PAT_NOTE.ATTENDANCE_MODE IGS_PS_OFR_PAT_NOTE.ATTENDANCE_TYPE
IGS_PS_OFR_PAT_NOTE	IGS_PS_OFR_PAT	IGS_PS_OFR_PAT_NOTE.COP_ID