[Home] [Help] [Dependency Information]
Object Name: | IGS_SV_EV_CRT_EV_BLK_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_SV_EV_CRT_EV_BLK_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
Create Exchange Visitor Block View.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (14) | Yes | Batch request identifier |
PERSON_ID | NUMBER | (15) | Yes | Person identifier in the request block |
PRINT_FORM | VARCHAR2 | (1) | Yes | Flag indicating whether form is to be printed or not. |
SEVIS_USER_ID | VARCHAR2 | (11) | SEVIS User Identifier based on user creation. | |
RECORD_NUMBER | NUMBER | (20) | Yes | Record number for the person in the batch request. |
EV_LAST_NAME | VARCHAR2 | (0) | Exchange Visitors last name | |
EV_FIRST_NAME | VARCHAR2 | (0) | Exchange Visitor first name | |
EV_MIDDLE_NAME | VARCHAR2 | (0) | Exchange Visitor middle name | |
EV_SUFFIX | VARCHAR2 | (0) | Exchange Visitor suffix | |
EV_BIRTH_DATE | VARCHAR2 | (0) | Exchange Visitor birth date | |
EV_GENDER | VARCHAR2 | (0) | Exchange Visitor gender | |
EV_BIRTH_CITY | VARCHAR2 | (0) | Exchange Visitor birth city | |
EV_BIRTH_CNTRY_CODE | VARCHAR2 | (0) | Exchange Visitory birth country code | |
EV_CITIZEN_CNTRY_CODE | VARCHAR2 | (0) | Exchange Visitor citizenship country code. | |
EV_PERM_RES_CNTRY_CODE | VARCHAR2 | (0) | Exchange Visitor permanent residency country code. | |
POSITION_CODE | VARCHAR2 | (0) | Exchange Visitor position code. | |
EV_VISA_TYPE | VARCHAR2 | (0) | Exchange Visitor Visa Type | |
US_ADDRESS_LINE1 | VARCHAR2 | (0) | United States address line 1. | |
US_ADDRESS_LINE2 | VARCHAR2 | (0) | United States address line 2 | |
US_CITY | VARCHAR2 | (0) | United States City of residence | |
US_STATE | VARCHAR2 | (0) | United States state of residence | |
US_POSTAL_CODE | VARCHAR2 | (0) | United States postal code | |
US_POSTAL_ROUTING_CODE | VARCHAR2 | (0) | United States postal routing code for address | |
CREATE_REASON_CODE | VARCHAR2 | (30) | Exchange Visitor create reason code. | |
INITIAL_PRGM_DATE | VARCHAR2 | (10) | Exchange Visitor initial program date | |
FORM_NUMBER | VARCHAR2 | (30) | Exchange Visitor form number. | |
PRGM_START_DATE | VARCHAR2 | (10) | Exchange Visitor program start date | |
PRGM_END_DATE | VARCHAR2 | (10) | Exchange Visitor program end date | |
RECVD_US_GOV_FUNDS | VARCHAR2 | (0) | Flag indicating Exchange Visitor received United States government funding. | |
PRGM_SPONSOR_FUNDS | VARCHAR2 | (0) | Amount of program sponsor funds received for Exchange Visitor. | |
US_GOVT_ORG1_CODE | VARCHAR2 | (0) | United States government organization code | |
US_GOVT_ORG1_FUNDS | VARCHAR2 | (0) | United States fund amount from Organization 1. | |
US_GOVT_ORG2_CODE | VARCHAR2 | (0) | United States government organization code | |
US_GOVT_ORG2_FUNDS | VARCHAR2 | (0) | United States government oganization funds | |
INTL_GOVT_ORG1_CODE | VARCHAR2 | (0) | International government organization code | |
INTL_GOVT_ORG1_FUNDS | VARCHAR2 | (0) | International government organization funds amount | |
INTL_GOVT_ORG2_CODE | VARCHAR2 | (0) | International government organization code | |
INTL_GOVT_ORG2_FUNDS | VARCHAR2 | (0) | International government organization funds amount | |
EV_GOVT_FUNDS | VARCHAR2 | (0) | Exchange Visitor government funds amount | |
BI_NATIONAL_COMM_FUNDS | VARCHAR2 | (0) | Bi national funds amount | |
OTHER_ORG_FUNDS | VARCHAR2 | (0) | Other organization funds received by Exchange Visitor | |
PERSONAL_FUNDS | VARCHAR2 | (0) | Exchange Visitor personal funds amount | |
FUND_REMARKS | VARCHAR2 | (0) | Remarks made for the funding of the Exchange Visitor | |
CATEGORY_CODE | VARCHAR2 | (0) | Category code for the Exchange Visitor. | |
SUBJECT_FIELD_CODE | VARCHAR2 | (0) | Subject Field Code value for the Exchange Visitor. | |
SUBJECT_REMARKS | VARCHAR2 | (0) | Exchange Visitor subject field remarks. | |
PDSO_SEVIS_ID | VARCHAR2 | (11) | Institutions PDSO SEVIS User identification number | |
STDNT_PERSON_ID | NUMBER | (15) | Yes | Exchange Visitor Person identifier. |
STDNT_PERSON_NUMBER | VARCHAR2 | (11) | Exchange Visitor Person Number | |
PERSON_ID_LONG | VARCHAR2 | (15) | Exchange Visitor Person identifier long value. |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, PERSON_ID
, PRINT_FORM
, SEVIS_USER_ID
, RECORD_NUMBER
, EV_LAST_NAME
, EV_FIRST_NAME
, EV_MIDDLE_NAME
, EV_SUFFIX
, EV_BIRTH_DATE
, EV_GENDER
, EV_BIRTH_CITY
, EV_BIRTH_CNTRY_CODE
, EV_CITIZEN_CNTRY_CODE
, EV_PERM_RES_CNTRY_CODE
, POSITION_CODE
, EV_VISA_TYPE
, US_ADDRESS_LINE1
, US_ADDRESS_LINE2
, US_CITY
, US_STATE
, US_POSTAL_CODE
, US_POSTAL_ROUTING_CODE
, CREATE_REASON_CODE
, INITIAL_PRGM_DATE
, FORM_NUMBER
, PRGM_START_DATE
, PRGM_END_DATE
, RECVD_US_GOV_FUNDS
, PRGM_SPONSOR_FUNDS
, US_GOVT_ORG1_CODE
, US_GOVT_ORG1_FUNDS
, US_GOVT_ORG2_CODE
, US_GOVT_ORG2_FUNDS
, INTL_GOVT_ORG1_CODE
, INTL_GOVT_ORG1_FUNDS
, INTL_GOVT_ORG2_CODE
, INTL_GOVT_ORG2_FUNDS
, EV_GOVT_FUNDS
, BI_NATIONAL_COMM_FUNDS
, OTHER_ORG_FUNDS
, PERSONAL_FUNDS
, FUND_REMARKS
, CATEGORY_CODE
, SUBJECT_FIELD_CODE
, SUBJECT_REMARKS
, PDSO_SEVIS_ID
, STDNT_PERSON_ID
, STDNT_PERSON_NUMBER
, PERSON_ID_LONG
FROM APPS.IGS_SV_EV_CRT_EV_BLK_V;
APPS.IGS_SV_EV_CRT_EV_BLK_V is not referenced by any database object
|
|
|