Data Schema Editor Characteristics Tab

Use the Data Schema editor Characteristics tab to define valid dates for calendar-type characteristics and to define enumerations (also known as drop down list values) for drop down-type characteristics.

Note:

You can define valid values for characteristics at two different levels: at the schema level (general) and at the specification level (specific). Design Studio evaluates the values defined for characteristics from the general level to the specific level. For example, the characteristic properties defined at the data element level (defined for data elements in the Data Schema editor) are overridden if you define properties for the same characteristic at the specification level (properties defined in the Specification editor).

See "Specification Editor Characteristics Tab" for more information about defining characteristic attributes at the specification level.

Field	Use
Start Date	Select the date on which the characteristic becomes valid.
End Date	Select the date after which the characteristic becomes invalid.
Drop Down Options	Select one of the following: Select Enumerations to populate the drop down list with a set of statically-defined values. See ”Creating Data Element Enumerations” and ”Enumerations Tab” for more information. Select Entity Link to populate the drop down list with the names of all entities created from the selected specification. Use the options in the Entity Link area to complete the configuration. Select Query to populate a drop-down list with the results of the query that you define. Use the options in the Query area to complete the configuration.
Entity Link	If you selected Entity Link in the Drop Down Options field, you can populate the drop down list with the names of all entities created from the selected specification. Do one of the following: Click the Entity link to create and use a new specification. Click Select to use an existing specification.
Query	If you selected Query in the Drop Down Options field, you can populate a drop-down list with the results of the query that you define. To specify the syntax of the query, select from the Data Source list, select JPQL, SQL or USERS. Select JPQL to use JPQL syntax. Select SQL to use SQL syntax. Select USERS to specify a query that populates the drop-down list with all UIM user. If you want to use a filtered data query, do one of the following: Click Parameter if you to want to create a new data element to use in a filtered data query. Click Select to select an existing data element in a filtered data query for the query parameter. Enter the query in the Body field using the selected syntax. No query text is required in you selected USERS.