DBA Data[Home] [Help] [Dependency Information]

TABLE: IGF.IGF_GR_ELEC_STAT_SUM_ALL

Object Details
Object Name: IGF_GR_ELEC_STAT_SUM_ALL
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.IGF_GR_ELEC_STAT_SUM_ALL
Subobject Name:
Status: VALID


IGF_GR_ELEC_STAT_SUM_ALL stores the summary details that are uploaded via the electronic statement of accounts that comes from the government.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_GR_ELEC_STAT_SUM_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnESS_ID
Columns
Name Datatype Length Mandatory Comments
ESS_ID NUMBER (15) Yes Sequence-generated unique identifier
REP_PELL_ID VARCHAR2 (30)
Reporting Pell identifier
DUNS_ID VARCHAR2 (30)
DUNS number assigned to reporting institution
GAPS_AWARD_NUM 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
PREV_OBLIGATION_AMT NUMBER (12)
Amount of institution's total obligation prior to adjustment
OBLIGATION_ADJ_AMT NUMBER (12)
Adjustment of obligations for accounting cycle
CURR_OBLIGATION_AMT NUMBER (12)
Amount of institution's current obligation balance
PREV_OBLIGATION_PYMT_AMT NUMBER (12)
Amount of institution's previous payment balance
OBLIGATION_PYMT_ADJ_AMT NUMBER (12)
Total of all adjustments to payment for GAPS Award Number
CURR_OBLIGATION_PYMT_AMT 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_AMT NUMBER (12)
YTD total of disbursements accepted by RFMS
YTD_POSTED_DISB_AMT 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_PYMTS 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_PYMT_NUMBER VARCHAR2 (30)
Reference number for last payment sent to institution
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column for concurrent programs
PROGRAM_ID NUMBER (15)
Standard Who column for concurrent programs
PROGRAM_UPDATE_DATE DATE

Standard Who column for concurrent programs
REQUEST_ID NUMBER (15)
Standard Who column for concurrent programs
ORG_ID NUMBER (15)
Operating unit identifier
Query Text

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


SELECT ESS_ID
,      REP_PELL_ID
,      DUNS_ID
,      GAPS_AWARD_NUM
,      ACCT_SCHEDULE_NUMBER
,      ACCT_SCHEDULE_DATE
,      PREV_OBLIGATION_AMT
,      OBLIGATION_ADJ_AMT
,      CURR_OBLIGATION_AMT
,      PREV_OBLIGATION_PYMT_AMT
,      OBLIGATION_PYMT_ADJ_AMT
,      CURR_OBLIGATION_PYMT_AMT
,      YTD_TOTAL_RECP
,      YTD_ACCEPTED_DISB_AMT
,      YTD_POSTED_DISB_AMT
,      YTD_ADMIN_COST_ALLOWANCE
,      CAPS_DRWN_DN_PYMTS
,      GAPS_LAST_DATE
,      LAST_PYMT_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ORG_ID
FROM IGF.IGF_GR_ELEC_STAT_SUM_ALL;

Dependencies

[top of page]

IGF.IGF_GR_ELEC_STAT_SUM_ALL does not reference any database object

IGF.IGF_GR_ELEC_STAT_SUM_ALL is referenced by following:

SchemaAPPS
SynonymIGF_GR_ELEC_STAT_SUM_ALL