SETIDPrompt Table: SETID_TBL
REQUESTOR_IDPrompt Table: REQUESTOR_VW
CATALOG_IDPrompt Table: CATALOG_VW
REQ_CAT_SRCH(SQL View) |
Index Back |
|---|---|
Requestor CatalogsUsed as Catalog ID prompt table for requisitions when a requestor can only use specific catalogs. |
| SELECT DISTINCT a.setid , a.requestor_id , a.catalog_id FROM ps_requestor_cat a , PSTREEDEFN b WHERE a.setid = b.setid AND b.eff_status = 'A' AND b.effdt = ( SELECT MAX(effdt) FROM PSTREEDEFN WHERE b.setid = setid AND b.tree_name = tree_name AND b.effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | REQUESTOR_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table: REQUESTOR_VW |
| 3 | CATALOG_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Catalog ID
Prompt Table: CATALOG_VW |