WCS_LK_TPMPTLNG

(SQL View)
 Index Back

Prompt Vw for Cfg Matrix- Lang

This serves as a related language prompt view for selecting a Prompt Table for a Configurable Matrix Input (search keys).

SELECT L.RECNAME , L.LANGUAGE_CD , L.RECDESCR FROM PSRECDEFN R , PSRECDEFNLANG L WHERE R.RECTYPE=0 AND R.RECNAME NOT IN ( SELECT RECNAME FROM PSRECFIELD WHERE FIELDNAME='EMPLID') AND R.RECNAME NOT IN ( SELECT RELLANGRECNAME FROM PSRECDEFN) AND R.RECNAME LIKE '%TBL' AND L.RECNAME=R.RECNAME

  • Related Language Record for WCS_LK_TPMPT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROMPT_TABLE Character(15) VARCHAR2(15) NOT NULL Record Name

    Prompt Table: WCS_LK_TPMPT_VW

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description