FND Design Data [Home] [Help]

Table: IGS_PR_STDNT_PR_OU_ALL

Product: IGS - Student System (Obsolete)
Description: This table describes a progression outcome applied to a student, either manually or by the system, as a result of failing a progression rule. This detail is subject to approval, waiving etc. prior to application to the student.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_PR_STDNT_PR_OU_PK
  1. ColumnPERSON_ID
  2. ColumnCOURSE_CD
  3. ColumnSEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PR_STDNT_PR_OU_ALL FK Joins to TableIGS_EN_ATD_TYPE_ALL IGS_PR_STDNT_PR_OU_ALL.RESTRICTED_ATTENDANCE_TYPE
IGS_PR_STDNT_PR_OU_ALL FK Joins to TableIGS_PS_GRP_ALL IGS_PR_STDNT_PR_OU_ALL.ENCMB_COURSE_GROUP_CD
IGS_PR_STDNT_PR_OU_ALL FK Joins to TableIGS_PR_OU_TYPE_ALL IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_OUTCOME_TYPE
IGS_PR_STDNT_PR_OU_ALL FK Joins to TableIGS_PR_RU_OU_ALL IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_RULE_CAT
IGS_PR_STDNT_PR_OU_ALL.PRO_PRA_SEQUENCE_NUMBER
IGS_PR_STDNT_PR_OU_ALL.PRO_SEQUENCE_NUMBER
IGS_PR_STDNT_PR_OU_ALL FK Joins to TableIGS_EN_STDNT_PS_ATT_ALL IGS_PR_STDNT_PR_OU_ALL.PERSON_ID
IGS_PR_STDNT_PR_OU_ALL.COURSE_CD
IGS_PR_STDNT_PR_OU_ALL FK Joins to TableIGS_PR_SDT_PR_RU_CK_ALL IGS_PR_STDNT_PR_OU_ALL.PERSON_ID
IGS_PR_STDNT_PR_OU_ALL.COURSE_CD
IGS_PR_STDNT_PR_OU_ALL.PRG_CAL_TYPE
IGS_PR_STDNT_PR_OU_ALL.PRG_CI_SEQUENCE_NUMBER
IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_RULE_CAT
IGS_PR_STDNT_PR_OU_ALL.PRA_SEQUENCE_NUMBER
IGS_PR_STDNT_PR_OU_ALL.RULE_CHECK_DT
TableIGS_PR_STDNT_PR_FND FK Joins to IGS_PR_STDNT_PR_OU_ALL IGS_PR_STDNT_PR_FND.PERSON_ID
IGS_PR_STDNT_PR_FND.COURSE_CD
IGS_PR_STDNT_PR_FND.SPO_SEQUENCE_NUMBER
TableIGS_PE_PERS_ENCUMB FK Joins to IGS_PR_STDNT_PR_OU_ALL IGS_PE_PERS_ENCUMB.PERSON_ID
IGS_PE_PERS_ENCUMB.SPO_COURSE_CD
IGS_PE_PERS_ENCUMB.SPO_SEQUENCE_NUMBER
TableIGS_PR_RU_APPL_ALL FK Joins to IGS_PR_STDNT_PR_OU_ALL IGS_PR_RU_APPL_ALL.SPO_PERSON_ID
IGS_PR_RU_APPL_ALL.SPO_COURSE_CD
IGS_PR_RU_APPL_ALL.SPO_SEQUENCE_NUMBER
TableIGS_PR_STU_OU_HIST_ALL FK Joins to IGS_PR_STDNT_PR_OU_ALL IGS_PR_STU_OU_HIST_ALL.PERSON_ID
IGS_PR_STU_OU_HIST_ALL.COURSE_CD
IGS_PR_STU_OU_HIST_ALL.SEQUENCE_NUMBER
TableIGS_PR_STDNT_PR_PS FK Joins to IGS_PR_STDNT_PR_OU_ALL IGS_PR_STDNT_PR_PS.PERSON_ID
IGS_PR_STDNT_PR_PS.SPO_COURSE_CD
IGS_PR_STDNT_PR_PS.SPO_SEQUENCE_NUMBER
TableIGS_PR_STDNT_PR_AWD FK Joins to IGS_PR_STDNT_PR_OU_ALL IGS_PR_STDNT_PR_AWD.PERSON_ID
IGS_PR_STDNT_PR_AWD.COURSE_CD
IGS_PR_STDNT_PR_AWD.SPO_SEQUENCE_NUMBER
TableIGS_PR_SDT_PR_UNT_ST FK Joins to IGS_PR_STDNT_PR_OU_ALL IGS_PR_SDT_PR_UNT_ST.PERSON_ID
IGS_PR_SDT_PR_UNT_ST.COURSE_CD
IGS_PR_SDT_PR_UNT_ST.SPO_SEQUENCE_NUMBER
TableIGS_PR_STDNT_PR_UNIT FK Joins to IGS_PR_STDNT_PR_OU_ALL IGS_PR_STDNT_PR_UNIT.PERSON_ID
IGS_PR_STDNT_PR_UNIT.COURSE_CD
IGS_PR_STDNT_PR_UNIT.SPO_SEQUENCE_NUMBER