GM_CONT_BFAH_VW

(SQL View)
 Index Back

F&A Data by Header view

Contains Fixed and Administrative (F&A) data by budget header/version

SELECT H.BUSINESS_UNIT , H.PROPOSAL_ID , H.VERSION_ID , H.SUB_PROP_NBR , H.BUDGET_ID , H.FA_RATE_TYPE , H.FA_INST_BASE_ID , H.FA_SPNSR_BASE_ID , H.FA_BASE_ID , H.SAME_AS_INST FROM PS_GM_BUD_FA_HDR H , PS_GM_PROP_PROJ J WHERE J.BUSINESS_UNIT = H.BUSINESS_UNIT AND J.PROPOSAL_ID = H.PROPOSAL_ID AND J.VERSION_ID = H.VERSION_ID AND J.SUB_PROP_NBR = H.SUB_PROP_NBR AND J.PROJECT_ID <> ' '

  • Parent record: 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
    6 FA_RATE_TYPE Character(5) VARCHAR2(5) NOT NULL FA_RATE_TYPE

    Prompt Table: GM_FA_RATE_TYPE

    7 FA_INST_BASE_ID Character(5) VARCHAR2(5) NOT NULL FA_INST_BASE_ID

    Prompt Table: GM_FA_BASE_DTL

    8 FA_SPNSR_BASE_ID Character(5) VARCHAR2(5) NOT NULL Sponsor Base

    Prompt Table: GM_FA_BASE_DTL

    9 FA_BASE_ID Character(5) VARCHAR2(5) NOT NULL FA_BASE_ID

    Prompt Table: GM_FA_BASE_DTL

    10 SAME_AS_INST Character(1) VARCHAR2(1) NOT NULL Same as Institution
    N=No
    Y=Yes

    Default Value: Y