View: IGS_SV_STATUS_DUM_V

Product:	IGS - Student System
Description:	View for fetching status information for student.
Implementation/DBA Data:	APPS.IGS_SV_STATUS_DUM_V

View Text

SELECT PERS.BATCH_ID
, PERS.PDSO_SEVIS_ID PDSO_SEVIS_ID
, PERS.PERSON_ID
, PERS.SEVIS_USER_ID SEVIS_USER_ID
, LTRIM(TO_CHAR(SUBSTR(PERS.PERSON_ID
, 1
, 10)
, '0000000000')) PERSON_NUMBER
, PERS.RECORD_NUMBER RECORD_NUMBER
, LTRIM(TO_CHAR(SUBSTR(PERS.PERSON_ID
, 1
, 14)
, '00000000000000')) PERSON_ID_LONG
, DECODE(PERS.REPRINT_RSN_CODE
, '11'
, NULL
, PERS.REPRINT_RSN_CODE) REPRINT_REASON
, PERS.REPRINT_REMARKS
FROM IGS_SV_PERSONS PERS
WHERE PERS.RECORD_STATUS = 'C'
AND ( PERS.REPRINT_RSN_CODE = '11' OR EXISTS ( SELECT 1
FROM IGS_SV_BTCH_SUMMARY STATUSSUMM
WHERE PERS.PERSON_ID = STATUSSUMM.PERSON_ID
AND PERS.BATCH_ID = STATUSSUMM.BATCH_ID
AND STATUSSUMM.TAG_CODE = 'SV_STATUS'
AND STATUSSUMM.ADM_ACTION_CODE = 'SEND' ) )

Columns