Table and field name definitions
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
The naming of tables and fields in the OpenEdge Management database follows certain conventions. Each table and field name consists of a prefix and a suffix, separated by an underscore. The prefix indicates which resource the table or field is related to. The suffix indicates the name of the data and might contain a subsection. The suffix cannot be more than 15 characters long. The following table describes each prefix.
| Prefix | Table or field contents | Description |
|---|---|---|
| Cf_ | Configuration data | Tables or fields that store configuration information for such OpenEdge Management functions as schedules, resource identification, and alert definitions. See Configuration tables for more information. |
| Sys_ | System data | Tables or fields that store raw data collected from samplings of such resources as CPU, disk, and memory. See System tables for more information. |
| Db_ | Database data | Tables or fields that store data gathered from OpenEdge® databases. Sample data includes I/O, user statistics, and memory management. See Compaction details for configuration tables and Database analysis tables for more information. |
| OE_ | OpenEdge Server data | Tables or fields that store data gathered from WebSpeed®
and AppServer. Note: OpenEdge Management supports management of the
WebSpeed® Transaction Server product. Throughout this guide, WebSpeed
Transaction Server and WebSpeed are used interchangeably. |
| Ar_ | Archive data | Tables or fields that store data gathered from OpenEdge databases for archiving purposes. Sample data includes all fields and data associated with a given table and archive-specific fields. Data stored in system and database tables can be archived; data stored in configuration tables cannot be archived. See the Archive tables for more information. |
| Net_ | Network data | Table or fields that store data gathered from TCP, UDP, ICMP, or HTTP resources. |