| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 AUDIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The OPRID of the user who made the changes audited on an audit record.
|
| 2 |
AUDIT_STAMP |
DateTime(26) |
TIMESTAMP |
Date and Time Stamp
|
| 3 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|
| 4 |
AUDIT_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Name of the record definition audited.
AUDIT_RECNAME is used in User-Defined Audit Record Definitions.
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT
Prompt Table:
SP_BU_RA_NONVW
|
| 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 |
RA_TRIGGER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Trigger ID
|
| 9 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 10 |
NOTE_SEQ_NBR |
Number(6,0) |
INTEGER NOT NULL |
Note ID
|
| 11 |
RA_CMPGN_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Campaign Name - field containing the name of the campaign.
|
| 12 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 13 |
RA_OBJECTIVE |
Character(50) |
VARCHAR2(50) NOT NULL |
Objective / Initiative free form entry field
|
| 14 |
RA_ROLLUP_CMPGN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Campaign - Roll Up (Parent) Campaign Identification
Prompt Table:
RA_PGM_ROLUP_VW
|
| 15 |
RA_CMPGN_STATUS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Valid Campaign and Wave Status Codes
APPR=Approved
ARCH=Archived
CMPL=Completed
DCLN=Declined
EXEC=Executing
IREV=In Review
NEW=New
STOP=Stop
TRIG=Trigger Approved
Prompt Table:
RA_UD_CPGN_STAT
|
| 16 |
START_DATE |
Date(10) |
DATE |
Campaign Start Date
|
| 17 |
END_DATE |
Date(10) |
DATE |
End date field to store an end date.
|
| 18 |
INDUSTRY_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Industry ID.
Prompt Table:
RSF_INDUSTRY_VW
|
| 19 |
RA_OBJECTIVE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Objective code of the campaign
Prompt Table:
RA_UD_CMPGN_OBJ
|
| 20 |
RA_WAVE_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry.
|
| 21 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 22 |
RA_LEAD_ACCEPT_DT |
Date(10) |
DATE |
Date used for final date in which leads can be attached to a marketing activity
|
| 23 |
RA_PRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Marketing - campaign wave content task priority
1=High Priority
2=Medium Priority
3=Low Priority
|
| 24 |
RA_ACTIVITY_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Campaign - Activity Code. Code is used for initial selection of channels.
|
| 25 |
RA_CHANNEL_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Marketing Channel Types
|
| 26 |
RA_CHANNEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Marketing Channels
|
| 27 |
RA_INTEGRATE_MTHD |
Character(4) |
VARCHAR2(4) NOT NULL |
Telemarketing Integration method, will be used in Telemarketing application to integrate with another PeopleSoft application to generate Leads or Orders
NA=Not Applicable
OCD=Order Capture Direct
OCI=Order Capture Indirect
SALE=Sales Leads
|
| 28 |
RA_BUDGET_AMT |
Number(18,2) |
DECIMAL(17,2) NOT NULL |
Campaign Budget Amount
|
| 29 |
RA_EXPENSE_AMT |
Number(18,2) |
DECIMAL(17,2) NOT NULL |
Marketing - Campaign Wave Expense Amount
|
| 30 |
RA_PROMOTION_CODE |
Character(35) |
VARCHAR2(35) NOT NULL |
Marketing - campaign wave promotion code
|
| 31 |
RA_OFFER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Marketing Offer ID
|
| 32 |
RA_CONTENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Marketing - Content ID
|
| 33 |
RA_LIST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Audience ID
|
| 34 |
RAD_ADVISOR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Advisor Dialog Guid - represents internally the Advisor dialog
|
| 35 |
RA_SCRIPT_ID_OTBN |
Number(12,0) |
DECIMAL(12) NOT NULL |
Outbound Script ID - Numeric
|
| 36 |
RA_TRIGGER_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Trigger Name
|
| 37 |
RA_TASK_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Status of the task
ASGN=Assigned
CANC=Cancelled
CMPL=Completed
NEW=New task - not assigned
OVER=Over Due
REJD=Rejected
|
| 38 |
DUE_DATE |
Date(10) |
DATE |
Delivery Due Date from PO
|
| 39 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 40 |
RA_PCT_COMPLETE |
Character(3) |
VARCHAR2(3) NOT NULL |
Marketing - Task - Percent Complete
|
| 41 |
RA_UNIT_COST |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Marketing - Unit Cost
|
| 42 |
RA_FORECAST_AMT |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Marketing - Costs Amounts
|
| 43 |
RA_ACTUAL_AMT |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Campaign Actual Cost / Value
|
| 44 |
RA_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Used for triggereing RA Capmaign Workflow
CMPG=Campaign
CONT=Collateral
EVNT=Event
LIST=List
OFFR=Offer
TSK1=Campaign Task
TSK2=Collateral Task
WAVE=Campaign Activity
|
| 45 |
RA_NOTE_SUMMARY |
Character(80) |
VARCHAR2(80) NOT NULL |
Note summary field
|
| 46 |
RA_DESCRLONG |
Long Character |
CLOB |
Long description field used in some marketing records
|