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_PRGMS_INFO

Object Details

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

IGS_SV_PRGMS_INFO - Table for program related information that SEVIS requires on the Foreign student and Exchange Visitors.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_SV_PRGMS_INFO_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID PERSON_ID PRGM_ACTION_TYPE
IGS_SV_PRGMS_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
PRGM_ACTION_TYPE	VARCHAR2	(2)	Yes	Type of action that has been performed on the program for the student.
PRINT_FORM	VARCHAR2	(1)	Yes	Flag indicating that the form is to be printed or not by SEVIS.
FORM_STATUS_ID	NUMBER	(15)		Form status identifier for the student based on either Exchange Visitor form or Foreign Student Form that has been filled out.
POSITION_CODE	VARCHAR2	(3)		Position code value for the Exchange Visitor.
SUBJECT_FIELD_CODE	VARCHAR2	(7)		Subject code that the student is involved with.
EDUCATION_LEVEL	VARCHAR2	(2)		Education level of the student being reported to SEVIS.
PRIMARY_MAJOR	VARCHAR2	(7)		Students primary major code for the student which is the value that SEVIS needs not OSS value for majors
SECONDARY_MAJOR	VARCHAR2	(7)		Students secondary major code for the student which is the value that SEVIS needs not OSS value for majors
MINOR	VARCHAR2	(7)		Students minor code for the student which is the value that SEVIS needs not OSS value for minors
LENGTH_OF_STUDY	VARCHAR2	(2)		Length of student that the student is planning for.
PRGM_START_DATE	VARCHAR2	(10)		Program start date that the student is involved in.
PRGM_END_DATE	VARCHAR2	(10)		Program end date that the student is involved in.
ENGLISH_REQD	VARCHAR2	(1)		Flag indicating if English is required for the program the student is in or not.
ENGLISH_REQD_MET	VARCHAR2	(1)		Flag indicating if English being required has been met or not for the program the student is in.
NOT_REQD_REASON	VARCHAR2	(500)		Reason for the english proficiency requirement not being needed.
MATRICULATION	VARCHAR2	(2)		Exchange Visitor matriculation value.
EFFECTIVE_DATE	VARCHAR2	(10)		Effective date of the program the student is in
AUTHORIZATION_REASON	VARCHAR2	(2)		Authorization reason code value
TERMINATION_REASON	VARCHAR2	(30)		Reason why the student has been terminated
END_PRGM_REASON	VARCHAR2	(30)		Reason code for the student ending the program.
REPRINT_REASON	VARCHAR2	(2)		Reason code for the form being reprinted.
SUBMIT_UPDATE	VARCHAR2	(1)		Flag indicating if the student has submitted for update
REMARKS	VARCHAR2	(500)		Remarks for the students program 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
EDUC_LVL_REMARKS	VARCHAR2	(500)		Education Level remarks for OTHER type of Education Level.
AUTH_ACTION_CODE	VARCHAR2	(30)		Action to indicate, if it is a new record, to be cancelled or to be modified
SEVIS_AUTH_ID	NUMBER			Authorization ID taken from EN transaction table

Query Text

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


SELECT BATCH_ID
,      PERSON_ID
,      PRGM_ACTION_TYPE
,      PRINT_FORM
,      FORM_STATUS_ID
,      POSITION_CODE
,      SUBJECT_FIELD_CODE
,      EDUCATION_LEVEL
,      PRIMARY_MAJOR
,      SECONDARY_MAJOR
,      MINOR
,      LENGTH_OF_STUDY
,      PRGM_START_DATE
,      PRGM_END_DATE
,      ENGLISH_REQD
,      ENGLISH_REQD_MET
,      NOT_REQD_REASON
,      MATRICULATION
,      EFFECTIVE_DATE
,      AUTHORIZATION_REASON
,      TERMINATION_REASON
,      END_PRGM_REASON
,      REPRINT_REASON
,      SUBMIT_UPDATE
,      REMARKS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      EDUC_LVL_REMARKS
,      AUTH_ACTION_CODE
,      SEVIS_AUTH_ID
FROM IGS.IGS_SV_PRGMS_INFO;

Dependencies

[top of page]

IGS.IGS_SV_PRGMS_INFO does not reference any database object

IGS.IGS_SV_PRGMS_INFO is referenced by following:

APPS: IGS_SV_PRGMS_INFO