PSPERMNAVCLS_VW(SQL View) |
Index Back |
---|---|
Perm. Used as Nav. HomepageThis SQL view provides a list of all Permission Lists in use as a Navigator Homepage Permissions List. It is used by the Purge_Permlist page to prevent the deletion of a Permissions List if it is currently in use as a Navigator Homepage Permissions List. |
SELECT DISTINCT DEFAULTNAVHP , COUNT(*) FROM PSOPRDEFN WHERE DEFAULTNAVHP <> ' ' GROUP BY DEFAULTNAVHP |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CLASSID | Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
2 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |