FND Design Data [Home] [Help]

View: IGFBV_PEL_ELEC_DET_STMNT_ACNTS

Product: IGF - Financial Aid
Description: Base 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
Implementation/DBA Data: ViewAPPS.IGFBV_PEL_ELEC_DET_STMNT_ACNTS
View Text

SELECT ESD.GAPS_AWARD_NUM
, ESD.TRANSACTION_DATE
, ESD.DB_CR_FLAG
, ESD.ADJ_AMT
, ESD.GAPS_PROCESS_DATE
, ESD.ADJ_BATCH_ID
, ESD.REP_PELL_ID
, ESD.DUNS_ID
, ESD.ESD_ID
, ESD.CREATED_BY
, ESD.CREATION_DATE
, ESD.LAST_UPDATED_BY
, ESD.LAST_UPDATE_DATE
FROM IGF_GR_ELEC_STAT_DET_ALL ESD WITH READ ONLY

Columns

Name
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