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_HIST

Object Details

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

IGS_GR_AWD_CRMN_HIST describes the link between a graduand, a student program attempt and a ceremony.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_GR_AWD_CRMN_HIST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GACH_ID
IGS_GR_AWD_CRMN_HIST_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID CREATE_DT

Columns

Name	Datatype	Length	Mandatory	Comments
GACH_ID	NUMBER	(9)	Yes	Unique number that identifies each row of this table
PERSON_ID	NUMBER	(15)	Yes	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	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	(6)	Yes	Describes the number uniquely identifying the graduation ceremony
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
HIST_START_DT	DATE		Yes	Effective start date and time of the history record
HIST_END_DT	DATE		Yes	Effective end date and time of the history record
HIST_WHO	NUMBER	(15)	Yes	The Oracle username of the person who created the history record
US_GROUP_NUMBER	NUMBER	(6)		Uniquely identifies a group of one or more unit sets being awarded at a course award ceremony.
ORDER_IN_PRESENTATION	NUMBER	(4)		Describes the graduands order in the presentation of graduates at the graduation ceremony. The order in presentation will ensure graduates will be in the correct seats to receive the correct award. Graduands being awarded in absentia will also be included in this ordering.
GRADUAND_SEAT_NUMBER	VARCHAR2	(10)		Describes the seat number allocated to the graduand for the graduation ceremony
NAME_PRONUNCIATION	VARCHAR2	(60)		Describes how to pronounce the graduands name, if pronunciation would cause a problem
NAME_ANNOUNCED	VARCHAR2	(60)		Describes the name to be announced at the ceremony if different to person name
ACADEMIC_DRESS_RQRD_IND	VARCHAR2	(1)		Describes if or not academic dress is required
ACADEMIC_GOWN_SIZE	VARCHAR2	(10)		Describes the size of the academic gown required by the graduand
ACADEMIC_HAT_SIZE	VARCHAR2	(10)		Describes the size of the academic headwear required by the graduand
GUEST_TICKETS_REQUESTED	NUMBER	(3)		Describes the number of guest tickets requested by the graduand for the the graduation ceremony
GUEST_TICKETS_ALLOCATED	NUMBER	(3)		Describes the number of guest tickets allocated for the graduand for the graduation ceremony. This will depend on theavailability of tickets.
GUEST_SEATS	VARCHAR2	(60)		Describes the seat numbers at the graduation ceremony for the graduands guests
FEES_PAID_IND	VARCHAR2	(1)		Describes if or not the graduand has paid their fees
SPECIAL_REQUIREMENTS	VARCHAR2	(2000)		Describes any special requirements by the graduand forceremony attendance. For example, wheelchair access, seat off stage, helper required.
COMMENTS	VARCHAR2	(2000)		Any additional detail for 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

Query Text

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


SELECT GACH_ID
,      PERSON_ID
,      CREATE_DT
,      GRD_CAL_TYPE
,      GRD_CI_SEQUENCE_NUMBER
,      CEREMONY_NUMBER
,      AWARD_COURSE_CD
,      AWARD_CRS_VERSION_NUMBER
,      AWARD_CD
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      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
FROM IGS.IGS_GR_AWD_CRMN_HIST;

Dependencies

[top of page]

IGS.IGS_GR_AWD_CRMN_HIST does not reference any database object

IGS.IGS_GR_AWD_CRMN_HIST is referenced by following:

APPS: IGS_GR_AWD_CRMN_HIST