eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGFBV_DL_STAFFORD_PROM_NOTES

Product:	IGF - Financial Aid (Obsolete)
Description:	Base view for the entity that holds Direct Stafford Loan Promissory Notes
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SPNOTE.BATCH_SEQ_NUM
, SPNOTE.LOAN_NUMBER
, SPNOTE.S_SSN
, SPNOTE.S_FIRST_NAME
, SPNOTE.S_LAST_NAME
, SPNOTE.S_MIDDLE_NAME
, SPNOTE.S_DATE_OF_BIRTH
, SPNOTE.S_LICENSE_NUM
, SPNOTE.S_LICENSE_STATE
, SPNOTE.S_PERMT_ADDR1
, SPNOTE.S_PERMT_ADDR2
, SPNOTE.S_PERMT_CITY
, SPNOTE.S_PERMT_STATE
, SPNOTE.S_PERMT_ZIP
, SPNOTE.S_EMAIL_ADDR
, SPNOTE.S_PHONE
, SPNOTE.STATUS
, SPNOTE.LOAN_ID
, SPNOTE.PERSON_ID
, SPNOTE.PNSP_ID
, SPNOTE.CREATED_BY
, SPNOTE.CREATION_DATE
, SPNOTE.LAST_UPDATED_BY
, SPNOTE.LAST_UPDATE_DATE
FROM IGF_SL_DL_PNOTE_S_P_ALL SPNOTE WITH READ ONLY

Columns

Name
BATCH_SEQUENCE_NUMBER
LOAN_NUMBER
STUDENT_SSN
STUDENT_FIRST_NAME
STUDENT_LAST_NAME
STUDENT_MIDDLE_NAME
STUDENT_DATE_OF_BIRTH
STUDENT_LICENSE_NUMBER
STUDENT_LICENSE_STATE
STUDENT_PERMIT_ADDRESS1
STUDENT_PERMIT_ADDRESS2
STUDENT_PERMIT_CITY
STUDENT_PERMIT_STATE
STUDENT_PERMIT_ZIP_CODE
STUDENT_EMAIL_ADDRESS
STUDENT_PHONE_NUMBER
PROM_NOTE_PRINT_STATUS_FLAG
LOAN_ID
PERSON_ID
PROMISSORY_NOTE_PRINT_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE