PSIBDOMSTAT2VW (SQL View)	Index Back
IB Static Secondary Domains

PSIBDOMSTAT2VW

(SQL View)

IB Static Secondary Domains

SELECT MACHINENAME ,APPSERVER_PATH ,DOMAIN_STATUS ,IB_SLAVEMODE FROM PSAPMSGDOMSTAT WHERE IB_SLAVEMODE = 1 OR IB_SLAVEMODE = 3 OR IB_SLAVEMODE = 4

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MACHINENAME Character(30) VARCHAR2(30) NOT NULL Machine Name

2 APPSERVER_PATH Character(64) VARCHAR2(64) NOT NULL Application Server Path

3 DOMAIN_STATUS Character(1) VARCHAR2(1) NOT NULL Domain Status
A=Active
I=Inactive

4 IB_SLAVEMODE Number(1,0) SMALLINT NOT NULL Integration Broker Sec Mode

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MACHINENAME	Character(30)	VARCHAR2(30) NOT NULL	Machine Name
2	APPSERVER_PATH	Character(64)	VARCHAR2(64) NOT NULL	Application Server Path
3	DOMAIN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Domain Status A=Active I=Inactive
4	IB_SLAVEMODE	Number(1,0)	SMALLINT NOT NULL	Integration Broker Sec Mode