RA_CASE_CRT_STA

(SQL Table)
Index Back

Create Case Status

Create Case Status for Bulk Case Creation from Marketing.

# 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 ROWS_PROCESSED Number(8,0) INTEGER NOT NULL Number of rows processed
4 ROWS_IN_ERROR Number(8,0) INTEGER NOT NULL Number of rows in error
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 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.
7 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
8 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.
9 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID