PTPN_CATEGORY_NAMEPTPN_CAT_DATA_KEYOPRID0=Default
1=High
2=Medium
3=Low
PSPTPN_ARCHIVE |
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
0=Default 1=High 2=Medium 3=Low |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |