FLD_REQ_APPR_VW(SQL View) |
Index Back |
|---|---|
Field Request Approval ViewField Request Approval View Not on-page fields: OPRID & GL_APPR_STATUS for search criteria Exclude Approved ('A'), Blank Value ('B'), Canceled ('C') & Component Interface Error ('E') (already approved) requests. |
| SELECT DISTINCT R.FLD_REQUEST_ID , R.SETID , R.FIELDNAME1 , R.FLD_REQ_FLD_ACT , R.FIELDVALUE1 , R.FLD_REQ_STATUS , F.FLD_REQ_FUNC_AREA , X.EOAWTHREAD_STATUS , R.REQUESTOR_ID , U.OPRID , U.EOAWSTEP_STATUS , D1.FIELD_VALUE_DATE , %Substring(D2.FLD_REQ_VALUE_GL,1,30) FROM PS_FLD_REQUEST R LEFT OUTER JOIN PS_FLD_REQ_COR_DTL D1 ON R.FLD_REQUEST_ID=D1.FLD_REQUEST_ID AND D1.FIELDNAME2='EFFDT' LEFT OUTER JOIN PS_FLD_REQ_COR_DTL D2 ON R.FLD_REQUEST_ID=D2.FLD_REQUEST_ID AND D2.FIELDNAME2='DESCR' , PS_FLD_REQ_AF_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PS_FLD_REQ_SETUP F WHERE R.FLD_REQUEST_ID=X.FLD_REQUEST_ID AND R.FLD_REQ_STATUS NOT IN ('A','B','C','E') AND X.EOAWTHREAD_ID=S.EOAWTHREAD_ID AND X.EOAWPRCS_ID=S.EOAWPRCS_ID AND X.EOAWDEFN_ID=S.EOAWDEFN_ID AND S.EOAWSTEP_INSTANCE=U.EOAWSTEP_INSTANCE AND R.FIELDNAME1=F.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
Prompt Table: SP_SETID_NONVW |
| 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 | EOAWTHREAD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Request Approval Status
A=Approved C=Complete D=Denied E=Pending Denial H=Hard Deny I=Initial N=Not Active P=Pending S=Awaiting Further Approvals T=Terminated W=Canceled X=Suspended/Pending Denial |
| 9 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 10 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 11 | GL_APPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Status
A=Approved B=Pushed Back D=Denied H=On Hold P=Pending |
| 12 | EFFDT | Date(10) | DATE | Effective Date |
| 13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |