Bank of America Corporation
Metadata validation tool

Abstract:

A metadata validation tool includes a retrieval engine, an extraction engine, a preparation engine a validation engine, and an export engine. The retrieval engine receives a sequential data file comprising a data table, the data table comprising a plurality of rows and a plurality of columns and the data table further comprising a plurality of data entries, wherein each data entry is placed in the data table at the intersection of one of the plurality of rows and one of the plurality of columns. The extraction engine extracts metadata from the sequential data file for at least one of the plurality of columns of data, wherein the metadata identifies the data table and a plurality of metadata identifiers. The extraction engine determines a metadata identifier for the extracted metadata, wherein the metadata identifier identifies a data field indicating a data type. The extraction engine determines, using the metadata identifier, a general requirement for at least one of the columns of data, the general requirement indicating the required format for each data entry in the at least one of the columns. The preparation engine generates a routine, the routine based on at least the general requirement, wherein the routine facilitates determining whether one or more of the plurality of data entries complies with the general requirement. The validation performs the routine and determines whether one or more rows of the plurality of rows comprises an error, the error indicating that at least one of the data entries of the one or more rows does not comply with the general requirement. Upon a determination that one or more rows of data comprise an error, the export engine generates a consolidated error report, the error report identifying an input row number indicating the one or more rows that contain the error.