RS_POOL_ACTIVE1(SQL View) |
Index Back |
---|---|
Resource Pool Active - ViewThis record is used on ESA for IT, for Resource Pool feature. This view bring the resource pool currently active. |
SELECT DESCR ,POOL_ID FROM PS_RS_RES_POOL WHERE STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
2 | POOL_ID | Character(10) | VARCHAR2(10) NOT NULL | Pool ID field. |