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_BATCHES

Object Details

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

IGS_SV_BATCHES - Main table for each Batch run for gathering information of Foreign Students and Exchange Visitors for SEVIS processing.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_SV_BATCHES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID
IGS_SV_BATCHES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_TYPE
IGS_SV_BATCHES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(14)	Yes	Batch run Identifier for the SEVIS data gathering process
SCHEMA_VERSION	NUMBER	(3)	Yes	Version of the XML Schema that is being used for the XML data transfer to SEVIS
SEVIS_USER_ID	VARCHAR2	(11)		DSO of the batch
SEVIS_SCHOOL_ID	VARCHAR2	(15)	Yes	SEVIS ID that is assigned to the School that is part of the SEVIS program
BATCH_STATUS	VARCHAR2	(1)	Yes	Status flag value for the Batch that has been requested.
BATCH_TYPE	VARCHAR2	(1)	Yes	Type of batch request that has been made. Foreign student request or Exchange Visitor
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
SEVIS_ERROR_CODE	VARCHAR2	(30)		SEVIS error code returned for the batch.
XML_GEN_DATE	DATE			Date for XML Generation
INBOUND_PROCESS_DATE	DATE			Date when the SEVIS Inbound was processed
SEVIS_SCHOOL_ORG_ID	NUMBER	(15)		Party Id of the School
SEVIS_USER_PERSON_ID	NUMBER	(15)		Party Id of the DSO

Query Text

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


SELECT BATCH_ID
,      SCHEMA_VERSION
,      SEVIS_USER_ID
,      SEVIS_SCHOOL_ID
,      BATCH_STATUS
,      BATCH_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SEVIS_ERROR_CODE
,      XML_GEN_DATE
,      INBOUND_PROCESS_DATE
,      SEVIS_SCHOOL_ORG_ID
,      SEVIS_USER_PERSON_ID
FROM IGS.IGS_SV_BATCHES;

Dependencies

[top of page]

IGS.IGS_SV_BATCHES does not reference any database object

IGS.IGS_SV_BATCHES is referenced by following:

APPS: IGS_SV_BATCHES