# ValidateIDData

Performs validation, which conforms to MIL-STD 130 and GS1, of the data decoded from an ID Code that is initially read by the ReadIDMax function Functions are tools that are available in Spreadsheet for processing and analyzing acquisitions or other results. You can add functions to your Spreadsheet job to create tool chains and produce results for specific applications..

Note: The referenced ReadIDMax function must have the Verify parameter enabled.
Inputs

Parameter | Description
IDCode | This argument must reference a spreadsheet cell that contains a valid IDMax data structure returned by the ReadIDMax function. Note: The Verify parameter must be enabled.
Validation Options | Specifies which validation option is used.
0 = Data Qualifiers (Default) | Specifies that the data qualifiers (a specified character, or string of characters, that immediately precedes data, which defines the general category or intended use of the data that follows) in the data are valid and the characters that follow each data qualifier conform in type, length and value. Three categories of data qualifiers can be validated: Application Identifiers (AIs) – Format 05 of ISO/IEC 15434 Data Identifiers (DIs) – Format 06 of ISO/IEC 15434 Text Element Identifiers (TEIs)
1 = ISO 15434 | Specifies ISO 15434 as the validation option. For more information, see: www.iso.ch/iso/en/ISOOnline.openerpage.
2 = DoD UID | Specifies the Department of Defense (DoD) Unique Identification (UID) as the validation option. For more information, see: https://www.acq.osd.mil/asda/dpc/ce/ds/unique-id.html or https://dodprocurementtoolbox.com/site-pages/unique-id. Note: The DoD minimum machine-readable information (MRI) symbology requirement is the Data Matrix ECC200 symbol defined by the ISO 16022 specification.
3 = GS1 | Specifies GS1 standards as the validation option. The latest supported version of the GS1 standard is the September 2024 version. For more information, see www.gs1.org.
4 = securPharm (strict) | Specifies "strict" securPharm (a German pharmaceutical industry barcode packaging system using DataMatrix symbols) as the validation option. Requires that Pharmacy Product Number (PPN), Serial Number, Lot and Expiration (GTIN is optional) be included.
5 = securPharm (loose) | Specifies "loose" securPharm (a German pharmaceutical industry barcode packaging system using DataMatrix symbols) as the validation option. Requires that only PPN be included, with the other information being optional.
DoD UID Construct | Specifies type of DoD UID Construct to validate. Note: This parameter is only enabled when DoD UID is the selected value for the Validation Options parameter.
0 = Either DoD UID Construct #1 or Construct #2 (Default) | Specifies either DoD UID Construct #1 or Construct #2 as the validation option. When complying with the DoD Construct #1 UID, all fields are validated and must contain, at a minimum: Enterprise ID Serial Number within the enterprise ID When complying with the DoD Construct #2 UID, all fields are validated and must contain, at a minimum: Enterprise ID Original part, lot or batch number Serial Number within the original part, lot or batch number Current part, lot or batch number
1 = DoD UID Construct #1 | Specifies DoD UID Construct #1 as the validation option.
2 = DoD UID Construct #2 | Specifies DoD UID Construct #2 as the validation option.

Outputs

Returns | An IDValid data structure containing validation metrics of the symbol or #ERR if any of the input parameters are invalid.
Results | When the function is initially inserted into a cell, the validation status automatically appears in the adjacent cell to the right of the IDValid data structure, along with an applicable information string. When the ValidateIDData function is initially created, the following Vision Data Access functions are automatically inserted into the spreadsheet to create the result table:
Label | Function | Description
Index |  | Indexed position
Valid | GetValid(IDValid) | The validity of the data (0 = not valid, 1 = valid).
Diagnostic Info | GetDiagnosticString(IDValid) | Returns an applicable diagnostic information string.
Additional data elements can be accessed using the IDValidate Vision Data Access functions.