RA_PROGRAM_CNTL

(SQL Table)
 Index Back

Marketing Program Control

This table controls the transfer to component location for the various program types

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RA_PROGRAM_TYPE Character(4) VARCHAR2(4) NOT NULL Marketing Program type - field that contains valid program types used in marketing, such as Campaigns, Roll ups, Dialogs and Trade Promotions
CMP=Campaign
DLG=Dialog
EVT=Event
RLU=Roll up
2 MENUNAME_TRN Character(30) VARCHAR2(30) NOT NULL Menu Name

Prompt Table: RB_MENUDEFN_VW

3 BARNAME_TRN Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

Prompt Table: RB_MENUBAR_VW

4 ITEMNAME_TRN Character(60) VARCHAR2(60) NOT NULL Menu/Bar/Item

Prompt Table: RB_MENUITEM_VW

5 COMPONENT_TRN Character(18) VARCHAR2(18) NOT NULL Trasaction Component
6 PAGE_TRN Character(30) VARCHAR2(30) NOT NULL Transfer Page

Prompt Table: RB_PNLGROUP_VW

7 TRANSFER_MODE Character(1) VARCHAR2(1) NOT NULL Transfer Mode
A=Add
C=Correction
E=Data Entry
L=Update/Display All
U=Update/Display
8 MARKET Character(3) VARCHAR2(3) NOT NULL Market
9 RA_PROGM_CONTNAME Character(30) VARCHAR2(30) NOT NULL Marketing - Activity Content Name (ICON)

Prompt Table: RC_TB_IMAGE_VW

10 RA_ACTVTY_CONTNAME Character(30) VARCHAR2(30) NOT NULL Marketing - Activity Content Name (ICON)

Prompt Table: RC_TB_IMAGE_VW