RA_PGM_STAT_VW2 (SQL View)	Index Back
Marketing Program Status All Marketing Program Statuses

RA_PGM_STAT_VW2

(SQL View)

Marketing Program Status

All Marketing Program Statuses

SELECT FIELDVALUE , XLATSHORTNAME FROM PSXLATITEM WHERE FIELDNAME IN ('RA_CMPGN_STATUS_CD', 'RY_STATUS_TRN')

Related Language Record: RA_PGM_STATLVW2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RA_PROGRAM_STATUS Character(4) VARCHAR2(4) NOT NULL Program Status - this is used by Marketing

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RA_PROGRAM_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Program Status - this is used by Marketing
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50