Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

> ## gst_record_version table — gstrv

> This table enables you to identify when static data is changed and must be deployed. This table is checked every time the deployment data is written to ensure that all data that matches the deployment criteria is written out.

> When an item of data on a record changes, the replication trigger on the table checks if the `version_data` flag on the `gsc_entity_mnemonic` table is switched on.

> If the flag is switched on, a record is written to this table. If a record already exists in the table, the record is updated to indicate that the data has changed by incrementing the `version_number_seq` and resetting the date, time, and user.

> A `version_number_seq` greater than 0 indicates that the record has been changed locally and might need to be deployed. Once an import is done for a record, the `version_number_seq` is set back to 0, indicating the data has not been modified since the last import.

> When importing data, the `import_version_number_seq` is used as a validity check. If this number does not match the `import_version_number_seq` of the data being imported, or the current `version_number_seq` does not match, there is a potential conflict.

> Table 3–19 lists the table’s FLA, fields, and foreign keys.

> Table 3–19: gst_record_version table information
> Table FLA | Fields (data type) | Foreign keys
> --- | --- | ---
> gstrv | record_version_obj (Decimal) entity_mnemonic (Character) key_field_value (Character) version_number_seq (Decimal) version_date (Date) version_time (Integer) version_user (Character) deletion_flag (Logical) import_version_number_seq (Decimal) last_version_number_seq (Decimal) secondary_key_value (Character) | entity_mnemonic record_version_obj

> Table 3–20 gives details of the table’s indexes.

> Table 3–20: gst_record_version index information
> Index name | Elements | Type
> --- | --- | ---
> XPKgst_record_version | record_version_obj | Primary Unique
> XAK1gst_record_version | entity_mnemonic key_field_value | Unique
> XIE1gst_record_version | key_field_value | Nonunique
> XIE3gst_record_version | entity_mnemonic version_date version_time | Nonunique
> XIE4gst_record_version | entity_mnemonic version_number_seq | Nonunique
> XIE5gst_record_version | version_number_seq | Nonunique
> XIE6gst_record_version | entity_mnemonic version_number_seq import_version_number_seq | Nonunique
> XIE7gst_record_version | entity_mnemonic secondary_key_value | Nonunique

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