ENTERED_BYPV_ENTER_BY_VW(SQL View) |
Index Back |
|---|---|
View for Entered By fieldDate Initials Reference # Description 08/02/07 Bob 1649942003 View for Entered By prompt button in Manage Requisitions screen |
| SELECT A.OPRID , B.OPRDEFNDESC FROM PS_OPR_DEF_TBL_PM A , PSOPRDEFN B WHERE A.ALL_REQUESTORS_FLG = 'Y' AND A.OPRID = B.OPRID UNION SELECT A.OPRID , B.OPRDEFNDESC FROM PS_OPR_PO_RQSTR A , PSOPRDEFN B WHERE A.OPRID = B.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ENTERED_BY |
Character(30) | VARCHAR2(30) NOT NULL | Entered by |
| 2 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |