The main data table for a form
Each form has an associated main data table that holds all the information for that form. The main data table contains a column for each field except Attachments and Status History. Each main data table or view (for join forms) is named with a T followed by the unique ID (schemaID ) for the form (for example, T3 ). To find the ID, search the arschema table by the name column and retrieving the schemaId value. The ID does not change regardless of changes made to the form, so the table name remains the same. In AR System Data Dictionary: Forms, Fields, VUIs, and Sample Forms, the main data table is labeled T n .
All columns in each table or view are named with a C followed by the unique ID for the field in the form. For example, the Submitter field is C2. The ID for the field does not change; the creator of the field can assign the ID. Every ID is unique within a form, so duplicate name issues do not occur. After an ID is assigned, it cannot be changed, regardless of any changes to the field. For information about reserved and core IDs, see the Developing section.
If a join form contains an attachment field, a column is added to the Main Data view. The contents of this column are a concatenation of the C, CO, and CC columns of the Attachment Details table. If attachments are added to the base form, the view is updated. See The attachment tables for a form.
Because BMC Remedy AR System must retain the IDs of the requests in the underlying table to form the ID of a join form entry, there are a few extra columns and some special handling for column C1. BMC Remedy AR System creates a series of columns for each regular form that is involved in the join tree. The columns are named with an E followed by a zero-based index (three regular tables would be named E0, E1, and E2 ). These columns point to the corresponding entry IDs (column C1 ) of the regular forms. The C1 column for the join form is determined by concatenating the entry IDs of the regular forms (in the E columns) separated by vertical bars (| ).