eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: IGS_PE_PERSENC_EFFCT

Product:	IGS - Student System (Obsolete)
Description:	This entity describes the effects which are imposed on a person (or one or their courses) as part on an encumbrance. eg. course exclusion, suppression of transcript.
Implementation/DBA Data:	Not implemented in this database

Primary Key: IGS_PE_PERSENC_EFFCT_PK

PERSON_ID
ENCUMBRANCE_TYPE
PEN_START_DT
S_ENCMB_EFFECT_TYPE
PEE_START_DT
SEQUENCE_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_PE_PERSENC_EFFCT	IGS_EN_ATD_TYPE_ALL	IGS_PE_PERSENC_EFFCT.RESTRICTED_ATTENDANCE_TYPE
IGS_PE_PERSENC_EFFCT	IGS_PE_PERS_ENCUMB	IGS_PE_PERSENC_EFFCT.PERSON_ID IGS_PE_PERSENC_EFFCT.ENCUMBRANCE_TYPE IGS_PE_PERSENC_EFFCT.PEN_START_DT
IGS_PE_PERSENC_EFFCT	IGS_EN_ENCMB_EFCTTYP	IGS_PE_PERSENC_EFFCT.S_ENCMB_EFFECT_TYPE
IGS_PE_FUND_EXCL	IGS_PE_PERSENC_EFFCT	IGS_PE_FUND_EXCL.PERSON_ID IGS_PE_FUND_EXCL.ENCUMBRANCE_TYPE IGS_PE_FUND_EXCL.PEN_START_DT IGS_PE_FUND_EXCL.S_ENCMB_EFFECT_TYPE IGS_PE_FUND_EXCL.PEE_START_DT IGS_PE_FUND_EXCL.PEE_SEQUENCE_NUMBER
IGS_PE_COURSE_EXCL	IGS_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
IGS_PE_CRS_GRP_EXCL	IGS_PE_PERSENC_EFFCT	IGS_PE_CRS_GRP_EXCL.PERSON_ID IGS_PE_CRS_GRP_EXCL.ENCUMBRANCE_TYPE IGS_PE_CRS_GRP_EXCL.PEN_START_DT IGS_PE_CRS_GRP_EXCL.S_ENCMB_EFFECT_TYPE IGS_PE_CRS_GRP_EXCL.PEE_START_DT IGS_PE_CRS_GRP_EXCL.PEE_SEQUENCE_NUMBER
IGS_PE_PERS_UNT_EXCL	IGS_PE_PERSENC_EFFCT	IGS_PE_PERS_UNT_EXCL.PERSON_ID IGS_PE_PERS_UNT_EXCL.ENCUMBRANCE_TYPE IGS_PE_PERS_UNT_EXCL.PEN_START_DT IGS_PE_PERS_UNT_EXCL.S_ENCMB_EFFECT_TYPE IGS_PE_PERS_UNT_EXCL.PEE_START_DT IGS_PE_PERS_UNT_EXCL.PEE_SEQUENCE_NUMBER
IGS_PE_UNT_REQUIRMNT	IGS_PE_PERSENC_EFFCT	IGS_PE_UNT_REQUIRMNT.PERSON_ID IGS_PE_UNT_REQUIRMNT.ENCUMBRANCE_TYPE IGS_PE_UNT_REQUIRMNT.PEN_START_DT IGS_PE_UNT_REQUIRMNT.S_ENCMB_EFFECT_TYPE IGS_PE_UNT_REQUIRMNT.PEE_START_DT IGS_PE_UNT_REQUIRMNT.PEE_SEQUENCE_NUMBER
IGS_PE_UNT_SET_EXCL	IGS_PE_PERSENC_EFFCT	IGS_PE_UNT_SET_EXCL.PERSON_ID IGS_PE_UNT_SET_EXCL.ENCUMBRANCE_TYPE IGS_PE_UNT_SET_EXCL.PEN_START_DT IGS_PE_UNT_SET_EXCL.S_ENCMB_EFFECT_TYPE IGS_PE_UNT_SET_EXCL.PEE_START_DT IGS_PE_UNT_SET_EXCL.PEE_SEQUENCE_NUMBER