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_CRT_STDT_FIN_V

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

View Text

SELECT FNCL.BATCH_ID
, FNCL.PERSON_ID
, FNCL.ACAD_TERM_LENGTH ACADEMIC_TERM
, FNCL.TUITION
, FNCL.LIVING_EXP LIVING_EXPENSE
, FNCL.DEPENDENT_EXP DEPENDENT_EXPENSE
, FNCL.OTHER_EXP OTHER_EXPENSE
, FNCL.OTHER_EXP_DESC OTHER_EXPENSE_DESC
, FNCL.PERSONAL_FUNDS
, FNCL.SCHOOL_FUNDS
, FNCL.SCHOOL_FUNDS_DESC
, FNCL.OTHER_FUNDS
, FNCL.OTHER_FUNDS_DESC
, FNCL.EMPL_FUNDS EMPLOYMENT_FUNDS
, FNCL.REMARKS FUNDING_REMARKS
FROM IGS_SV_FINANCE_INFO FNCL

Columns

Name
BATCH_ID
PERSON_ID
ACADEMIC_TERM
TUITION
LIVING_EXPENSE
DEPENDENT_EXPENSE
OTHER_EXPENSE
OTHER_EXPENSE_DESC
PERSONAL_FUNDS
SCHOOL_FUNDS
SCHOOL_FUNDS_DESC
OTHER_FUNDS
OTHER_FUNDS_DESC
EMPLOYMENT_FUNDS
FUNDING_REMARKS