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

RA_MCORWITH_LVW

(SQL View)

Marketing Program Status

All Marketing Program Statuses

SELECT FIELDVALUE , LANGUAGE_CD , XLATSHORTNAME FROM PSXLATITEMLANG WHERE FIELDNAME = 'RA_AND_OR_WITH' AND xlatshortname IN ('OR','WITH')

Related Language Record for RA_MCORWITH_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RA_AND_OR_WITH Character(4) VARCHAR2(4) NOT NULL Marketing Center Selection Criteria an/or/with value
AND=And
OR=Or
WITH=With

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RA_AND_OR_WITH	Character(4)	VARCHAR2(4) NOT NULL	Marketing Center Selection Criteria an/or/with value AND=And OR=Or WITH=With
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50