[Home] [Help]
View: IGFFV_DL_YTD_SUMMARY
| Product: | IGF - Financial Aid (Obsolete) |
|---|
| Description: | Full View for the Entity that holds Year to Date Direct Loan Summary |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT YTDS.DL_VERSION
, YTDS.RECORD_TYPE
, YTDS.SCHOOL_CODE
, YTDS.REGION_CODE
, YTDS.STATE_CODE
, YTDS.REC_COUNT
, YTDS.STAT_END_DT
, YTDS.PROCESS_DT
, YTDS.DISB_SMR_TYPE
, YTDS.BKD_GROSS
, YTDS.BKD_FEE
, YTDS.BKD_INT_REBATE
, YTDS.BKD_NET
, YTDS.UNBKD_GROSS
, YTDS.UNBKD_FEE
, YTDS.UNBKD_INT_REBATE
, YTDS.UNBKD_NET
, YTDS.BATCH_ID
, YTDS.YTDS_ID
, YTDS.CREATED_BY
, YTDS.CREATION_DATE
, YTDS.LAST_UPDATED_BY
, YTDS.LAST_UPDATE_DATE
FROM IGF_DB_YTD_SMR_ALL YTDS WITH READ ONLY
Columns
| Name |
| DIRECT_LOAN_SPEC_VERSION |
| RECORD_TYPE |
| SCHOOL_CODE |
| REGION_CODE |
| STATE_CODE |
| RECORD_COUNT |
| STATEMENT_END_DATE |
| PROCESS_DATE |
| DISBURSEMENT_SUMMARY_TYPE |
| BOOKED_GROSS_AMOUNT |
| BOOKED_FEES_AMOUNT |
| BOOKED_INTEREST_REBATE |
| BOOKED_NET_AMOUNT |
| UNBOOKED_GROSS_AMOUNT |
| UNBOOKED_FEES_AMOUNT |
| UNBOOKED_INTEREST_REBATE |
| UNBOOKED_NET_AMOUNT |
| BATCH_ID |
| YEAR_TO_DATE_DISB_SUMMARY_ID |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |