FND Design Data [Home] [Help]

Table: IGS_PS_UNIT_OFR_PAT_ALL

Product: IGS - Student System (Obsolete)
Description: This entity describes the offering pattern of a unit offering option.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_PS_UNIT_OFR_PAT_PK
  1. ColumnUNIT_CD
  2. ColumnVERSION_NUMBER
  3. ColumnCAL_TYPE
  4. ColumnCI_SEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_UNIT_OFR_PAT_ALL FK Joins to TableIGS_CA_INST_ALL IGS_PS_UNIT_OFR_PAT_ALL.CAL_TYPE
IGS_PS_UNIT_OFR_PAT_ALL.CI_SEQUENCE_NUMBER
IGS_PS_UNIT_OFR_PAT_ALL.CI_START_DT
IGS_PS_UNIT_OFR_PAT_ALL.CI_END_DT
IGS_PS_UNIT_OFR_PAT_ALL FK Joins to TableIGS_CA_INST_ALL IGS_PS_UNIT_OFR_PAT_ALL.CAL_TYPE
IGS_PS_UNIT_OFR_PAT_ALL.CI_SEQUENCE_NUMBER
IGS_PS_UNIT_OFR_PAT_ALL.CI_START_DT
IGS_PS_UNIT_OFR_PAT_ALL.CI_END_DT
IGS_PS_UNIT_OFR_PAT_ALL FK Joins to TableIGS_PS_UNIT_OFR IGS_PS_UNIT_OFR_PAT_ALL.UNIT_CD
IGS_PS_UNIT_OFR_PAT_ALL.VERSION_NUMBER
IGS_PS_UNIT_OFR_PAT_ALL.CAL_TYPE
TableIGS_AD_PS_APLINSTUNT_ALL FK Joins to IGS_PS_UNIT_OFR_PAT_ALL IGS_AD_PS_APLINSTUNT_ALL.UNIT_CD
IGS_AD_PS_APLINSTUNT_ALL.UV_VERSION_NUMBER
IGS_AD_PS_APLINSTUNT_ALL.CAL_TYPE
IGS_AD_PS_APLINSTUNT_ALL.CI_SEQUENCE_NUMBER
TableIGS_AS_MARK_SHEET_ALL FK Joins to IGS_PS_UNIT_OFR_PAT_ALL IGS_AS_MARK_SHEET_ALL.UNIT_CD
IGS_AS_MARK_SHEET_ALL.VERSION_NUMBER
IGS_AS_MARK_SHEET_ALL.CAL_TYPE
IGS_AS_MARK_SHEET_ALL.CI_SEQUENCE_NUMBER
TableIGS_AS_NON_ENR_STDOT_ALL FK Joins to IGS_PS_UNIT_OFR_PAT_ALL IGS_AS_NON_ENR_STDOT_ALL.UNIT_CD
IGS_AS_NON_ENR_STDOT_ALL.VERSION_NUMBER
IGS_AS_NON_ENR_STDOT_ALL.CAL_TYPE
IGS_AS_NON_ENR_STDOT_ALL.CI_SEQUENCE_NUMBER
TableIGS_PS_RSV_UOP_PRI FK Joins to IGS_PS_UNIT_OFR_PAT_ALL IGS_PS_RSV_UOP_PRI.UNIT_CD
IGS_PS_RSV_UOP_PRI.VERSION_NUMBER
IGS_PS_RSV_UOP_PRI.CALENDER_TYPE
IGS_PS_RSV_UOP_PRI.CI_SEQUENCE_NUMBER
TableIGS_AS_UNITASS_ITEM_ALL FK Joins to IGS_PS_UNIT_OFR_PAT_ALL IGS_AS_UNITASS_ITEM_ALL.UNIT_CD
IGS_AS_UNITASS_ITEM_ALL.VERSION_NUMBER
IGS_AS_UNITASS_ITEM_ALL.CAL_TYPE
IGS_AS_UNITASS_ITEM_ALL.CI_SEQUENCE_NUMBER
TableIGS_PS_UNIT_OFR_OPT_ALL FK Joins to IGS_PS_UNIT_OFR_PAT_ALL IGS_PS_UNIT_OFR_OPT_ALL.UNIT_CD
IGS_PS_UNIT_OFR_OPT_ALL.VERSION_NUMBER
IGS_PS_UNIT_OFR_OPT_ALL.CAL_TYPE
IGS_PS_UNIT_OFR_OPT_ALL.CI_SEQUENCE_NUMBER
TableIGS_PS_UNT_OFR_PAT_N FK Joins to IGS_PS_UNIT_OFR_PAT_ALL IGS_PS_UNT_OFR_PAT_N.UNIT_CD
IGS_PS_UNT_OFR_PAT_N.VERSION_NUMBER
IGS_PS_UNT_OFR_PAT_N.CAL_TYPE
IGS_PS_UNT_OFR_PAT_N.CI_SEQUENCE_NUMBER
TableIGS_PS_UOFR_WLST_PRI FK Joins to IGS_PS_UNIT_OFR_PAT_ALL IGS_PS_UOFR_WLST_PRI.UNIT_CD
IGS_PS_UOFR_WLST_PRI.VERSION_NUMBER
IGS_PS_UOFR_WLST_PRI.CALENDER_TYPE
IGS_PS_UOFR_WLST_PRI.CI_SEQUENCE_NUMBER