[Home] [Help] [Dependency Information]
Object Name: | IGS_SV_BIO_INFO |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_SV_BIO_INFO |
Subobject Name: | |
Status: | VALID |
IGS_SV_BIO_INFO - Table that is to be used for all the student Bio information that is new or updated. All information on Foreign students or Exchange Visitors that is required for SEVIS.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_SV_BIO_INFO_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BATCH_ID
PERSON_ID |
IGS_SV_BIO_INFO_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PERSON_ID |
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. |
BIRTH_DATE | VARCHAR2 | (10) | Yes | Date of the persons birth. |
BIRTH_CNTRY_CODE | VARCHAR2 | (2) | Yes | Country code that the person was born in. |
LAST_NAME | VARCHAR2 | (40) | Yes | The persons last name. |
CITIZEN_CNTRY_CODE | VARCHAR2 | (2) | Citizenship country code value for the person | |
MIDDLE_NAME | VARCHAR2 | (40) | Persons middle name. | |
FIRST_NAME | VARCHAR2 | (40) | Persons first name | |
SUFFIX | VARCHAR2 | (3) | Suffix for the persons name | |
GENDER | VARCHAR2 | (1) | Persons Gender. | |
LEGAL_RES_CNTRY_CODE | VARCHAR2 | (2) | Country code the student is legally from | |
POSITION_CODE | VARCHAR2 | (3) | SEVIS position code for the student | |
COMMUTER | VARCHAR2 | (1) | Flag indicating if student is commuter or not. | |
VISA_TYPE | VARCHAR2 | (2) | SEVIS code value for visa type the student is associated to. | |
REMARKS | VARCHAR2 | (500) | Storage for the remarks on the students Bio information | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
BIRTH_CITY | VARCHAR2 | (60) | The Exchange Visitor birth city | |
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
, PRINT_FORM
, BIRTH_DATE
, BIRTH_CNTRY_CODE
, LAST_NAME
, CITIZEN_CNTRY_CODE
, MIDDLE_NAME
, FIRST_NAME
, SUFFIX
, GENDER
, LEGAL_RES_CNTRY_CODE
, POSITION_CODE
, COMMUTER
, VISA_TYPE
, REMARKS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, BIRTH_CITY
, CATEGORY_CODE
, BIRTH_CNTRY_RESN_CODE
FROM IGS.IGS_SV_BIO_INFO;
IGS.IGS_SV_BIO_INFO does not reference any database object
IGS.IGS_SV_BIO_INFO is referenced by following:
|
|
|