[Home] [Help]
View: IGF_SL_DB_COD_REP_V
| Product: | IGF - Financial Aid (Obsolete) |
|---|
| Description: | View used for reporting the disbursement tags in the outbound XML file. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT TRIM(DOCUMENT_ID_TXT)
, TRIM(REP_ENTITY_ID_TXT)
, TRIM(ATD_ENTITY_ID_TXT)
, AWARD_ID
, DISB_NUM
, DISB_ACCEPTED_AMT
, TO_CHAR(DISB_DATE
, 'YYYY-MM-DD')
, DISB_REL_FLAG
, DISB_SEQ_NUM
, NOTE_MESSAGE
, FIRST_DISB_FLAG
, DISB_NET_AMT
, ORIG_FEE_AMT
, INTEREST_REBATE_AMT
, DISB_CONF_FLAG
, TO_CHAR( PYMNT_PER_START_DATE
, 'YYYY-MM-DD')
FROM IGF_AW_DB_COD_DTLS
Columns
| Name |
| DOCUMENT_ID_TXT |
| REP_ENTITY_ID_TXT |
| ATD_ENTITY_ID_TXT |
| AWARD_ID |
| DISB_NUM |
| DISB_ACCEPTED_AMT |
| DISB_DATE |
| DISB_REL_FLAG |
| DISB_SEQ_NUM |
| NOTE_MESSAGE |
| FIRST_DISB_FLAG |
| DISB_NET_AMT |
| ORIG_FEE_AMT |
| INTEREST_REBATE_AMT |
| DISB_CONF_FLAG |
| PYMNT_PER_START_DATE |