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_CRMN_ALL

Object Details

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

IGS_GR_CRMN_ALL describes a graduation ceremony.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_GR_CRMN_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GRD_CAL_TYPE GRD_CI_SEQUENCE_NUMBER CEREMONY_NUMBER
IGS_GR_CRMN_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENUE_CD
IGS_GR_CRMN_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRD_CAL_TYPE GRD_CI_SEQUENCE_NUMBER CEREMONY_DT_ALIAS CEREMONY_DAI_SEQUENCE_NUMBER
IGS_GR_CRMN_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRD_CAL_TYPE GRD_CI_SEQUENCE_NUMBER CLOSING_DT_ALIAS CLOSING_DAI_SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
GRD_CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type of the graduation calendar used for the ceremony round.
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	Number uniquely identifying the graduation ceremony. Once a graduation ceremony has been created, its number can not be modified.
VENUE_CD	VARCHAR2	(10)	Yes	Code for the venue the ceremony is to be held
CEREMONY_DT_ALIAS	VARCHAR2	(10)	Yes	Date alias representing the date of the graduation ceremony. The date alias selected must exist within the graduation calendar instance used for the ceremony round.
CEREMONY_DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the date alias instance of the graduation ceremony. The date alias is related to the graduation calendar type and calendar instance of the ceremony round.
CLOSING_DT_ALIAS	VARCHAR2	(10)	Yes	Date alias used to represent the closing date for graduands applying to graduate at the context ceremony. Oracle Student System uses this date to raise a warning if new graduand records are created and associated with the context ceremony, or existing graduand records associated with the ceremony are updated. The selected date alias must exist within the graduation calendar instance associated with the ceremony round.
CLOSING_DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Sequence number of the ceremony closing date alias instance
CEREMONY_START_TIME	DATE		Yes	Start time of the graduation ceremony
CEREMONY_END_TIME	DATE		Yes	Estimated end time of the graduation ceremony
CEREMONY_FEE	NUMBER	(5)		Fee to be paid by each graduand attending the ceremony
NUMBER_OF_GUESTS	NUMBER	(3)		Maximum number of guests allowed for each graduand at thegraduation ceremony
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 GRD_CAL_TYPE
,      GRD_CI_SEQUENCE_NUMBER
,      CEREMONY_NUMBER
,      VENUE_CD
,      CEREMONY_DT_ALIAS
,      CEREMONY_DAI_SEQUENCE_NUMBER
,      CLOSING_DT_ALIAS
,      CLOSING_DAI_SEQUENCE_NUMBER
,      CEREMONY_START_TIME
,      CEREMONY_END_TIME
,      CEREMONY_FEE
,      NUMBER_OF_GUESTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_GR_CRMN_ALL;

Dependencies

[top of page]

IGS.IGS_GR_CRMN_ALL does not reference any database object

IGS.IGS_GR_CRMN_ALL is referenced by following:

APPS: IGS_GR_CRMN_ALL