GM_BUD_HDR_VW

(SQL View)
Index Back

Grants Budget Header View

Each row of this record represents an entire budget or budget version for a proposal/project. Selects only records that have INCL_IN_PROPOSAL marked as "Y".

SELECT BUSINESS_UNIT ,PROPOSAL_ID ,VERSION_ID ,SUB_PROP_NBR ,BUDGET_ID ,DESCR ,PRICING_METHOD ,PPSL_TO_ACTVTY_FLG ,ACTIVITY_ID ,PRL_CREATED_FLG ,PRODUCT_ID FROM PS_GM_BUD_HDR WHERE INCL_IN_PROPOSAL = '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 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 PRICING_METHOD Character(3) VARCHAR2(3) NOT NULL Pricing Method
FIX=Fixed
INC=As Incurred
8 PPSL_TO_ACTVTY_FLG Character(1) VARCHAR2(1) NOT NULL Proposal To Activity
D=Generated
N=Activity Not Created
P=Pre-Sales
9 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
10 PRL_CREATED_FLG Character(1) VARCHAR2(1) NOT NULL PRL Created FLag
11 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID