RY_DLG_AUD_VW

(SQL View)
 Index Back

Dialog Audiences

Audiences associated to a Dialog

SELECT DLG.DIALOG_ID , LST.SETID , LST.RA_LIST_ID , LST.RA_LIST_NAME , LST.RA_LIST_STATUS , LST.RA_LIST_SOURCE , LST.RA_INT_EXT_IND , LST.RA_STAT_DYN_IND , LST.LIST_CURR_COUNT , LST.DESCR254 , LST.ROW_ADDED_OPRID FROM PS_RY_DIALOG DLG , PS_RY_TASK_LIST TSK , PS_RY_ACT_TASK ACT , PS_RY_AUDIENCE AUD , PS_RA_LIST LST WHERE ACT.DIALOG_ID = DLG.DIALOG_ID AND TSK.RY_ACTION_ID = ACT.RY_ACTION_ID AND AUD.RY_LIST_ID = TSK.RY_LIST_ID AND LST.SETID = AUD.SETID AND LST.RA_LIST_ID = AUD.RA_LIST_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
3 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID
4 RA_LIST_NAME Character(30) VARCHAR2(30) NOT NULL Audience / List Name
5 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
6 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

7 RA_INT_EXT_IND Character(1) VARCHAR2(1) NOT NULL Internal/External Audience indicator
E=External Audience
I=Internal Audience
8 RA_STAT_DYN_IND Character(1) VARCHAR2(1) NOT NULL Fixed/Dynamic Audience indicator
D=Dynamic Audience
S=Fixed Audience
9 LIST_CURR_COUNT Number(18,0) DECIMAL(18) NOT NULL Audience current count
10 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
11 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.