[Home] [Help] [Dependency Information]
Object Name: | IGS_SV_EV_EDT_BIO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_SV_EV_EDT_BIO_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View for fetching modified biographic informations for 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 |
LAST_NAME | VARCHAR2 | (40) | Yes | The persons last name. |
FIRST_NAME | VARCHAR2 | (40) | Persons first name | |
MIDDLE_NAME | VARCHAR2 | (40) | Persons middle name. | |
SUFFIX | VARCHAR2 | (3) | Suffix for the persons name | |
BIRTH_DATE | VARCHAR2 | (10) | Yes | Date of the persons birth. |
GENDER | VARCHAR2 | (1) | Persons Gender. | |
BIRTH_CITY | VARCHAR2 | (60) | The Exchange Visitor birth city | |
BIRTH_CNTRY_CODE | VARCHAR2 | (2) | Yes | Country code that the person was born in. |
CITIZEN_CNTRY_CODE | VARCHAR2 | (2) | Citizenship country code value for the person | |
PERM_RES_CNTRY_CODE | VARCHAR2 | (2) | Country code the student is legally from | |
POSITION_CODE | VARCHAR2 | (3) | SEVIS position code for the student | |
REMARKS | VARCHAR2 | (500) | Storage for the remarks on the students Bio information | |
BIRTH_CNTRY_RESN_CODE | VARCHAR2 | (30) | Stores the reason code if the birth of country is U.S. or a U.S. Territory | |
PRINT_FORM | VARCHAR2 | (1) | Yes | Flag to indicate if SEVIS is to print the form based on user request. |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, PERSON_ID
, LAST_NAME
, FIRST_NAME
, MIDDLE_NAME
, SUFFIX
, BIRTH_DATE
, GENDER
, BIRTH_CITY
, BIRTH_CNTRY_CODE
, CITIZEN_CNTRY_CODE
, PERM_RES_CNTRY_CODE
, POSITION_CODE
, REMARKS
, BIRTH_CNTRY_RESN_CODE
, PRINT_FORM
FROM APPS.IGS_SV_EV_EDT_BIO_V;
APPS.IGS_SV_EV_EDT_BIO_V is not referenced by any database object
|
|
|