FLD_REQ_CF_VW

(SQL View)
 Index Back

ChartField Request Search View

Field Request Search View - ChartField Need clone this when build request component for fields of other functional areas.

SELECT %subrec(FLD_REQ_CF_VW, A) FROM PS_FLD_REQUEST A , PS_FLD_REQ_SETUP S WHERE A.FIELDNAME1=S.FIELDNAME1 AND S.FLD_REQ_FUNC_AREA='CF'

# 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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: FLD_REQ_TFCF_VW

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

Default Value: A

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

Default Value: N

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

Prompt Table: OPRID_VW

8 GL_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By

Prompt Table: OPRID_VW