PRCR_VIEW_NAMEPRCR_VWCAN_PHVW(SQL View) |
Index Back |
|---|---|
PRCR View Candidates for HST |
| SELECT PRCR_VIEW_NAME, PRCR_VIEW_ID FROM PS_PRCR_VIEW_CAN WHERE PRCR_INQ_TYPE = 'PH' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRCR_VIEW_NAME |
Character(30) | VARCHAR2(30) NOT NULL | View By |
| 2 | PRCR_VIEW_ID | Character(15) | VARCHAR2(15) NOT NULL | View ID |