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.

[Home] [Help]

View: IGS_SV_EV_CRT_FIN_V

Product:	IGS - Student System (Obsolete)
Description:	View for fetching financial information for new Exchange Visitor students
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT FNCL.PERSON_ID
, FNCL.BATCH_ID
, FNCL.RECVD_US_GVT_FUNDS RECVD_US_GOV_FUNDS
, FNCL.PROGRAM_SPONSOR PRGM_SPONSOR_FUNDS
, FNCL.GOVT_ORG1_CODE US_GOVT_ORG1_CODE
, FNCL.GOVT_ORG1 US_GOVT_ORG1_FUNDS
, FNCL.GOVT_ORG2_CODE US_GOVT_ORG2_CODE
, FNCL.GOVT_ORG2 US_GOVT_ORG2_FUNDS
, FNCL.INTL_ORG1_CODE INTL_GOVT_ORG1_CODE
, FNCL.INTL_ORG1 INTL_GOVT_ORG1_FUNDS
, FNCL.INTL_ORG2_CODE INTL_GOVT_ORG2_CODE
, FNCL.INTL_ORG2 INTL_GOVT_ORG2_FUNDS
, FNCL.EV_GOVT EV_GOVT_FUNDS
, FNCL.BI_NATNL_COM BI_NATIONAL_COMM_FUNDS
, FNCL.OTHER_ORG OTHER_ORG_FUNDS
, FNCL.PERSONAL_FUNDS PERSONAL_FUNDS
, FNCL.REMARKS FUND_REMARKS
, FNCL.GOVT_ORG1_OTHR_NAME
, FNCL.GOVT_ORG2_OTHR_NAME
, FNCL.INTL_ORG1_OTHR_NAME
, FNCL.INTL_ORG2_OTHR_NAME
, FNCL.OTHER_GOVT_NAME
FROM IGS_SV_FINANCE_INFO FNCL

Columns

Name
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