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]

View: IGSFV_PERSON_HOLD_EFFECTS

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 a hold. e.g. course exclusion, suppression of transcript.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PEE.PERSON_ID PERSON_ID
, PEE.ENCUMBRANCE_TYPE HOLD_TYPE
, PEE.PEN_START_DT HOLD_EFFECTIVE_START_DATE
, PEE.S_ENCMB_EFFECT_TYPE SYSTEM_HOLD_EFFECT_TYPE
, PEE.PEE_START_DT HOLD_EFCT_EFFECTIVE_START_DATE
, PEE.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PEE.EXPIRY_DT EXPIRY_DATE
, PEE.RESTRICTED_ENROLMENT_CP RESTRICTED_ENROLMENT_LOAD
, PEE.COURSE_CD PROGRAM_CODE
, PEE.RESTRICTED_ATTENDANCE_TYPE RESTRICTED_ATTENDANCE_TYPE
, HP.PARTY_NUMBER PERSON_NUMBER
, ENT.DESCRIPTION HOLD_TYPE_DESCRIPTION
, '_LA:PEE.S_ENCMB_EFFECT_TYPE:IGS_LOOKUP_VALUES:ENCMB_EFFECT_TYPE:MEANING'
, EAT.DESCRIPTION RESTRICTED_ATTENDANCE_TYP_DESC
, PEE.CREATED_BY
, PEE.CREATION_DATE
, PEE.LAST_UPDATED_BY
, PEE.LAST_UPDATE_DATE
FROM IGS_PE_PERSENC_EFFCT PEE
, IGS_FI_ENCMB_TYPE_ALL ENT
, HZ_PARTIES HP
, IGS_EN_ATD_TYPE_ALL EAT
WHERE HP.PARTY_ID = PEE.PERSON_ID
AND ENT.ENCUMBRANCE_TYPE = PEE.ENCUMBRANCE_TYPE
AND PEE.RESTRICTED_ATTENDANCE_TYPE = EAT.ATTENDANCE_TYPE(+) WITH READ ONLY

Columns

Name
PERSON_ID
HOLD_TYPE
HOLD_EFFECTIVE_START_DATE
SYSTEM_HOLD_EFFECT_TYPE
HOLD_EFCT_EFFECTIVE_START_DATE
SEQUENCE_NUMBER
EXPIRY_DATE
RESTRICTED_ENROLMENT_LOAD
PROGRAM_CODE
RESTRICTED_ATTENDANCE_TYPE
PERSON_NUMBER
HOLD_TYPE_DESCRIPTION
"_LA:SYS_HOLD_EFFECT_TYP_DESC"
RESTRICTED_ATTENDANCE_TYP_DESC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE