FLD_REQ_AF_VW (SQL View)	Index Back
Field Request AF View Field Request View used by AF (Approval Framework aka AWE) Exclude Approved ('A'), Canceled ('C') & Component Interface Error ('E') (already approved) requests. For Component Interface Error requests, if the fixing doesn't involve request data change, then there is no need to re-submit it. If user needs to change the request data, then the component will flip the status to Need Attention ('T').

FLD_REQ_AF_VW

(SQL View)

Field Request AF View

Field Request View used by AF (Approval Framework aka AWE) Exclude Approved ('A'), Canceled ('C') & Component Interface Error ('E') (already approved) requests. For Component Interface Error requests, if the fixing doesn't involve request data change, then there is no need to re-submit it. If user needs to change the request data, then the component will flip the status to Need Attention ('T').

SELECT %subrec(FLD_REQ_AF_VW, A) FROM PS_FLD_REQUEST A WHERE A.FLD_REQ_STATUS NOT IN ('C')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FLD_REQUEST_ID Character(30) VARCHAR2(30) NOT NULL Field Request ID