Share this page
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | SF_ID | The record ID. | int | 4 | |||
| SF_TABLE_NAME | The name of the table containing the field being described. | varchar | 40 | ||||
| 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 | 200 | | |||
| SF_EDIT_STYLE | The type of control used by the ALM user interface to edit the value. This value is used only if the specific application window supports controls. If the edit style is an empty string or controls are not supported, a text edit box is used. The possible values are: BaselineSingleTreeCombo, CycleTreeCombo, DateCombo, HostCombo, ListCombo, PathCombo, ReleaseCycleMultiTreeCombo, ReleaseCycleSingleTreeCombo, ReleaseMultiTreeCombo, ReleaseSingleTreeCombo, ReqTreeCombo, ReqTypeCombo, TestClassTreeCombo, TreeCombo, and UserCombo. | varchar | 50 | | |||
| SF_EDIT_MASK | A mask for controlling input format for strings such as phone numbers, dates, ID numbers, and the like. | varchar | 255 | | |||
| 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. | int | 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 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 | If SF_IS_VERIFY is Y, the LISTS.LS_ID of the root of the list from which the values are taken. If the field is a test subject, this is the ALL_LISTS.AL_ITEM_ID. | int | 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 | If Y, the field has a permission associated with it. | varchar | 1 | | |||
| SF_FIELD_SIZE | The size of the field in bytes. For large object fields, such as memos, the size is | int | 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. Changing a value triggers a update to the VC_<entity> table of the entity. If N, changing a value updates both the VC_<entity> and the main entity tables. | 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 | | |||
| SF_IS_CROSS_SUBTYPE | Y indicates that the field applies to all sub-types of the entity. | varchar | 1 | | |||
| SF_IS_SUPPORTS_HISTORY | Y indicates that the field history checkbox in the user interface is enabled. | varchar | 1 | | |||
| SF_IS_SUPPORTS_REQUIRED | Y indicates that the field required checkbox in the user interface is enabled. | varchar | 1 | | |||
| SF_UDF_VERSION | The number of times the properties of the user-defined field have been changed. | int | 4 | | |||
| SF_LIST_LOGICAL_NAME | A name, unique in the scope of this table, that refers to this record. | varchar | 64 | | |||
| SF_OUT_SANITIZATION | The type of processing used to reduce the possibility of the REST API returning data that contains executable code. One of none, text, or html. | varchar | 4 | | |||
| SF_IS_VISIBLE_ON_WEB_UI | For internal use. | varchar | 1 | | |||
| SF_WEB_UI_DESCRIPTION | A free text description of this item. | varchar | 16 | | |||
| SF_SUPPORTS_DATAHIDING | varchar | 1 |
| Index | Description | Primary | Unique |
|---|---|---|---|
| SYSTEM_FIELD_PK | | | |
| SYSTEM_FIELD_UK | |
Related Objects
