GM_XML_BUD_EQU

(SQL View)
 Index Back

Budget Detail View

This view delivers pre-award budget data for detail lines. Important: Only budget headers that have 'Include in Proposal' turned ON are selected.

SELECT B.BUSINESS_UNIT , B.PROPOSAL_ID , B.VERSION_ID , B.SUB_PROP_NBR , B.BUDGET_ID , B.BUDGET_PERIOD_GM , B.BUDGET_LN , B.SEQ_NUM , A.BUDGET_CATEGORY , B.DESCR , B.BUDGET_AMT , %Round(%DecMult(B.BUDGET_AMT, %DecDiv(A.SPONSOR_AMT, A.BUDGET_AMT)),2) FROM PS_GM_BUD_LSUM_VW9 A , PS_GM_BUD_LINE_DTL B , PS_GM_BUD_CATEGORY D WHERE A.BUDGET_AMT <> 0 AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PROPOSAL_ID = A.PROPOSAL_ID AND B.VERSION_ID = A.VERSION_ID AND B.SUB_PROP_NBR = A.SUB_PROP_NBR AND B.BUDGET_ID = A.BUDGET_ID AND B.BUDGET_PERIOD_GM = A.BUDGET_PERIOD_GM AND B.BUDGET_LN = A.BUDGET_LN AND A.BUDGET_CATEGORY = D.BUDGET_CATEGORY AND D.GM_BUD_GROUP = 'EQUP' AND D.SETID = ( SELECT G.SETID FROM PS_SET_CNTRL_REC G WHERE G.SETCNTRLVALUE = A.BUSINESS_UNIT AND G.RECNAME ='GM_BUD_CATEGORY') AND D.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_GM_BUD_CATEGORY B1 WHERE D.SETID = B1.SETID AND D.BUDGET_CATEGORY = B1.BUDGET_CATEGORY AND B1.EFFDT <= %CurrentDateIn)

# 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 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
4 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
5 BUDGET_ID Character(15) VARCHAR2(15) NOT NULL BUDGET_ID
6 BUDGET_PERIOD_GM Number(3,0) SMALLINT NOT NULL BUDGET_PERIOD_GM
7 BUDGET_LN Number(6,0) INTEGER NOT NULL BUDGET_LN
8 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
9 BUDGET_CATEGORY Character(15) VARCHAR2(15) NOT NULL BUDGET_CATEGORY
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 BUDGET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL BUDGET_AMT
12 SPONSOR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL SPONSOR_AMT