DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_SV_EDT_BIO_V

Object Details
Object Name: IGS_SV_EDT_BIO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_SV_EDT_BIO_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View for fetching biographic information


[View Source]

Columns
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
PRINT_FORM VARCHAR2 (1) Yes Flag to indicate if SEVIS is to print the form based on user request.
FIRST_NAME VARCHAR2 (40)
Persons first name
LAST_NAME VARCHAR2 (40) Yes The persons last name.
MIDDLE_NAME VARCHAR2 (40)
Persons middle name.
BIRTH_DATE VARCHAR2 (10) Yes Date of the persons birth.
GENDER VARCHAR2 (1)
Persons Gender.
BIRTH_CNTRY_CODE VARCHAR2 (2) Yes Country code that the person was born in.
CTZNSHIP_CNTRY_CODE VARCHAR2 (2)
Citizenship country code value for the person
COMMUTER VARCHAR2 (1)
Flag indicating if student is commuter or not.
SUFFIX VARCHAR2 (3)
Suffix for the persons name
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ID
,      PERSON_ID
,      PRINT_FORM
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAME
,      BIRTH_DATE
,      GENDER
,      BIRTH_CNTRY_CODE
,      CTZNSHIP_CNTRY_CODE
,      COMMUTER
,      SUFFIX
FROM APPS.IGS_SV_EDT_BIO_V;

Dependencies

[top of page]

APPS.IGS_SV_EDT_BIO_V references the following:

SchemaAPPS
SynonymIGS_SV_BIO_INFO
SynonymIGS_SV_BTCH_SUMMARY

APPS.IGS_SV_EDT_BIO_V is not referenced by any database object