FLD_REQUEST_IDA=Add
U=Update
A=Approved
B=Blank Value
C=Canceled
D=Denied
E=Component Interface Error
N=Newly Created
P=Pending Approval
T=Need Attention
CF=ChartField
FLD_REQ_ID_VW(SQL View) |
Index Back |
|---|---|
Field Request ID ViewField Request ID View |
| 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 , A.GL_ENTERED_BY FROM PS_FLD_REQUEST A , PS_FLD_REQ_SETUP S WHERE 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 |
| 9 | GL_ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered By |