RA_CAMPAIGN_IDRA_CMPGN_RPT_VW(SQL View) |
Index Back |
|---|---|
Campaign View for Report |
| SELECT RA_CAMPAIGN_ID , RA_CMPGN_NAME FROM PS_RA_CAMPAIGN GROUP BY RA_CAMPAIGN_ID ,RA_CMPGN_NAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | RA_CMPGN_NAME | Character(50) | VARCHAR2(50) NOT NULL | Campaign Name - field containing the name of the campaign. |