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_OR_REL_PS_TYPE

Product:	IGS - Student System (Obsolete)
Description:	This table contains the course type restrictions used in the organization unit relationship for the purposes of committee structures used within Progression and in future to be used in other areas.
Implementation/DBA Data:	Not implemented in this database

Primary Key: IGS_OR_REL_PS_TYPE_PK

PARENT_ORG_UNIT_CD
PARENT_START_DT
CHILD_ORG_UNIT_CD
CHILD_START_DT
OUR_CREATE_DT
COURSE_TYPE

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_OR_REL_PS_TYPE	IGS_PS_TYPE_ALL	IGS_OR_REL_PS_TYPE.COURSE_TYPE
IGS_OR_REL_PS_TYPE	IGS_OR_UNIT_REL	IGS_OR_REL_PS_TYPE.PARENT_ORG_UNIT_CD IGS_OR_REL_PS_TYPE.PARENT_START_DT IGS_OR_REL_PS_TYPE.CHILD_ORG_UNIT_CD IGS_OR_REL_PS_TYPE.CHILD_START_DT IGS_OR_REL_PS_TYPE.OUR_CREATE_DT
IGS_OR_REL_PS_TYPE	%	IGS_OR_REL_PS_TYPE.PARENT_ORG_UNIT_CD IGS_OR_REL_PS_TYPE.PARENT_START_DT IGS_OR_REL_PS_TYPE.CHILD_ORG_UNIT_CD IGS_OR_REL_PS_TYPE.CHILD_START_DT IGS_OR_REL_PS_TYPE.OUR_CREATE_DT