WL_TEMPLATE_VAR

(SQL Table)
Index Back

Template variables

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

Prompt Table: WL_PNLGROUP_VW

2 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Default Value: GBL

3 WL_TEMPL_CHANGE Character(1) VARCHAR2(1) NOT NULL Indicator to allow user to change the notification template.
N=No
Y=Yes

Default Value: N

4 WL_SAVE_NOTIFY Character(1) VARCHAR2(1) NOT NULL Allow the notification to be saved in the database.
N=No
Y=Yes

Default Value: N

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