# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_RA_NONVW
|
2 |
RA_ROLLUP_CMPGN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Campaign - Roll Up (Parent) Campaign Identification
|
3 |
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.
|
4 |
RA_CMPGN_WAVE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Used to uniquely identify a Marketing - Campaign Activity (wave) ID
|
5 |
RA_FORECAST_AMT |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Marketing - Costs Amounts
|
6 |
RA_ACTUAL_AMT |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Campaign Actual Cost / Value
|