[Home] [Help]
View: IGS_RE_THESIS_EXAM_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PERSON_ID
, CA_SEQUENCE_NUMBER
, THE_SEQUENCE_NUMBER
, CREATION_DT
, DECODE(NVL(SUBMISSION_DT
, SYSDATE)
, SYSDATE
, 'N'
, 'Y') SUBMITTED_IND
, SUBMISSION_DT
, THESIS_EXAM_TYPE
, THESIS_PANEL_TYPE
, TRACKING_ID
, THESIS_RESULT_CD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_RE_THESIS_EXAM TEX
Columns
Name |
PERSON_ID |
CA_SEQUENCE_NUMBER |
THE_SEQUENCE_NUMBER |
CREATION_DT |
SUBMITTED_IND |
SUBMISSION_DT |
THESIS_EXAM_TYPE |
THESIS_PANEL_TYPE |
TRACKING_ID |
THESIS_RESULT_CD |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |