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_M1R

Object Details

Object Name:	IGS_SV_PRGMS_INFO_M1R
Object Type:	TABLE
Owner:	IGS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory
BATCH_ID	NUMBER	(14)	Yes
PERSON_ID	NUMBER	(15)	Yes
PRGM_ACTION_TYPE	VARCHAR2	(2)	Yes
PRINT_FORM	VARCHAR2	(1)	Yes
FORM_STATUS_ID	NUMBER	(15)
POSITION_CODE	VARCHAR2	(3)
SUBJECT_FIELD_CODE	VARCHAR2	(7)
EDUCATION_LEVEL	VARCHAR2	(2)
PRIMARY_MAJOR	VARCHAR2	(7)
SECONDARY_MAJOR	VARCHAR2	(7)
MINOR	VARCHAR2	(7)
LENGTH_OF_STUDY	VARCHAR2	(2)
PRGM_START_DATE	VARCHAR2	(10)
PRGM_END_DATE	VARCHAR2	(10)
ENGLISH_REQD	VARCHAR2	(1)
ENGLISH_REQD_MET	VARCHAR2	(1)
NOT_REQD_REASON	VARCHAR2	(500)
MATRICULATION	VARCHAR2	(2)
EFFECTIVE_DATE	VARCHAR2	(10)
AUTHORIZATION_REASON	VARCHAR2	(2)
TERMINATION_REASON	VARCHAR2	(30)
END_PRGM_REASON	VARCHAR2	(30)
REPRINT_REASON	VARCHAR2	(2)
SUBMIT_UPDATE	VARCHAR2	(1)
REMARKS	VARCHAR2	(500)
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
EDUC_LVL_REMARKS	VARCHAR2	(500)
AUTH_ACTION_CODE	VARCHAR2	(30)
SEVIS_AUTH_ID	NUMBER

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_M1R;

Dependencies

[top of page]

IGS.IGS_SV_PRGMS_INFO_M1R does not reference any database object

IGS.IGS_SV_PRGMS_INFO_M1R is referenced by following:

APPS: IGS_SV_PRGMS_INFO_M1R