GM_AWDPR_PRJ_VW

(SQL View)
 Index Back

View of Projects by Award

This view retrieves all the Projects for a particular Award (CONTRACT_NUM_PC).

SELECT DISTINCT AWD.OPRID , A.CONTRACT_NUM , A.BUSINESS_UNIT_PC ,A.PROJECT_ID FROM PS_CA_DETAIL_PROJ A , PS_GM_PREF_AWD_VW AWD , PS_PROJECT PRJ WHERE A.CONTRACT_NUM = AWD.CONTRACT_NUM AND PRJ.BUSINESS_UNIT = A.BUSINESS_UNIT_PC AND PRJ.PROJECT_ID = A.PROJECT_ID AND PRJ.EFF_STATUS <> 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField