WL_TEMPL_CMPVAR

(SQL Table)
 Index Back

Component template Vars

Used to define substitution variables for component templates.

  • Related Language Record: WL_TEMPL_CMP_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 WL_OCCURS Character(1) VARCHAR2(1) NOT NULL Occurs Level
    0=Level 0
    1=Level 1
    6 WL_TOKENID Character(10) VARCHAR2(10) NOT NULL Value
    7 WL_RECNAMEPRIMARY Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

    Prompt Table: WL_RECORD_VW

    8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: WL_RECORD2_VW

    9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: WL_RECFIELD_VW

    10 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

    Prompt Table: WL_FLDLABEL_VW

    11 WL_DISPLAY_TYPE Character(1) VARCHAR2(1) NOT NULL Different ways to display a field value
    1=Formatted Value
    2=Field Name
    4=Value
    12 WL_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    13 WL_ADDED_DTTM DateTime(26) TIMESTAMP Date/Time Created
    14 WL_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By
    15 WL_LASTMANT_DTTM DateTime(26) TIMESTAMP Date Modified