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

Object Details

Object Name:	IGF_AP_CLASS_STD_MAP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_AP_CLASS_STD_MAP_V
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Holds the Class Standing mapping of OSS User defined class standing to Financial Aid class standing (Grade Level Code)

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
IGS_PR_CSS_CLASS_STD_ID	NUMBER	(15)	Yes	Holds the foreign key to class standing mapping for the credit point range and the academic years for each program type and a period
IGS_PR_CS_SCHDL_ID	NUMBER	(15)	Yes
CLASS_STANDING	VARCHAR2	(50)	Yes	Indicates class standing
CLASS_STANDING_DESC	VARCHAR2	(90)	Yes	description for class standing
ROW_ID	ROWID	(10)		Row ID
IPCS_ID	NUMBER	(15)	Yes	Sequence generated Column
AP_STD_DESC	VARCHAR2	(4000)		description for the class standing mapping used by Application Processing
AP_STD_CODE	VARCHAR2	(30)		Holds the class standing mapping used by Application Processing
DL_STD_DESC	VARCHAR2	(4000)		description for the class standing mapping used by Direct Loan
DL_STD_CODE	VARCHAR2	(30)		indicates for the class standing mapping used by Direct Loan
CL_STD_DESC	VARCHAR2	(4000)		description for the class standing mapping used by CommonLine Loan
CL_STD_CODE	VARCHAR2	(30)		indicates for the class standing mapping used by CommonLine Loan
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Columns
CREATION_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Columns
PPT_ID	NUMBER	(15)		Indicates Sequence Generated Primary Key Identifier

Query Text

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


SELECT 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
FROM APPS.IGF_AP_CLASS_STD_MAP_V;

Dependencies

[top of page]

APPS.IGF_AP_CLASS_STD_MAP_V references the following:

APPS: IGF_AP_CLASS_STD_MAP; IGF_AW_GEN - show dependent code; IGS_PR_CLASS_STD; IGS_PR_CSS_CLASS_STD

APPS.IGF_AP_CLASS_STD_MAP_V is referenced by following:

APPS: IGF_AP_ISIR_GEN_PKG - show dependent code