RSF_CRIT_RECLNG

(SQL View)
 Index Back

Component Records - Primary

Component Records - Primary

SELECT DISTINCT B.RECNAME , D.LANGUAGE_CD , D.RECDESCR FROM PSPNLFIELD B , PSRECDEFN C , PSRECDEFNLANG D WHERE B.RECNAME <> ' ' AND B.FIELDNAME <> ' ' AND B.RECNAME = C.RECNAME AND C.RECTYPE IN (0,1) AND D.RECNAME = C.RECNAME

  • Related Language Record for RSF_CRIT_REC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRITERIA_RECORD Character(18) VARCHAR2(18) NOT NULL Criteria Record for Configurable Assignment
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description