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_GR_AWD_CEREMONY_ALL

Object Details

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

IGS_GR_AWD_CEREMONY_ALL describes the awards that are being processed during the nominated graduation ceremony.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_GR_AWD_CEREMONY_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AWC_ID
IGS_GR_AWD_CEREMONY_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_COURSE_CD AWARD_CRS_VERSION_NUMBER AWARD_CD
IGS_GR_AWD_CEREMONY_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRD_CAL_TYPE GRD_CI_SEQUENCE_NUMBER CEREMONY_NUMBER
IGS_GR_AWD_CEREMONY_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_CD

Columns

Name	Datatype	Length	Mandatory	Comments
AWC_ID	NUMBER	(9)	Yes	Unique number which identifies each row of this table
GRD_CAL_TYPE	VARCHAR2	(10)	Yes	Describes the graduation calendar type the ceremony round is for
GRD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the calendar instance of the graduation calendar the ceremony round is for
CEREMONY_NUMBER	NUMBER	(3)	Yes	Describes the number uniquely identifying the graduation ceremony
AWARD_COURSE_CD	VARCHAR2	(6)		The course award course code
AWARD_CRS_VERSION_NUMBER	NUMBER	(3)		The course award course version number
AWARD_CD	VARCHAR2	(10)	Yes	The award code for the award or course award
ORDER_IN_CEREMONY	NUMBER	(4)	Yes	The order in graduation ceremony presentation assigned to the award or course award. For example, if the course award is assigned an order in ceremony value of '1', graduands in that course award are presented first.
CLOSED_IND	VARCHAR2	(1)	Yes	Indicates and specifies if the award ceremony is open or closed. Selecting the checkbox to 'closed' prevents use of the award ceremony and will cause the graduand award ceremony allocation process to allocate the graduand_award_ceremony records currently associated with this award ceremony to another award ceremony or delete them if none is available.
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
ORG_ID	NUMBER	(15)		Operating unit identifier

Query Text

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


SELECT AWC_ID
,      GRD_CAL_TYPE
,      GRD_CI_SEQUENCE_NUMBER
,      CEREMONY_NUMBER
,      AWARD_COURSE_CD
,      AWARD_CRS_VERSION_NUMBER
,      AWARD_CD
,      ORDER_IN_CEREMONY
,      CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_GR_AWD_CEREMONY_ALL;

Dependencies

[top of page]

IGS.IGS_GR_AWD_CEREMONY_ALL does not reference any database object

IGS.IGS_GR_AWD_CEREMONY_ALL is referenced by following:

APPS: IGS_GR_AWD_CEREMONY_ALL