REQ_ID_HC_VW

(SQL View)
Index Back

Requisition ids by requestor.

This view shows the requisition ids by requestor ids.

SELECT A.BUSINESS_UNIT , A.REQUESTOR_ID , A.REQ_ID , A.REQ_STATUS , A.ENTERED_DT FROM PS_REQ_HDR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
3 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
4 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
5 ENTERED_DT Date(10) DATE Entered on