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 |