PGM_SRCHPOOL

(SQL View)
 Index Back

Pool Search

This is a dummy view to store the Pools found by search

SELECT ' ' , ' ' , ' ' , ' ' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.

Prompt Table: RS_RES_POOL

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

Prompt Table: RS_RES_POOL

3 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID

Prompt Table: RS_RES_POOL

4 SELECT_CB Character(1) VARCHAR2(1) NOT NULL Select Check Box
N=No
Y=Yes