> #### 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.

> Table 3–13 and Table 3–14 define the unique fields associated with each database or system table. Table 3–16 identifies the common fields for which values are generated and added to a table when you archive it.

> Table 3–16: Common archive fields
> Field name | Data type | Description
> --- | --- | ---
> _ArchiveType | Character | Identifies the field's archive type: H — Hourly D — Daily W — Weekly
> _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 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.

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095