[Home] [Help]
View: IGSFV_PR_STDNT_PRG_UNITS
Product: | IGS - Student System (Obsolete) |
Description: | Describes the units a student will be excluded from enrollment in or required to enroll in when a student progression outcome is applied. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, UV.TITLE
, SPU.UNIT_CD
, SPU.S_UNIT_TYPE
, SPU.PERSON_ID
, SPU.COURSE_CD
, SPU.SPO_SEQUENCE_NUMBER
, SPU.CREATED_BY
, SPU.CREATION_DATE
, SPU.LAST_UPDATED_BY
, SPU.LAST_UPDATE_DATE
FROM IGS_PR_STDNT_PR_UNIT SPU
, HZ_PARTIES HP
, IGS_PS_UNIT_VER_ALL UV
WHERE SPU.PERSON_ID = HP.PARTY_ID
AND SPU.UNIT_CD = UV.UNIT_CD
AND UV.VERSION_NUMBER = (SELECT MAX(UV2.VERSION_NUMBER)
FROM IGS_PS_UNIT_VER_ALL UV2
WHERE SPU.UNIT_CD = UV2.UNIT_CD) WITH READ ONLY
Columns
Name |
PERSON_NAME |
PERSON_NUMBER |
UNIT_TITLE |
UNIT_CODE |
UNIT_REQUIREMENT_TYPE |
PERSON_ID |
SPO_PROGRAM_CODE |
SPO_SEQUENCE_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |