GM_AWD_PRJ_VW3

(SQL View)
 Index Back

Award Projects View

Award Projects Description View.

SELECT DISTINCT A.BUSINESS_UNIT , A.CONTRACT_NUM , A.PROJECT_ID_SRCH , A.DESCR , A.EMPLID , A.PROPOSAL_ID , A.AWARD_TYPE , A.AWARD_STATUS , B.EFF_STATUS , B.DESCR , C.XLATLONGNAME FROM (PS_GM_HDR_AWD2_VW A LEFT JOIN PS_PROJECT B ON A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID_SRCH = B.PROJECT_ID LEFT OUTER JOIN PSXLATITEM C ON B.EFF_STATUS = C.FIELDVALUE AND C.FIELDNAME = 'EFF_STATUS' )

  • Related Language Record: GM_AWD_PRJ_LVW3

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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
    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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    10 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    11 STATUS1 Character(30) VARCHAR2(30) NOT NULL Status