[Home] [Help]
View: IGW_PRPO_BIOSKETCH_DEGREES_V
Product: | IGW - Grants Proposal (Obsolete) |
Description: | View displays a person's educational qualifications |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PPPD.PROPOSAL_ID
, PPD.PERSON_ID
, PPD.PARTY_ID
, PPD.DEGREE_TYPE_CODE
, PPD.GRADUATION_DATE
, PPD.DEGREE
, PPD.FIELD_OF_STUDY
, PPD.SPECIALIZATION
, PPD.SCHOOL_NAME
, PPD.ATTRIBUTE_CATEGORY
, PPD.ATTRIBUTE1
, PPD.ATTRIBUTE2
, PPD.ATTRIBUTE3
, PPD.ATTRIBUTE4
, PPD.ATTRIBUTE5
, PPD.ATTRIBUTE6
, PPD.ATTRIBUTE7
, PPD.ATTRIBUTE8
, PPD.ATTRIBUTE9
, PPD.ATTRIBUTE10
, PPD.ATTRIBUTE11
, PPD.ATTRIBUTE12
, PPD.ATTRIBUTE13
, PPD.ATTRIBUTE14
, PPD.ATTRIBUTE15
FROM IGW_PROP_PERSON_DEGREES PPPD
, IGW_PERSON_DEGREES PPD
WHERE PPPD.PERSON_DEGREE_ID = PPD.PERSON_DEGREE_ID
AND PPPD.SHOW_FLAG = 'Y' ORDER BY PPD.PERSON_ID
, PPPD.DEGREE_SEQUENCE
Columns
Name |
PROPOSAL_ID |
PERSON_ID |
PARTY_ID |
DEGREE_CODE |
DEGREE_TIME_PERIOD |
DEGREE_DESCRIPTION |
FIELD_OF_STUDY |
AREA_OF_SPECIALIZATION |
EDUCATIONAL_INSTITUTION |
BIO_DEGREE_ATTRIBUTE_CATEGORY |
BIO_DEGREE_ATTRIBUTE1 |
BIO_DEGREE_ATTRIBUTE2 |
BIO_DEGREE_ATTRIBUTE3 |
BIO_DEGREE_ATTRIBUTE4 |
BIO_DEGREE_ATTRIBUTE5 |
BIO_DEGREE_ATTRIBUTE6 |
BIO_DEGREE_ATTRIBUTE7 |
BIO_DEGREE_ATTRIBUTE8 |
BIO_DEGREE_ATTRIBUTE9 |
BIO_DEGREE_ATTRIBUTE10 |
BIO_DEGREE_ATTRIBUTE11 |
BIO_DEGREE_ATTRIBUTE12 |
BIO_DEGREE_ATTRIBUTE13 |
BIO_DEGREE_ATTRIBUTE14 |
BIO_DEGREE_ATTRIBUTE15 |