See Also

Quality Center Database

See Also Quality Center Database

SYSTEM_FIELD Table

Description

Meta-data about data fields in other tables. Stores settings from project entity customizations and system defaults.

Columns

  Column Name Description Datatype Length Allow
Nulls
Primary Key  SF_TABLE_NAME The name of the table containing the field being described. VarChar 40  
Primary Key  SF_COLUMN_NAME The field being described. VarChar 40  
  SF_COLUMN_TYPE The data type, such as DATE, char, memo, number, or time. VarChar 20
  SF_USER_LABEL The display label text. VarChar 100
  SF_EDIT_STYLE The type of control used to edit the value if the specific application window supports controls. If edit style is an empty string or controls are not supported, a text edit box is used. VarChar 50
  SF_EDIT_MASK A mask for controlling input format for strings such as phone numbers, dates, ID numbers, and the like. VarChar 50
  SF_IS_SYSTEM A value of Y indicates a system field. N indicates a user defined field. VarChar 1
  SF_IS_CANFILTER A value of Y indicates that the users can add the field to a view filter. N indicates that the field cannot be used in a filter. VarChar 1
  SF_IS_KEY A value of Y indicates that the field is a member of an index.  VarChar 1
  SF_KEY_ORDER For backward compatibility. Field may be removed in future version. Integer 4
  SF_IS_EDIT A value of Y indicates that the field value can be changed by users. N indicates a calculated or fixed value. VarChar 1
  SF_IS_ACTIVE A value of Y indicates that the field can be displayed in the User Interface. VarChar 1
  SF_IS_HISTORY A value of Y indicates that change records are kept on this field. VarChar 1
  SF_IS_MAIL A value of Y indicates that users are notified when the value of this field is changed. VarChar 1
  SF_IS_VERIFY A value of Y indicates that the field value must be an item in a list. Most verification is done against named lists in the ALL_LISTS Table. User name fields are checked against the USERS Table. Subject fields are from the subject tree in the ALL_LISTS Table. VarChar 1
  SF_ROOT_ID The ALL_LISTS.AL_ITEM_ID of the root of the list from which the values are taken. Integer 4
  SF_IS_BY_CODE A value of Y indicates that the contents of the field are the ID of a folder. VarChar 1
  SF_IS_REQUIRED A value of Y indicates that a value for the field is required before a user can create the entity. VarChar 1
  SF_GRANT_MODIFY A bit mask that specifies the groups whose members may modify the field. If bit X is set, the modify action is enabled for the group identified with GROUPS.GR_GROUP_ID = X. VarChar 512
  SF_IS_TRANSITION_LOGIC For backward compatibility. Field may be removed in future version. VarChar 1
  SF_USER_COLUMN_TYPE The type of data a user enters in a field. This is not always the same as the SF_COLUMN_TYPE. For example, a user may enter date or numerical information in a char database field. VarChar 20
  SF_IS_KEEP_VALUE For backward compatibility. Field may be removed in future version. VarChar 1
  SF_IS_CUSTOMIZABLE If Y, the field is displayed in the customization user interface. VarChar 1
  SF_CAN_CHANGE_PERMISSIONS For backward compatibility. Field may be removed in future version. VarChar 1
  SF_FIELD_SIZE The size of the field in bytes. For large object fields, such as memos, the size is -1. Integer 4
  SF_IS_VISIBLE_IN_NEW_BUG A bit mask that specifies the groups for whose members the field is visible in the new defect dialog. If bit X is set, the field is visible for the group identified with GROUPS.GR_GROUP_ID = X. VarChar 512
  SF_IS_VISIBLE_FOR_GROUPS A bit mask that specifies the groups for whose members the field is visible in the User Interface. If bit X is set, the field is visible for the group identified with GROUPS.GR_GROUP_ID = X. VarChar 512
  SF_IS_TO_SUM For backward compatibility. Field may be removed in future version. VarChar 1
  SF_IS_UNDER_VCS If Y, the field is under configuration control. Applicable only to test fields. VarChar 1
  SF_OWNER_SENSIBLE A bit mask that specifies groups. The modify action is enabled for the owner of the entity if the owner belongs to a group whose bit is set. The group's bit is the bit corresponding to the GROUPS.GR_GROUP_ID value. VarChar 512
  SF_CAN_GROUP If Y, the field can be grouped in the UI. VarChar 1
  SF_IS_SEARCHABLE If Y, searching in the values of the field is enabled. VarChar 1
  SF_IS_VIRTUAL If Y, the field does not have a physical representation in the database. VarChar 1
  SF_IS_MULTIVALUE Indicates whether the field can contain multiple values from a look-up list. If true (Y), the UI control linked to the field supports multiple selection and the field contains a semicolon-separated list of values.

Note: The values are denormalized for performance reasons. Any program that alters the values in the specified field must also handle the [entity]_MULTIVALUE entries.

VarChar 1
  SF_REFERENCE_TABLE The name of the table containing the displayed value.
If this field is in use, set SF_IS_BY_CODE to Y.
VarChar 40
  SF_REFERENCE_ID_COLUMN The name of the table containing the key.
If this field is in use, set SF_IS_BY_CODE to Y.
VarChar 40
  SF_REFERENCE_NAME_COLUMN The name of the column containing the displayed value.
If this field is in use, set SF_IS_BY_CODE to Y.
VarChar 40

Indexes

Index Primary Unique
SF_PRIMARYKEY

See Also

Quality Center Database



Copyright 2002-2007 Mercury Interactive Corporation.

Documentation comments or suggestions?
Please send feedback to SW-Doc@hp.com