eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_PE_EV_FORM

Object Details

Object Name:	IGS_PE_EV_FORM
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_PE_EV_FORM
Subobject Name:
Status:	VALID

This table is used to gather input that has been given by the user via the EV form. This is the main table for storing information on the student

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PE_EV_FORM_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EV_FORM_ID
IGS_PE_EV_FORM_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EV_FORM_ID	NUMBER	(15)	Yes	A unique identifier
PERSON_ID	NUMBER	(15)	Yes	Person ID for student
PRINT_FORM	VARCHAR2	(1)	Yes	Flag indicating if the form is to be printed
FORM_EFFECTIVE_DATE	DATE		Yes	Form Effective Date
FORM_STATUS	VARCHAR2	(1)	Yes	Status of the form
CREATE_REASON	VARCHAR2	(30)	Yes	Reason for Exchange Visitor Form being created
IS_VALID	VARCHAR2	(1)	Yes	Flag indicating if student is valid
PRGM_SPONSOR_AMT	NUMBER	(10)		Program sponsor for the student
GOVT_ORG1_AMT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor
GOVT_ORG1_CODE	VARCHAR2	(6)		US Government Agency code supporting
GOVT_ORG2_AMT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor
GOVT_ORG2_CODE	VARCHAR2	(6)		US Government Agency code supporting
INTL_ORG1_AMT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor
INTL_ORG1_CODE	VARCHAR2	(6)		International government agency code supporting
INTL_ORG2_AMT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor
INTL_ORG2_CODE	VARCHAR2	(6)		International government agency code supporting
EV_GOVT_AMT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor from the Exchange Visitors country
BI_NATNL_COM_AMT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor from Binational Commission of Exchange Visitors country
OTHER_GOVT_AMT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor from all other organizations providing support
PERSONAL_FUNDS_AMT	NUMBER	(10)		Personal Funds for the student
EV_FORM_NUMBER	VARCHAR2	(30)		Exchange Visitor Form Number
PRGM_START_DATE	DATE		Yes	Program Start Date
PRGM_END_DATE	DATE		Yes	Program End Date
LAST_REPRINT_DATE	DATE			Last time form was reprinted
REPRINT_REASON	VARCHAR2	(2)		Reprint Reason Code
REPRINT_REMARKS	VARCHAR2	(500)		Reprint Remarks
POSITION_CODE	NUMBER	(3)	Yes	Position Code of Exchange Visitor
POSITION_REMARKS	VARCHAR2	(500)		Position remarks
SUBJECT_FIELD_CODE	VARCHAR2	(7)	Yes	Subject code for the field of study
SUBJECT_FIELD_REMARKS	VARCHAR2	(500)		Subject remarks on field of study
MATRICULATION	VARCHAR2	(2)		Exchange Visitor matriculation
REMARKS	VARCHAR2	(500)		General Remarks
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
CATEGORY_CODE	VARCHAR2	(30)		Category code for the Exchange Visitor
INIT_PRGM_START_DATE	DATE			The exchange visitor initial program date
NO_SHOW_FLAG	VARCHAR2	(1)		Used to capture information if an EV have not reported for program
GOVT_ORG1_OTHR_NAME	VARCHAR2	(360)		Capture the name of the organization if the funding org is selected as OTHER
GOVT_ORG2_OTHR_NAME	VARCHAR2	(360)		Capture the name of the organization if the funding org is selected as OTHER
INTL_ORG1_OTHR_NAME	VARCHAR2	(360)		Capture the name of the organization if the funding org is selected as OTHER
INTL_ORG2_OTHR_NAME	VARCHAR2	(360)		Capture the name of the organization if the funding org is selected as OTHER
OTHER_GOVT_NAME	VARCHAR2	(360)		Captures the name of the other govt organization.
SEVIS_SCHOOL_IDENTIFIER	NUMBER	(15)		Party Id for a School Identifier

Query Text

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


SELECT EV_FORM_ID
,      PERSON_ID
,      PRINT_FORM
,      FORM_EFFECTIVE_DATE
,      FORM_STATUS
,      CREATE_REASON
,      IS_VALID
,      PRGM_SPONSOR_AMT
,      GOVT_ORG1_AMT
,      GOVT_ORG1_CODE
,      GOVT_ORG2_AMT
,      GOVT_ORG2_CODE
,      INTL_ORG1_AMT
,      INTL_ORG1_CODE
,      INTL_ORG2_AMT
,      INTL_ORG2_CODE
,      EV_GOVT_AMT
,      BI_NATNL_COM_AMT
,      OTHER_GOVT_AMT
,      PERSONAL_FUNDS_AMT
,      EV_FORM_NUMBER
,      PRGM_START_DATE
,      PRGM_END_DATE
,      LAST_REPRINT_DATE
,      REPRINT_REASON
,      REPRINT_REMARKS
,      POSITION_CODE
,      POSITION_REMARKS
,      SUBJECT_FIELD_CODE
,      SUBJECT_FIELD_REMARKS
,      MATRICULATION
,      REMARKS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CATEGORY_CODE
,      INIT_PRGM_START_DATE
,      NO_SHOW_FLAG
,      GOVT_ORG1_OTHR_NAME
,      GOVT_ORG2_OTHR_NAME
,      INTL_ORG1_OTHR_NAME
,      INTL_ORG2_OTHR_NAME
,      OTHER_GOVT_NAME
,      SEVIS_SCHOOL_IDENTIFIER
FROM IGS.IGS_PE_EV_FORM;

Dependencies

[top of page]

IGS.IGS_PE_EV_FORM does not reference any database object

IGS.IGS_PE_EV_FORM is referenced by following:

APPS: IGS_PE_EV_FORM