OPRIDHRS_OWNER_IDDESCR40HRS_SRCHSAVP_VW(SQL View) |
Index Back |
|---|---|
Stored SearchSaved stored Profile Match search criteria. |
| SELECT B.OPRID , A.HRS_OWNER_ID , (((%NumToChar(A.HRS_SEARCH_ID)) %Concat ' ') %Concat A.SEARCH_NAME) , A.SEARCH_NAME FROM PS_HRS_SRCH_SAVED A , PSOPRDEFN B WHERE ((A.HRS_SCH_ACCESS = 'P' AND A.HRS_SCH_ACTIVE = 'Y') OR (A.HRS_OWNER_ID = B.EMPLID AND A.HRS_SCH_ACCESS = 'V' AND A.HRS_SCH_ACTIVE = 'Y')) AND A.HRS_SCH_TYPE = 'P' |
| # | 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 | HRS_OWNER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Owner ID |
| 3 | DESCR40 |
Character(40) | VARCHAR2(40) NOT NULL | Description |
| 4 | SEARCH_NAME | Character(20) | VARCHAR2(20) NOT NULL | Stored Search Name |