description

STRING 100

Specifies the comments field.

chg_prefix

STRING 5

Specifies the prefix for changes for a region.

cr_prefix

STRING 5

Specifies the prefix for requests for a region.

del

INTEGER

NOT_NULL

Active_Boolean_ Table::enum

Deleted flag

0—Active

1—Inactive/marked as deleted

global_name

STRING 30

UNIQUE

NOT_NULL

Value of NX_GLOBAL_NAME on region

id

INTEGER

UNIQUE

NOT_NULL KEY

Unique (to the table) Numeric ID

is_master

INTEGER

Boolean_Table ::enum

Indicates if this server defined as master.

iss_prefix

STRING 5

Specifies the prefix for issues for a region.

last_mod_by

UUID

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

LOCAL_TIME

Indicates the timestamp of when this record was last modified.

remote_sys_id

INTEGER

UNIQUE

NOT_NULL

Regional system id

slump_addr

STRING 30

Specifies the CA SDM primary server hostname or IP address. A slump_addr is defined for each global region definition.

sym

STRING 30

UNIQUE

NOT_NULL

Specifies the descriptive name.

web_protocol

STRING 10

Specifies the master region web access protocol (http https).

web_server

STRING 30

Specifies the web server name.

web_server_port

STRING 10

Specifies the web server port (can be blank).

web_url

STRING 100

Specifies the rest of URL to pdmweb.exe of remote system (or webdirector).

id

INTEGER UNIQUE

Unique key.

local_host

STRING 128 UNIQUE NOT_NULL S_KEY

Host name/Server name

timezone

STRING 30

Timezone

Timezone of server.

desc

STRING 1024

Textual description of the this host/server.

del

INTEGER NOT_NULL

Deleted flag

0—active

1—inactive/marked as deleted

server_id

INTEGER

Server ID or Slump ID

slump_port

INTEGER

Slump port number for communication.

server_type

INTEGER

server_types

Type of Server

0—primary

1—Secondary

2—Background

3—Stand-By

4—Application Server

database_type

STRING 30

Currently unused.

0—SQL

1—Oracle

external_dns_name

STRING 30

Currently unused.

platform

STRING 30

Currently unused.

0—Unix/Linux

1—Windows

linked

INTEGER NOT_NULL

Specify whether the server is configured.

last_mod_dt

LOCAL_TIME

Timestamp of when the record was last modified.

last_mod_by

UUID

ca_contact

Specifies the UUID of the contact who last modified the record.