[Home] [Help]
View: IGW_PROP_PERSON_DEGREES_V
Product: | IGW - Grants Proposal (Obsolete) |
Description: | 10SC Only |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PPPD.ROWID ROW_ID
, PPPD.PROPOSAL_ID
, PPPD.PERSON_DEGREE_ID
, PPPD.SHOW_FLAG
, PPPD.DEGREE_SEQUENCE PROP_DEGREE_SEQUENCE
, PPPD.LAST_UPDATE_DATE
, PPPD.LAST_UPDATED_BY
, PPPD.CREATION_DATE
, PPPD.CREATED_BY
, PPPD.LAST_UPDATE_LOGIN
, PPD.PERSON_ID
, PPD.DEGREE_TYPE_CODE
, PPD.GRADUATION_DATE
, PPD.DEGREE
, PPD.DEGREE_SEQUENCE PERSON_DEGREE_SEQUENCE
, PPD.FIELD_OF_STUDY
, PPD.SPECIALIZATION
, PPD.SCHOOL_NAME
FROM IGW_PROP_PERSON_DEGREES PPPD
, IGW_PERSON_DEGREES PPD
WHERE PPPD.PERSON_DEGREE_ID = PPD.PERSON_DEGREE_ID
Columns
Name |
ROW_ID |
PROPOSAL_ID |
PERSON_DEGREE_ID |
SHOW_FLAG |
PROP_DEGREE_SEQUENCE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
PERSON_ID |
DEGREE_TYPE_CODE |
GRADUATION_DATE |
DEGREE |
PERSON_DEGREE_SEQUENCE |
FIELD_OF_STUDY |
SPECIALIZATION |
SCHOOL_NAME |