GM_HDR_AWD2_VW

(SQL View)
 Index Back

Contr Hdr and Award Extended


SELECT DISTINCT A.BUSINESS_UNIT , A.CONTRACT_NUM , B.PROJECT_ID , %Substring(A.TITLE56,1,30) , A.EMPLID , A.PROPOSAL_ID , A.AWARD_TYPE , A.AWARD_STATUS , A.REF_AWD_NUMBER FROM PS_GM_AWARD A ,PS_CA_DETAIL_PROJ B WHERE A.CONTRACT_NUM = B.CONTRACT_NUM (+)

  • Related Language Record: GM_HDR_AWD2_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

    Prompt Table: SP_BU_CA_NONVW

    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Award ID
    3 PROJECT_ID_SRCH Character(15) VARCHAR2(15) NOT NULL Project Id

    Prompt Table: SP_GM_PRJ_NONVW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    6 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
    7 AWARD_TYPE Character(3) VARCHAR2(3) NOT NULL Award Type
    BOA=Basic Ordering Agreement
    CLI=Clinical Trial
    CON=Contract
    CP=Cooperative Agreement
    FDP=FDP
    FIX=Fixed
    GR=Grant
    IPA=IPA
    LIC=License
    LN=Loan
    MOU=MOU
    MTA=MTA
    NDA=NDA
    OTH=Other
    PA=Patent Agreement
    PO=Purchase Order
    SB=SubContract
    TO=Task Order
    8 AWARD_STATUS Character(3) VARCHAR2(3) NOT NULL Award Status
    ACP=Accepted
    CLS=Closed
    HOL=Holding
    NEG=Under Negotiation
    PEN=Pending
    PRE=Pre-Award
    REF=Refused
    TER=Terminated
    TRA=Transfer
    WTH=Withdrawn
    9 REF_AWD_NUMBER Character(25) VARCHAR2(25) NOT NULL Reference Award Number