[Home] [Help]
View: IGSFV_PR_STDNT_PRG_PGM_CNCTRNS
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Describes the program concentrations a student will be 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
, US.TITLE
, SPUS.UNIT_SET_CD
, SPUS.VERSION_NUMBER
, SPUS.PERSON_ID
, SPUS.COURSE_CD
, SPUS.SPO_SEQUENCE_NUMBER
, SPUS.CREATED_BY
, SPUS.CREATION_DATE
, SPUS.LAST_UPDATED_BY
, SPUS.LAST_UPDATE_DATE
FROM IGS_PR_SDT_PR_UNT_ST SPUS
, HZ_PARTIES HP
, IGS_EN_UNIT_SET_ALL US
WHERE SPUS.PERSON_ID = HP.PARTY_ID
AND SPUS.COURSE_CD = US.UNIT_SET_CD
AND SPUS.VERSION_NUMBER = US.VERSION_NUMBER WITH READ ONLY
Columns
| Name |
| PERSON_NAME |
| PERSON_NUMBER |
| UNIT_SET_TITLE |
| UNIT_SET_CODE |
| UNIT_SET_VERSION_NUMBER |
| PERSON_ID |
| SPO_PROGRAM_CODE |
| SPO_SEQUENCE_NUMBER |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |