GM_BUD_LSUM_VW9

(SQL View)
 Index Back

Budget Summary Line View

This view provides pre-award budget data at the summary line (category) level. Only budget headers that have 'Include in Proposal' turned ON are selected.

SELECT A.BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID , A.SUB_PROP_NBR , A.BUDGET_ID , A.BUDGET_PERIOD_GM , A.BUDGET_LN , A.BUDGET_CATEGORY , A.DESCR , A.BUDGET_AMT , A.SPONSOR_AMT , A.COST_SHARE_IN_AMT , A.COST_SHARE_TP_AMT , A.MAP_MODULAR_LN , A.DESCRLONG , A.CURRENCY_CD FROM PS_GM_BUD_LINE_SUM A , PS_GM_BUD_HDR B WHERE B.INCL_IN_PROPOSAL = 'Y' 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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

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 BUDGET_CATEGORY Character(15) VARCHAR2(15) NOT NULL BUDGET_CATEGORY
9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
10 BUDGET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL BUDGET_AMT
11 SPONSOR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL SPONSOR_AMT
12 COST_SHARE_IN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL COST_SHARE_IN_AMT
13 COST_SHARE_TP_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL COST_SHARE_TP_AMT
14 MAP_MODULAR_LN Character(1) VARCHAR2(1) NOT NULL MAP_MODULAR_LN
15 DESCRLONG Long Character CLOB Long Description
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code