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

Object Details

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

View Type

A Business Intelligence System view

Full View for the Entity that holds the information about the summary details that get uploaded by the electronic statement of accounts that comes from the government

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REP_PELL_ID	VARCHAR2	(30)		Reporting Pell identifier
DUNS_ID	VARCHAR2	(30)		DUNS number assigned to reporting institution
GAPS_AWARD_NUMBER	VARCHAR2	(30)		Identifies unique funding for institution
ACCT_SCHEDULE_NUMBER	VARCHAR2	(30)		Sequence number assigned by RFMS to track accounting schedules
ACCT_SCHEDULE_DATE	DATE			Date of current accounting schedule
PREVIOUS_OBLIGATION_AMOUNT	NUMBER	(12)		Amount of institution's total obligation prior to adjustment
OBLIGATION_ADJUSTED_AMOUNT	NUMBER	(12)		Adjustment of obligations for accounting cycle
CURRENT_OBLIGATION_AMOUNT	NUMBER	(12)		Amount of institution's current obligation balance
PREVIOUS_OBLIG_PYMT_AMOUNT	NUMBER	(12)		Amount of institution's previous payment balance
OBLIG_PYMT_ADJUSTED_AMOUNT	NUMBER	(12)		Total of all adjustments to payment for GAPS Award Number
CURRENT_OBLIG_PYMT_AMOUNT	NUMBER	(12)		Amount of institution's current payment balance
YTD_TOTAL_RECP	NUMBER	(7)		Year to date number of unduplicated recipients for institution
YTD_ACCEPTED_DISB_AMOUNT	NUMBER	(12)		YTD total of disbursements accepted by RFMS
YTD_POSTED_DISB_AMOUNT	NUMBER	(12)		YTD total of disbursements sent to and acknowledged by GAPS
YTD_ADMIN_COST_ALLOWANCE	NUMBER	(12)		YTD amount paid to institution
CAPS_DRWN_DN_PAYMENTS	NUMBER	(15)		Sum instituted by school. Direct payments for obligation or payment accounts less returns and refunds.
GAPS_LAST_DATE	DATE			The date GAPS last posted transaction for GAPS award number
LAST_PAYMENT_NUMBER	VARCHAR2	(30)		Reference number for last payment sent to institution
ESS_ID	NUMBER	(15)	Yes	Sequence-generated unique identifier
CREATED_BY	NUMBER	(15)	Yes	WHO column
CREATION_DATE	DATE		Yes	WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	WHO column
LAST_UPDATE_DATE	DATE		Yes	WHO column

Query Text

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


SELECT REP_PELL_ID
,      DUNS_ID
,      GAPS_AWARD_NUMBER
,      ACCT_SCHEDULE_NUMBER
,      ACCT_SCHEDULE_DATE
,      PREVIOUS_OBLIGATION_AMOUNT
,      OBLIGATION_ADJUSTED_AMOUNT
,      CURRENT_OBLIGATION_AMOUNT
,      PREVIOUS_OBLIG_PYMT_AMOUNT
,      OBLIG_PYMT_ADJUSTED_AMOUNT
,      CURRENT_OBLIG_PYMT_AMOUNT
,      YTD_TOTAL_RECP
,      YTD_ACCEPTED_DISB_AMOUNT
,      YTD_POSTED_DISB_AMOUNT
,      YTD_ADMIN_COST_ALLOWANCE
,      CAPS_DRWN_DN_PAYMENTS
,      GAPS_LAST_DATE
,      LAST_PAYMENT_NUMBER
,      ESS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFFV_PEL_ELEC_SUM_STMNT_ACNTS;

Dependencies

[top of page]

APPS.IGFFV_PEL_ELEC_SUM_STMNT_ACNTS references the following:

APPS: IGF_GR_ELEC_STAT_SUM_ALL

APPS.IGFFV_PEL_ELEC_SUM_STMNT_ACNTS is not referenced by any database object