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]

VIEW: APPS.IGSFV_EXCHANGE_VISITORS

Object Details

Object Name:	IGSFV_EXCHANGE_VISITORS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_EXCHANGE_VISITORS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This entity contains information about the person entering the institution as an exchange visitor.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PRINT_FORM	VARCHAR2	(1)	Yes	Flag indicating if the form is to be printed
FORM_EFFECTIVE_DATE	DATE		Yes	Form Effective Date
_LA:FORM_STATUS	CHAR	(64)		Status of the form
CREATE_REASON	VARCHAR2	(30)	Yes	Reason for Exchange Visitor Form being created
IS_VALID	VARCHAR2	(1)	Yes	Flag indicating if exchange visitor is valid
PROGRAM_SPONSOR_AMOUNT	NUMBER	(10)		Program sponsor Amount for the exchange visitor.
GOVERNMENT_ORG1_AMOUNT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor from government organization 1
GOVERNMENT_ORG1_CODE	VARCHAR2	(6)		US Government Agency code supporting
GOVERNMENT_ORG2_AMOUNT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor from government organization 2
GOVERNMENT_ORG2_CODE	VARCHAR2	(6)		US Government Agency code supporting
INTERNATIONAL_ORG1_AMOUNT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor from international organization 1
INTERNATIONAL_ORG1_CODE	VARCHAR2	(6)		International government agency code supporting
INTERNATIONAL_ORG2_AMOUNT	NUMBER	(10)		Financial support in US dollars for Exchange Visitorfrom international organization 2
INTERNATIONAL_ORG2_CODE	VARCHAR2	(6)		International government agency code supporting
EXCHANGE_VISITOR_GOVT_AMOUNT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor from the Exchange Visitors country
BI_NATIONAL_COMMISION_AMOUNT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor from Binational Commission of Exchange Visitors country
OTHER_GOVERNMENT_AMOUNT	NUMBER	(10)		Financial support in US dollars for Exchange Visitor from all other organizations providing support
PERSONAL_FUNDS_AMOUNT	NUMBER	(10)		Personal Funds for the exchange visitor
EXCHANGE_VISITOR_FORM_NUMBER	VARCHAR2	(30)		Exchange Visitor Form Number
PROGRAM_START_DATE	DATE		Yes	Program Start Date
PROGRAM_END_DATE	DATE		Yes	Program End Date
LAST_REPRINT_DATE	DATE			Last time form was reprinted
_LA:REPRINT_REASON	CHAR	(69)		Reprint Reason
REPRINT_REMARKS	VARCHAR2	(500)		Reprint Remarks
_LA:POSITION_CODE	CHAR	(65)		Position of Exchange Visitor
POSITION_REMARKS	VARCHAR2	(500)		Position remarks
_LA:SUBJECT_FIELD_CODE	CHAR	(73)		Subject code for the field of study
SUBJECT_FIELD_REMARKS	VARCHAR2	(500)		Subject remarks on field of study
_LA:MATRICULATION	CHAR	(66)		Exchange Visitor matriculation
REMARKS	VARCHAR2	(500)		General Remarks
_LA:CATEGORY_CODE	CHAR	(69)		Category code for the Exchange Visitor
INITIAL_PROGRAM_START_DATE	DATE			The exchange visitor initial program date
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person number
EV_FORM_ID	NUMBER	(15)	Yes	Unique identifier of the exchange visitor form
PERSON_ID	NUMBER	(15)	Yes	Unique identifier of the person
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

Query Text

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


SELECT PRINT_FORM
,      FORM_EFFECTIVE_DATE
,      _LA:FORM_STATUS
,      CREATE_REASON
,      IS_VALID
,      PROGRAM_SPONSOR_AMOUNT
,      GOVERNMENT_ORG1_AMOUNT
,      GOVERNMENT_ORG1_CODE
,      GOVERNMENT_ORG2_AMOUNT
,      GOVERNMENT_ORG2_CODE
,      INTERNATIONAL_ORG1_AMOUNT
,      INTERNATIONAL_ORG1_CODE
,      INTERNATIONAL_ORG2_AMOUNT
,      INTERNATIONAL_ORG2_CODE
,      EXCHANGE_VISITOR_GOVT_AMOUNT
,      BI_NATIONAL_COMMISION_AMOUNT
,      OTHER_GOVERNMENT_AMOUNT
,      PERSONAL_FUNDS_AMOUNT
,      EXCHANGE_VISITOR_FORM_NUMBER
,      PROGRAM_START_DATE
,      PROGRAM_END_DATE
,      LAST_REPRINT_DATE
,      _LA:REPRINT_REASON
,      REPRINT_REMARKS
,      _LA:POSITION_CODE
,      POSITION_REMARKS
,      _LA:SUBJECT_FIELD_CODE
,      SUBJECT_FIELD_REMARKS
,      _LA:MATRICULATION
,      REMARKS
,      _LA:CATEGORY_CODE
,      INITIAL_PROGRAM_START_DATE
,      PERSON_NUMBER
,      EV_FORM_ID
,      PERSON_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_EXCHANGE_VISITORS;

Dependencies

[top of page]

APPS.IGSFV_EXCHANGE_VISITORS references the following:

APPS: HZ_PARTIES; IGS_PE_EV_FORM

APPS.IGSFV_EXCHANGE_VISITORS is not referenced by any database object