index back

PeopleSoft Field Name Field Type Column Type Description
PTPN_CATEGORY_NAME Character(50) VARCHAR2(50) NOT NULL Notification Name
PTPN_EVENTNAME Character(30) VARCHAR2(30) NOT NULL Event Name
PTPN_NODENAME Character(30) VARCHAR2(30) NOT NULL Node Name
PTPN_CAT_ALIAS Character(50) VARCHAR2(50) NOT NULL Category Alias
PTPN_CATEGORY_TYPE Character(10) VARCHAR2(10) NOT NULL Category Type
PTPN_CATEGORY_CNT Character(10) VARCHAR2(10) NOT NULL Category Count
PTPN_CAT_DATA_KEY Character(100) VARCHAR2(100) NOT NULL Data Key
PTPN_DATA_MSG_INFO Character(250) VARCHAR2(250) NOT NULL Message Info
PTPN_ONCLICK_LINK Long Character(512) VARCHAR2(512) Onclick
PTPN_MSG_STATE Character(10) VARCHAR2(10) NOT NULL Message State
PTPN_ACTIONS_LABEL Character(200) VARCHAR2(200) NOT NULL Actions Label
PTPN_ACTIONS_LINK Long Character CLOB Message Actions
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.
ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
PTPN_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
index back (c)David Kurtz 2020, PeopleTools 8.58
PTRef generated on 21-DEC-20