WL_TEMPL_GEN_RS

(SQL Table)
 Index Back

Generic Template Responses

Used for RIM pager responses for generic templates used in notifications.

  • Related Language Record: WL_TEMPL_GNRSLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 WL_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Template Name
    2 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    3 WL_FWD_TOSENDER Character(1) VARCHAR2(1) NOT NULL Forward notification to sender indicator.
    N=No
    Y=Yes
    4 WL_FWD_WORKLIST Character(1) VARCHAR2(1) NOT NULL Forward to Sender indicator
    N=No
    Y=Yes
    5 WL_RESPONSE Character(30) VARCHAR2(30) NOT NULL Response Name
    6 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

    Prompt Table: WL_AEAPP_LIB_VW

    7 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

    Prompt Table: PSAESECTDEFN

    8 WL_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    9 WL_ADDED_DTTM DateTime(26) TIMESTAMP Date/Time Created
    10 WL_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By
    11 WL_LASTMANT_DTTM DateTime(26) TIMESTAMP Date Modified