GM_BUD_F_H2_VW

(SQL View)
Index Back

F&A Header View with period


select A.BUSINESS_UNIT, A.PROPOSAL_ID, A.VERSION_ID, A.SUB_PROP_NBR, A.BUDGET_ID, B.BUDGET_PERIOD_GM, A.FA_RATE_TYPE, A.FA_INST_BASE_ID, A.FA_SPNSR_BASE_ID, A.FA_BASE_ID from PS_GM_BUD_FA_HDR A, PS_GM_BUD_PERIOD B where A.BUSINESS_UNIT = B.BUSINESS_UNIT and A.PROPOSAL_ID = B.PROPOSAL_ID and A.VERSION_ID = B.VERSION_ID and A.SUB_PROP_NBR = B.SUB_PROP_NBR and A.BUDGET_ID = B.BUDGET_ID

# 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 FA_RATE_TYPE Character(5) VARCHAR2(5) NOT NULL FA_RATE_TYPE
8 FA_INST_BASE_ID Character(5) VARCHAR2(5) NOT NULL FA_INST_BASE_ID
9 FA_SPNSR_BASE_ID Character(5) VARCHAR2(5) NOT NULL Sponsor Base
10 FA_BASE_ID Character(5) VARCHAR2(5) NOT NULL FA_BASE_ID