PTPN_CATEGORY_NAMEPrompt Table: PSPTPN_CAT_TBL
OBJECTOWNERIDPTPN_BUSPROCNAMEPTPN_ACTIVITYNAMEPTPN_EVENTNAME1PTPN_WORKLISTNAMEY/N Table Edit
Default Value: N
FSCM_TBEPN_STG(SQL Table) |
Index Back |
|---|---|
TBE PN Message Reference tableReference table maintaining the TBE mapping to Push Notification message catalog numbers |
| # | 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_ENABLE | Character(1) | VARCHAR2(1) NOT NULL |
Enable Disable
Y/N Table Edit Default Value: N |
| 8 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 9 | MESSAGE_NBR01 | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 10 | MESSAGE_NBR02 | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 11 | MESSAGE_NBR03 | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 12 | FSCM_SC_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Field to capture the processed status of staging data. M = Not processed P = Processed |