[Home] [Help]
View: IGS_PE_ACAD_HONORS_V
Product: | IGS - Student System (Obsolete) |
Description: | Academic Honors View |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AH.ROWID ROW_ID
, AH.PERSON_ID
, AH.ACAD_HONOR_ID
, AH.ACAD_HONOR_TYPE
, LK.DESCRIPTION ACAD_HONOR_DESC
, AH.HONOR_DATE
, AH.COMMENTS
, AH.CREATED_BY
, AH.CREATION_DATE
, AH.LAST_UPDATED_BY
, AH.LAST_UPDATE_DATE
, AH.LAST_UPDATE_LOGIN
, AH.REQUEST_ID
, AH.PROGRAM_APPLICATION_ID
, AH.PROGRAM_ID
, AH.PROGRAM_UPDATE_DATE
FROM IGS_PE_ACAD_HONORS AH
, IGS_LOOKUP_VALUES LK
WHERE LK.LOOKUP_CODE = AH.ACAD_HONOR_TYPE
AND LK.LOOKUP_TYPE ='PE_ACAD_HONORS'
Columns
Name |
ROW_ID |
PERSON_ID |
ACAD_HONOR_ID |
ACAD_HONOR_TYPE |
ACAD_HONOR_DESC |
HONOR_DATE |
COMMENTS |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |