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: IGF_AP_CLASS_STD_MAP_V

Product:	IGF - Financial Aid
Description:	Holds the Class Standing mapping of OSS User defined class standing to Financial Aid class standing (Grade Level Code)
Implementation/DBA Data:	APPS.IGF_AP_CLASS_STD_MAP_V

View Text

SELECT PCSS.IGS_PR_CSS_CLASS_STD_ID
, PCSS.IGS_PR_CS_SCHDL_ID
, PCS.CLASS_STANDING
, PCS.DESCRIPTION
, IPCS.ROWID
, IPCS.IPCS_ID
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_GRADE_LEVEL'
, IPCS.AP_STD_CODE)
, IPCS.AP_STD_CODE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_GRADE_LEVEL'
, IPCS.DL_STD_CODE)
, IPCS.DL_STD_CODE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_CL_GRADE_LEVEL'
, IPCS.CL_STD_CODE)
, IPCS.CL_STD_CODE
, IPCS.CREATED_BY
, IPCS.CREATION_DATE
, IPCS.LAST_UPDATED_BY
, IPCS.LAST_UPDATE_DATE
, IPCS.LAST_UPDATE_LOGIN
, IPCS.PPT_ID FROM IGF_AP_CLASS_STD_MAP IPCS
, IGS_PR_CSS_CLASS_STD PCSS
, IGS_PR_CLASS_STD PCS
WHERE PCSS.IGS_PR_CLASS_STD_ID = PCS.IGS_PR_CLASS_STD_ID
AND PCSS.IGS_PR_CSS_CLASS_STD_ID = IPCS.IGS_PR_CSS_CLASS_STD_ID

Columns

Name
IGS_PR_CSS_CLASS_STD_ID
IGS_PR_CS_SCHDL_ID
CLASS_STANDING
CLASS_STANDING_DESC
ROW_ID
IPCS_ID
AP_STD_DESC
AP_STD_CODE
DL_STD_DESC
DL_STD_CODE
CL_STD_DESC
CL_STD_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PPT_ID