eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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