PV_APPR_HDR_VW

(SQL View)
 Index Back

Approve Requisition User View


SELECT DISTINCT A.BUSINESS_UNIT , A.REQ_ID , A.EOAWSTEP_STATUS , A.EOAWSTEP_STATUS , MIN(%DatePart(A.DTTM_CREATED)) , A.OPRID , B.REQUESTOR_ID , B.OPRID_ENTERED_BY , B.REQ_NAME , B.REQ_STATUS , B.PRIORITY_FLG , B.REQ_DT , B.CURRENCY_CD , B.REQ_TOTAL FROM PS_PV_AW_ACTION_VW A , PS_PV_APPR_REQH_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID GROUP BY A.BUSINESS_UNIT, A.REQ_ID, A.EOAWSTEP_STATUS, A.EOAWSTEP_STATUS, A.EOAWTHREAD_STATUS, A.OPRID, B.REQUESTOR_ID, B.OPRID_ENTERED_BY, B.REQ_NAME, B.REQ_STATUS, B.PRIORITY_FLG, B.REQ_DT, B.CURRENCY_CD, B.REQ_TOTAL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
3 AWSTEP_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
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
S=Skipped
T=Terminated
U=Auto approved
X=Deleted
Y=Bypassed
4 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
5 DATE_ROUTED Date(10) DATE Routed Date
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
7 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
8 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
9 REQ_NAME Character(30) VARCHAR2(30) NOT NULL Requisition Name
10 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
A=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled
11 PRIORITY_FLG Character(1) VARCHAR2(1) NOT NULL Priority Flag
1=High
2=Medium
3=Low
12 REQ_DT Date(10) DATE Requisition Date
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 REQ_TOTAL Signed Number(30,5) DECIMAL(28,5) NOT NULL Requisition Total