WL_TEMPL_URLVAR

(SQL Table)
 Index Back

Define URL variables

Used to define URL variables for the component notification templates.

  • Related Language Record: WL_TEMPL_URL_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: PSPNLGRPDEFN

    2 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    4 WL_TOKENID Character(10) VARCHAR2(10) NOT NULL Value
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

    Prompt Table: PSPRDMDEFN

    7 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

    Prompt Table: PSMSGNODEDEFN

    8 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    9 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    10 WL_PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: WL_PNLGRP_VW

    11 WL_MARKET Character(3) VARCHAR2(3) NOT NULL Market

    Default Value: GBL

    Prompt Table: WL_MARKET_VW

    12 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

    Prompt Table: WL_PNLNAME_VW

    13 WL_URL_TEXT Character(254) VARCHAR2(254) NOT NULL URL Text
    14 WL_ACTIONS Character(1) VARCHAR2(1) NOT NULL Component Actions
    A=Add
    C=Correction
    L=Update/Display All
    U=Update/Display
    15 WL_CURR_PORT_FLG Character(1) VARCHAR2(1) NOT NULL Use current portal
    N=No
    Y=Yes

    Default Value: Y

    16 WL_CURR_NODE_FLG Character(1) VARCHAR2(1) NOT NULL Use current node
    N=No
    Y=Yes

    Default Value: Y

    17 WL_CURR_PAGE_FLG Character(1) VARCHAR2(1) NOT NULL Use current page
    N=No
    Y=Yes

    Default Value: Y

    18 WL_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    19 WL_ADDED_DTTM DateTime(26) TIMESTAMP Date/Time Created
    20 WL_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By
    21 WL_LASTMANT_DTTM DateTime(26) TIMESTAMP Date Modified