FLD_REQUEST_IDDefault Value: NEXT
SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
FIELDNAME1Prompt Table: FLD_REQ_TFCF_VW
FLD_REQ_FLD_ACTA=Add
U=Update
Default Value: A
FIELDVALUE1Prompt Table: %EDITTABLE
FLD_REQ_ADD_VW(SQL View) |
Index Back |
|---|---|
ChartField Request Add ViewField Request Add View - ChartField Need clone this when build request component for fields of other functional areas. |
| SELECT %subrec(FLD_REQ_ADD_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
Default Value: NEXT |
| 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
Prompt Table: %EDITTABLE |