RY_SERVERS_VW

(SQL View)
 Index Back

Prompt for RY_INSTANCE table.

This view is used as a prompt by RY_INSTANCE record.

SELECT A.SERVERNAME , A.SERVERNAME %Concat ' - ' %Concat A.DESCR FROM PS_SERVERDEFN A , PS_SERVERCLASS B WHERE A.SERVERNAME = B.SERVERNAME AND B.PRCSTYPE = 'Application Engine'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
2 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254