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_SV_FINANCE_INFO

Object Details

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

IGS_SV_FINANCE_INFO - Table that stores all the financial information on Foreign students and Exchange Visitors that is required for SEVIS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_SV_FINANCE_INFO_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID PERSON_ID
IGS_SV_FINANCE_INFO_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(14)	Yes	Batch identifier used for the run of the SEVIS process
PERSON_ID	NUMBER	(15)	Yes	Person identifier that the conviction record is associated to
PRINT_FORM	VARCHAR2	(1)	Yes	Flag indicating if SEVIS is being requested to print the form
ACAD_TERM_LENGTH	VARCHAR2	(2)		Academic Term length the student is expected to be present for.
TUITION	NUMBER	(10)		Tuition amount that the student is getting
LIVING_EXP	NUMBER	(10)		Living expense amount for the student.
PERSONAL_FUNDS	NUMBER	(10)		Personal Funds for the student
DEPENDENT_EXP	NUMBER	(10)		Dependent expenses amount for the student.
OTHER_EXP	NUMBER	(10)		Other expenses amount for the student
OTHER_EXP_DESC	VARCHAR2	(500)		Description of the other expenses for the student
SCHOOL_FUNDS	NUMBER	(10)		School funds amount for the student.
SCHOOL_FUNDS_DESC	VARCHAR2	(500)		Description of the school funds amount
OTHER_FUNDS	NUMBER	(10)		Other funds amount for the student
OTHER_FUNDS_DESC	VARCHAR2	(500)		Other funds description for the student
EMPL_FUNDS	NUMBER	(10)		Employment funds amount for the student
PROGRAM_SPONSOR	NUMBER			Program sponsor for the Exchange Visitor
GOVT_ORG1	NUMBER	(10)		United States Government agency amount for the Exchange Visitor
GOVT_ORG2	NUMBER	(10)		United States Government agency amount for the Exchange Visitor
GOVT_ORG1_CODE	VARCHAR2	(6)		United States government agency code supporting Exchange Visitor
GOVT_ORG2_CODE	VARCHAR2	(6)		United States government agency code supporting Exchange Visitor
INTL_ORG1	NUMBER	(10)		International government agency amount for Exchange Visitor
INTL_ORG2	NUMBER	(10)		International government agency amount for Exchange Visitor
INTL_ORG1_CODE	VARCHAR2	(6)		International agency code supporting Exchange Visitor
INTL_ORG2_CODE	VARCHAR2	(6)		International agency code supporting Exchange Visitor
EV_GOVT	NUMBER	(10)		Financial amount for Exchange Visitor from the students legal residence country
BI_NATNL_COM	NUMBER	(10)		Bi-National Commision financial support amount for the Exchange Visitor.
OTHER_ORG	NUMBER	(10)		Other organization funds amount for the Exchange Visitor.
REMARKS	VARCHAR2	(500)		Remarks for the student financial information
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
RECVD_US_GVT_FUNDS	VARCHAR2	(1)		Yes or No flag indicating that the Exchange Visitor has received United States Government Funds.
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 BATCH_ID
,      PERSON_ID
,      PRINT_FORM
,      ACAD_TERM_LENGTH
,      TUITION
,      LIVING_EXP
,      PERSONAL_FUNDS
,      DEPENDENT_EXP
,      OTHER_EXP
,      OTHER_EXP_DESC
,      SCHOOL_FUNDS
,      SCHOOL_FUNDS_DESC
,      OTHER_FUNDS
,      OTHER_FUNDS_DESC
,      EMPL_FUNDS
,      PROGRAM_SPONSOR
,      GOVT_ORG1
,      GOVT_ORG2
,      GOVT_ORG1_CODE
,      GOVT_ORG2_CODE
,      INTL_ORG1
,      INTL_ORG2
,      INTL_ORG1_CODE
,      INTL_ORG2_CODE
,      EV_GOVT
,      BI_NATNL_COM
,      OTHER_ORG
,      REMARKS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RECVD_US_GVT_FUNDS
,      GOVT_ORG1_OTHR_NAME
,      GOVT_ORG2_OTHR_NAME
,      INTL_ORG1_OTHR_NAME
,      INTL_ORG2_OTHR_NAME
,      OTHER_GOVT_NAME
FROM IGS.IGS_SV_FINANCE_INFO;

Dependencies

[top of page]

IGS.IGS_SV_FINANCE_INFO does not reference any database object

IGS.IGS_SV_FINANCE_INFO is referenced by following:

APPS: IGS_SV_FINANCE_INFO