[Home] [Help] [Dependency Information]
Object Name: | IGS_SV_EDT_BIO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_SV_EDT_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
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 |
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;
APPS.IGS_SV_EDT_BIO_V is not referenced by any database object
|
|
|