EOAW_MSG_TMP2

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTPN_CATEGORY_NAME Character(50) VARCHAR2(50) NOT NULL Notification Name

2 PTPN_CAT_DATA_KEY Character(100) VARCHAR2(100) NOT NULL Data Key

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 PTPN_DATA_MSG_INFO Character(250) VARCHAR2(250) NOT NULL Message Info

5 PTPN_ONCLICK_LINK Long Character(512) VARCHAR2(512) Onclick

6 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTPN_CATEGORY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Notification Name
2	PTPN_CAT_DATA_KEY	Character(100)	VARCHAR2(100) NOT NULL	Data Key
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	PTPN_DATA_MSG_INFO	Character(250)	VARCHAR2(250) NOT NULL	Message Info
5	PTPN_ONCLICK_LINK	Long Character(512)	VARCHAR2(512)	Onclick
6	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.