Note: | The parameters are related to logical definition, physical structure, and presentation layer, and change based on data type. |
Property | Description | ||
Column | Column name. Used when creating the table in the database. The name cannot be prefixed with any special character, but can contain the special characters - _, $ and #. | ||
Is Logical Column? | Whether the column defines a relationship or contains data. ![]() ![]() ![]() ![]() ![]() | ||
Caption | The name that displays in OneData interfaces. | ||
XML Element Name | The name used in the XSD while generating the XML schema. If not provided, the XML name is the Column name. | ||
Data Type | Data type of the column. The other column properties vary according to the data type. For information about supported data types in OneData, see Oracle Data Types Supported in
OneData and SQL Server Data Types Supported in
OneData .
| ||
Length | The column length. The default length is 255. Applies to numeric, char, varchar, percentage, and sequence data types. | ||
Precision | The column precision, The value of the precision is one more than the number of digits allowed after the decimal point. For numeric, percentage, and timestamp data types.
| ||
Display Length | Column width in pixels. For long descriptions, make the column wider on display grids. | ||
Disable Unicode Data Storage? | Indicates whether to support unicode characters in the column. Applicable only when you use SQL Server for varchar and char data types in OneData. By default, OneData supports unicode characters in SQL Server through the data types nvarchar and nchar in the database. If selected, OneData no longer supports unicode characters and the data types change to varchar and char respectively in the database. | ||
Number of Decimal Digits | The number of digits allowed after the decimal point. For numeric data type. | ||
Sequence Name | Name of the sequence. Select Existing Sequence? if the sequence already exists. Applies to all sequence data types.
| ||
Trigger Name | Name of the trigger. Select Existing Trigger? if the trigger already exists. For database/external sequences.
| ||
Use Specified Value? | Indicates whether to use a specified value. If selected, OneData uses the specified value; otherwise, it generates a sequence number. For optional, contiguous, or external sequences.
| ||
Begin Value | Enter a starting value for the sequence. For Database Sequence.
| ||
End Value | Enter an ending value for the sequence. For Database Sequence.
| ||
Required (Database)? | Indicates if the column is required in the database, in which case the column cannot be null. | ||
Required (Application)? | Indicates whether the column is required. Required columns cannot be null. Enforced only in the application interface. | ||
Default Value | Default value to populate in the column, limited by the data type. For example, you can specify sysdate to show the current date as the default value.
| ||
Default Format | Default format for numeric, date or timestamp value. Depending on the data type, the list of applicable formats change. | ||
Delete? | Whether the column is logically deleted. Logically deleted columns physically exist in the database (or base data objects in case of virtual entities), but are not visible to users. Database required columns cannot be logically deleted. | ||
Enable Advanced Filtering? | Whether the column's advanced filtering options should be visible to the users when the advanced filtering is enabled. | ||
Save in upper case? | Indicates whether to save the value in uppercase, for char and varchar data types. | ||
Edit type | Whether the value in the column is editable. The options include: ![]() ![]() ![]()
| ||
Show in Filter? | Whether the column displays in the filter in Data Manager: ![]() ![]() ![]() | ||
Show in Data Entry? | Whether the column should be displayed in Data Entry screen: ![]() ![]() ![]() ![]()
| ||
Owner | Select the column's owner. Click user name to set the value. You can also filter the user name(s) by entering the filter criteria and clicking the Search Value icon or by pressing Enter. To clear the user selection click
| ||
Group | Select the group to which the column has to be associated. | ||
Description | The text that displays in the column caption on mouse-over (tool tips). To set multiple description columns when working with related objects, see . | ||
Multi-select / Relation table | Select the table that manages many-to-many relationships between the object being created to other objects. Provides a means of single creation/edit point for these relationships. | ||
Multi-select/ Relation column | Table column in the multi-select table designated as the primary key of the object being created. | ||
Multi-select / Relation Display Option | Indicates whether to display the multi-select column as a list box or as a lookup. | ||
Is Description Column? | Check to define the column as a description column.
| ||
Hide in Display Screen? | Indicates whether to hide the column in the Display screen. The column is available in Insert or Edit screens. | ||
Column Qualifier | Additional qualifiers are as follows: ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() For data quality objects, you can use the following qualifiers: ![]() ![]() For information about data quality, see webMethods OneData Consolidation MDM Guide. In hierarchy objects, the following qualifiers are available: ![]() ![]() | ||
Additional Column Qualifiers | The following additional column qualifiers define the column behavior. ![]() ![]() ![]() The following qualifiers apply to CDI Staging objects. For more information about consolidation, see webMethods OneData Consolidation MDM Guide. ![]() ![]() ![]() | ||
Show in Report? | Whether to show the column in reports. The default option is Hide. Other options are: ![]() ![]() ![]() ![]() | ||
Column Width | Set the width for the column. | ||
Validation Regular Expression | Data validation using Oracle Regular Expressions. | ||
Transformation Regular Expression | Data transformation using Oracle Regular Expressions. Not yet functional. | ||
Regular Expression Error Message | Enter the error message to be displayed on failure of regular expression validation. | ||
Column Cost | Internal use to OneData. | ||
Custodian System | A list of custodian systems, one of which can be associated with the column. | ||
Inheritance Qualifier | Default is Inherit/Overwrite. If set to inherit, then the value of the column is copied over when record is copied. | ||
Caption Alignment | Alignment of the column caption. Default is Right. |