Updating the Request ID field in other AR System tables

When you change the Request ID in a main data table, you must also consider whether you need to make a similar change to the status history table and attachment tables.

 Updating status history tables

Status history information is stored in a separate table. This table uses the Request ID field as the link to the main table. Accordingly, you use the same procedure to change the Request ID field values in the status history table as you do in other tables.

To update the status history table, use the commands described in the previous examples, substituting H43 for T43 and entryId for C1. For more information, see Using-SQL-commands-to-shorten-the-Request-ID-field and The-status-history-table-for-a-form.

 Updating attachment tables

Attachment information is stored in the following tables:

• Attachment Details table — Holds attachment characteristics, such as the name and size of the attachment.
• Attachment Data table — Holds the actual attachment.

These tables use the Request ID field as the link to the main table. Accordingly, you use the same procedure to change the Request ID field values in the status history table as you do in other tables.

The Attachment Details table is named with a B followed by the schema ID (for example, B3 ). The Attachment Data table is named with a B followed by the schema ID, followed by C, followed by the attachment field ID. For example, the Attachment Data table might be called B7C536870920, where 7 is the schema ID, and 536870920 is the attachment field ID.

The column holding the Request ID in the Attachment Details table is named C1, and in the Attachment Data table, it is named entryId. To update the Request ID field in the attachment tables, use the commands described in the previous examples, substituting the appropriate table name, and using C1 or entryId for the Request ID. For more information, see Using-SQL-commands-to-shorten-the-Request-ID-field.

See the The-attachment-tables-for-a-form.