Page Comparison

Column Name

System Column Name

Data Type

Description

SYSTEM_NAME

SYSTEM

VARCHAR(17)

The system name included in the enterprise network.

Note: The system format is nnnnnnnn.ssssssss where nnnnnnnn is the network identifier and ssssssss is the local location name.

RELATIONAL_DATABASE_NAME

RDBNAME

VARCHAR(18)

The relational database name of the enterprise node.

COMMUNICATIONSYSTEM_STATUS

COMSTATUSSYSSTATUS

VARCHAR(7)

Nullable

Indicates the communication system status of the network system relative to the local system. The status is updated with each attempt by the local system to communicate with the network system.

The possible values are:

• OFFLINE

• ONLINE

Contains the null value if the system communication status has not been set.

NETWORKCOMMUNICATION_STATUS

NETSTATUSCOMSTATUS

VARCHAR(8)

Nullable

Indicate if the system has been set up to share media information with the other systems in the networkIndicates the communication status of the network system relative to the local system. The status is updated with each attempt by the local system to communicate with the network system.

The possible values are:

• ACTIVE

• INACTIVE

Contains the null value if the network system communication status has not been set.

LOCAL_RECEIVES_HISTORY

LCLRCVHST

VARCHAR(3)

Nullable

Indicates whether history information will be received by the current system from the specified remote system.

The possible values are:

• NO

• YES

Contains the null value if the local receives history has not been set.

REMOTE_RECEIVES_HISTORY

RMTRCVHST

VARCHAR(3)

Nullable

Indicates whether the remote system is to receive history information from the current system.

The possible values are:

• NO

• YES

Contains the null value if the remote receives history has not been set.

SYSTEM_NAME

SYSTEM_STATUS

NETWORKCOMMUNICATION_STATUS

APPN.SYSTEM1

ONLINE

ACTIVE