OPRDEFN_SCRTY3

(SQL View)
 Index Back

Data Access Permission Lists

This view selects the Data Permission Lists to setup a Department Security Access Profile

SELECT CLASSID , CLASSDEFNDESC FROM PSCLASSDEFN WHERE CLASSID LIKE 'HCDP%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
2 CLASSDEFNDESC Character(30) VARCHAR2(30) NOT NULL Permission List Description