RA_PRFOPERO_LVW

(SQL View)
Index Back

Selection criteria operators

Related language view. List of valid operators when building selection criteria for marketing center. Use this view when connector is blank or connector is equal to OR.

SELECT FIELDVALUE , LANGUAGE_CD , XLATLONGNAME FROM PSXLATITEMLANG WHERE FIELDNAME = 'RA_PRF_ATTRIB_OPER' AND FIELDVALUE IN ('0015','0018','0019','0020','0021','0022','0023','0024')

  • Related Language Record for RA_PRFOPERO_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RA_PRF_ATTRIB_OPER Character(4) VARCHAR2(4) NOT NULL This field stores the operator for use in audience builder and manage profile changes.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50