FND Design Data [Home] [Help]

Table: IGS_PE_COURSE_EXCL

Product: IGS - Student System (Obsolete)
Description: This entity defines a course which a student has been excluded from. e.g. block admission to a course for an applicant.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_PE_COURSE_EXCL_PK
  1. ColumnPERSON_ID
  2. ColumnENCUMBRANCE_TYPE
  3. ColumnPEN_START_DT
  4. ColumnS_ENCMB_EFFECT_TYPE
  5. ColumnPEE_START_DT
  6. ColumnPEE_SEQUENCE_NUMBER
  7. ColumnCOURSE_CD
  8. ColumnPCE_START_DT
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PE_COURSE_EXCL FK Joins to TableIGS_PS_COURSE IGS_PE_COURSE_EXCL.COURSE_CD
IGS_PE_COURSE_EXCL FK Joins to TableIGS_PE_PERSENC_EFFCT IGS_PE_COURSE_EXCL.PERSON_ID
IGS_PE_COURSE_EXCL.ENCUMBRANCE_TYPE
IGS_PE_COURSE_EXCL.PEN_START_DT
IGS_PE_COURSE_EXCL.S_ENCMB_EFFECT_TYPE
IGS_PE_COURSE_EXCL.PEE_START_DT
IGS_PE_COURSE_EXCL.PEE_SEQUENCE_NUMBER