[Home] [Help] [Dependency Information]
Object Name: | IGF_GR_ELEC_STAT_DET_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_GR_ELEC_STAT_DET_ALL |
Subobject Name: | |
Status: | VALID |
IGF_GR_ELEC_STAT_DET_ALL stores the details that are uploaded via the electronic statement of accounts that comes from the government.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_GR_ELEC_STAT_DET_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ESD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ESD_ID | NUMBER | (15) | Yes | Unique identifier for electronic statement detail |
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 | |
TRANSACTION_DATE | DATE | Effective date of accounting transaction sent to GAPS | ||
DB_CR_FLAG | VARCHAR2 | (1) | Indicates whether reported disbursement amount is increase or decrease to total amount disbursed to student for award year | |
ADJ_AMT | NUMBER | (12) | Amount of institution's adjustment batch | |
GAPS_PROCESS_DATE | DATE | Date GAPS processed adjustment batch | ||
ADJ_BATCH_ID | VARCHAR2 | (30) | Batch identifier that generated adjustment | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column for concurrent programs |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ESD_ID
, REP_PELL_ID
, DUNS_ID
, GAPS_AWARD_NUM
, TRANSACTION_DATE
, DB_CR_FLAG
, ADJ_AMT
, GAPS_PROCESS_DATE
, ADJ_BATCH_ID
, 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_DET_ALL;
IGF.IGF_GR_ELEC_STAT_DET_ALL does not reference any database object
IGF.IGF_GR_ELEC_STAT_DET_ALL is referenced by following:
|
|
|