The Global Database is a central location for storing values for system variables.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | varchar(50) | not null | 50 chars, text field, required for everything except a DEFINE, is returned on a DEFINE. This is the unique identifier for a Global record and is generated by the Level 1 API. |
| name | varchar(80) | with null | 80 chars, text field, read/write access. This is the display name for a Global object. |
| type | integer | with null | Integer field, read/write access. The values for type are: CFGTYPE_EVENT_MANAGERS (Alert enabled event managers); CFGTYPE_CALLOUT ( lib/procname of the user callout); CFGTYPE_DROOT, (Alternative place to create AMSHOLD, AMSARCHIVE directories); CFGTYPE_ADMINGUI (AMS GUI); and CFGTYPE_DAEMON (AMS daemon entry). |
| value | varchar(256) | with null | 256 chars, text field, read/write access. This is the information being stored. |
| value2 | varchar(2048) | with null | 2048 chars, text field, secondary field for associating data with a global record. |
| active | char(1) | with null | Boolean field, read/write access. This indicates whether or not the value for the Global is to be applied. |
| internal | char(1) | with null | Boolean field, read/write access. This indicates whether or not this Global can be modified by the user. When Internal is TRUE the value for this Global is something that the user cannot change. |
| created | integer | with null | ULONG cast of time_t, read only access. The Level 1 API sets this field to the current time when a Global record is created. |
| createdby | varchar(60) | with null | 60 chars, read only access. The Level 1 API sets this field to the ID of the user who created this Global record. |
| modified | integer | with null | ULONG cast of time_t, read only access. The Level 1 API sets this field to the current time when a Global record is altered. This is the most recent change and there is no history kept of previous changes. |
| modifiedby | varchar(60) | with null | 60 chars, text field, read only access. The Level 1 API sets this field to the ID of the user who most recently modified this Global record. |
Product Name: Unicenter Network and System Management/Alert Management
Table Type: Table