[Home] [Help]
View: IGS_SV_CRT_STDT_BIO_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | View for fetching biographic information of new Non-Immigrant records |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT BIO.BATCH_ID
, BIO.PERSON_ID
, BIO.LAST_NAME STDNT_LAST_NAME
, BIO.FIRST_NAME STDNT_FIRST_NAME
, BIO.MIDDLE_NAME STDNT_MIDDLE_NAME
, BIO.SUFFIX STDNT_SUFFIX
, BIO.BIRTH_DATE STDNT_BIRTH_DATE
, BIO.GENDER STDNT_GENDER
, BIO.BIRTH_CNTRY_CODE STDNT_BIRTH_CNTRY_CODE
, BIO.CITIZEN_CNTRY_CODE STDNT_CITIZEN_CNTRY_CODE
, BIO.COMMUTER STDNT_COMMUTER
, BIO.VISA_TYPE STDNT_VISA_TYPE
FROM IGS_SV_BIO_INFO BIO
Columns
| Name |
| BATCH_ID |
| PERSON_ID |
| STDNT_LAST_NAME |
| STDNT_FIRST_NAME |
| STDNT_MIDDLE_NAME |
| STDNT_SUFFIX |
| STDNT_BIRTH_DATE |
| STDNT_GENDER |
| STDNT_BIRTH_CNTRY_CODE |
| STDNT_CITIZEN_CNTRY_CODE |
| STDNT_COMMUTER |
| STDNT_VISA_TYPE |