[Home] [Help]
View: IGFBV_DL_ORIGINATION_CHANGES
| Product: | IGF - Financial Aid (Obsolete) |
|---|
| Description: | Base view for the entity that holds Financial Aid Direct Loan Origination Changes |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT CHG.LOAN_NUMBER
, CHG.CHG_CODE
, CHG.NEW_VALUE
, '_LA:CHG.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_CHG_STATUS:MEANING'
, CHG.DBTH_ID
, CHG.CHG_NUM
, CHG.CREATED_BY
, CHG.CREATION_DATE
, CHG.LAST_UPDATED_BY
, CHG.LAST_UPDATE_DATE
FROM IGF_SL_DL_CHG_SEND_ALL CHG WITH READ ONLY
Columns
| Name |
| LOAN_NUMBER |
| CHANGE_CODE |
| NEW_VALUE |
| "_LA:CHANGED_RECORD_STATUS" |
| BATCH_ID |
| CHANGE_RECORD_ID |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |