OPRIDCOMPONENT_IDWM_FLEXSRCH_IDWM_FLEXSRCH_VW(SQL View) |
Index Back |
|---|---|
WM Flexible Search View |
| SELECT A.OPRID , A.COMPONENT_ID , A.WM_FLEXSRCH_ID , A.DESCR , %DatePart(A.LAST_UPDATE_DTTM) , COUNT(*) FROM PS_WM_FLEXSRCH_HDR A , PS_WM_FLEXSRCH_DTL B WHERE A.EFF_STATUS = 'A' AND B.OPRID = A.OPRID AND B.COMPONENT_ID = A.COMPONENT_ID AND B.WM_FLEXSRCH_ID = A.WM_FLEXSRCH_ID GROUP BY A.OPRID , A.COMPONENT_ID , A.WM_FLEXSRCH_ID , A.DESCR , A.LAST_UPDATE_DTTM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | COMPONENT_ID |
Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 3 | WM_FLEXSRCH_ID |
Character(15) | VARCHAR2(15) NOT NULL | Search Name |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | LAST_UPDATE_DT | Date(10) | DATE | Last Updated |
| 6 | TOTAL_SRCH_LINES | Number(5,0) | INTEGER NOT NULL | Total Search Criteria Lines |