PTPN_CATEGORY_NAMEPrompt Table: PSPTPN_CAT_TBL
PTPN_TBENOT_VW(SQL View) |
Index Back |
|---|---|
View for TBE Notifications |
| SELECT PTPN_CATEGORY_NAME , DESCR100 , PTPN_FUNC_CATEGORY FROM %Table(PTPN_CAT_REG) |
| # | 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 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 3 | PTPN_FUNC_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL | Functional Category |