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.IGS_SV_EV_CRT_FIN_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

View for fetching financial information for new Exchange Visitor students

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person identifier that the conviction record is associated to
BATCH_ID	NUMBER	(14)	Yes	Batch identifier used for the run of the SEVIS process
RECVD_US_GOV_FUNDS	VARCHAR2	(1)		Yes or No flag indicating that the Exchange Visitor has received United States Government Funds.
PRGM_SPONSOR_FUNDS	NUMBER			Program sponsor for the Exchange Visitor
US_GOVT_ORG1_CODE	VARCHAR2	(6)		United States government agency code supporting Exchange Visitor
US_GOVT_ORG1_FUNDS	NUMBER	(10)		United States Government agency amount for the Exchange Visitor
US_GOVT_ORG2_CODE	VARCHAR2	(6)		United States government agency code supporting Exchange Visitor
US_GOVT_ORG2_FUNDS	NUMBER	(10)		United States Government agency amount for the Exchange Visitor
INTL_GOVT_ORG1_CODE	VARCHAR2	(6)		International agency code supporting Exchange Visitor
INTL_GOVT_ORG1_FUNDS	NUMBER	(10)		International government agency amount for Exchange Visitor
INTL_GOVT_ORG2_CODE	VARCHAR2	(6)		International agency code supporting Exchange Visitor
INTL_GOVT_ORG2_FUNDS	NUMBER	(10)		International government agency amount for Exchange Visitor
EV_GOVT_FUNDS	NUMBER	(10)		Financial amount for Exchange Visitor from the students legal residence country
BI_NATIONAL_COMM_FUNDS	NUMBER	(10)		Bi-National Commision financial support amount for the Exchange Visitor.
OTHER_ORG_FUNDS	NUMBER	(10)		Other organization funds amount for the Exchange Visitor.
PERSONAL_FUNDS	NUMBER	(10)		Personal Funds for the student
FUND_REMARKS	VARCHAR2	(500)		Remarks for the student financial information
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.

Query Text

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


SELECT PERSON_ID
,      BATCH_ID
,      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
,      GOVT_ORG1_OTHR_NAME
,      GOVT_ORG2_OTHR_NAME
,      INTL_ORG1_OTHR_NAME
,      INTL_ORG2_OTHR_NAME
,      OTHER_GOVT_NAME
FROM APPS.IGS_SV_EV_CRT_FIN_V;

Dependencies

[top of page]

APPS.IGS_SV_EV_CRT_FIN_V references the following:

APPS: IGS_SV_FINANCE_INFO

APPS.IGS_SV_EV_CRT_FIN_V is not referenced by any database object