SP_APPRVR_REQUETORSPF_REQAPPVR_VW(SQL View) |
Index Back |
|---|---|
Approver & Requestor ViewApprover & Requestor view |
| SELECT A.REQUESTOR_ID , B.OPRDEFNDESC FROM PS_REQUESTOR_TBL A , PSOPRDEFN B WHERE A.REQUESTOR_ID = B.OPRID UNION SELECT TE_APPROVER ,DESCR FROM PS_SPF_APPROVER_VW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SP_APPRVR_REQUETOR |
Character(30) | VARCHAR2(30) NOT NULL | Requestor/Approver |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |