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_CRMN

Object Details

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

IGS_GR_AWD_CRMN contains graduand details associated with an award ceremony.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_GR_AWD_CRMN_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GAC_ID
IGS_GR_AWD_CRMN_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID CREATE_DT GRD_CAL_TYPE GRD_CI_SEQUENCE_NUMBER AWARD_CD AWARD_COURSE_CD AWARD_CRS_VERSION_NUMBER
IGS_GR_AWD_CRMN_N3	NORMAL	NONUNIQUE	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
IGS_GR_AWD_CRMN_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACADEMIC_GOWN_SIZE
IGS_GR_AWD_CRMN_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACADEMIC_HAT_SIZE

Columns

Name	Datatype	Length	Mandatory	Comments
GAC_ID	NUMBER	(9)	Yes	Unique numberthat identifies each row of this table
PERSON_ID	NUMBER	(15)	Yes	The person ID of the graduand
CREATE_DT	DATE		Yes	Describes the date this graduand record was created. This with the person ID uniquely identifies a graduand.
GRD_CAL_TYPE	VARCHAR2	(10)	Yes	The ceremony round containing the graduand's award ceremony
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	The number of the ceremony to that the graduand has been allocated
AWARD_COURSE_CD	VARCHAR2	(6)		Describes the course code for that the award is being specified
AWARD_CRS_VERSION_NUMBER	NUMBER	(3)		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)		The number of the unit set group to that the graduand has been allocated within their award at the ceremony.
ORDER_IN_PRESENTATION	NUMBER	(4)		The graduand's order in presentation at the graduation ceremony. Ensures that graduands will be in the correct order and seat. An Order in presentation is allocated to each attending graduand viathe job GRDF5200.
GRADUAND_SEAT_NUMBER	VARCHAR2	(10)		The seat number allocated to the graduand for the graduation ceremony.
NAME_PRONUNCIATION	VARCHAR2	(60)		Guide to the pronunciation of the graduand 's name at the graduationceremony.
NAME_ANNOUNCED	VARCHAR2	(80)		Graduand name to be announced at the ceremony. If no name is specified, the person's recorded given names and surname are used.
ACADEMIC_DRESS_RQRD_IND	VARCHAR2	(1)	Yes	Indicates and specifies if or not the graduand requires academic regalia for the graduation ceremony. When the checkbox is selected, regalia is required.
ACADEMIC_GOWN_SIZE	VARCHAR2	(10)		Size of the academic gown required by the graduand.
ACADEMIC_HAT_SIZE	VARCHAR2	(10)		Size of the academic headwear required by the graduand.
GUEST_TICKETS_REQUESTED	NUMBER	(3)		The number of guest tickets requested by the graduand for the graduation ceremony.
GUEST_TICKETS_ALLOCATED	NUMBER	(3)		The number of guest tickets allocated to the graduand for the graduation ceremony.
GUEST_SEATS	VARCHAR2	(60)		The seat numbers allocated to the graduand's guests at the graduation ceremony.
FEES_PAID_IND	VARCHAR2	(1)	Yes	Indicates and specifies if or not the graduand has paid the fees associated with graduation. When the checkbox is selected, the fees have been paid.
SPECIAL_REQUIREMENTS	VARCHAR2	(2000)		A text field forentering any special graduand requirements at the graduation ceremony. For example, wheelchair access required, seat off stage, helper required.
COMMENTS	VARCHAR2	(2000)		A text field forentering any additional details about the graduand award 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
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program

Query Text

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


SELECT GAC_ID
,      PERSON_ID
,      CREATE_DT
,      GRD_CAL_TYPE
,      GRD_CI_SEQUENCE_NUMBER
,      CEREMONY_NUMBER
,      AWARD_COURSE_CD
,      AWARD_CRS_VERSION_NUMBER
,      AWARD_CD
,      US_GROUP_NUMBER
,      ORDER_IN_PRESENTATION
,      GRADUAND_SEAT_NUMBER
,      NAME_PRONUNCIATION
,      NAME_ANNOUNCED
,      ACADEMIC_DRESS_RQRD_IND
,      ACADEMIC_GOWN_SIZE
,      ACADEMIC_HAT_SIZE
,      GUEST_TICKETS_REQUESTED
,      GUEST_TICKETS_ALLOCATED
,      GUEST_SEATS
,      FEES_PAID_IND
,      SPECIAL_REQUIREMENTS
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_GR_AWD_CRMN;

Dependencies

[top of page]

IGS.IGS_GR_AWD_CRMN does not reference any database object

IGS.IGS_GR_AWD_CRMN is referenced by following:

APPS: IGS_GR_AWD_CRMN