EOEN_CAT_NM_VW1(SQL View) |
Index Back |
|---|---|
Notification Category Names |
| SELECT A.PTPN_CATEGORY_NAME , A.PTPN_EVENTNAME , A.PTPN_FUNC_CATEGORY , A.DESCR100 , COUNT(*) FROM PS_PTPN_CAT_REG A , PS_EOEN_REG_AUX B WHERE A.PTPN_CATEGORY_NAME = B.PTPN_CATEGORY_NAME AND B.PTPN_CATEGORY_NAME <> ' ' GROUP BY A.PTPN_CATEGORY_NAME, A.PTPN_EVENTNAME, A.PTPN_FUNC_CATEGORY, A.DESCR100 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTPN_CATEGORY_NAME | Character(50) | VARCHAR2(50) NOT NULL | Notification Name |
| 2 | PTPN_EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Event Name |
| 3 | PTPN_FUNC_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL | Functional Category |
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 5 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |