Table: IGS_EN_STDNT_PS_INTM

Product:	IGS - Student System
Description:	This entity describes an intermission by a student from the student course attempt.
Implementation/DBA Data:	IGS.IGS_EN_STDNT_PS_INTM

Primary Key: IGS_EN_STDNT_PS_INTM_PK

1. PERSON_ID
2. COURSE_CD
3. START_DT
4. LOGICAL_DELETE_DATE

Primary Key: IGS_EN_STDNT_PS_INTM_UK

1. PERSON_ID
2. COURSE_CD
3. INTERMISSION_TYPE
4. START_DT

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_EN_STDNT_PS_INTM		IGS_EN_INTM_TYPES	IGS_EN_STDNT_PS_INTM.INTERMISSION_TYPE
IGS_EN_STDNT_PS_INTM		HZ_PARTIES	IGS_EN_STDNT_PS_INTM.APPROVER_ID
IGS_EN_STDNT_PS_INTM		IGS_EN_STDNT_PS_ATT_ALL	IGS_EN_STDNT_PS_INTM.PERSON_ID IGS_EN_STDNT_PS_INTM.COURSE_CD
IGS_EN_SPI_RCONDS		IGS_EN_STDNT_PS_INTM	IGS_EN_SPI_RCONDS.PERSON_ID IGS_EN_SPI_RCONDS.COURSE_CD IGS_EN_SPI_RCONDS.START_DT IGS_EN_SPI_RCONDS.LOGICAL_DELETE_DATE