[Home] [Help] [Dependency Information]
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 |
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.
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 |
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;
APPS.IGS_DA_XML_GPA_V is not referenced by any database object
|
|
|