PROCESS_INSTANCEPrompt Table: SP_SETID_NONVW
Prompt Table: RA_LIST
01=Scheduled
02=Processing
03=Success
04=Error
05=Deleted
N=No
Y=Yes
Default Value: Y
RA_LIST_SCHED(SQL Table) |
Index Back |
|---|---|
Audience Generation run cntrlRun control record for Audience Generation |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | 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 |
| 3 | RA_LIST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Audience ID
Prompt Table: RA_LIST |
| 4 | LIST_GEN_RUN_STAT | Character(2) | VARCHAR2(2) NOT NULL |
Audience - Generation Status
01=Scheduled 02=Processing 03=Success 04=Error 05=Deleted |
| 5 | NUM_TEST_AUDIENCES | Number(3,0) | SMALLINT NOT NULL | Enter Number of Test Audiences |
| 6 | RA_LIST_STAT_FAIL | Character(4) | VARCHAR2(4) NOT NULL | Audience status upon generation process failure |
| 7 | RA_LIST_STAT_SUCC | Character(4) | VARCHAR2(4) NOT NULL | Audience status upon generation process success |
| 8 | LIST_USER_SCHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag indicating if Audience Generation process was scheduled by a user of the RA_LIST component
N=No Y=Yes Default Value: Y |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | RAE_EVENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id. |
| 11 | MESSAGE_ID | Character(30) | VARCHAR2(30) NOT NULL | Message ID |
| 12 | REPLY_TO_ADDRESS | Character(254) | VARCHAR2(254) NOT NULL | Email Address associated with the Reply To Person |