/
HMDA Schema and Datapoints

HMDA Schema and Datapoints

 

Meeting overview, FCT LOANS Technical team, 4/2/2015

Present: Dean Allemang, Jim Cooper

The aim of this meeting was to review the assets that we’ve created in the past three months, just to catalogue and understand them.   We achieved that:  Here they are:

  1. Jim has created an OWL file from the master MISMO XSDs that are available from MISMO.  He has not included any of the object properties from this model, because many of them are defined in xlink (which we can translate easily enough into RDFS, but we’d have to do something special for it), but more to the point, there aren’t a lot of distinctions in these xlinks to make these object properties very interesting.
  2. More interesting were the interpretations Jim has done of selected subsets of MISMO that Jim has done, in particular HMDA and URLA. These reflect the well-known relationships between loans, collateral and borrower.  

     
    The diagram shows that there are three components of a Deal, namely Loan and Collateral.   Subject_Property can serve as Collateral.  The Borrower has an obligation for the Loan.
  3. This structure also connects to the datapoints that the MISMO team has been working with in their spreadsheet.  For example, as part of the HMDA declaration, the borrower discloses their Race, which includes one of a specified set of Race Types. 

     
  4. Finally, the Race Type includes a list of race types, according to the legislation behind this declaration requirement.  These are the seven values from the MISMO spreadsheet that Lynn and Mark have been developing:

    Conclusions

    The MISMO models from the XSDs reflect an accessible understanding of the structure of a Deal (including Loans). A good deal of the value provided by MISMO is the sets of values that are required by the regulations (e.g., the list of allowable values for Race for HMDA declarations).  These values comes from a number of sources, as documented in the spreadsheet that Mark and Lynn are maintaining.

    If we turn these into classes of SKOS concepts, we can integrate the models directly, by changing the properties that refer to these data points to object properties, as shown in the diagram above for HDMARaceType.

    The class diagram shows the relationship between domain concepts (e.g., Borrower, Loan, Declaration and Race) and the allowed values (Asian, American Indian, etc.).