RBW_POI_VW

(SQL View)
 Index Back

Product of Interest View

Product of Interest table joined with the Product Descriptions from Product table

SELECT A.POI_ID , A.BO_ID , A.SETID , A.POI_INT_TYPE , A.PRODUCT_ID , A.STOCK_SYMBOL , A.POI_PROD_DESCR , A.POI_INT_LEVEL , A.POI_AMOUNT , A.CURRENCY_CD , A.STATUS_CODE_POI , A.ACTIVE_FLG , B.DESCR , A.ROW_ADDED_DTTM , A.SYNCID , A.DESCRLONG FROM PS_RBW_POI A , PS_PROD_ITEM B WHERE A.SETID = B.SETID (+) AND A.PRODUCT_ID = B.PRODUCT_ID (+)

  • Related Language Record: RBW_POI_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POI_ID Number(15,0) DECIMAL(15) NOT NULL The unique ID for the product of interest

    Default Value: 999999999999

    2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    3 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

    4 POI_INT_TYPE Character(4) VARCHAR2(4) NOT NULL Type of Interest expressed by a client
    EQTS=Equities
    PROM=Product Outside Management
    PRUM=Product Under Management
    5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    6 STOCK_SYMBOL Character(10) VARCHAR2(10) NOT NULL This field is used to store the Stock Symbol

    Prompt Table: RBF_STOCK_TBL

    7 POI_PROD_DESCR Character(254) VARCHAR2(254) NOT NULL Description of product of interest expressed by a client
    8 POI_INT_LEVEL Character(4) VARCHAR2(4) NOT NULL Client's level of interest in a product
    HIGH=1 - High
    LOW=3 - Low
    MED=2 - Medium
    9 POI_AMOUNT Number(29,4) DECIMAL(28,4) NOT NULL Amount of the Product of Interest
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    11 STATUS_CODE_POI Character(4) VARCHAR2(4) NOT NULL The status of the client's product of interest

    Prompt Table: RBW_POI_STS_TBL

    12 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Active
    N=Inactive
    Y=Active

    Y/N Table Edit

    Default Value: Y

    13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    14 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    15 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.
    16 DESCRLONG Long Character CLOB Long Description