GM_BUD_HDR_VW2

(SQL View)
Index Back

Grants Budget Header View2

Each row of this record represents a budget that exists within a proposal project. Used to determine if a proposal project can be deleted or changed.

select business_unit, proposal_id, version_id, sub_prop_nbr, budget_id from PS_GM_BUD_HDR

# 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