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_CRM_US_GP

Object Details

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

IGS_GR_AWD_CRM_US_GP describes the groups of unit sets 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_CRM_US_GP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GRD_CAL_TYPE GRD_CI_SEQUENCE_NUMBER CEREMONY_NUMBER AWARD_COURSE_CD AWARD_CRS_VERSION_NUMBER AWARD_CD US_GROUP_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
GRD_CAL_TYPE	VARCHAR2	(10)	Yes	Describes the graduation calendar type the ceremony roundis 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)	Yes	Describes the course code for the award is being specified
AWARD_CRS_VERSION_NUMBER	NUMBER	(3)	Yes	Describes the version number of the course for that the award is being specified
AWARD_CD	VARCHAR2	(10)	Yes	The unique identifier for the award
US_GROUP_NUMBER	NUMBER	(6)	Yes	Uniquely identifies a group of one or more unit sets being awarded at a program award ceremony
ORDER_IN_AWARD	NUMBER	(3)	Yes	The order in graduation ceremony presentation assigned to the unit set group within the program award. For example, iIf the unit set group is assigned an order in award of '2', graduands in the unit set group are grouped together and presented second within the program award. However, if 'Ignore Unit Sets' is set to 'Y' when the 'Set Graduand Order inPresentation' job is run, graduands are not grouped by unit set group.
OVERRIDE_TITLE	VARCHAR2	(90)		Title for the unit set group that will override the default title. The default title is derived from the names of the unit sets within the unit set group. For example, the default title for the group can be 'ACCOUNTING MAJOR AND FINANCE MAJOR'. The override title can be set to 'ACCOUNTING AND FINANCE MAJORS'.
CLOSED_IND	VARCHAR2	(1)	Yes	Indicates and specifies if the award ceremony unit set group is open or closed. Selecting the checkbox to 'closed' prevents use of the award ceremony unit set group and will prompt the graduand award ceremony allocation process to allocate the graduand award ceremony records currently associated with this award ceremony unit set group to another award ceremony unit set group 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

Query Text

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


SELECT GRD_CAL_TYPE
,      GRD_CI_SEQUENCE_NUMBER
,      CEREMONY_NUMBER
,      AWARD_COURSE_CD
,      AWARD_CRS_VERSION_NUMBER
,      AWARD_CD
,      US_GROUP_NUMBER
,      ORDER_IN_AWARD
,      OVERRIDE_TITLE
,      CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_GR_AWD_CRM_US_GP;

Dependencies

[top of page]

IGS.IGS_GR_AWD_CRM_US_GP does not reference any database object

IGS.IGS_GR_AWD_CRM_US_GP is referenced by following:

APPS: IGS_GR_AWD_CRM_US_GP