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_EMPL_INFO

Object Details

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

IGS_SV_EMPL_INFO - Table to hold all employment related information on Foreign students and Exchange Visitors that is required to be sent to SEVIS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_SV_EMPL_INFO_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID PERSON_ID EMPL_REC_TYPE
IGS_SV_EMPL_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
EMPL_REC_TYPE	VARCHAR2	(1)	Yes	Employment record type that is being sent to SEVIS.
PRINT_FORM	VARCHAR2	(1)	Yes	Flag indicating to SEVIS to print the form or not
EMPL_TYPE	VARCHAR2	(2)	Yes	Employment type for the record being sent. Off campus OPT or CPT.
NONIMG_EMPL_ID	NUMBER	(15)	Yes	Foreign student employment identifier.
RECOMMEND_EMPL	VARCHAR2	(1)		Flag indicating if student has been recommended for employment or not.
RESCIND_EMPL	VARCHAR2	(1)		Flag indicating if student has rescinded employment or not.
REMARKS	VARCHAR2	(500)		Remarks made by student on employment record
EMPL_START_DATE	VARCHAR2	(10)		Date that the student started this type of employment.
EMPL_END_DATE	VARCHAR2	(10)		Date that the student is to end employment of this type.
EMPL_NAME	VARCHAR2	(500)		Student employers company name
EMPL_TIME	VARCHAR2	(2)		Employment time for this type Full or Part time.
COURSE_RELEVANCE	VARCHAR2	(500)		Course that has relevance to this employment for student
EMPL_ADDR_LINE1	VARCHAR2	(60)		Employers address line 1.
EMPL_ADDR_LINE2	VARCHAR2	(60)		Employers address line 2.
CITY	VARCHAR2	(60)		Employers city
STATE	VARCHAR2	(2)		Employers state
POSTAL_CODE	VARCHAR2	(5)		Employers postal code
POSTAL_ROUTING_CODE	VARCHAR2	(4)		Employers postal routing code
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
CREATION_DATE	DATE		Yes	Standard Who Column
ACTION_CODE	VARCHAR2	(30)		Action to indicate, if it is a new record, to be deleted or to be modified

Query Text

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


SELECT BATCH_ID
,      PERSON_ID
,      EMPL_REC_TYPE
,      PRINT_FORM
,      EMPL_TYPE
,      NONIMG_EMPL_ID
,      RECOMMEND_EMPL
,      RESCIND_EMPL
,      REMARKS
,      EMPL_START_DATE
,      EMPL_END_DATE
,      EMPL_NAME
,      EMPL_TIME
,      COURSE_RELEVANCE
,      EMPL_ADDR_LINE1
,      EMPL_ADDR_LINE2
,      CITY
,      STATE
,      POSTAL_CODE
,      POSTAL_ROUTING_CODE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      ACTION_CODE
FROM IGS.IGS_SV_EMPL_INFO;

Dependencies

[top of page]

IGS.IGS_SV_EMPL_INFO does not reference any database object

IGS.IGS_SV_EMPL_INFO is referenced by following:

APPS: IGS_SV_EMPL_INFO