PRCR_VIEW_NAMEPRCR_VWCAN_RLVW(SQL View) |
Index Back |
|---|---|
PRCR View Candidate 4 RCV List |
| SELECT PRCR_VIEW_NAME, PRCR_VIEW_ID FROM PS_PRCR_VIEW_CAN WHERE PRCR_INQ_TYPE = 'RL' |
| # | 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 |