WCS_LK_TPMPT_VW

(SQL View)
 Index Back

Prompt View for Config Matrix

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

SELECT RECNAME , RECDESCR FROM PSRECDEFN WHERE RECTYPE=0 AND RECNAME NOT IN ( SELECT RECNAME FROM PSRECFIELD WHERE FIELDNAME='EMPLID') AND RECNAME NOT IN ( SELECT RELLANGRECNAME FROM PSRECDEFN) AND %TrimSubstr(RECNAME,1,15) LIKE '%TBL'

  • Related Language Record: WCS_LK_TPMPTLNG

    • # 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 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description