PSPTPN_ARCHIVE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTPN_CATEGORY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Notification Name
2	PTPN_EVENTNAME	Character(30)	VARCHAR2(30) NOT NULL	Event Name
3	PTPN_NODENAME	Character(30)	VARCHAR2(30) NOT NULL	Node Name
4	PTPN_CAT_ALIAS	Character(50)	VARCHAR2(50) NOT NULL	Category Alias
5	PTPN_CATEGORY_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Category Type
6	PTPN_CATEGORY_CNT	Character(20)	VARCHAR2(20) NOT NULL	Category Count
7	PTPN_CAT_DATA_KEY	Character(100)	VARCHAR2(100) NOT NULL	Data Key
8	PTPN_DATA_MSG_INFO	Character(250)	VARCHAR2(250) NOT NULL	Message Info
9	PTPN_ONCLICK_LINK	Long Character(512)	VARCHAR2(512)	Onclick
10	PTPN_MSG_STATE	Character(10)	VARCHAR2(10) NOT NULL	Message State
11	PTPN_ACTIONS_LABEL	Character(200)	VARCHAR2(200) NOT NULL	Actions Label
12	PTPN_ACTIONS_LINK	Long Character	CLOB	Message Actions
13	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.
14	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
15	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
16	INSTANCEID	Number(10,0)	DECIMAL(10) NOT NULL	For a given worklist the unique number of rows in PSWORKLIST
17	PTPN_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 0=Default 1=High 2=Medium 3=Low