Table: IGS_ST_GVTSEMLOAD_OV

Product:	IGS - Student System
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:	IGS.IGS_ST_GVTSEMLOAD_OV

Primary Key: GSLOV_UK

1. SUBMISSION_YR
2. SUBMISSION_NUMBER
3. CAL_TYPE
4. CI_SEQUENCE_NUMBER
5. TEACH_CAL_TYPE

Primary Key: IGS_ST_GVTSEMLOAD_OV_PK

1. SUBMISSION_YR
2. SUBMISSION_NUMBER
3. GOVT_SEMESTER
4. CAL_TYPE
5. CI_SEQUENCE_NUMBER
6. TEACH_CAL_TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_ST_GVTSEMLOAD_OV		IGS_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		IGS_ST_GOVT_SEMESTER	IGS_ST_GVTSEMLOAD_OV.SUBMISSION_YR IGS_ST_GVTSEMLOAD_OV.SUBMISSION_NUMBER IGS_ST_GVTSEMLOAD_OV.GOVT_SEMESTER