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_UC_CRSE_DETS

Product:	IGS - Student System
Description:	Holds additional details for a course that are updated to UCAS views Also holds details of courses run by other institutes , to synchronize with UCAS views 'cvCourse','uvCourse'.
Implementation/DBA Data:	IGS.IGS_UC_CRSE_DETS

Primary Key: IGS_UC_CRSE_DETS_PK

SYSTEM_CODE
UCAS_PROGRAM_CODE
INSTITUTE
UCAS_CAMPUS

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_UC_CRSE_DETS	IGS_UC_DEFAULTS	IGS_UC_CRSE_DETS.SYSTEM_CODE
IGS_UC_APP_CHOICES	IGS_UC_CRSE_DETS	IGS_UC_APP_CHOICES.SYSTEM_CODE IGS_UC_APP_CHOICES.UCAS_PROGRAM_CODE IGS_UC_APP_CHOICES.INSTITUTE_CODE IGS_UC_APP_CHOICES.CAMPUS
IGS_UC_APP_CLR_RND	IGS_UC_CRSE_DETS	IGS_UC_APP_CLR_RND.SYSTEM_CODE IGS_UC_APP_CLR_RND.UCAS_PROGRAM_CODE IGS_UC_APP_CLR_RND.INSTITUTION IGS_UC_APP_CLR_RND.UCAS_CAMPUS
IGS_UC_CRSE_KEYWRDS	IGS_UC_CRSE_DETS	IGS_UC_CRSE_KEYWRDS.SYSTEM_CODE IGS_UC_CRSE_KEYWRDS.UCAS_PROGRAM_CODE IGS_UC_CRSE_KEYWRDS.INSTITUTE IGS_UC_CRSE_KEYWRDS.UCAS_CAMPUS
IGS_UC_CRSE_VAC_OPS	IGS_UC_CRSE_DETS	IGS_UC_CRSE_VAC_OPS.SYSTEM_CODE IGS_UC_CRSE_VAC_OPS.UCAS_PROGRAM_CODE IGS_UC_CRSE_VAC_OPS.INSTITUTE IGS_UC_CRSE_VAC_OPS.UCAS_CAMPUS