FLD_REQ_INQ_VW(SQL View) |
Index Back |
|---|---|
Field Request Inquiry ViewField Request Inquiry View |
| SELECT DISTINCT R.FLD_REQUEST_ID , R.SETID , R.FIELDNAME1 , R.FLD_REQ_FLD_ACT , R.FIELDVALUE1 , R.FLD_REQ_STATUS , S.FLD_REQ_FUNC_AREA , X.EOAWTHREAD_STATUS , R.REQUESTOR_ID , R.ATTACHMENT_EXIST , D1.FIELD_VALUE_DATE , %Substring(D2.FLD_REQ_VALUE_GL,1,30) FROM PS_FLD_REQUEST R LEFT OUTER JOIN PS_FLD_REQ_AF_XREF X ON R.FLD_REQUEST_ID=X.FLD_REQUEST_ID 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_SETUP S WHERE R.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
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 | ATTACHMENT_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
Attachments Exist
N=N Y=Y |
| 11 | EFFDT | Date(10) | DATE | Effective Date |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |