FND Design Data [Home] [Help]

Table: IGS_AD_SBM_PS_FNTRGT

Product: IGS - Student System
Description: Holds program version funding source and optional components that have one or more targets for a submission period
Implementation/DBA Data: TableIGS.IGS_AD_SBM_PS_FNTRGT
Primary Key: IGS_AD_SBM_PS_FNTRGT_PK
  1. ColumnSUBMISSION_YR
  2. ColumnSUBMISSION_NUMBER
  3. ColumnCOURSE_CD
  4. ColumnCRV_VERSION_NUMBER
  5. ColumnFUNDING_SOURCE
  6. ColumnSEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_AD_SBM_PS_FNTRGT FK Joins to TableIGS_EN_ATD_MODE_ALL IGS_AD_SBM_PS_FNTRGT.ATTENDANCE_MODE
IGS_AD_SBM_PS_FNTRGT FK Joins to TableIGS_EN_ATD_TYPE_ALL IGS_AD_SBM_PS_FNTRGT.ATTENDANCE_TYPE
IGS_AD_SBM_PS_FNTRGT FK Joins to TableIGS_PS_VER_ALL IGS_AD_SBM_PS_FNTRGT.COURSE_CD
IGS_AD_SBM_PS_FNTRGT.CRV_VERSION_NUMBER
IGS_AD_SBM_PS_FNTRGT FK Joins to TableIGS_FI_FUND_SRC_ALL IGS_AD_SBM_PS_FNTRGT.FUNDING_SOURCE
IGS_AD_SBM_PS_FNTRGT FK Joins to TableIGS_ST_GVT_SPSHT_CTL_ALL IGS_AD_SBM_PS_FNTRGT.SUBMISSION_YR
IGS_AD_SBM_PS_FNTRGT.SUBMISSION_NUMBER
IGS_AD_SBM_PS_FNTRGT FK Joins to TableIGS_AD_LOCATION_ALL IGS_AD_SBM_PS_FNTRGT.LOCATION_CD
IGS_AD_SBM_PS_FNTRGT FK Joins to TableIGS_EN_UNIT_SET_ALL IGS_AD_SBM_PS_FNTRGT.UNIT_SET_CD
IGS_AD_SBM_PS_FNTRGT.US_VERSION_NUMBER
TableIGS_AD_SBMPS_FN_ITTT FK Joins to IGS_AD_SBM_PS_FNTRGT IGS_AD_SBMPS_FN_ITTT.SUBMISSION_YR
IGS_AD_SBMPS_FN_ITTT.SUBMISSION_NUMBER
IGS_AD_SBMPS_FN_ITTT.COURSE_CD
IGS_AD_SBMPS_FN_ITTT.CRV_VERSION_NUMBER
IGS_AD_SBMPS_FN_ITTT.FUNDING_SOURCE
IGS_AD_SBMPS_FN_ITTT.SEQUENCE_NUMBER