RA_CSTA_SRCH_VW

(SQL View)
 Index Back

Case Create Status Search View

Case Create Status Search View for Bulk Case Creation from Marketing.

SELECT A.PROCESS_INSTANCE , A.RUNDATE ,A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.RAE_EVENT_ID , A.RA_LIST_ID , B.OPRID , B.RUNCNTLID FROM PS_RA_CASE_CRT_STA A , PSPRCSRQST B WHERE A.PROCESS_INSTANCE = B.PRCSINSTANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUNDATE Date(10) DATE Process Scheduler Run Date
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RA_NONVW

4 RA_CAMPAIGN_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.

Prompt Table: RA_EXEC_CMPG_VW

5 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID

Prompt Table: RA_ACTEXELST_VW

6 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.

Prompt Table: RAE_EVENT

7 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID

Prompt Table: RA_LIST

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID