[Home] [Help]
View: IGSBV_PR_STDNT_PRG_PROGRAMS
Product: | IGS - Student System (Obsolete) |
Description: | Describes the programs a student will be suspended, expelled or excluded from when a student progression outcome is applied. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, CRV.TITLE
, SPC.COURSE_CD
, SPC.PERSON_ID
, SPC.SPO_COURSE_CD
, SPC.SPO_SEQUENCE_NUMBER
, SPC.CREATED_BY
, SPC.CREATION_DATE
, SPC.LAST_UPDATED_BY
, SPC.LAST_UPDATE_DATE
FROM IGS_PR_STDNT_PR_PS SPC
, HZ_PARTIES HP
, IGS_PS_VER_ALL CRV
WHERE SPC.PERSON_ID = HP.PARTY_ID
AND SPC.COURSE_CD = CRV.COURSE_CD
AND CRV.VERSION_NUMBER = (SELECT MAX(CRV2.VERSION_NUMBER)
FROM IGS_PS_VER_ALL CRV2
WHERE SPC.COURSE_CD = CRV2.COURSE_CD) WITH READ ONLY
Columns
Name |
PERSON_NAME |
PERSON_NUMBER |
PROGRAM_TITLE |
PROGRAM_CODE |
PERSON_ID |
SPO_PROGRAM_CODE |
SPO_SEQUENCE_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |