eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_SV_CRT_STDT_PRGM_V

Product:	IGS - Student System (Obsolete)
Description:	View for fetching program information for the new Non-Immigrant students
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PRGM.BATCH_ID
, PRGM.PERSON_ID
, PRGM.EDUCATION_LEVEL
, PRGM.EDUC_LVL_REMARKS
, PRGM.PRIMARY_MAJOR
, PRGM.SECONDARY_MAJOR SECOND_MAJOR
, PRGM.MINOR
, PRGM.LENGTH_OF_STUDY
, PRGM.PRGM_START_DATE PRG_START_DATE
, PRGM.PRGM_END_DATE PRG_END_DATE
, PRGM.ENGLISH_REQD ENGL_REQUIRED
, PRGM.ENGLISH_REQD_MET ENGL_REQUIREMENTS_MET
, PRGM.NOT_REQD_REASON ENGL_NOT_REQD_REASON
, PRGM.REMARKS PROG_REMARKS
FROM IGS_SV_PRGMS_INFO PRGM

Columns

Name
BATCH_ID
PERSON_ID
EDUCATION_LEVEL
EDUC_LVL_REMARKS
PRIMARY_MAJOR
SECOND_MAJOR
MINOR
LENGTH_OF_STUDY
PRG_START_DATE
PRG_END_DATE
ENGL_REQUIRED
ENGL_REQUIREMENTS_MET
ENGL_NOT_REQD_REASON
PROG_REMARKS