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: IGSBV_PERSON_HOLD_EFFECTS

Product:	IGS - Student System
Description:	contains the effects which are imposed on a person (or one or their courses) as part on a hold. eg. course exclusion, suppression of transcript.
Implementation/DBA Data:	APPS.IGSBV_PERSON_HOLD_EFFECTS

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'
, PEE.CREATED_BY
, PEE.CREATION_DATE
, PEE.LAST_UPDATED_BY
, PEE.LAST_UPDATE_DATE
FROM IGS_PE_PERSENC_EFFCT PEE
, HZ_PARTIES HP
, IGS_FI_ENCMB_TYPE_ALL ENT
WHERE PEE.PERSON_ID = HP.PARTY_ID
AND PEE.ENCUMBRANCE_TYPE = ENT.ENCUMBRANCE_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"
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE