Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity describes the holds placed on an applicant or student e.g. overdue parking fines, unpaid fees, and failure to return library books. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PEN.PERSON_ID PERSON_ID
, PEN.ENCUMBRANCE_TYPE HOLD_TYPE
, PEN.START_DT EFFECTIVE_START_DATE
, PEN.EXPIRY_DT EXPIRY_DATE
, PEN.COMMENTS NOTES
, PEN.SPO_COURSE_CD PROG_OUTCOME_PROGRAM_CODE
, PEN.SPO_SEQUENCE_NUMBER PROG_OUTCOME_SEQUENCE_NUMBER
, PEN.CAL_TYPE CALENDAR_TYPE
, PEN.SEQUENCE_NUMBER SEQUENCE_NUMBER
, HP.PARTY_NUMBER PERSON_NUMBER
, ENT.DESCRIPTION HOLD_TYPE_DESCRIPTION
, PEN.AUTHORISING_PERSON_ID AUTHORIZING_PERSON_ID
, PEN.AUTH_RESP_ID AUTH_RESP_ID
, PEN.CREATED_BY
, PEN.CREATION_DATE
, PEN.LAST_UPDATED_BY
, PEN.LAST_UPDATE_DATE
, PEN.EXTERNAL_REFERENCE
FROM IGS_PE_PERS_ENCUMB PEN
, HZ_PARTIES HP
, IGS_FI_ENCMB_TYPE_ALL ENT
WHERE PEN.ENCUMBRANCE_TYPE = ENT.ENCUMBRANCE_TYPE
AND PEN.PERSON_ID = HP.PARTY_ID WITH READ ONLY