FND Design Data [Home] [Help]

Table: IGS_ST_GVT_SPSHT_CTL_ALL

Product: IGS - Student System (Obsolete)
Description: This entity describes the characteristics of each government submission and is used to control the various snapshot and extract processes. There is a version for each government submission. Example 1995 submission 1.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_ST_GVT_SPSHT_CTL_PK
  1. ColumnSUBMISSION_YR
  2. ColumnSUBMISSION_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
TableIGS_ST_GVT_SPSHT_CHG FK Joins to IGS_ST_GVT_SPSHT_CTL_ALL IGS_ST_GVT_SPSHT_CHG.SUBMISSION_YR
IGS_ST_GVT_SPSHT_CHG.SUBMISSION_NUMBER
TableIGS_ST_GOVT_SEMESTER FK Joins to IGS_ST_GVT_SPSHT_CTL_ALL IGS_ST_GOVT_SEMESTER.SUBMISSION_YR
IGS_ST_GOVT_SEMESTER.SUBMISSION_NUMBER
TableIGS_ST_GOVT_STDNT_EN FK Joins to IGS_ST_GVT_SPSHT_CTL_ALL IGS_ST_GOVT_STDNT_EN.SUBMISSION_YR
IGS_ST_GOVT_STDNT_EN.SUBMISSION_NUMBER
TableIGS_AD_SBMAO_FN_AMTT FK Joins to IGS_ST_GVT_SPSHT_CTL_ALL IGS_AD_SBMAO_FN_AMTT.SUBMISSION_YR
IGS_AD_SBMAO_FN_AMTT.SUBMISSION_NUMBER
TableIGS_AD_SBMAO_FN_CTTT FK Joins to IGS_ST_GVT_SPSHT_CTL_ALL IGS_AD_SBMAO_FN_CTTT.SUBMISSION_YR
IGS_AD_SBMAO_FN_CTTT.SUBMISSION_NUMBER
TableIGS_AD_SBM_AOU_FNDTT FK Joins to IGS_ST_GVT_SPSHT_CTL_ALL IGS_AD_SBM_AOU_FNDTT.SUBMISSION_YR
IGS_AD_SBM_AOU_FNDTT.SUBMISSION_NUMBER
TableIGS_AD_SBMAO_FN_UITT FK Joins to IGS_ST_GVT_SPSHT_CTL_ALL IGS_AD_SBMAO_FN_UITT.SUBMISSION_YR
IGS_AD_SBMAO_FN_UITT.SUBMISSION_NUMBER
TableIGS_AD_SBM_PS_FNTRGT FK Joins to IGS_ST_GVT_SPSHT_CTL_ALL IGS_AD_SBM_PS_FNTRGT.SUBMISSION_YR
IGS_AD_SBM_PS_FNTRGT.SUBMISSION_NUMBER
TableIGS_AD_SBMINTAK_TRGT FK Joins to IGS_ST_GVT_SPSHT_CTL_ALL IGS_AD_SBMINTAK_TRGT.SUBMISSION_YR
IGS_AD_SBMINTAK_TRGT.SUBMISSION_NUMBER