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_DA_XML_GPA_V

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

XML element GPAType (child of AcademicProgram). Returns the GPA Stored or Calculated on the identified by the program code, calendar and time frame.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
GPA_CATEGORY	VARCHAR2	(50)	Yes	Contains the type of GPA calculated.
SESSION_ID	VARCHAR2	(10)		Contains the term in which the GPA was calculated.
TIME_FRAME	CHAR	(10)		Contains the timeframe over which the GPA is relevant
ATTEMPTED_CREDIT_POINTS	NUMBER			Contains the total achievable credit hours for the GPA type.
EARNED_CREDIT_POINTS	NUMBER			Contains the total earned credit hours for the GPA type.
CALCULATED_GPA	NUMBER			Contains the calculated GPA.
GPA_CREDIT_POINTS	NUMBER			Contains the total GPA credit hours for the GPA type.
GPA_QUALITY_POINTS	NUMBER			Contains the total GPA quality points for the GPA type.
BATCH_ID	NUMBER	(15)	Yes	Contains the OSS generated Batch ID for tracking purposes.
PERSON_ID	NUMBER	(15)	Yes	Describes the details of the person ID code that is being passed.
PROGRAM_CODE	VARCHAR2	(6)		Contains the concentration.
LOAD_CAL_TYPE	VARCHAR2	(10)	Yes	Load calendar type
LOAD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Load calendar sequence number
IGS_DA_REQ_STDNTS_ID	NUMBER	(15)	Yes	Student ID

Query Text

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


SELECT GPA_CATEGORY
,      SESSION_ID
,      TIME_FRAME
,      ATTEMPTED_CREDIT_POINTS
,      EARNED_CREDIT_POINTS
,      CALCULATED_GPA
,      GPA_CREDIT_POINTS
,      GPA_QUALITY_POINTS
,      BATCH_ID
,      PERSON_ID
,      PROGRAM_CODE
,      LOAD_CAL_TYPE
,      LOAD_CI_SEQUENCE_NUMBER
,      IGS_DA_REQ_STDNTS_ID
FROM APPS.IGS_DA_XML_GPA_V;

Dependencies

[top of page]

APPS.IGS_DA_XML_GPA_V references the following:

APPS: IGS_CA_INST_ALL; IGS_DA_REQ_STDNTS; IGS_DA_XML_PKG - show dependent code; IGS_PR_INST_STAT

APPS.IGS_DA_XML_GPA_V is not referenced by any database object