FND Design Data [Home] [Help]

Table: IGS_EN_UNIT_SET_ALL

Product: IGS - Student System (Obsolete)
Description: This field describes a unit-set, being a logical sub-grouping of course. e.g. Major, Minor, Stream, Strand. A unit-set is typically related to the rules which govern its completion via the Rules Sub-system.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_EN_UNIT_SET_PK
  1. ColumnUNIT_SET_CD
  2. ColumnVERSION_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
TableIGS_AD_PS_APPL_INST_ALL FK Joins to IGS_EN_UNIT_SET_ALL IGS_AD_PS_APPL_INST_ALL.UNIT_SET_CD
IGS_AD_PS_APPL_INST_ALL.US_VERSION_NUMBER
TableIGS_GR_AWD_CRM_UT_ST FK Joins to IGS_EN_UNIT_SET_ALL IGS_GR_AWD_CRM_UT_ST.UNIT_SET_CD
IGS_GR_AWD_CRM_UT_ST.US_VERSION_NUMBER
TableIGS_PS_COO_AD_UNIT_S FK Joins to IGS_EN_UNIT_SET_ALL IGS_PS_COO_AD_UNIT_S.UNIT_SET_CD
IGS_PS_COO_AD_UNIT_S.US_VERSION_NUMBER
TableIGS_PS_ENT_PT_REF_CD FK Joins to IGS_EN_UNIT_SET_ALL IGS_PS_ENT_PT_REF_CD.UNIT_SET_CD
IGS_PS_ENT_PT_REF_CD.US_VERSION_NUMBER
TableIGS_PS_OFR_UNIT_SET FK Joins to IGS_EN_UNIT_SET_ALL IGS_PS_OFR_UNIT_SET.UNIT_SET_CD
IGS_PS_OFR_UNIT_SET.US_VERSION_NUMBER
TableIGS_AS_GPC_UNIT_SETS FK Joins to IGS_EN_UNIT_SET_ALL IGS_AS_GPC_UNIT_SETS.UNIT_SET_CD
IGS_AS_GPC_UNIT_SETS.UNIT_SET_VERSION_NUMBER
TableIGS_HE_POOUS_OU_ALL FK Joins to IGS_EN_UNIT_SET_ALL IGS_HE_POOUS_OU_ALL.UNIT_SET_CD
IGS_HE_POOUS_OU_ALL.US_VERSION_NUMBER
TableIGS_HE_POOUS_CC_ALL FK Joins to IGS_EN_UNIT_SET_ALL IGS_HE_POOUS_CC_ALL.UNIT_SET_CD
IGS_HE_POOUS_CC_ALL.US_VERSION_NUMBER
TableIGS_HE_POOUS_ALL FK Joins to IGS_EN_UNIT_SET_ALL IGS_HE_POOUS_ALL.UNIT_SET_CD
IGS_HE_POOUS_ALL.US_VERSION_NUMBER
TableIGS_EN_UNIT_SET_MAP FK Joins to IGS_EN_UNIT_SET_ALL IGS_EN_UNIT_SET_MAP.STREAM_UNIT_SET_CD
IGS_EN_UNIT_SET_MAP.US_VERSION_NUMBER
TableIGS_FI_FAI_DTLS FK Joins to IGS_EN_UNIT_SET_ALL IGS_FI_FAI_DTLS.UNIT_SET_CD
IGS_FI_FAI_DTLS.US_VERSION_NUMBER
TableIGS_FI_FEE_AS_ITEMS FK Joins to IGS_EN_UNIT_SET_ALL IGS_FI_FEE_AS_ITEMS.UNIT_SET_CD
IGS_FI_FEE_AS_ITEMS.US_VERSION_NUMBER
TableIGS_FI_FEE_AS_RATE FK Joins to IGS_EN_UNIT_SET_ALL IGS_FI_FEE_AS_RATE.UNIT_SET_CD
IGS_FI_FEE_AS_RATE.US_VERSION_NUMBER
TableIGS_FI_FEE_AS_RT_H_ALL FK Joins to IGS_EN_UNIT_SET_ALL IGS_FI_FEE_AS_RT_H_ALL.UNIT_SET_CD
IGS_FI_FEE_AS_RT_H_ALL.US_VERSION_NUMBER
TableIGS_PS_US_FLD_STUDY FK Joins to IGS_EN_UNIT_SET_ALL IGS_PS_US_FLD_STUDY.UNIT_SET_CD
IGS_PS_US_FLD_STUDY.VERSION_NUMBER
TableIGS_SS_AD_UNITSE_STG FK Joins to IGS_EN_UNIT_SET_ALL IGS_SS_AD_UNITSE_STG.UNIT_SET_CD
IGS_SS_AD_UNITSE_STG.VERSION_NUMBER
TableIGS_SS_APP_PGM_STG FK Joins to IGS_EN_UNIT_SET_ALL IGS_SS_APP_PGM_STG.FINAL_UNIT_SET_CD
IGS_SS_APP_PGM_STG.FINAL_UNIT_SET_CD_VER
TableIGS_PR_OU_UNIT_SET_ALL FK Joins to IGS_EN_UNIT_SET_ALL IGS_PR_OU_UNIT_SET_ALL.UNIT_SET_CD
IGS_PR_OU_UNIT_SET_ALL.US_VERSION_NUMBER
TableIGS_PE_UNT_SET_EXCL FK Joins to IGS_EN_UNIT_SET_ALL IGS_PE_UNT_SET_EXCL.UNIT_SET_CD
IGS_PE_UNT_SET_EXCL.US_VERSION_NUMBER
TableIGS_PS_RSV_ORGUN_PRF FK Joins to IGS_EN_UNIT_SET_ALL IGS_PS_RSV_ORGUN_PRF.PREFERENCE_CODE
IGS_PS_RSV_ORGUN_PRF.PREFERENCE_VERSION
TableIGS_PS_RSV_UOP_PRF FK Joins to IGS_EN_UNIT_SET_ALL IGS_PS_RSV_UOP_PRF.PREFERENCE_CODE
IGS_PS_RSV_UOP_PRF.PREFERENCE_VERSION
TableIGS_AD_SBM_PS_FNTRGT FK Joins to IGS_EN_UNIT_SET_ALL IGS_AD_SBM_PS_FNTRGT.UNIT_SET_CD
IGS_AD_SBM_PS_FNTRGT.US_VERSION_NUMBER
TableIGS_PR_SDT_PR_UNT_ST FK Joins to IGS_EN_UNIT_SET_ALL IGS_PR_SDT_PR_UNT_ST.UNIT_SET_CD
IGS_PR_SDT_PR_UNT_ST.VERSION_NUMBER
TableIGS_AS_SU_SETATMPT FK Joins to IGS_EN_UNIT_SET_ALL IGS_AS_SU_SETATMPT.UNIT_SET_CD
IGS_AS_SU_SETATMPT.US_VERSION_NUMBER
TableIGS_EN_UNITSETPSTYPE FK Joins to IGS_EN_UNIT_SET_ALL IGS_EN_UNITSETPSTYPE.UNIT_SET_CD
IGS_EN_UNITSETPSTYPE.VERSION_NUMBER
TableIGS_EN_UNITSETFEETRG FK Joins to IGS_EN_UNIT_SET_ALL IGS_EN_UNITSETFEETRG.UNIT_SET_CD
IGS_EN_UNITSETFEETRG.VERSION_NUMBER
TableIGS_PS_RSV_USEC_PRF FK Joins to IGS_EN_UNIT_SET_ALL IGS_PS_RSV_USEC_PRF.PREFERENCE_CODE
IGS_PS_RSV_USEC_PRF.PREFERENCE_VERSION
TableIGS_EN_UNIT_SET_RULE FK Joins to IGS_EN_UNIT_SET_ALL IGS_EN_UNIT_SET_RULE.UNIT_SET_CD
IGS_EN_UNIT_SET_RULE.VERSION_NUMBER
TableIGS_EN_UNIT_SET_NOTE FK Joins to IGS_EN_UNIT_SET_ALL IGS_EN_UNIT_SET_NOTE.UNIT_SET_CD
IGS_EN_UNIT_SET_NOTE.VERSION_NUMBER