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_EV_CRT_BIO_V

Product:	IGS - Student System (Obsolete)
Description:	View for fetching biographic information for new Exchange Visitor students
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT BIO.BATCH_ID
, BIO.PERSON_ID
, BIO.LAST_NAME EV_LAST_NAME
, BIO.FIRST_NAME EV_FIRST_NAME
, BIO.MIDDLE_NAME EV_MIDDLE_NAME
, BIO.SUFFIX EV_SUFFIX
, BIO.BIRTH_DATE EV_BIRTH_DATE
, BIO.GENDER EV_GENDER
, BIO.BIRTH_CITY EV_BIRTH_CITY
, BIO.BIRTH_CNTRY_CODE EV_BIRTH_CNTRY_CODE
, BIO.CITIZEN_CNTRY_CODE EV_CITIZEN_CNTRY_CODE
, BIO.LEGAL_RES_CNTRY_CODE EV_PERM_RES_CNTRY_CODE
, BIO.VISA_TYPE EV_VISA_TYPE
, BIO.CATEGORY_CODE CATEGORY_CODE
, BIO.BIRTH_CNTRY_RESN_CODE
FROM IGS_SV_BIO_INFO BIO

Columns

Name
BATCH_ID
PERSON_ID
EV_LAST_NAME
EV_FIRST_NAME
EV_MIDDLE_NAME
EV_SUFFIX
EV_BIRTH_DATE
EV_GENDER
EV_BIRTH_CITY
EV_BIRTH_CNTRY_CODE
EV_CITIZEN_CNTRY_CODE
EV_PERM_RES_CNTRY_CODE
EV_VISA_TYPE
CATEGORY_CODE
BIRTH_CNTRY_RESN_CODE