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_AS_SUA_REF_CDS

Object Details

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

This table stores the Student Unit Attempt Reference Codes

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_SUA_REF_CDS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UOO_ID REFERENCE_CODE_ID APPLIED_COURSE_CD DELETED_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
SUAR_ID	NUMBER		Yes	Unique key for Student Unit Attempt Reference Code
PERSON_ID	NUMBER	(15)	Yes	Person ID - part of foreign key to SUA
COURSE_CD	VARCHAR2	(6)	Yes	Program ID - part of foreign key to SUA
UOO_ID	NUMBER	(7)	Yes	Unit Offering Option ID - part of foreign key to SUA
REFERENCE_CODE_ID	NUMBER	(10)	Yes	Reference Code ID - foreign key to reference code
REFERENCE_CD_TYPE	VARCHAR2	(10)	Yes	The reference code type
REFERENCE_CD	VARCHAR2	(30)	Yes	The reference code applied to the student unit attempt
APPLIED_COURSE_CD	VARCHAR2	(6)	Yes	The program code under which the reference code is saved.
DELETED_DATE	DATE			The date the record was marked as deleted.
CREATED_BY	NUMBER	(15)	Yes	Created By -Standard Who Column
CREATION_DATE	DATE		Yes	Creation Date -Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Last Updated By -Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Last Update Date Standard Who Column

Query Text

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


SELECT SUAR_ID
,      PERSON_ID
,      COURSE_CD
,      UOO_ID
,      REFERENCE_CODE_ID
,      REFERENCE_CD_TYPE
,      REFERENCE_CD
,      APPLIED_COURSE_CD
,      DELETED_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM IGS.IGS_AS_SUA_REF_CDS;

Dependencies

[top of page]

IGS.IGS_AS_SUA_REF_CDS does not reference any database object

IGS.IGS_AS_SUA_REF_CDS is referenced by following:

APPS: IGS_AS_SUA_REF_CDS