FND Design Data [Home] [Help]

Table: IGS_PS_UNIT_VER_ALL

Product: IGS - Student System (Obsolete)
Description: This entity describes a version of a unit, which is offered by the university.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_PS_UNIT_VER_PK
  1. ColumnUNIT_CD
  2. ColumnVERSION_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_UNIT_VER_ALL FK Joins to TableIGS_FI_ACC_ALL IGS_PS_UNIT_VER_ALL.REV_ACCOUNT_CD
IGS_PS_UNIT_VER_ALL FK Joins to TableIGS_CA_INST_ALL IGS_PS_UNIT_VER_ALL.CAL_TYPE_ENROL_LOAD_CAL
IGS_PS_UNIT_VER_ALL.SEQUENCE_NUM_ENROL_LOAD_CAL
IGS_PS_UNIT_VER_ALL FK Joins to TableIGS_CA_INST_ALL IGS_PS_UNIT_VER_ALL.CAL_TYPE_OFFER_LOAD_CAL
IGS_PS_UNIT_VER_ALL.SEQUENCE_NUM_OFFER_LOAD_CAL
IGS_PS_UNIT_VER_ALL FK Joins to TableHZ_PARTIES IGS_PS_UNIT_VER_ALL.COORD_PERSON_ID
IGS_PS_UNIT_VER_ALL FK Joins to TableIGS_PS_RPT_FMLY_ALL IGS_PS_UNIT_VER_ALL.RPT_FMLY_ID
IGS_PS_UNIT_VER_ALL FK Joins to TableIGS_PS_UNIT_INT_LVL IGS_PS_UNIT_VER_ALL.UNIT_INT_COURSE_LEVEL_CD
IGS_PS_UNIT_VER_ALL FK Joins to TableIGS_PS_UNIT_LEVEL_ALL IGS_PS_UNIT_VER_ALL.UNIT_LEVEL
IGS_PS_UNIT_VER_ALL FK Joins to TableIGS_PS_UNIT IGS_PS_UNIT_VER_ALL.UNIT_CD
IGS_PS_UNIT_VER_ALL FK Joins to TableIGS_PS_UNIT_STAT IGS_PS_UNIT_VER_ALL.UNIT_STATUS
IGS_PS_UNIT_VER_ALL FK Joins to TableIGS_PS_UNIT_TYPE_LVL IGS_PS_UNIT_VER_ALL.UNIT_TYPE_ID
IGS_PS_UNIT_VER_ALL FK Joins to TableIGS_PS_UNT_CRCLM_ALL IGS_PS_UNIT_VER_ALL.CURRICULUM_ID
IGS_PS_UNIT_VER_ALL FK Joins to TableIGS_PS_UNIT_SUBTITLE IGS_PS_UNIT_VER_ALL.SUBTITLE_ID
TableIGS_AS_APPR_GRD_SCH FK Joins to IGS_PS_UNIT_VER_ALL IGS_AS_APPR_GRD_SCH.UNIT_CD
IGS_AS_APPR_GRD_SCH.VERSION_NUMBER
TableIGS_AD_PS_APLINSTUNT_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_AD_PS_APLINSTUNT_ALL.SUP_UNIT_CD
IGS_AD_PS_APLINSTUNT_ALL.SUP_UV_VERSION_NUMBER
TableIGS_AV_STND_ALT_UNIT FK Joins to IGS_PS_UNIT_VER_ALL IGS_AV_STND_ALT_UNIT.ALT_UNIT_CD
IGS_AV_STND_ALT_UNIT.ALT_VERSION_NUMBER
TableIGS_AV_STND_UNIT_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_AV_STND_UNIT_ALL.UNIT_CD
IGS_AV_STND_UNIT_ALL.VERSION_NUMBER
TableIGS_PS_ANL_LOAD_U_LN FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_ANL_LOAD_U_LN.UNIT_CD
IGS_PS_ANL_LOAD_U_LN.UV_VERSION_NUMBER
TableIGS_CO_ITM_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_CO_ITM_ALL.UNIT_CD
IGS_CO_ITM_ALL.UV_VERSION_NUMBER
TableIGS_PS_UNIT_LVL_HIST_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_LVL_HIST_ALL.UNIT_CD
IGS_PS_UNIT_LVL_HIST_ALL.VERSION_NUMBER
TableIGS_PS_UNIT_LVL_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_LVL_ALL.UNIT_CD
IGS_PS_UNIT_LVL_ALL.VERSION_NUMBER
TableIGS_HE_ST_UV_CC_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_HE_ST_UV_CC_ALL.UNIT_CD
IGS_HE_ST_UV_CC_ALL.VERSION_NUMBER
TableIGS_HE_ST_UNT_VS_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_HE_ST_UNT_VS_ALL.UNIT_CD
IGS_HE_ST_UNT_VS_ALL.VERSION_NUMBER
TableIGS_EN_ELGB_OVR_UOO FK Joins to IGS_PS_UNIT_VER_ALL IGS_EN_ELGB_OVR_UOO.UNIT_CD
IGS_EN_ELGB_OVR_UOO.VERSION_NUMBER
TableIGS_FI_FEE_AS_RATE FK Joins to IGS_PS_UNIT_VER_ALL IGS_FI_FEE_AS_RATE.UNIT_CD
IGS_FI_FEE_AS_RATE.UNIT_VERSION_NUMBER
TableIGS_FI_FEE_AS_RT_H_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_FI_FEE_AS_RT_H_ALL.UNIT_CD
IGS_FI_FEE_AS_RT_H_ALL.UNIT_VERSION_NUMBER
TableIGS_FI_FTCI_ACCTS FK Joins to IGS_PS_UNIT_VER_ALL IGS_FI_FTCI_ACCTS.UNIT_CD
IGS_FI_FTCI_ACCTS.UNIT_VERSION_NUMBER
TableIGS_PS_UNIT_X_GRPMEM FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_X_GRPMEM.UNIT_CD
IGS_PS_UNIT_X_GRPMEM.VERSION_NUMBER
TableIGS_CO_OU_CO_REF_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_CO_OU_CO_REF_ALL.UNIT_CD
IGS_CO_OU_CO_REF_ALL.UV_VERSION_NUMBER
TableIGS_PS_UNIT_ACCTS_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_ACCTS_ALL.UNIT_CD
IGS_PS_UNIT_ACCTS_ALL.VERSION_NUMBER
TableIGS_EN_SU_ATTEMPT_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_EN_SU_ATTEMPT_ALL.SUP_UNIT_CD
IGS_EN_SU_ATTEMPT_ALL.SUP_VERSION_NUMBER
TableIGS_EN_SU_ATTEMPT_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_EN_SU_ATTEMPT_ALL.UNIT_CD
IGS_EN_SU_ATTEMPT_ALL.VERSION_NUMBER
TableIGS_PS_SUB_UNIT_REL FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_SUB_UNIT_REL.SUP_UNIT_CD
IGS_PS_SUB_UNIT_REL.SUP_VERSION_NUMBER
TableIGS_PS_SUB_UNIT_REL FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_SUB_UNIT_REL.SUB_UNIT_CD
IGS_PS_SUB_UNIT_REL.SUB_VERSION_NUMBER
TableIGS_PS_TCH_RESP_HIST_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_TCH_RESP_HIST_ALL.UNIT_CD
IGS_PS_TCH_RESP_HIST_ALL.VERSION_NUMBER
TableIGS_PS_TCH_RESP FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_TCH_RESP.UNIT_CD
IGS_PS_TCH_RESP.VERSION_NUMBER
TableIGS_PS_UNIT_CROS_REF FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_CROS_REF.CHILD_UNIT_CODE
IGS_PS_UNIT_CROS_REF.CHILD_UNIT_VERSION_NUMBER
TableIGS_PS_UNIT_CROS_REF FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_CROS_REF.PARENT_UNIT_CODE
IGS_PS_UNIT_CROS_REF.PARENT_UNIT_VERSION_NUMBER
TableIGS_PS_UNIT_CATEGORY_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_CATEGORY_ALL.UNIT_CD
IGS_PS_UNIT_CATEGORY_ALL.VERSION_NUMBER
TableIGS_PS_UNT_DSCP_HIST_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNT_DSCP_HIST_ALL.UNIT_CD
IGS_PS_UNT_DSCP_HIST_ALL.VERSION_NUMBER
TableIGS_PS_UNIT_DSCP FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_DSCP.UNIT_CD
IGS_PS_UNIT_DSCP.VERSION_NUMBER
TableIGS_PS_UNIT_FLD_STDY FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_FLD_STDY.UNIT_CODE
IGS_PS_UNIT_FLD_STDY.VERSION_NUMBER
TableIGS_FI_UNIT_FEE_TRG FK Joins to IGS_PS_UNIT_VER_ALL IGS_FI_UNIT_FEE_TRG.UNIT_CD
IGS_FI_UNIT_FEE_TRG.VERSION_NUMBER
TableIGS_PS_UNIT_FACILITY FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_FACILITY.UNIT_CODE
IGS_PS_UNIT_FACILITY.UNIT_VERSION_NUMBER
TableIGS_PS_UNIT_GRD_SCHM FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_GRD_SCHM.UNIT_CODE
IGS_PS_UNIT_GRD_SCHM.UNIT_VERSION_NUMBER
TableIGS_PS_UNIT_LOCATION FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_LOCATION.UNIT_CODE
IGS_PS_UNIT_LOCATION.UNIT_VERSION_NUMBER
TableIGS_PS_UNIT_OFR_MODE FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_OFR_MODE.UNIT_CD
IGS_PS_UNIT_OFR_MODE.VERSION_NUMBER
TableIGS_PS_UNIT_OFR FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_OFR.UNIT_CD
IGS_PS_UNIT_OFR.VERSION_NUMBER
TableIGS_PS_UNT_PRV_GRADE FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNT_PRV_GRADE.UNIT_CODE
IGS_PS_UNT_PRV_GRADE.UNIT_VERSION_NUMBER
TableIGS_PS_UNIT_REF_HIST_ALL FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_REF_HIST_ALL.UNIT_CD
IGS_PS_UNIT_REF_HIST_ALL.VERSION_NUMBER
TableIGS_PS_UNIT_REF_CD FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_REF_CD.UNIT_CD
IGS_PS_UNIT_REF_CD.VERSION_NUMBER
TableIGS_PS_UNT_REPT_FMLY FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNT_REPT_FMLY.REPEAT_FMLY_UNIT_CODE
IGS_PS_UNT_REPT_FMLY.REPEAT_FMLY_UNIT_VERSION_NUM
TableIGS_PS_UNT_REPT_FMLY FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNT_REPT_FMLY.UNIT_CODE
IGS_PS_UNT_REPT_FMLY.UNIT_VERSION_NUMBER
TableIGS_PS_USEC_RPT_FMLY FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_USEC_RPT_FMLY.REPEAT_FAMILY_UNIT_CD
IGS_PS_USEC_RPT_FMLY.REPEAT_FAMILY_VERSION_NUMBER
TableIGS_PS_UNIT_VER_NOTE FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_VER_NOTE.UNIT_CD
IGS_PS_UNIT_VER_NOTE.VERSION_NUMBER
TableIGS_PS_UNIT_VER_RU FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_VER_RU.UNIT_CD
IGS_PS_UNIT_VER_RU.VERSION_NUMBER
TableIGS_PS_UNIT_SUBTITLE FK Joins to IGS_PS_UNIT_VER_ALL IGS_PS_UNIT_SUBTITLE.UNIT_CD
IGS_PS_UNIT_SUBTITLE.VERSION_NUMBER