RA_LIST_SUM_VW

(SQL View)
 Index Back

Audience Summary View

Audience summary, configurable search record

SELECT A.SETID , A.RA_LIST_ID , A.RA_LIST_NAME , A.RA_LIST_STATUS , A.RA_LIST_SOURCE , A.LIST_CURR_COUNT , A.LIST_LAST_UPD_DTTM , A.LIST_GENERATE_DTTM , A.RA_STAT_DYN_IND , A.RA_INT_EXT_IND , A.DESCR254 , A.BO_ID_OWNER , A.BO_ROLE_TYPE_ID , CASE WHEN B.BO_NAME IS NULL THEN ' ' ELSE B.BO_NAME END , CASE WHEN B.BO_NAME_DISPLAY IS NULL THEN ' ' ELSE B.BO_NAME_DISPLAY END , A.SYNCID , A.RA_PARENT_LIST_ID , CASE WHEN P.RA_LIST_NAME IS NULL THEN ' ' ELSE P.RA_LIST_NAME END , A.RA_SEGMENT_GRP_ID , ' ' , D.OPRID FROM PS_RA_LIST A LEFT OUTER JOIN PS_BO_NAME_PRIM_VW B ON (B.BO_ID = A.BO_ID_OWNER) LEFT OUTER JOIN PS_RA_LIST P ON (P.SETID = A.SETID AND P.RA_LIST_ID = A.RA_PARENT_LIST_ID) ,PS_RA_LST_SCRTY_VW D WHERE A.SETID = D.SETID AND A.RA_LIST_ID = D.RA_LIST_ID AND A.RA_LIST_SOURCE IN ( SELECT RA_LIST_SOURCE FROM PS_RA_LIST_SRC_VW)

  • Parent record: RA_LIST

    • # 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.

    Prompt Table: SP_SETID_NONVW

    2 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID
    3 RA_LIST_NAME Character(30) VARCHAR2(30) NOT NULL Audience / List Name
    4 RA_LIST_STATUS Character(4) VARCHAR2(4) NOT NULL Audience / List Status
    010=In Design
    020=Designed
    030=Scheduled
    040=Processing
    050=Generated
    060=Approved
    070=Committed
    080=Archived
    5 RA_LIST_SOURCE Character(4) VARCHAR2(4) NOT NULL Audience / List Source
    CGRP=Control Group
    COMP=Combine Audiences
    CRIT=Audience Builder
    EXT=External Audience
    IMP=Import
    QRY=PS Query
    SEG=Segment
    SRCH=Saved Search
    TEST=Test Audience

    Prompt Table: RA_LIST_SRC_VW

    6 LIST_CURR_COUNT Number(18,0) DECIMAL(18) NOT NULL Audience current count
    7 LIST_LAST_UPD_DTTM DateTime(26) TIMESTAMP Audience - Last Updated Date Time
    8 LIST_GENERATE_DTTM DateTime(26) TIMESTAMP Audience - date last generated
    9 RA_STAT_DYN_IND Character(1) VARCHAR2(1) NOT NULL Fixed/Dynamic Audience indicator
    D=Dynamic Audience
    S=Fixed Audience
    10 RA_INT_EXT_IND Character(1) VARCHAR2(1) NOT NULL Internal/External Audience indicator
    E=External Audience
    I=Internal Audience
    11 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    12 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID
    13 BO_ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL BO_ROLE_TYPE_ID
    14 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    15 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
    16 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.
    17 RA_PARENT_LIST_ID Character(15) VARCHAR2(15) NOT NULL Marketing Audience parent id field. Parent ID is used to tie the segment to a parent segment.
    18 RA_LIST_PARENT_NAM Character(30) VARCHAR2(30) NOT NULL Parent Segment Name
    19 RA_SEGMENT_GRP_ID Character(15) VARCHAR2(15) NOT NULL Marketing Segment Group Key ID field
    20 RA_SEGMENT_GROUP Character(30) VARCHAR2(30) NOT NULL Marketing Segment Group name field.
    21 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).