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

Object Details

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

View Type

A Business Intelligence System view

Base 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
GAPS_AWARD_NUMBER	VARCHAR2	(30)		Identifies unique funding for institution
ACCTOUNT_SCHEDULE_NUMBER	VARCHAR2	(30)		Sequence number assigned by RFMS to track accounting schedules
ACCTOUNT_SCHEDULE_DATE	DATE			Date of current accounting schedule
PREVOUS_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
PREVOUS_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
YEAR_TD_TOTAL_RECP	NUMBER	(7)		Year to date number of unduplicated recipients for institution
YEAR_TD_ACCEPTED_DISB_AMOUNT	NUMBER	(12)		YTD total of disbursements accepted by RFMS
YEAR_TD_POSTED_DISB_AMOUNT	NUMBER	(12)		YTD total of disbursements sent to and acknowledged by GAPS
YEAR_TD_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
REPORTING_PELL_ID	VARCHAR2	(30)		Reporting Pell identifier
DUNS_ID	VARCHAR2	(30)		DUNS number assigned to reporting 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 GAPS_AWARD_NUMBER
,      ACCTOUNT_SCHEDULE_NUMBER
,      ACCTOUNT_SCHEDULE_DATE
,      PREVOUS_OBLIGATION_AMOUNT
,      OBLIGATION_ADJUSTED_AMOUNT
,      CURRENT_OBLIGATION_AMOUNT
,      PREVOUS_OBLIG_PYMT_AMOUNT
,      OBLIG_PYMT_ADJUSTED_AMOUNT
,      CURRENT_OBLIG_PYMT_AMOUNT
,      YEAR_TD_TOTAL_RECP
,      YEAR_TD_ACCEPTED_DISB_AMOUNT
,      YEAR_TD_POSTED_DISB_AMOUNT
,      YEAR_TD_ADMIN_COST_ALLOWANCE
,      CAPS_DRWN_DN_PAYMENTS
,      GAPS_LAST_DATE
,      LAST_PAYMENT_NUMBER
,      REPORTING_PELL_ID
,      DUNS_ID
,      ESS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFBV_PEL_ELEC_SUM_STMNT_ACNTS;

Dependencies

[top of page]

APPS.IGFBV_PEL_ELEC_SUM_STMNT_ACNTS references the following:

APPS: IGF_GR_ELEC_STAT_SUM_ALL

APPS.IGFBV_PEL_ELEC_SUM_STMNT_ACNTS is not referenced by any database object