Here are some of the requirements for this project:
- we want to eliminate all records where Creditor field is blank
- we want to delete records from the "Filing" column which include any
of theses terms: Release, Vacated, Satisfied. However, we need to
delete ALL the records associated with that judgment. The sample
data sent yesterday had some of those examples highlighted.
- when getting rid of duplicate records, we need to key off of more
than just the name, as the name can sometimes be slightly different
even on related records. Perhaps we can also key off "Judgment
Amount" and/or "File Date" to make the connections.
- we need ability to manually input a list of Creditor Names that we
want removed from the list
-- this will change from state to state, but it would be good if we
could develop this so that we can save a list from a specific
state to be used anytime we may run records from that state
Please ask any additional question you have to help you understand the scope of this project