RA_OFFER_GRD_VW

(SQL View)
 Index Back

Offer Grid View table

View of all offer records available for marketing campaigns

SELECT A.SETID ,A.RA_OFFER_ID ,A.PRICE_SET_ID , CASE WHEN B.PRODUCT_ID IS NULL THEN ' ' ELSE B.PRODUCT_ID END ,A.RA_OFFER_NAME ,C.RA_DISCOUNT_TYPE ,B.DESCR ,A.BO_ID_OWNER ,A.RA_OFFER_STATUS ,A.START_DATE ,A.END_DATE ,%Substring(BNP.BO_NAME_DISPLAY,1,50) ,BNP.NAME_AC ,A.RA_OFFER_TYPE ,A.RA_OBJECTIVE_CD ,A.DESCR254 ,A.RA_PRIORITY ,A.RA_SCRIPT_ID_OTBN ,A.RAD_ADVISOR_ID ,BS.SCRIPT_NAME ,BA.RAD_ADVISOR_NAME ,A.SYNCID ,A.DESCRLONG FROM PS_RA_OFFER A LEFT OUTER JOIN PS_BO_NAME_PRIM_VW BNP ON (A.BO_ID_OWNER = BNP.BO_ID) LEFT OUTER JOIN PS_RA_OFFER_PR_VW B ON (A.SETID = B.SETID AND A.RA_OFFER_ID = B.RA_OFFER_ID) LEFT OUTER JOIN PS_RA_OFFER_PRCSET C ON (A.SETID = C.SETID AND A.RA_OFFER_ID = C.RA_OFFER_ID AND A.PRICE_SET_ID = C.PRICE_SET_ID) LEFT OUTER JOIN PS_RA_SURVEY_VW BS ON (A.SETID = BS.SETID AND A.RA_SCRIPT_ID_OTBN = BS.SCRIPT_ID) LEFT OUTER JOIN PS_RAD_ADV_ACTI_VW BA ON (A.RAD_ADVISOR_ID = BA.RAD_ADVISOR_ID)

  • Related Language Record: RA_OFFERGRD_LN3

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 RA_OFFER_ID Character(15) VARCHAR2(15) NOT NULL Marketing Offer ID

    Default Value: NEXT

    3 PRICE_SET_ID Character(10) VARCHAR2(10) NOT NULL Price Rule

    Default Value: NEXT

    4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: RA_OFR_PRDCT_VW

    5 RA_OFFER_NAME Character(50) VARCHAR2(50) NOT NULL Marketing Offer Name
    6 RA_DISCOUNT_TYPE Character(4) VARCHAR2(4) NOT NULL Marketing - Offer - Discount Type
    GIVE=Giveaway
    NONE=No Discount
    STD=Standard Discount
    TIER=Tiered Pricing
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID
    9 RA_OFFER_STATUS Character(4) VARCHAR2(4) NOT NULL Marketing Offer status
    ARCH=Archived
    CMPL=Completed
    DECL=Declined
    IREV=In Review
    NEW=New
    PLAN=Planning
    10 START_DATE Date(10) DATE Offer Start Date
    11 END_DATE Date(10) DATE End date field to store an end date.
    12 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    13 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    14 RA_OFFER_TYPE Character(1) VARCHAR2(1) NOT NULL Offer type is used to differentiate between Communication and Promotional Discount offers
    C=Communication
    P=Promotional Discount
    15 RA_OBJECTIVE_CD Character(4) VARCHAR2(4) NOT NULL Objective code of the campaign
    16 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    17 RA_PRIORITY Character(1) VARCHAR2(1) NOT NULL Marketing - campaign wave content task priority
    1=High Priority
    2=Medium Priority
    3=Low Priority
    18 SCRIPT_ID Number(12,0) DECIMAL(12) NOT NULL Script ID
    19 RAD_ADVISOR_ID Character(20) VARCHAR2(20) NOT NULL Advisor Dialog Guid - represents internally the Advisor dialog
    20 SCRIPT_NAME Character(40) VARCHAR2(40) NOT NULL Branch Scripting Name Field
    21 RAD_ADVISOR_NAME Character(30) VARCHAR2(30) NOT NULL Advisor Dialog name - obtained from the RAD_ADVISOR header
    22 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    23 DESCRLONG Long Character CLOB Long Description