[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Describes occurrence of an application for special consideration. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, SCAP.COURSE_CD
, CRV.TITLE
, SCAP.UNIT_CD
, UV.TITLE
, SCAP.CAL_TYPE
, SCAP.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, UOO.LOCATION_CD
, LOC.DESCRIPTION
, AI.DESCRIPTION
, SCAP.CREATION_DT
, SCAP.RECEIVED_DT
, SCAP.SOUGHT_OUTCOME
, SCAP.SPCL_CONSIDERATION_CAT
, SCAP.SPCL_CONSIDERATION_OUTCOME
, SCAP.ESTIMATED_PROCESSING_DAYS
, SCAP.TRACKING_ID
, SCAP.COMMENTS
, SCAP.NOTIFIED_DATE
, SCAP.PERSON_ID
, SCAP.UOO_ID
, SCAP.ASS_ID
, SCAP.CREATED_BY
, SCAP.CREATION_DATE
, SCAP.LAST_UPDATED_BY
, SCAP.LAST_UPDATE_DATE
FROM HZ_PARTIES HP
, IGS_AS_SPL_CONS_APPL SCAP
, IGS_PS_VER_ALL CRV
, IGS_PS_UNIT_VER_ALL UV
, IGS_AS_ASSESSMNT_ITM_ALL AI
, IGS_CA_INST_ALL CI
, IGS_PS_UNIT_OFR_OPT_ALL UOO
, IGS_AD_LOCATION_ALL LOC
, IGS_EN_STDNT_PS_ATT_ALL SPA
WHERE SCAP.PERSON_ID = HP.PARTY_ID
AND SCAP.ASS_ID = AI.ASS_ID AND SCAP.CAL_TYPE = CI.CAL_TYPE AND SCAP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND SCAP.UOO_ID = UOO.UOO_ID
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD AND SCAP.PERSON_ID = SPA.PERSON_ID AND SCAP.COURSE_CD = SPA.COURSE_CD AND SPA.COURSE_CD = CRV.COURSE_CD
AND SPA.VERSION_NUMBER = CRV.VERSION_NUMBER WITH READ ONLY