View: IGS_SV_EV_TERM_EV_BLK_V

Product:	IGS - Student System
Description:	View for terminating the Exchange Visitor information that is in XML file being sent to SEVIS.
Implementation/DBA Data:	APPS.IGS_SV_EV_TERM_EV_BLK_V

View Text

SELECT PRGM.BATCH_ID BATCH_ID
, PRGM.PERSON_ID PERSON_ID
, PRGM.TERMINATION_REASON TERMINATION_REASON
, PRGM.EFFECTIVE_DATE TERMINATION_DATE
, DECODE(PRGM.TERMINATION_REASON
, 'OTHER'
, NULL
, PRGM.REMARKS) TERMINATION_REMARKS
, DECODE(PRGM.TERMINATION_REASON
, 'OTHER'
, PRGM.REMARKS
, NULL) OTHER_REMARKS
FROM IGS_SV_PRGMS_INFO PRGM
WHERE PRGM.PRGM_ACTION_TYPE = 'TR'

Columns