LM_NOTIF_TMPL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Template Name
2	LM_DATA_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Data Source Code C=Custom D=Delivered Default Value: C
3	LM_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description
4	LM_NOTIF_STTS	Character(1)	VARCHAR2(1) NOT NULL	Notification Status Flag A=Active I=Inactive Default Value: A
5	LM_NOTIF_CAT_ID	Character(15)	VARCHAR2(15) NOT NULL	Notification Event Category ID Prompt Table: LM_NOTIF_CAT
6	LM_NOTIF_PRI	Character(1)	VARCHAR2(1) NOT NULL	Notification Priority 1=High 2=Medium 3=Low
7	LM_SENDER	Character(1)	VARCHAR2(1) NOT NULL	Notification Sender 1=User 2=System 3=Other 4=System-Blackberry Default Value: 1
8	LM_EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address
9	LM_SUBJECT	Character(254)	VARCHAR2(254) NOT NULL	Message Subject
10	LM_INSTRUCTIONS	Character(250)	VARCHAR2(250) NOT NULL	Instructions
11	LM_HTML_FLG	Character(1)	VARCHAR2(1) NOT NULL	HTML Flag Y/N Table Edit Default Value: N
12	LM_ATTACH_ACT	Character(1)	VARCHAR2(1) NOT NULL	Attach Activity Flag Y/N Table Edit Default Value: N
13	LM_ATTACH_PROG	Character(1)	VARCHAR2(1) NOT NULL	Attach Program Flag Y/N Table Edit Default Value: N
14	LM_ATTACH_FAC	Character(1)	VARCHAR2(1) NOT NULL	Attach Facility Flag Y/N Table Edit Default Value: N
15	LM_ATTACH_EQUIP	Character(1)	VARCHAR2(1) NOT NULL	Attach Equipment Flag Y/N Table Edit Default Value: N
16	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
17	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
18	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
19	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid
20	LM_MSG_TXT	Long Character	CLOB	Message Text