PTPN_TBE_CFG_2(SQL Table) |
Index Back |
|---|---|
TBE Configuration Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTPN_CATEGORY_NAME |
Character(50) | VARCHAR2(50) NOT NULL |
Notification Name
Prompt Table: PSPTPN_CAT_TBL |
| 2 | OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 3 | PTPN_BUSPROCNAME |
Character(30) | VARCHAR2(30) NOT NULL | Business Process Name |
| 4 | PTPN_ACTIVITYNAME |
Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity |
| 5 | PTPN_EVENTNAME1 |
Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 6 | PTPN_WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 7 | PTPN_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Priority
0=Default 1=High 2=Medium 3=Low Default Value: 0 |
| 8 | PTPN_ENABLE | Character(1) | VARCHAR2(1) NOT NULL |
Enable Disable
Y/N Table Edit Default Value: N |
| 9 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 10 | MESSAGE_NBR01 | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 11 | MESSAGE_NBR02 | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 12 | MESSAGE_NBR03 | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 13 | PTPN_NOTIF_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Notification Name
Prompt Table: PTPN_TBENOT_VW |
| 14 | PTPN_GROUPTBE | Character(30) | VARCHAR2(30) NOT NULL | Group Name |
| 15 | PTPN_NOTTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Notification Type
A=Actionable I=Alert Default Value: I |
| 16 | PTPN_EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Event Name |