[Home] [Help]
View: GMS_KEY_MEMBER_ROLE_V
View Text
SELECT GA.AWARD_ID
, GA.AWARD_NUMBER
, GA.AWARD_SHORT_NAME
, GP.AWARD_ROLE
, PF.PERSON_ID
, PF.FULL_NAME
, GA.ORG_ID
FROM GMS_AWARDS GA
, GMS_PERSONNEL GP
, PER_PEOPLE_F PF
WHERE GA.AWARD_ID = GP.AWARD_ID
AND GP.PERSON_ID = PF.PERSON_ID
Columns
Name |
AWARD_ID |
AWARD_NUMBER |
AWARD_SHORT_NAME |
AWARD_ROLE |
PERSON_ID |
FULL_NAME |
ORG_ID |