SEC_VIEW_NAMES

(SQL Table)
Index Back

Security Name Views

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEARCH_TEXT Character(15) VARCHAR2(15) NOT NULL Search Text for Security Views
2 VIEW_NO_SECURITY Character(15) VARCHAR2(15) NOT NULL No Security View

Prompt Table: RECDEFN_VW

3 VIEW_OPR_SECURITY Character(15) VARCHAR2(15) NOT NULL User ID Security Views

Prompt Table: RECDEFN_VW

4 VIEW_CLS_SECURITY Character(15) VARCHAR2(15) NOT NULL Permission List Security View

Prompt Table: RECDEFN_VW

5 FIELD_LEVEL Character(1) VARCHAR2(1) NOT NULL Secured Field Type
B=Business Unit Security
C=Company Security
I=Item Type Security
N=Institution Set Security
O=Origin Security
S=TableSet ID Security