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]

VIEW: APPS.IGS_GR_AWD_CRMN_HIST_V

Object Details

Object Name:	IGS_GR_AWD_CRMN_HIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_GR_AWD_CRMN_HIST_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
PERSON_ID	NUMBER	(15)	The person id of the graduand.
CREATE_DT	DATE		This field describes the date this graduand record was created. This with the person id uniquely identifies a graduand.
GRD_CAL_TYPE	VARCHAR2	(10)	This field describes the graduation calendar type the ceremony round is for.
GRD_CI_SEQUENCE_NUMBER	NUMBER	(6)	This field describes the calendar instance of the graduation calendar the ceremony round is for.
CEREMONY_NUMBER	NUMBER		This field describes the number uniquely identifying the graduation ceremony.
AWARD_COURSE_CD	VARCHAR2	(6)	Describes the course code for which the award is being specified.
AWARD_CRS_VERSION_NUMBER	NUMBER	(3)	Describes the version number of the course for which the award is being specified.
AWARD_CD	VARCHAR2	(10)	The unique identifier for the award.
HIST_START_DT	DATE		The effective start date/time of the history record.
HIST_END_DT	DATE		The effective end date/time of the history record.
HIST_WHO	NUMBER	(15)	The Oracle username of the person who created the history record.
US_GROUP_NUMBER	NUMBER		Uniquely identifies a group of one or more unit sets being awarded at a course award ceremony.
ORDER_IN_PRESENTATION	NUMBER		This field describes the graduand's 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)	This field describes the seat number allocated to the graduand for the graduation ceremony.
NAME_PRONUNCIATION	VARCHAR2	(60)	This field describes how to pronounce the graduand's name, if pronunciation would cause a problem.
NAME_ANNOUNCED	VARCHAR2	(80)	This field describes the name to be announced at the ceremony if different to person name.
ACADEMIC_DRESS_RQRD_IND	VARCHAR2	(1)	This field describes whether or not academic dress is required.
ACADEMIC_GOWN_SIZE	VARCHAR2	(10)	This field describes the size of the academic gown required by the graduand.
ACADEMIC_HAT_SIZE	VARCHAR2	(10)	This field describes the size of the academic headwear required by the graduand.
GUEST_TICKETS_REQUESTED	NUMBER		This field describes the number of guest tickets requested by the graduand for the the graduation ceremony.
GUEST_TICKETS_ALLOCATED	NUMBER		This field describes the number of guest tickets allocated for the graduand for the graduation ceremony. This will depend on the availability of tickets.
GUEST_SEATS	VARCHAR2	(60)	This field describes the seat numbers at the graduation ceremony for the graduand's guests.
FEES_PAID_IND	VARCHAR2	(1)	This field describes whether or not the graduand has paid their fees.
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
SPECIAL_REQUIREMENTS	VARCHAR2	(2000)	This field describes any special requirements by the graduand for ceremony attendance. Examples: Wheelchair access, Seat off stage, Helper required.
COMMENTS	VARCHAR2	(2000)	Any additional detail for the graduand award ceremony.

Query Text

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


SELECT 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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SPECIAL_REQUIREMENTS
,      COMMENTS
FROM APPS.IGS_GR_AWD_CRMN_HIST_V;

Dependencies

[top of page]

APPS.IGS_GR_AWD_CRMN_HIST_V references the following:

APPS: IGS_AU_GEN_003 - show dependent code; IGS_GR_AWD_CRMN; IGS_GR_AWD_CRMN_HIST

APPS.IGS_GR_AWD_CRMN_HIST_V is not referenced by any database object