FND Design Data [Home] [Help]

View: IGS_DA_XML_DEGREEPROGRAM_V

Product: IGS - Student System (Obsolete)
Description: XML element DegreeProgramLead index view to Academic Program and Academic Subprogram. Provides the batch_id, local_institution_cd, and person_id to the sub views whereclause is provide in XML map.
Implementation/DBA Data: Not implemented in this database
View Text

SELECT DISTINCT DRS.BATCH_ID
, HP.PARTY_NUMBER
, DRS.PERSON_ID
FROM HZ_PARTIES HP
, IGS_DA_REQ_STDNTS DRS
WHERE DRS.REPORT_TEXT IS NULL

Columns

Name
BATCH_ID
INSTITUTION_CD
PERSON_ID