PR_APPR_MAP_VW(SQL View) |
Index Back |
|---|---|
Approve Voucher User View |
| SELECT DISTINCT V.REQUEST_ID , V.BUSINESS_UNIT , V.VOUCHER_ID , V.GROSS_AMT , V.TXN_CURRENCY_CD , V.INVOICE_DT , V.INVOICE_ID , V.SCHEDULED_PAY_DT , V.DESCR50 , O.OPRDEFNDESC , U.EOAWSTEP_STATUS , U.OPRID , U.EOAWORIG_OPRID , %DatePart(U.EOAWDTTM_MODIFIED) , S.EOAWTHREAD_ID , X.EOAWTHREAD_STATUS , U.EOAWDTTM_COMPLETE , X.EOAWREQUESTOR_ID , X.EOAWDTTM_MODIFIED , S.EOAWPRCS_ID , S.EOAWDEFN_ID , S.EFFDT , S.EOAWSTEP_NBR , ' ' , U.DTTM_CREATED FROM PS_PR_REQUEST_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PS_PR_REQUEST V , PSOPRDEFN O WHERE V.REQUEST_ID = X.REQUEST_ID AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND O.OPRID = X.EOAWREQUESTOR_ID AND X.EOAWTHREAD_ID = ( SELECT MAX(X1.EOAWTHREAD_ID) FROM PS_PR_REQUEST_XREF X1 WHERE X1.REQUEST_ID = X.REQUEST_ID ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 4 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 5 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 6 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 7 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 8 | SCHEDULED_PAY_DT | Date(10) | DATE | Scheduled to Pay |
| 9 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 10 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 11 | EOAWSTEP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Step Instance Status
A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial |
| 12 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 13 | EOAWORIG_OPRID | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 14 | EOAWSTART_DT | Date(10) | DATE | Start Date |
| 15 | EOAWTHREAD_ID | Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 16 | EOAWTHREAD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Thread Status
A=Approved C=Complete D=Denied E=Pending Denial H=Hard Deny I=Initial N=Not Active P=Pending S=Awaiting Further Approvals T=Terminated W=Canceled X=Suspended/Pending Denial |
| 17 | EOAWDTTM_COMPLETE | DateTime(26) | TIMESTAMP | Date/Time Completed |
| 18 | EOAWREQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 19 | EOAWDTTM_MODIFIED | DateTime(26) | TIMESTAMP | Datetime modified |
| 20 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 21 | EOAWDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |
| 22 |  EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 23 | EOAWSTEP_NBR | Number(6,2) | DECIMAL(5,2) NOT NULL | Sequence number of step in its path |
| 24 | PRIORITY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Priority Flag
1=High 2=Medium 3=Low |
| 25 | DTTM_CREATED | DateTime(26) | TIMESTAMP | Datetime Created |