[Home] [Help]
View: IGS_EN_SUA_PLACEMENT_DET_V
Product: | IGS - Student System (Obsolete) |
Description: | List of students with placement with an indicator to show whether placement details have been entered. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SUA.PERSON_ID
, HZ.PARTY_NUMBER
, SUA.COURSE_CD
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UOO.UNIT_CLASS
, UOO.LOCATION_CD
, SUA.UOO_ID
, DECODE(SPLAC.SPLACEMENT_ID
, NULL
, 'N'
, 'Y')
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_EN_SPLACEMENTS SPLAC
, IGS_PS_UNIT_OFR_OPT UOO
, HZ_PARTIES HZ
WHERE SUA.PERSON_ID =SPLAC.PERSON_ID(+)
AND SUA.COURSE_CD =SPLAC.COURSE_CD(+)
AND SUA.UOO_ID =SPLAC.UOO_ID(+)
AND SUA.UOO_ID = UOO.UOO_ID
AND SUA.PERSON_ID = HZ.PARTY_ID WITH READ ONLY
Columns
Name |
PERSON_IDENTIFIER |
PERSON_NUMBER |
PROGRAM_CODE |
UNIT_CODE |
UNIT_VERSION_NUMBER |
UNIT_CLASS |
LOCATION_CODE |
UNIT_SECTION_IDENTIFIER |
STUDENT_PLACEMENT_INDICATOR |