Previous Topic

Next Topic

Book Contents

Defining CDD mapping table column properties

After creating a CDD mapping definition table column definition, specify its properties:

  1. Select the table column name in the Data Mappings editor window.
  2. Edit the CDD table column property values in the Properties window.

The following table describes the properties of a CDD mapping table column definition.

Property

Description

Name

RefName of the component.

REQUIRED.

For rules about the use of RefNames, see RefNames

Type

Specifies the column type in the target table. Note that when you create a control mapping, the InForm Architect application attempts to specify an appropriate column type based on the data type of the control. If the control type is not known, the default Type is Text.

  • Date—Data for a complete date and time field. Note that when you map a date and time field, the InForm application actually creates four columns internally:
    • DATE—For a complete date and time
    • _DT suffix—For a date and time field with only date components
    • _TM suffix—For a date and time field with only time components
    • _STR suffix—For an incomplete date and time field
  • Float—Float data. When you map a float field, the InForm application creates three columns internally: one for the entered value, one for the normalized value, and one for the units associated with the value, if any.
  • Numeric—Numeric data. When you map a numeric field, the InForm application creates three columns internally: one for the entered value, one for the normalized value, and one for the units associated with the value, if any.
  • Split Date—Date and time data mapped to six columns, each containing one of the date or time components of the control. Each column has the generated or specified column name and the appropriate one of the following suffixes: _Day, _Mon, _Year, _Hour, _Min, or _Sec.
  • String—String data that is 255 characters long or less.
  • Text—Long varchar data.

    OPTIONAL.

Length

Maximum length of a column, in the range 1 - 255. This property is visible only when the column type is STRING.

REQUIRED. if the column type is STRING.

Design Note

Free-form text, with a maximum of 255 characters, containing any information you want to capture about the design of the component. This information is for documentation only.

OPTIONAL.

Design Note text is not transferred to the target tables.

Send Feedback