FND Design Data [Home] [Help]

Table: IGS_PS_PAT_OF_STUDY

Product: IGS - Student System
Description: This entity describes a pattern of study, which applies to a program offering.
Implementation/DBA Data: TableIGS.IGS_PS_PAT_OF_STUDY
Primary Key: IGS_PS_PAT_OF_STUDY_PK
  1. ColumnCOURSE_CD
  2. ColumnVERSION_NUMBER
  3. ColumnCAL_TYPE
  4. ColumnSEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_PAT_OF_STUDY FK Joins to TableIGS_AD_CAT_ALL IGS_PS_PAT_OF_STUDY.ADMISSION_CAT
IGS_PS_PAT_OF_STUDY FK Joins to TableIGS_EN_ATD_MODE_ALL IGS_PS_PAT_OF_STUDY.ATTENDANCE_MODE
IGS_PS_PAT_OF_STUDY FK Joins to TableIGS_EN_ATD_TYPE_ALL IGS_PS_PAT_OF_STUDY.ATTENDANCE_TYPE
IGS_PS_PAT_OF_STUDY FK Joins to TableIGS_CA_TYPE IGS_PS_PAT_OF_STUDY.ADMISSION_CAL_TYPE
IGS_PS_PAT_OF_STUDY FK Joins to TableIGS_CA_INST_ALL IGS_PS_PAT_OF_STUDY.CAL_TYPE
IGS_PS_PAT_OF_STUDY.APRVD_CI_SEQUENCE_NUMBER
IGS_PS_PAT_OF_STUDY FK Joins to TableIGS_PS_OFR_ALL IGS_PS_PAT_OF_STUDY.COURSE_CD
IGS_PS_PAT_OF_STUDY.VERSION_NUMBER
IGS_PS_PAT_OF_STUDY.CAL_TYPE
IGS_PS_PAT_OF_STUDY FK Joins to TableIGS_AD_LOCATION_ALL IGS_PS_PAT_OF_STUDY.LOCATION_CD
TableIGS_PS_PAT_STUDY_PRD FK Joins to IGS_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