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