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.

[Home] [Help]

View: IGS_DA_XML_GPA_V

Product:	IGS - Student System (Obsolete)
Description:	XML element GPAType (child of AcademicProgram). Returns the GPA Stored or Calculated on the identified by the program code, calendar and time frame.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT INS.STAT_TYPE
, CI.ALTERNATE_CODE
, 'CUMULATIVE'
, IGS_DA_XML_PKG.GET_CUM_ATTEMPTED_CP(DRS.PERSON_ID
, DRS.PROGRAM_CODE
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, INS.STAT_TYPE)
, IGS_DA_XML_PKG.GET_CUM_EARNED_CP(DRS.PERSON_ID
, DRS.PROGRAM_CODE
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, INS.STAT_TYPE)
, IGS_DA_XML_PKG.GET_CUM_GPA(DRS.PERSON_ID
, DRS.PROGRAM_CODE
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, INS.STAT_TYPE)
, IGS_DA_XML_PKG.GET_CUM_GPA_CP(DRS.PERSON_ID
, DRS.PROGRAM_CODE
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, INS.STAT_TYPE)
, IGS_DA_XML_PKG.GET_CUM_GPA_QP(DRS.PERSON_ID
, DRS.PROGRAM_CODE
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, INS.STAT_TYPE)
, DRS.BATCH_ID
, DRS.PERSON_ID
, DRS.PROGRAM_CODE
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, DRS.IGS_DA_REQ_STDNTS_ID
FROM IGS_CA_INST_ALL CI
, IGS_DA_REQ_STDNTS DRS
, IGS_PR_INST_STAT INS
WHERE INS.STANDARD_IND = 'Y'
AND INS.TIMEFRAME IN ('CUMULATIVE'
, 'BOTH')

Columns

Name
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