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_SE_EARNINGS_SUMMARY_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BASE_ID	NUMBER	(10)	Yes	FA base record identifier.
FUND_ID	NUMBER	(15)	Yes	Unique Fund identifier alloted to the student.
LD_CAL_TYPE	VARCHAR2	(10)	Yes	Calendar Type for Load Calendar
LD_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique Identifier for the Load Calendar
LD_ALTERNATE_CODE	VARCHAR2	(10)		User identifier for a Calendar of type Load calendar.
AWARD_AMOUNT	NUMBER			The amount accpeted by the student for the Fund.
EARNINGS_TILL_DATE	NUMBER			The amount disbursed to the student corresponding to the Fund, in the term. This disbursement happens through the payroll payment either from external system or HR payroll system. THe information for payroll will either be in IGF_SE_PAYMENT or IGF_SE_PAYMENT_INT.
REMAINING_AMOUNT	NUMBER			The amount of fund left to be paid/disbursed to the student in this Term. This is accepted amount less the earnings till date.
PROGRESS_TO_LIMIT	NUMBER			The percentage ratio of the amount of the fund received during the term with the accepted amount. This indicator will indicate when the notifcation should be sent. There will be a setup for the fund, indicating the threshold value or percentage for the fund.
NOTIFICATION_SENT	VARCHAR2	(0)		No longer used.
NOTIFICATION_DATE	VARCHAR2	(0)		No longer used.
AUTH_ID	VARCHAR2	(0)		No longer used.
AUTH_DATE	VARCHAR2	(0)		No longer used.

Query Text

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


SELECT BASE_ID
,      FUND_ID
,      LD_CAL_TYPE
,      LD_SEQUENCE_NUMBER
,      LD_ALTERNATE_CODE
,      AWARD_AMOUNT
,      EARNINGS_TILL_DATE
,      REMAINING_AMOUNT
,      PROGRESS_TO_LIMIT
,      NOTIFICATION_SENT
,      NOTIFICATION_DATE
,      AUTH_ID
,      AUTH_DATE
FROM APPS.IGF_SE_EARNINGS_SUMMARY_V;

Dependencies

[top of page]

APPS.IGF_SE_EARNINGS_SUMMARY_V references the following:

APPS: IGF_AW_AWARD_V; IGF_AW_AWD_DISB; IGF_AW_GEN - show dependent code; IGS_CA_INST

APPS.IGF_SE_EARNINGS_SUMMARY_V is not referenced by any database object