Adding fields to a record type

Each record type has a Fields grid, which shows its associated fields. You can use this grid to add fields to the record type and to modify field properties.

Before you begin

When naming fields, do not use keywords that are reserved by the database vendor. See your vendor documentation for a list of reserved keywords.

About this task

The DB Column Name is the name that the Designer uses for the table column. By default it is the same as the field name.

To add a field to a record type:

Procedure

Start the Designer.
In the Workspace, expand the Record Types folder, expand the record type, and double-click Fields.
Click Edit > Add Field.
In the New Field window, type a field name.
In the Type field, select a field data type.
- For fields of type SHORT_STRING, enter a value for Maximum Length. This value cannot exceed 254 characters. You cannot modify this value after you check in the schema.
  Storage space in the database is reserved for the maximum length of a field. To save storage space, set the maximum length to be as short as possible. Values that exceed the maximum field length are truncated.
- For fields of type REFERENCE and REFERENCE_LIST, select a record type to which the field refers. The record type can be state-based or stateless. You can also enter an optional back-reference field to create a link from the referenced record back to this field record. For more information, see Using fields to link records.
Select the Visible in queries check box to ensure that this field is included in queries run from the Rational® ClearQuest® Client. If you do not want to include this field in queries, clear this check box.

What to do next

To make the new field available to users:

You must associate it with a form control. For more information, see Working with form controls.
You must check in the schema and apply that version of it to the user database.

After you check in the schema, you cannot change the type, size, or DB Name properties of the field. However, you can change the name that you use to refer to the field.