View: IGSFV_PERSON_HOLD_EFFECTS

Product:	IGS - Student System
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:	APPS.IGSFV_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'
, 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