Create an application to enable a user to combine up to 4 disparate “files” into one “match” and one “no match with reason codes” output. Determination for output is through user defined matching logic business rules, eliminated dupes, combine similar and identical names/addresses, improve deficient addresses with data from good or better addresses, and identify addresses that cannot be improved. Overall structure to be that of a web service/API with a UI that consumes that API.
The following is a list of tools that GrayHair Software (GHS) has licensed and are available to use, development is not limited to these tools, but any tools outside of this list should be approved by GHS prior to their use, including open source tools.
- Microsoft SQL
- DataRight (Name Parsing)
- ACE 9 CASS Software (Address Hygiene)
The ability to upload multiple files (up to 4) simultaneously to the system.
The files will contain plain text data in fixed width, DBF and/or delimited format.
The user will need to identify the fields to be included and excluded from the match and label the fields using the UI and API.
The user will need to select the fields for use in matching (up to 7) and the type of matching that will be used (exact, not-exact).
The user will need to identify what fields will be included in each output (based on the input file fields) and which types of match(s) will be included in each file.
Once process completes create a transaction log containing rules applied and the results per input record.
Users will have a tab or access via the API where they can view current and past jobs and have a link/URL to the output from jobs that are 30 or less old.
The API will need to return either the output or a failure/reason code.