FLD_REQUEST_VW (SQL View)	Index Back
Field Request View Field Request View for Defining AF Criteria 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_REQUEST_VW

(SQL View)

Field Request View

Field Request View for Defining AF Criteria 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 A.FLD_REQUEST_ID , A.SETID , A.FIELDNAME1 , A.FLD_REQ_FLD_ACT , A.FIELDVALUE1 , A.FLD_REQ_STATUS , S.FLD_REQ_FUNC_AREA , A.REQUESTOR_ID FROM PS_FLD_REQUEST A , PS_FLD_REQ_SETUP S WHERE A.FLD_REQ_STATUS NOT IN ('A','C','E') AND A.FIELDNAME1=S.FIELDNAME1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

4 FLD_REQ_FLD_ACT Character(1) VARCHAR2(1) NOT NULL Field Request Field Action
A=Add
U=Update

5 FIELDVALUE1 Character(30) VARCHAR2(30) NOT NULL Field Value

6 FLD_REQ_STATUS Character(1) VARCHAR2(1) NOT NULL Field Request Status
A=Approved
B=Blank Value
C=Canceled
D=Denied
E=Component Interface Error
N=Newly Created
P=Pending Approval
T=Need Attention

7 FLD_REQ_FUNC_AREA Character(4) VARCHAR2(4) NOT NULL Field Request Functional Area
CF=ChartField

8 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FLD_REQUEST_ID	Character(30)	VARCHAR2(30) NOT NULL	Field Request ID
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	FIELDNAME1	Character(18)	VARCHAR2(18) NOT NULL	Field Name 1
4	FLD_REQ_FLD_ACT	Character(1)	VARCHAR2(1) NOT NULL	Field Request Field Action A=Add U=Update
5	FIELDVALUE1	Character(30)	VARCHAR2(30) NOT NULL	Field Value
6	FLD_REQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Field Request Status A=Approved B=Blank Value C=Canceled D=Denied E=Component Interface Error N=Newly Created P=Pending Approval T=Need Attention
7	FLD_REQ_FUNC_AREA	Character(4)	VARCHAR2(4) NOT NULL	Field Request Functional Area CF=ChartField
8	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id