Meta-data about data fields in other tables. Stores settings from project entity customizations and system defaults.
Column Name | Description | Datatype | Length | Allow Nulls |
|
---|---|---|---|---|---|
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 | 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
|
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 |
Index | Primary | Unique |
---|---|---|
SF_PRIMARYKEY |
Copyright 2002-2007 Mercury Interactive Corporation. |
|
Documentation comments or suggestions? Please send feedback to SW-Doc@hp.com |