GM_PREF_AWD_VW

(SQL View)
 Index Back

Award Preferences View

Award Preferences View

SELECT PREF_AWD.OPRID , AWD.BUSINESS_UNIT , AWD.CONTRACT_NUM , AWD.VERSION_ID , AWD.TITLE56 , AWD.EMPLID , AWD.BEGIN_DT , AWD.END_DT , AWD.AWARD_STATUS , AWD.CUST_ID , CUST.NAME1 , AWD.NAME FROM PS_GM_AWARD AWD , PS_CUSTOMER CUST , PS_GM_MY_PREF PREF_AWD WHERE PREF_AWD.BUSINESS_UNIT = AWD.BUSINESS_UNIT AND ((PREF_AWD.BEGIN_DT <= AWD.BEGIN_DT) OR PREF_AWD.BEGIN_DT IS NULL) AND AWARD_STATUS <> 'CLS' AND ((PREF_AWD.GM_SELECT_PI ='N') OR (PREF_AWD.GM_SELECT_PI ='Y' AND EXISTS ( SELECT 'X' FROM PS_GM_PREF_PI PREF_PI WHERE PREF_PI.OPRID = PREF_AWD.OPRID AND PREF_PI.EMPLID = AWD.EMPLID ))) AND ((PREF_AWD.GM_SEL_AWD_STS ='N') OR (PREF_AWD.GM_SEL_AWD_STS ='Y' AND EXISTS ( SELECT 'X' FROM PS_GM_PREF_AWD_STS PREF_STS WHERE PREF_STS.OPRID = PREF_AWD.OPRID AND PREF_STS.AWARD_STATUS = AWD.AWARD_STATUS ))) AND CUST.CUST_ID = AWD.CUST_ID AND CUST.SETID = ( SELECT REC.SETID FROM PS_SET_CNTRL_REC REC WHERE REC.RECNAME = 'CUSTOMER' AND AWD.BUSINESS_UNIT = REC.SETCNTRLVALUE ) AND ((PREF_AWD.GM_SELECT_SPONSOR ='N') OR (PREF_AWD.GM_SELECT_SPONSOR ='Y' AND EXISTS ( SELECT 'X' FROM PS_GM_PREF_SPONSOR PREF_SPN WHERE PREF_SPN.OPRID = PREF_AWD.OPRID AND PREF_SPN.CUST_ID = AWD.CUST_ID AND PREF_SPN.SETID = CUST.SETID )))

  • Related Language Record: GM_PREF_AWD_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    4 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
    5 TITLE56 Character(56) VARCHAR2(56) NOT NULL TITLE56
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    7 BEGIN_DT Date(10) DATE Begin Date
    8 END_DT Date(10) DATE End Date
    9 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
    10 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    12 NAME Character(50) VARCHAR2(50) NOT NULL Name