Common archive fields
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
Common archive fields
You can archive data that is derived from the values stored in fields associated with database, OpenEdge, or system tables. An additional set of archive-specific fields for which unique values are defined during the archiving process is also generated for, and stored with, each archived table.
The Archive OpenEdge Management Trend Database tables and Archive system tables tables define the unique fields associated with each database or system table. The following table identifies the common fields for which values are generated and added to a table when you archive it.
| Field name | Data type | Description |
|---|---|---|
| _ArchiveType | Character | Identifies the field's archive type:
|
| _Length | Integer | Number of seconds for the archive to take place |
| _StartDate | Date | Start date for the row (this date will always be the same as the end date for hourly and daily) |
| _StartTime | Integer | Start time for the row |
| _EndDate | Date | End date for the row |
| _EndTime | Integer | End time for the row |
| _Transactions | Integer | Number of transactions committed |
| _RecordCount | Integer | Number of records in this archived file |
| Resrc_ID | Integer | The Resource ID of the database for this site |
| Site_ID | Character | The Site ID for the database |