FND Design Data [Home] [Help]

Table: IGS_PS_PAT_STUDY_PRD

Product: IGS - Student System
Description: This entity describes the periods of a pattern of study. Each period is represented by an academic period number (which is equivalent to the students academic period) and a teaching calendar type.
Implementation/DBA Data: TableIGS.IGS_PS_PAT_STUDY_PRD
Primary Key: IGS_PS_PAT_STUDY_PRD_PK
  1. ColumnCOURSE_CD
  2. ColumnVERSION_NUMBER
  3. ColumnCAL_TYPE
  4. ColumnPOS_SEQUENCE_NUMBER
  5. ColumnSEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_PAT_STUDY_PRD FK Joins to TableIGS_CA_TYPE IGS_PS_PAT_STUDY_PRD.TEACH_CAL_TYPE
IGS_PS_PAT_STUDY_PRD FK Joins to TableIGS_PS_PAT_OF_STUDY IGS_PS_PAT_STUDY_PRD.COURSE_CD
IGS_PS_PAT_STUDY_PRD.VERSION_NUMBER
IGS_PS_PAT_STUDY_PRD.CAL_TYPE
IGS_PS_PAT_STUDY_PRD.POS_SEQUENCE_NUMBER
TableIGS_PS_PAT_STUDY_UNT FK Joins to IGS_PS_PAT_STUDY_PRD IGS_PS_PAT_STUDY_UNT.COURSE_CD
IGS_PS_PAT_STUDY_UNT.VERSION_NUMBER
IGS_PS_PAT_STUDY_UNT.CAL_TYPE
IGS_PS_PAT_STUDY_UNT.POS_SEQUENCE_NUMBER
IGS_PS_PAT_STUDY_UNT.POSP_SEQUENCE_NUMBER