SETIDRY_LIST_ID010=In Design
020=Designed
030=Scheduled
040=Processing
050=Generated
060=Approved
070=Committed
080=Archived
E=External Audience
I=Internal Audience
RY_AUD_SEL_VW2(SQL View) |
Index Back |
|---|---|
Dialog Audience Prompt ViewDialog Audience selection view for the audience selection. for all the status except archived) |
| SELECT DISTINCT A.SETID , C.RY_LIST_ID , A.RA_LIST_NAME , A.RA_LIST_ID , A.RA_LIST_STATUS , A.LIST_CURR_COUNT , A.DESCR254 , A.RA_INT_EXT_IND FROM PS_RA_LIST A , PS_RY_OPTIONS B , PS_RY_AUDIENCE C WHERE A.RA_LIST_STATUS <> '080' AND (A.RA_STAT_DYN_IND='D' OR A.RA_STAT_DYN_IND='S') AND A.RA_LIST_ID=C.RA_LIST_ID AND A.SETID = C.SETID AND C.RY_STAG_DIALOG_ID = 0 |
| # | 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 | RY_LIST_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Audience ID for Dialogs, used in the dialog designer. |
| 3 | RA_LIST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Audience / List Name |
| 4 | RA_LIST_ID | Character(15) | VARCHAR2(15) NOT NULL | Audience ID |
| 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 | LIST_CURR_COUNT | Number(18,0) | DECIMAL(18) NOT NULL | Audience current count |
| 7 | RY_LIST_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Audience Description for Dialogs. |
| 8 | RA_INT_EXT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Internal/External Audience indicator
E=External Audience I=Internal Audience |