GM_FRN_DTL_VW8

(SQL View)
Index Back

Sponsor, Frng, Dtl In, Dtl Out

Budget extract for GM pre-to-post interface. Funder: Sponsor Categ: Fringe Level In: Detail Level Out: Detail

SELECT S.BUSINESS_UNIT , S.PROPOSAL_ID , S.VERSION_ID , S.SUB_PROP_NBR , S.BUDGET_ID , S.BUDGET_PERIOD_GM , S.BUDGET_LN , D.SEQ_NUM , '1' , '2' , S.BUDGET_CATEGORY , D.DESCR , '1' , J.DEPTID , %Round(%DecMult(D.FRINGE_AMT, %DecDiv(S.SPONSOR_AMT, S.BUDGET_AMT)),C.DECIMAL_POSITIONS) FROM PS_GM_BUD_LINE_SUM S , PS_GM_BUD_LINE_DTL D , PS_GM_PROP_PROJ J , PS_CURRENCY_CD_TBL C WHERE (S.BUDGET_AMT = ( SELECT SUM(BUDGET_AMT) FROM PS_GM_BUD_LINE_DTL WHERE BUSINESS_UNIT = S.BUSINESS_UNIT AND PROPOSAL_ID = S.PROPOSAL_ID AND VERSION_ID = S.VERSION_ID AND SUB_PROP_NBR = S.SUB_PROP_NBR AND BUDGET_ID = S.BUDGET_ID AND BUDGET_PERIOD_GM = S.BUDGET_PERIOD_GM AND BUDGET_LN = S.BUDGET_LN) AND S.MAP_DETAIL_FLG = 'Y') AND S.BUSINESS_UNIT = D.BUSINESS_UNIT AND S.PROPOSAL_ID = D.PROPOSAL_ID AND S.VERSION_ID = D.VERSION_ID AND S.SUB_PROP_NBR = D.SUB_PROP_NBR AND S.BUDGET_ID = D.BUDGET_ID AND S.BUDGET_PERIOD_GM = D.BUDGET_PERIOD_GM AND S.BUDGET_LN = D.BUDGET_LN AND D.FRINGE_AMT <> 0 AND S.SPONSOR_AMT <> 0 AND S.BUDGET_AMT <> 0 AND C.CURRENCY_CD = S.CURRENCY_CD AND %EffdtCheck(CURRENCY_CD_TBL C1,C,%CurrentDateIn) AND J.BUSINESS_UNIT = S.BUSINESS_UNIT AND J.PROPOSAL_ID = S.PROPOSAL_ID AND J.VERSION_ID = S.VERSION_ID AND J.SUB_PROP_NBR = S.SUB_PROP_NBR

# 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_PD2 Number(3,0) SMALLINT NOT NULL Represents the second displayed column in the position monitor.
9 GM_FA_SEQ_FLG Character(1) VARCHAR2(1) NOT NULL Fixed and Administrative
1=Base (Non F&A)
2=Fixed and Administrative
10 GM_CATEG_SEQ_FLG Character(1) VARCHAR2(1) NOT NULL Category Sequence
0=All Categories
1=Nonfringe
2=Fringe
11 BUDGET_CATEGORY Character(15) VARCHAR2(15) NOT NULL BUDGET_CATEGORY
12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
13 GM_CS_SEQ_FLG Character(1) VARCHAR2(1) NOT NULL Cost Sharing
1=Sponsor
2=Cost Sharing
14 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
15 BUDGET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL BUDGET_AMT