[Home] [Help]
View: IGF_AW_FUND_GRP_V
View Text
SELECT AWD.PERSON_NUMBER
, FA.PERSON_ID
, AWD.SSN
, AWD.FULL_NAME
, AWD.FUND_CODE
, FCAT.DESCRIPTION
, FA.ENCUMBERED_IND
, FA.DECEASED_IND
FROM IGF_AW_AWARD_V AWD
, IGF_AP_FA_CON_V FA
, IGF_AW_FUND_CAT_ALL FCAT
WHERE AWD.PERSON_NUMBER = FA.PERSON_NUMBER
AND AWD.FUND_CODE = FCAT.FUND_CODE
AND AWD.AWARD_STATUS IN ('OFFERED'
, 'ACCEPTED') GROUP BY AWD.PERSON_NUMBER
, FA.PERSON_ID
, AWD.SSN
, AWD.FULL_NAME
, AWD.FUND_CODE
, FCAT.DESCRIPTION
, FA.ENCUMBERED_IND
, FA.DECEASED_IND
Columns
Name |
PERSON_NUMBER |
PERSON_ID |
SSN |
FULL_NAME |
FUND_CODE |
FUND_DESC |
ENCUMBERED_IND |
DECEASED_IND |