Skip to content
[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 |