[Home] [Help] [Dependency Information]
Object Name: | IGS_SV_EV_CRT_BIO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_SV_EV_CRT_BIO_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View for fetching biographic information for new Exchange Visitor students
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (14) | Yes | Batch identifier used for the run of the SEVIS process |
PERSON_ID | NUMBER | (15) | Yes | Person identifier that the conviction record is associated to |
EV_LAST_NAME | VARCHAR2 | (40) | Yes | The persons last name. |
EV_FIRST_NAME | VARCHAR2 | (40) | Persons first name | |
EV_MIDDLE_NAME | VARCHAR2 | (40) | Persons middle name. | |
EV_SUFFIX | VARCHAR2 | (3) | Suffix for the persons name | |
EV_BIRTH_DATE | VARCHAR2 | (10) | Yes | Date of the persons birth. |
EV_GENDER | VARCHAR2 | (1) | Persons Gender. | |
EV_BIRTH_CITY | VARCHAR2 | (60) | The Exchange Visitor birth city | |
EV_BIRTH_CNTRY_CODE | VARCHAR2 | (2) | Yes | Country code that the person was born in. |
EV_CITIZEN_CNTRY_CODE | VARCHAR2 | (2) | Citizenship country code value for the person | |
EV_PERM_RES_CNTRY_CODE | VARCHAR2 | (2) | Country code the student is legally from | |
EV_VISA_TYPE | VARCHAR2 | (2) | SEVIS code value for visa type the student is associated to. | |
CATEGORY_CODE | VARCHAR2 | (30) | Category code value for the Exchange Visitor | |
BIRTH_CNTRY_RESN_CODE | VARCHAR2 | (30) | Stores the reason code if the birth of country is U.S. or a U.S. Territory |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.IGS_SV_EV_CRT_BIO_V;
APPS.IGS_SV_EV_CRT_BIO_V is not referenced by any database object
|
|
|