RA_PGM_STATLVW (SQL View)	Index Back
marketing program status value marketing program status values

RA_PGM_STATLVW

(SQL View)

marketing program status value

marketing program status values

SELECT DISTINCT A.RA_PROGRAM_TYPE , A.RA_PROGRAM_STATUS ,B.LANGUAGE_CD , B.DESCR50 FROM PS_RA_PROGRAM_TBL A , PS_RA_PGM_STATLVW2 B WHERE A.RA_PROGRAM_STATUS = B.RA_PROGRAM_STATUS

Related Language Record for RA_PGM_STAT_VW

# 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 RA_PROGRAM_STATUS Character(4) VARCHAR2(4) NOT NULL Program Status - this is used by Marketing

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 STATUS_DESCR Character(50) VARCHAR2(50) NOT NULL Field used to show the status description. Field used as edit box.

#	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	RA_PROGRAM_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Program Status - this is used by Marketing
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	STATUS_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Field used to show the status description. Field used as edit box.