FND Design Data [Home] [Help]

Table: IGS_ST_GVTSEMLOAD_OV

Product: IGS - Student System (Obsolete)
Description: This table describes the link between a government report semester and load from specific teaching periods. This link is made to the relationship between a teaching period and a load calendar instance to ensure consistency across all load
Implementation/DBA Data: Not implemented in this database
Primary Key: GSLOV_UK
  1. ColumnSUBMISSION_YR
  2. ColumnSUBMISSION_NUMBER
  3. ColumnCAL_TYPE
  4. ColumnCI_SEQUENCE_NUMBER
  5. ColumnTEACH_CAL_TYPE
Primary Key: IGS_ST_GVTSEMLOAD_OV_PK
  1. ColumnSUBMISSION_YR
  2. ColumnSUBMISSION_NUMBER
  3. ColumnGOVT_SEMESTER
  4. ColumnCAL_TYPE
  5. ColumnCI_SEQUENCE_NUMBER
  6. ColumnTEACH_CAL_TYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_ST_GVTSEMLOAD_OV FK Joins to TableIGS_ST_DFT_LOAD_APPO IGS_ST_GVTSEMLOAD_OV.CAL_TYPE
IGS_ST_GVTSEMLOAD_OV.CI_SEQUENCE_NUMBER
IGS_ST_GVTSEMLOAD_OV.TEACH_CAL_TYPE
IGS_ST_GVTSEMLOAD_OV FK Joins to TableIGS_ST_GOVT_SEMESTER IGS_ST_GVTSEMLOAD_OV.SUBMISSION_YR
IGS_ST_GVTSEMLOAD_OV.SUBMISSION_NUMBER
IGS_ST_GVTSEMLOAD_OV.GOVT_SEMESTER