[Home] [Help]
View: IGS_PE_PERS_NOTE_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Person note view. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT T.ROWID ROW_ID
, T.PERSON_ID
, T.PE_NOTE_TYPE
, L1.MEANING PE_NOTE_TYPE_DESC
, T.REFERENCE_NUMBER
, T.CREATED_BY
, T.CREATION_DATE
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN
, T.START_DATE
, T.END_DATE
FROM IGS_PE_PERS_NOTE T
, IGS_LOOKUP_VALUES L1
WHERE L1.LOOKUP_CODE = T.PE_NOTE_TYPE
AND L1.LOOKUP_TYPE = 'PE_NOTE_TYPE'
Columns
| Name |
| ROW_ID |
| PERSON_ID |
| PE_NOTE_TYPE |
| PE_NOTE_TYPE_DESC |
| REFERENCE_NUMBER |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |
| START_DATE |
| END_DATE |