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_PE_NONIMG_EMPL

Object Details

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

This table is used for the holding of all student related employment information that is required by SEVIS

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PE_NONIMG_EMPL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	NONIMG_EMPL_ID
IGS_PE_NONIMG_EMPL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NONIMG_FORM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
NONIMG_EMPL_ID	NUMBER	(15)	Yes	A unique identifier
NONIMG_FORM_ID	NUMBER	(15)	Yes	Non-Immigrant Form ID for student
EMPL_TYPE	VARCHAR2	(2)	Yes	Employment type code
RECOMMEND_EMPL	VARCHAR2	(1)		Recommend Employment
RESCIND_EMPL	VARCHAR2	(1)		Rescind Employment
REMARKS	VARCHAR2	(500)		Remarks on Student employment
EMPL_START_DATE	DATE			Employment Start date for the student
EMPL_END_DATE	DATE			Employment End date for the student
COURSE_RELEVANCE	VARCHAR2	(500)		Relevant student employment to course
EMPL_TIME	VARCHAR2	(2)		Employment type of time FULL or PART
EMPL_PARTY_ID	NUMBER	(15)		Employer party ID.
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
PRINT_FLAG	VARCHAR2	(1)		To indicate that a NON IMG form is to be printed
ACTION_CODE	VARCHAR2	(30)		To capture the action code means, if it is a new record, to be deleted , to be modified. Accordingly this record will go in XML under a particular element.

Query Text

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


SELECT NONIMG_EMPL_ID
,      NONIMG_FORM_ID
,      EMPL_TYPE
,      RECOMMEND_EMPL
,      RESCIND_EMPL
,      REMARKS
,      EMPL_START_DATE
,      EMPL_END_DATE
,      COURSE_RELEVANCE
,      EMPL_TIME
,      EMPL_PARTY_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PRINT_FLAG
,      ACTION_CODE
FROM IGS.IGS_PE_NONIMG_EMPL;

Dependencies

[top of page]

IGS.IGS_PE_NONIMG_EMPL does not reference any database object

IGS.IGS_PE_NONIMG_EMPL is referenced by following:

APPS: IGS_PE_NONIMG_EMPL