FND Design Data [Home] [Help]

Table: IGS_PS_STDNT_TRN

Product: IGS - Student System
Description: This entity describes the link between two programs, which were involved in a program transfer.
Implementation/DBA Data: TableIGS.IGS_PS_STDNT_TRN
Primary Key: IGS_PS_STDNT_TRN_PK
  1. ColumnPERSON_ID
  2. ColumnCOURSE_CD
  3. ColumnTRANSFER_COURSE_CD
  4. ColumnTRANSFER_DT
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_STDNT_TRN FK Joins to TableIGS_CA_INST_ALL IGS_PS_STDNT_TRN.EFFECTIVE_TERM_CAL_TYPE
IGS_PS_STDNT_TRN.EFFECTIVE_TERM_SEQUENCE_NUM
IGS_PS_STDNT_TRN FK Joins to TableIGS_EN_STDNT_PS_ATT_ALL IGS_PS_STDNT_TRN.PERSON_ID
IGS_PS_STDNT_TRN.COURSE_CD
IGS_PS_STDNT_TRN FK Joins to TableIGS_EN_STDNT_PS_ATT_ALL IGS_PS_STDNT_TRN.PERSON_ID
IGS_PS_STDNT_TRN.TRANSFER_COURSE_CD
TableIGS_PS_STDNT_UNT_TRN FK Joins to IGS_PS_STDNT_TRN IGS_PS_STDNT_UNT_TRN.PERSON_ID
IGS_PS_STDNT_UNT_TRN.COURSE_CD
IGS_PS_STDNT_UNT_TRN.TRANSFER_COURSE_CD
IGS_PS_STDNT_UNT_TRN.TRANSFER_DT