GM_CUSTOMER_VW2

(SQL View)
 Index Back

Grants Customer Info

View of Customer table that only pulls records for Grants Sponsors and Awarding sponsors. Used as prompt table in proposal. Cust_status = 'A'

SELECT A.SETID , A.CUST_ID , A.NAME1 FROM PS_CUSTOMER A ,PS_CUST_OPTION C WHERE C.INTERUNIT_FLG ='N' AND %EffdtCheck(CUST_OPTION B,C, %CurrentDateIn) AND C.EFF_STATUS = 'A' AND C.SETID= A.SETID AND C.CUST_ID = A.CUST_ID AND A.CUST_STATUS = 'A' AND A.GRANTS_SPONSOR_FLG = 'Y' AND A.SOLD_TO_FLG = 'Y'

  • Related Language Record: GM_SPNSR_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 SPONSOR_ID Character(15) VARCHAR2(15) NOT NULL SPONSOR_ID
    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1