GM_PPOSAL_SR_VW

(SQL View)
 Index Back

Proposal ID search view


SELECT DISTINCT A.BUSINESS_UNIT ,A.PROPOSAL_ID , A.PROPOSAL_TITLE , A.PROPOSAL_FLG FROM PS_GM_PROPOSAL A , PS_GM_OPTY_SRCH_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROPOSAL_FLG = 'S' AND A.CURRENT_VERSION = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
3 PROPOSAL_TITLE Character(56) VARCHAR2(56) NOT NULL Description
4 PROPOSAL_FLG Character(1) VARCHAR2(1) NOT NULL Proposal Checkbox
G=Grants Proposal
I=Internal Proposal
S=Solicitation Proposal