[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This entity contains the student program attempt transfers |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PST.PERSON_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, PST.COURSE_CD
, PSV.TITLE
, PST.TRANSFER_COURSE_CD
, PSV1.TITLE
, PST.TRANSFER_DT
, PST.COMMENTS
, PST.CREATED_BY
, PST.CREATION_DATE
, PST.LAST_UPDATED_BY
, PST.LAST_UPDATE_DATE
, PST.APPROVED_DATE
, PST.EFFECTIVE_TERM_CAL_TYPE
, PST.EFFECTIVE_TERM_SEQUENCE_NUM
, CI.DESCRIPTION
, PST.DISCONTINUE_SOURCE_FLAG
, PST.TRANSFER_ADV_STAND_FLAG
, PST. UOOIDS_TO_TRANSFER
, PST.SUSA_TO_TRANSFER
, PST.STATUS_FLAG
, PST.STATUS_DATE
FROM IGS_PS_STDNT_TRN PST
, HZ_PARTIES HP
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_EN_STDNT_PS_ATT_ALL SCA1
, IGS_PS_VER_ALL PSV
, IGS_PS_VER_ALL PSV1
, IGS_CA_INST_ALL CI
WHERE PST.PERSON_ID = HP.PARTY_ID
AND PST.PERSON_ID = SCA.PERSON_ID
AND PST.COURSE_CD = SCA.COURSE_CD
AND PST.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER
AND PST.PERSON_ID = SCA1.PERSON_ID
AND PST.TRANSFER_COURSE_CD = SCA1.COURSE_CD
AND PST.TRANSFER_COURSE_CD = PSV1.COURSE_CD
AND SCA1.VERSION_NUMBER = PSV1.VERSION_NUMBER
AND PST.EFFECTIVE_TERM_CAL_TYPE = CI.CAL_TYPE (+)
AND PST.EFFECTIVE_TERM_SEQUENCE_NUM = CI.SEQUENCE_NUMBER (+) WITH READ ONLY