Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity describes a student's satisfaction of a special requirement within a nominated student program attempt. For example, first-aid certificate. |
Implementation/DBA Data: | Not implemented in this database |
SELECT SCSR.PERSON_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, SCSR.COURSE_CD
, PSV.TITLE
, SCSR.SPECIAL_REQUIREMENT_CD
, SRQ.DESCRIPTION
, SCSR.COMPLETED_DT
, SCSR.EXPIRY_DT
, SCSR.REFERENCE
, SCSR.COMMENTS
, SCSR.CREATED_BY
, SCSR.CREATION_DATE
, SCSR.LAST_UPDATED_BY
, SCSR.LAST_UPDATE_DATE
FROM IGS_PS_STDNT_SPL_REQ SCSR
, HZ_PARTIES HP
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_PS_VER_ALL PSV
, IGS_GE_SPL_REQ SRQ
WHERE SCSR.PERSON_ID = HP.PARTY_ID
AND SCSR.PERSON_ID = SCA.PERSON_ID
AND SCSR.COURSE_CD = SCA.COURSE_CD
AND SCSR.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER
AND SCSR.SPECIAL_REQUIREMENT_CD = SRQ.SPECIAL_REQUIREMENT_CD WITH READ ONLY