RB_PTSF_CATG_VW(SQL View) |
Index Back |
---|---|
Search Category NameThis view returns search category names, descriptions |
SELECT PTSF_SRCCAT_NAME , DESCR100 FROM PSPTSF_SRCCAT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PTSF_SRCCAT_NAME | Character(65) | VARCHAR2(65) NOT NULL | Search Category Name (see PSPTSF_SRCCAT). |
2 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |