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.IGSBV_GR_CRMN_STDNT_PRG

Object Details

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

View Type

A Business Intelligence System view

Describes Graduand Ceremony Student Program

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_NAME	VARCHAR2	(360)	Yes	Describes the person name.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the person number.
CREATE_DT	DATE		Yes	Describes the date the Graduand record was created.
GRD_CAL_TYPE	VARCHAR2	(10)	Yes	Describes the Graduation Calendar Type.
GRD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the Graduation Calendar Instance Sequence Number.
CEREMONY_NUMBER	NUMBER	(3)	Yes	Describes the Ceremony Number the Graduand will be presented in.
AWARD_PROGRAM_CODE	VARCHAR2	(6)		Describes the program which the award is being conferred.
AWARD_PROGRAM_VERSION_NUMBER	NUMBER	(3)		Describes the program which the award is being conferred.
AWARD_CD	VARCHAR2	(10)	Yes	Describes the award is being conferred.
US_GROUP_NUMBER	NUMBER	(6)		Describes the Unit Set Grouping the Graduand is in.
ORDER_IN_PRESENTATION	NUMBER	(4)		Describes the Graduands Order in Presentation.
GRADUAND_SEAT_NUMBER	VARCHAR2	(10)		Describes the Seat Number of the Graduand.
NAME_PRONUNCIATION	VARCHAR2	(60)		Describes the correct Pronunciation of the Graduands name.
NAME_ANNOUNCED	VARCHAR2	(80)		Describes the Name the Graduand wishes to have announced.
_LA:ACADEMIC_DRESS_RQRD_IND	CHAR	(64)		Describes the whether the Graduand requires Academic Dress.
ACADEMIC_GOWN_SIZE	VARCHAR2	(10)		Describes the Graduands Gown Size.
ACADEMIC_HAT_SIZE	VARCHAR2	(10)		Describes the Graduands Hat Size.
GUEST_TICKETS_REQUESTED	NUMBER	(3)		Describes how many tickets the Graduand has requested.
GUEST_TICKETS_ALLOCATED	NUMBER	(3)		Describes how many tickets the Graduand has been allocated.
GUEST_SEATS	VARCHAR2	(60)		Describes the Graduands Guest Seat numbers.
_LA:FEES_PAID_IND	CHAR	(54)		Describes if the Graduands Fees have been paid.
SPECIAL_REQUIREMENTS	VARCHAR2	(2000)		Describes any Special Requirements the Graduand may have.
COMMENTS	VARCHAR2	(2000)		Describes the Comments related to this Graduand.
GAC_ID	NUMBER	(9)	Yes	Describes the ID that uniquely identifies a Graduand Award Ceremony record.
PERSON_ID	NUMBER	(15)	Yes	Describes the ID that uniquely identifies a person.
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

Query Text

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


SELECT PERSON_NAME
,      PERSON_NUMBER
,      CREATE_DT
,      GRD_CAL_TYPE
,      GRD_CI_SEQUENCE_NUMBER
,      CEREMONY_NUMBER
,      AWARD_PROGRAM_CODE
,      AWARD_PROGRAM_VERSION_NUMBER
,      AWARD_CD
,      US_GROUP_NUMBER
,      ORDER_IN_PRESENTATION
,      GRADUAND_SEAT_NUMBER
,      NAME_PRONUNCIATION
,      NAME_ANNOUNCED
,      _LA:ACADEMIC_DRESS_RQRD_IND
,      ACADEMIC_GOWN_SIZE
,      ACADEMIC_HAT_SIZE
,      GUEST_TICKETS_REQUESTED
,      GUEST_TICKETS_ALLOCATED
,      GUEST_SEATS
,      _LA:FEES_PAID_IND
,      SPECIAL_REQUIREMENTS
,      COMMENTS
,      GAC_ID
,      PERSON_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_GR_CRMN_STDNT_PRG;

Dependencies

[top of page]

APPS.IGSBV_GR_CRMN_STDNT_PRG references the following:

APPS: HZ_PARTIES; IGS_GR_AWD_CRMN

APPS.IGSBV_GR_CRMN_STDNT_PRG is not referenced by any database object