SUBMIT_OPRIDRB_OPRDEFN_SRCH(SQL View) |
Index Back |
|---|---|
Clone of User ID search viewThis view is created as clone of PSOPRDEFN_SRCH. This view is used in the CRM custom search. The custom search was not allowing any prompts that are from Tools table. This view should be deleted once CRM custom search is fixed. (This is a dynamic view because if it is made a regular view, it is trated as a security view, ie, a where clause is added. |
| SELECT oprid , oprdefndesc FROM PSOPRDEFN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SUBMIT_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | Submitted By OPRID......................................... |
| 2 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |