[Home] [Help]
View: IGF_AP_PERS_NOTE_V
Product: | IGF - Financial Aid |
Description: | stores institution-defined note type pertaining to a student or a particular award year |
Implementation/DBA Data: |
APPS.IGF_AP_PERS_NOTE_V
|
View Text
SELECT PERN.ROWID
, PERN.REFERENCE_NUMBER
, PERN.BASE_ID
, PERN.PE_NOTE_TYPE
, PNT.MEANING PE_NOTE_TYPE_DESC
, PERN.SHORT_DESC
, PERN.REC_RESP
, PERN.CREATED_BY
, PERN.CREATION_DATE
, PERN.LAST_UPDATED_BY
, PERN.LAST_UPDATE_DATE
, PERN.LAST_UPDATE_LOGIN
FROM IGF_AP_PERS_NOTE PERN
, IGS_LOOKUP_VALUES PNT
WHERE PERN.PE_NOTE_TYPE = PNT.LOOKUP_CODE
AND PNT.LOOKUP_TYPE = 'PE_NOTE_TYPE'
Columns
Name |
ROW_ID |
REFERENCE_NUMBER |
BASE_ID |
PE_NOTE_TYPE |
PE_NOTE_TYPE_DESC |
SHORT_DESC |
REC_RESP |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |