SELECT DISTINCT jbInternational.idnumber
	,jbInternational.lastname
	,jbInternational.firstname
	,jbInternational.midname
	,jbInternational.campus
	,jbInternational.universityid
	,jbInternational.sevisid
	,jbInternational.citizenship
	,jbInternational.immigrationstatus
	,sevisI20Program.prgEndDate
FROM jbInternational
INNER JOIN configAlertOrgCode ON jbInternational.orgCode = configAlertOrgCode.orgCode
	AND configAlertOrgCode.alertGroup = 'Students'
INNER JOIN viewAlertCampusF1 ON jbInternational.campus = viewAlertCampusF1.campus
	AND viewAlertCampusF1.alertGroup = 'Students'
INNER JOIN sevisI20Program ON jbInternational.idnumber = sevisI20Program.idnumber
	AND jbInternational.sevisid = sevisI20Program.sevisid
	AND sevisI20Program.STATUS IN (
		SELECT systemValue
		FROM configFilterSEVISStatusActive
		)
WHERE sevisI20Program.prgEndDate BETWEEN DateAdd(day, 30, GETDATE())
		AND DateAdd(day, 60, getDate())
	AND idnumber = 2302
ORDER BY jbInternational.lastname
	,jbInternational.firstname
	,jbInternational.midname