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

VIEW: APPS.IGFFV_PEL_ELEC_DET_STMNT_ACNTS

Object Details
Object Name: IGFFV_PEL_ELEC_DET_STMNT_ACNTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGFFV_PEL_ELEC_DET_STMNT_ACNTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Full View for the Entity that holds the information about the 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
TRANSACTION_DATE DATE

Effective date of accounting transaction sent to GAPS
DEBIT_CREDIT_FLAG VARCHAR2 (1)
Indicates whether reported disbursement amount is increase or decrease to total amount disbursed to student for award year
ADJUSTED_AMOUNT NUMBER (12)
Amount of institution's adjustment batch
GAPS_PROCESS_DATE DATE

Date GAPS processed adjustment batch
ADJUSTED_BATCH_ID VARCHAR2 (30)
Batch identifier that generated adjustment
REPORTING_PELL_ID VARCHAR2 (30)
Reporting Pell identifier
DUNS_ID VARCHAR2 (30)
DUNS number assigned to reporting institution
ESD_ID NUMBER (15) Yes Unique identifier for electronic statement detail
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
,      TRANSACTION_DATE
,      DEBIT_CREDIT_FLAG
,      ADJUSTED_AMOUNT
,      GAPS_PROCESS_DATE
,      ADJUSTED_BATCH_ID
,      REPORTING_PELL_ID
,      DUNS_ID
,      ESD_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFFV_PEL_ELEC_DET_STMNT_ACNTS;

Dependencies

[top of page]

APPS.IGFFV_PEL_ELEC_DET_STMNT_ACNTS references the following:

SchemaAPPS
SynonymIGF_GR_ELEC_STAT_DET_ALL

APPS.IGFFV_PEL_ELEC_DET_STMNT_ACNTS is not referenced by any database object