[Home] [Help]
View: IGS_DA_XML_STUDENTTYPE_V
Product: | IGS - Student System (Obsolete) |
Description: | XML element StudentType |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT PTI.PERSON_TYPE_CODE
, PTI.PERSON_ID
FROM IGS_PE_TYP_INSTANCES_ALL PTI
, IGS_PE_PERSON_TYPES PPT
WHERE NVL (PTI.END_DATE
, SYSDATE) >= SYSDATE
AND PTI.PERSON_TYPE_CODE = PPT.PERSON_TYPE_CODE
AND NVL (PPT.CLOSED_IND
, 'N') = 'N'
AND PPT.SYSTEM_TYPE IN ('STUDENT'
, 'FORMER_STUDENT'
, 'GRADUATE')
Columns
Name |
STUDENT_TYPE |
PERSON_ID |