Siebel Medical Handheld Guide > Application Administration > Administering Barcode Settings for Siebel Medical Handheld >

About the Barcode Parsing Algorithm Used in Siebel Medical Handheld

Barcode readers are like any other input device. The reader takes a barcode and converts it to a set of characters. Siebel Medical Handheld utilizes a specialized barcode class which defines the algorithm used to parse and automatically validate data from these converted characters. Out of the box, Siebel Medical Handheld can parse data from HIBC and UCC/EAN barcodes but Siebel Administrators can easily define new one-dimensional (1D) barcodes in the Barcode Administrations views.

It is therefore important to understand how Siebel's barcode algorithm will use data defined in the Barcode Administration View to parse information from the barcode. Table 9 defines these applets as well as the underlying business component and tables on which they are based.

SHCE Barcode Item is a child of SHCE Barcode. Thus, for each record in S_Barcode table there are many child records in the S_Barcode_Item table.

The barcode parsing algorithm uses barcode definitions in the Barcode Applet to identify the barcode. It uses the values specified in the Prefix, Min Length, and Max Length fields to find a match. Once it finds a match, it will determine the corresponding values in the Barcode Type and Separator (Ascii #) fields. It will then use this information to parse data from the barcode into property sets as defined in Barcode Item Applet.

The Barcode Type and Separator (Ascii #) fields determine how the child records in the Barcode Item applet will be used to parse data from the barcode.

There are only two types of barcodes. Table 10 describes the type of barcodes standards.

The Separator (Ascii #) field defines the Ascii character that will be used to separate data elements if there is more than one element that is variable (for example, there is more than one record where Min Length is not equal to Max Length in the Barcode Item Applet).

The table below provides examples of how the barcode parsing algorithm will use data in the Barcode Administration views to parse data from Location-based barcode and a Code-Based barcode:

Example of Location Barcode Type

Table 11 provides an example of the Location Barcode type.

Location Barcode Type: HIBC +$$3061211220152LC

Data is parsed based on the child records in the Barcode Item Applet. Since Barcode Type = Location, the parsing algorithm used the sequence listed in Table 12 to parse data from the barcode.

Thus the relevant data that will be parsed from this barcode is as follows:

• Expiry Data = Dec 11, 2006
• Serial Number = 12201
• Lot Number = 52

Example of Code Barcode Type

Table 13 provides an example of the Code Barcode type.

Code Barcode Type: UCC/ EAN ^17040606106654355^2111202^3050

Data Parsed Based on Child Records in Barcode Item Applet. Since Barcode Type = Code and Separator (Ascii#) = 29 (corresponds to ^), the parsing algorithm used the Code and Sequence to parse data from the barcode, and used the ^ character to distinguish variable data elements.

NOTE:  The child records displayed in this table represent only a subset of all Barcode Item child records for Medical UCC/EAN Primary. These represent the child records that have a match in the barcode that we are trying to parse.

Thus the relevant data that will parsed from this barcode is as follows:

• Lot Number = 6654355
• Expiry Date = June 6, 2004
• Serial Number = 11202
• Quantity = 50