BPW_SERVER_VW

(SQL View)
Index Back

BPW Server View


SELECT SERVERNAME , DESCR , OPSYS FROM PS_SERVERDEFN WHERE DISTNODENAME <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 OPSYS Character(1) VARCHAR2(1) NOT NULL Operating System
0=DOS
1=NT/Win95 Client
2=Windows
3=OS/2
4=UNIX
5=VMS
6=MPE/XL
7=OS390
9=OS/400