FND Design Data [Home] [Help]

Table: IGS_UC_CRSE_KEYWRDS

Product: IGS - Student System (Obsolete)
Description: Holds the keywords linked to a course during the UCAS admission cycle . It synchronizes with UCAS view 'uvCourseKeyword'
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_UC_CRSE_KEYWRDS_PK
  1. ColumnCRSE_KEYWORD_ID
Primary Key: IGS_UC_CRSE_KEYWRDS_U1
  1. ColumnPREFERENCE
  2. ColumnINSTITUTE
  3. ColumnUCAS_PROGRAM_CODE
  4. ColumnOPTION_CODE
  5. ColumnSYSTEM_CODE
  6. ColumnUCAS_CAMPUS
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_UC_CRSE_KEYWRDS FK Joins to TableIGS_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_KEYWRDS FK Joins to TableIGS_UC_REF_KEYWORDS IGS_UC_CRSE_KEYWRDS.KEYWORD