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_PS_AWD

Object Details

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

IGS_PS_AWD describes an award offered by the university.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PS_AWD_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AWARD_CD
IGS_PS_AWD_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_TITLE
IGS_PS_AWD_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TESTAMUR_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
AWARD_CD	VARCHAR2	(10)	Yes	Code for an award offered by the institution.
AWARD_TITLE	VARCHAR2	(90)	Yes	Name of an award offered by the institution. For example, bachelor of arts, graduate diploma of education.
S_AWARD_TYPE	VARCHAR2	(10)	Yes	System defined award type that is program, honorary, prize, medal.
TESTAMUR_TYPE	VARCHAR2	(10)		Institution defined degree type to that the award is mapped. Enables student system to produce the correct degree type for each graduate. For example, university, entrepreneurial.
CLOSED_IND	VARCHAR2	(1)	Yes	Indicator that specifies if the award is open or closed. Setting the checkbox to closed prevents use of the award in new or modified records in other parts of the system, such as program awards in IGSPS017 and special awards in IGSGR012.
NOTES	VARCHAR2	(2000)		Enables the entering of any additional information or details about the award.
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
GRADING_SCHEMA_CD	VARCHAR2	(10)		The Grading Schema for the award
GS_VERSION_NUMBER	NUMBER	(3)		The grading schema version number for the award

Query Text

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


SELECT AWARD_CD
,      AWARD_TITLE
,      S_AWARD_TYPE
,      TESTAMUR_TYPE
,      CLOSED_IND
,      NOTES
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
FROM IGS.IGS_PS_AWD;

Dependencies

[top of page]

IGS.IGS_PS_AWD does not reference any database object

IGS.IGS_PS_AWD is referenced by following:

APPS: IGS_PS_AWD