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_UC_QUAL_INTS

Object Details

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

Contains Qualification details to be imported into the IGS_UC_QUAL_DETS table by the Admissions Legacy Data Import process.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Legacy Qualification Details
Category: BUSINESS_ENTITY HZ_PERSON

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_UC_QUAL_INTS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	INTERFACE_QUAL_ID
IGS_UC_QUAL_INTS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERFACE_ID
IGS_UC_QUAL_INTS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	STATUS
IGS_UC_QUAL_INTS_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERFACE_RUN_ID
IGS_UC_QUAL_INTS_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PERSON_ID EXAM_LEVEL

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_QUAL_ID	NUMBER	(15)	Yes	A unique identifier to identify each row in this table
INTERFACE_ID	NUMBER	(15)	Yes	Interface identifier
EXAM_LEVEL	VARCHAR2	(20)	Yes	Qualification
SUBJECT_CODE	VARCHAR2	(20)		Subject Code
YEAR	NUMBER			Year, If the value is there then it should be greater than 1900 and less than 2200
SITTING	VARCHAR2	(1)		Sitting
AWARDING_BODY	VARCHAR2	(30)		Awarding Body
GRADING_SCHEMA_CD	VARCHAR2	(10)		Grading Schema Code
VERSION_NUMBER	NUMBER			Grading Schema Version Number
PREDICTED_RESULT	VARCHAR2	(5)		Predicted Result
APPROVED_RESULT	VARCHAR2	(5)		Approved Result
CLAIMED_RESULT	VARCHAR2	(5)		Claimed Result
UCAS_TARIFF	NUMBER			UCAS tariff
IMPORTED_FLAG	VARCHAR2	(1)		Imported Flag
IMPORTED_DATE	DATE			Imported Date
STATUS	VARCHAR2	(1)	Yes	Status of the interface record
ERROR_CODE	VARCHAR2	(30)		Error Code
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
REQUEST_ID	NUMBER	(15)		Standard WHO Column for concurrent programs
PROGRAM_ID	NUMBER	(15)		Standard WHO Column for concurrent programs
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard WHO Column for concurrent programs
PROGRAM_UPDATE_DATE	DATE			Standard WHO Column for concurrent programs
INTERFACE_RUN_ID	NUMBER			Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user
PERSON_ID	NUMBER	(15)		Person Identifier. This column will be populated by the import process
ERROR_TEXT	VARCHAR2	(2000)		Error Text

Query Text

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


SELECT INTERFACE_QUAL_ID
,      INTERFACE_ID
,      EXAM_LEVEL
,      SUBJECT_CODE
,      YEAR
,      SITTING
,      AWARDING_BODY
,      GRADING_SCHEMA_CD
,      VERSION_NUMBER
,      PREDICTED_RESULT
,      APPROVED_RESULT
,      CLAIMED_RESULT
,      UCAS_TARIFF
,      IMPORTED_FLAG
,      IMPORTED_DATE
,      STATUS
,      ERROR_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      INTERFACE_RUN_ID
,      PERSON_ID
,      ERROR_TEXT
FROM IGS.IGS_UC_QUAL_INTS;

Dependencies

[top of page]

IGS.IGS_UC_QUAL_INTS does not reference any database object

IGS.IGS_UC_QUAL_INTS is referenced by following:

APPS: IGS_UC_QUAL_INTS