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_AD_OS_SEC_ED_SUB

Object Details

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

IGS_AD_OS_SEC_ED_SUB describes secondary education subject details that are required for assessment of an admissions application.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_OS_SEC_ED_SUB_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID OSE_SEQUENCE_NUMBER SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Contains the institution-defined number that uniquely identifies a person.
OSE_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Identifies uniquely an overseas secondary education subject record for a person.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Identifies uniquely an overseas secondary education subject record for a person.
SUBJECT_CD	VARCHAR2	(10)		Contains the code that identifies the subject
SUBJECT_DESC	VARCHAR2	(60)		Describes the overseas secondary education subject.
RESULT_TYPE	VARCHAR2	(10)	Yes	Type of result for the overseas secondary education subject attempt.
RESULT	VARCHAR2	(20)		Result of the applicant's overseas secondary education subject attempt.
SUBJECT_RESULT_YR	NUMBER	(4)		Year the result was given for an overseas secondary education subject attempt.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		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

Query Text

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


SELECT PERSON_ID
,      OSE_SEQUENCE_NUMBER
,      SEQUENCE_NUMBER
,      SUBJECT_CD
,      SUBJECT_DESC
,      RESULT_TYPE
,      RESULT
,      SUBJECT_RESULT_YR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_OS_SEC_ED_SUB;

Dependencies

[top of page]

IGS.IGS_AD_OS_SEC_ED_SUB does not reference any database object

IGS.IGS_AD_OS_SEC_ED_SUB is referenced by following:

APPS: IGS_AD_OS_SEC_ED_SUB