FND Design Data [Home] [Help]

Table: IGS_AV_STND_UNIT_LVL_ALL

Product: IGS - Student System
Description: Describes the number of advanced standing credit points granted to a student at a given level
Implementation/DBA Data: TableIGS.IGS_AV_STND_UNIT_LVL_ALL
Primary Key: IGS_AV_STND_UNIT_LVL_PK
  1. ColumnAV_STND_UNIT_LVL_ID
Primary Key: IGS_AV_STND_UNIT_LVL_UK
  1. ColumnPERSON_ID
  2. ColumnAS_COURSE_CD
  3. ColumnAS_VERSION_NUMBER
  4. ColumnS_ADV_STND_TYPE
  5. ColumnUNIT_LEVEL
  6. ColumnCRS_GROUP_IND
  7. ColumnEXEMPTION_INSTITUTION_CD
  8. ColumnUNIT_DETAILS_ID
  9. ColumnTST_RSLT_DTLS_ID
  10. ColumnQUAL_DETS_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_AV_STND_UNIT_LVL_ALL FK Joins to TableIGS_AV_ADV_STANDING_ALL IGS_AV_STND_UNIT_LVL_ALL.PERSON_ID
IGS_AV_STND_UNIT_LVL_ALL.AS_COURSE_CD
IGS_AV_STND_UNIT_LVL_ALL.AS_VERSION_NUMBER
IGS_AV_STND_UNIT_LVL_ALL.EXEMPTION_INSTITUTION_CD
IGS_AV_STND_UNIT_LVL_ALL FK Joins to TableIGS_PS_UNIT_LEVEL_ALL IGS_AV_STND_UNIT_LVL_ALL.UNIT_LEVEL
IGS_AV_STND_UNIT_LVL_ALL FK Joins to TableIGS_AD_TST_RSLT_DTLS IGS_AV_STND_UNIT_LVL_ALL.TST_RSLT_DTLS_ID
IGS_AV_STND_UNIT_LVL_ALL FK Joins to TableIGS_AD_TERM_UNITDTLS IGS_AV_STND_UNIT_LVL_ALL.UNIT_DETAILS_ID
IGS_AV_STND_UNIT_LVL_ALL FK Joins to TableIGS_UC_QUAL_DETS IGS_AV_STND_UNIT_LVL_ALL.QUAL_DETS_ID
TableIGS_AV_STD_ULVLBASIS_ALL FK Joins to IGS_AV_STND_UNIT_LVL_ALL IGS_AV_STD_ULVLBASIS_ALL.AV_STND_UNIT_LVL_ID