REQ_RC_WB_SR_VW

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , A.REQ_ID , A.ACTIVITY_DATE , A.REQ_DT , A.REQ_STATUS , A.REQUESTOR_ID , A.HOLD_STATUS , A.CHNG_ORD_BATCH , A.BUDGET_HDR_STATUS , A.CC_SECURITY_ID , A.CC_USE_FLAG FROM PS_REQ_HDR A WHERE A.IN_PROCESS_FLG = 'N'

# 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 ACTIVITY_DATE Date(10) DATE Last Activity
4 REQ_DT Date(10) DATE Requisition Date
5 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
6 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
7 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
8 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
9 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
10 CC_SECURITY_ID Number(10,0) DECIMAL(10) NOT NULL Procurement Card Number
11 CC_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Use Procurement Card

Y/N Table Edit

Default Value: N