[Home] [Help]
View: IGFBV_DL_STAFFORD_PROM_NOTES
Product: | IGF - Financial Aid |
Description: | Base view for the entity that holds Direct Stafford Loan Promissory Notes |
Implementation/DBA Data: |
APPS.IGFBV_DL_STAFFORD_PROM_NOTES
|
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 |