RPM_RA_SRCH_VW

(SQL View)
 Index Back

Use for Portfolio Filter page

This record is to limit data display on the dashboard

SELECT D.SETID , D.RA_LIST_ID , A.START_DATE , A.BO_ID , A.ROLE_TYPE_ID , C.DESCR , B.BO_NAME , B.FIRST_NAME , B.LAST_NAME , E.RA_SEGMENT_GRP_ID , E.LEAF_FLAG , F.PERSON_ID_MBR FROM PS_RPM_RA_LIST_REC A , PS_BO_NAME B , PS_BO_ROLE_TYPE C , PS_RPM_RA_LIST_MAP D , PS_RPM_RA_LIST E , PS_RPM_ALL_MBR_VW F WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y' AND A.ROLE_TYPE_ID = C.ROLE_TYPE_ID AND A.RA_LIST_ID = D.RA_LEAF_LIST_ID AND A.SETID = D.SETID AND A.START_DATE = D.START_DATE AND D.SETID = E.SETID AND D.RA_LIST_ID = E.RA_LIST_ID AND D.START_DATE = E.START_DATE AND E.SETID = F.SETID AND E.RA_LIST_ID = F.RA_LIST_ID

  • Related Language Record: RPM_RA_SRCH_LNG

    • # 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.
    2 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID
    3 START_DATE Date(10) DATE Start Date for Gen Standing PO
    4 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    5 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

    Prompt Table: BO_ROLE_TYPE

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    10 RA_SEGMENT_GRP_ID Character(15) VARCHAR2(15) NOT NULL Marketing Segment Group Key ID field
    11 LEAF_FLAG Character(1) VARCHAR2(1) NOT NULL Leaf Flag
    12 PERSON_ID_MBR Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts