[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This entity describes the encumbrances placed on an applicant/student e.g. overdue parking fines, unpaid fees, failure to return library books. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT A.ROW_ID
, A.PERSON_ID
, A.ENCUMBRANCE_TYPE
, B.DESCRIPTION
, B.CLOSED_IND
, B.S_ENCUMBRANCE_CAT
, A.CAL_TYPE
, A.SEQUENCE_NUMBER
, CT.TERM
, A.START_DT
, A.EXPIRY_DT
, A.AUTHORISING_PERSON_ID
, C.PERSON_NUMBER
, A.COMMENTS
, A.SPO_COURSE_CD
, A.SPO_SEQUENCE_NUMBER
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.AUTH_RESP_ID
, A.AUTH_RESP_NAME
, A.EXTERNAL_REFERENCE
, L1.MEANING EXTERNAL_REFERENCE_DESC
FROM IGS_PE_PERS_ENCUMB_V A
, IGS_FI_ENCMB_TYPE B
, IGS_PE_PERSON_BASE_V C
, ( SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, DECODE(CT.S_CAL_CAT
, 'LOAD'
, IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(CI.CAL_TYPE
, CI.SEQUENCE_NUMBER) || '/'|| NVL(CI.ALTERNATE_CODE
, CI.CAL_TYPE)
, 'ACADEMIC'
, CI.ALTERNATE_CODE) TERM
FROM IGS_CA_INST CI
, IGS_CA_TYPE CT
WHERE CI.CAL_TYPE = CT.CAL_TYPE
AND CT.S_CAL_CAT IN ('LOAD'
, 'ACADEMIC') ) CT
, IGS_LOOKUP_VALUES L1
WHERE A.ENCUMBRANCE_TYPE = B.ENCUMBRANCE_TYPE
AND A.AUTHORISING_PERSON_ID = C.PERSON_ID (+)
AND A.CAL_TYPE = CT.CAL_TYPE(+)
AND A.SEQUENCE_NUMBER = CT.SEQUENCE_NUMBER (+)
AND A.EXTERNAL_REFERENCE = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'PE_EXT_REF'