[Home] [Help] [Dependency Information]
Object Name: | IGS_SV_CRT_STDT_BIO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_SV_CRT_STDT_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 of new Non-Immigrant records
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 |
STDNT_LAST_NAME | VARCHAR2 | (40) | Yes | The persons last name. |
STDNT_FIRST_NAME | VARCHAR2 | (40) | Persons first name | |
STDNT_MIDDLE_NAME | VARCHAR2 | (40) | Persons middle name. | |
STDNT_SUFFIX | VARCHAR2 | (3) | Suffix for the persons name | |
STDNT_BIRTH_DATE | VARCHAR2 | (10) | Yes | Date of the persons birth. |
STDNT_GENDER | VARCHAR2 | (1) | Persons Gender. | |
STDNT_BIRTH_CNTRY_CODE | VARCHAR2 | (2) | Yes | Country code that the person was born in. |
STDNT_CITIZEN_CNTRY_CODE | VARCHAR2 | (2) | Citizenship country code value for the person | |
STDNT_COMMUTER | VARCHAR2 | (1) | Flag indicating if student is commuter or not. | |
STDNT_VISA_TYPE | VARCHAR2 | (2) | SEVIS code value for visa type the student is associated to. |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.IGS_SV_CRT_STDT_BIO_V;
APPS.IGS_SV_CRT_STDT_BIO_V is not referenced by any database object
|
|
|