This page is used to select ODBC and constant data fields for linkage or mapping to HL7 message fields.
Data Source Selection - Select an ODBC data source from the list of available sources on your system. This list corresponds to the list displayed by the MS ODBC 32 administrator utility. For each data source selected, a node is added to the data tree view. Selection of a data source activates the list of datasets for that data source. Operationally, select a data source then select it's datasets then go on to select the next data source and so on.
Dataset Selection - Select one or more datasets from either the Table or Stored Procedure list boxes. Alternatively you may enter a query by giving it a name and entering the query text. Queries may be entered ad hoc, or pasted from some other SQL modeling tool such as MS SQL or Crystal Reports etc.
Selection of a dataset or clicking the Add Query Fields button will add a node for the dataset and nodes for each of the fields within the dataset.
Constants/Non-Active Links - Constants and non active links are added to the data tree under the Constants node. This provides a means for linking to non-database derived fields, typically static in nature. For example the field separator and encoding characters are supplied as default values under this node. Three different types of nodes are catagorized: Constant, Executable and Information only. The executable designation is meant to code for some sort of RPC that might be called to get the field value. Information only type nodes provide a means of linking field specific instructions or explanations into the specification document.
Available Fields - At the lowest level, the data tree window shows the fields available for linking to message fields. This same tree is also displayed on the Message Definition Page where the linking is done. Fields are indicated by a blue dot when they haven't been linked. Fields that have been linked show a check mark. A field with a boxed check mark indicates that this field has been linked to more than one message field (the second and succeeding links are added as child nodes to the field, and have blue checkmarks.
If a specification with defined data sources is reloaded at a later time and the data source its datasets or individual fields are no longer available on the system, the affected elements will show a non-active status indicator in the data tree.
Record set viewer - Selection of an active dataset causes a grid to appear with a list of records from the dataset. You may browse through the records. The Apply as e.g. button allows you to select one of the records to be used as an example. Any of the fields linked in the message to these dataset fields will have its Example data parameter changed to the values contained in the selected record.