HSC_TBEPN_STG

(SQL Table)
 Index Back

TBE PN Message Reference table

Reference 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 HCSC_STATUS Character(1) VARCHAR2(1) NOT NULL Field to capture the processed status of staging data. N = Not processed P = Processed

Default Value: N