PTPN_MSG_VW

(SQL View)

SELECT PTPN_CATEGORY_NAME ,PTPN_CATEGORY_TYPE ,PTPN_CATEGORY_CNT ,PTPN_CAT_DATA_KEY ,PTPN_DATA_MSG_INFO ,PTPN_ONCLICK_LINK ,PTPN_MSG_STATE ,PTPN_ACTIONS_LABEL ,PTPN_ACTIONS_LINK ,LASTUPDDTTM ,ROLENAME ,OPRID ,INSTANCEID ,PTPN_PRIORITY FROM PSPTPN_MSG_TBL WHERE PTPN_MSG_STATE NOT IN ( 'Dismiss','Completed')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PTPN_CATEGORY_TYPE Character(10) VARCHAR2(10) NOT NULL Category Type

3 PTPN_CATEGORY_CNT Character(20) VARCHAR2(20) NOT NULL Category Count

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

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

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

7 PTPN_MSG_STATE Character(10) VARCHAR2(10) NOT NULL Message State

8 PTPN_ACTIONS_LABEL Character(200) VARCHAR2(200) NOT NULL Actions Label

9 PTPN_ACTIONS_LINK Long Character CLOB Message Actions

10 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.

11 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

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

13 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST

14 PTPN_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
0=Default
1=High
2=Medium
3=Low
Default Value: 0

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