{"action":"created","comment":{"url":"https://api.github.com/repos/cfpb/hmda-platform/pulls/comments/67243690","id":67243690,"diff_hunk":"@@ -0,0 +1,62 @@\n+# Institutions Data Model\n+\n+This document describes the data model for Financial Institutions in HMDA. \n+A Financial Institution Database is created in HMDA for the purposes of \n+filing mortgage data. The information in this database is used in some edits, \n+as complementary information for publication and analysis of mortgage data, \n+and in the creation of the HMDA Panel. The HMDA Panel is the list of institutions\n+that are required to file HMDA data, every year. \n+\n+The Institutions Database needs to keep historical information for analysis, \n+and at least have information readily available for the two previous years in order\n+to be able to perform the necessary checks when performing validation on the HMDA\n+data being submitted or when composing the HDMA Panel. In addition to this, it must\n+maintain the relationships between institutions (i.e. parent/child relationships)\n+ and the actions that modify them (i.e. mergers, acquisitions). \n+ \n+ \n+The end product is a list of institutions that contains the necessary information \n+so that the HMDA Panel can be processed automatically. This table contains the following\n+information:\n+\n+\n+* `Activity Year` (integer length 4, i.e. 2017)\n+* `Respondent ID` (string length 10)\n+  Unique identifier for the financial institution for HMDA Panel\n+* `Respondent RSSD ID` (string)\n+  Unique identifier for financial institution in NIC. Present for depository\n+  institutions, may not be present for non-depository institutions\n+* `Agency Code` (integer, i.e. 9=CFPB)\n+* `Name` (string)\n+* `Assets` (double)\n+* `Other Lender Code` (i.e. 1=Mtg Bkg Sub(MBS))\n+* `Region` (integer length 2; Agency Office Code)\n+* `Number of Loans` (integer)","path":"Documents/Institutions.md","position":34,"original_position":34,"commit_id":"044be679a7f5ee652b7d90311f5f92ed66f9af0c","original_commit_id":"044be679a7f5ee652b7d90311f5f92ed66f9af0c","user":{"login":"debseidner","id":9748138,"avatar_url":"https://avatars.githubusercontent.com/u/9748138?v=3","gravatar_id":"","url":"https://api.github.com/users/debseidner","html_url":"https://github.com/debseidner","followers_url":"https://api.github.com/users/debseidner/followers","following_url":"https://api.github.com/users/debseidner/following{/other_user}","gists_url":"https://api.github.com/users/debseidner/gists{/gist_id}","starred_url":"https://api.github.com/users/debseidner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/debseidner/subscriptions","organizations_url":"https://api.github.com/users/debseidner/orgs","repos_url":"https://api.github.com/users/debseidner/repos","events_url":"https://api.github.com/users/debseidner/events{/privacy}","received_events_url":"https://api.github.com/users/debseidner/received_events","type":"User","site_admin":false},"body":"@Kibrael Do we need to also store dollar value of loans for depositories since we don't have count?","created_at":"2016-06-15T20:54:17Z","updated_at":"2016-06-15T20:54:17Z","html_url":"https://github.com/cfpb/hmda-platform/pull/381#discussion_r67243690","pull_request_url":"https://api.github.com/repos/cfpb/hmda-platform/pulls/381","_links":{"self":{"href":"https://api.github.com/repos/cfpb/hmda-platform/pulls/comments/67243690"},"html":{"href":"https://github.com/cfpb/hmda-platform/pull/381#discussion_r67243690"},"pull_request":{"href":"https://api.github.com/repos/cfpb/hmda-platform/pulls/381"}}},"pull_request":{"url":"https://api.github.com/repos/cfpb/hmda-platform/pulls/381","id":72714051,"html_url":"https://github.com/cfpb/hmda-platform/pull/381","diff_url":"https://github.com/cfpb/hmda-platform/pull/381.diff","patch_url":"https://github.com/cfpb/hmda-platform/pull/381.patch","issue_url":"https://api.github.com/repos/cfpb/hmda-platform/issues/381","number":381,"state":"open","locked":false,"title":"For discussion: Institutions prototype","user":{"login":"jmarin","id":438146,"avatar_url":"https://avatars.githubusercontent.com/u/438146?v=3","gravatar_id":"","url":"https://api.github.com/users/jmarin","html_url":"https://github.com/jmarin","followers_url":"https://api.github.com/users/jmarin/followers","following_url":"https://api.github.com/users/jmarin/following{/other_user}","gists_url":"https://api.github.com/users/jmarin/gists{/gist_id}","starred_url":"https://api.github.com/users/jmarin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmarin/subscriptions","organizations_url":"https://api.github.com/users/jmarin/orgs","repos_url":"https://api.github.com/users/jmarin/repos","events_url":"https://api.github.com/users/jmarin/events{/privacy}","received_events_url":"https://api.github.com/users/jmarin/received_events","type":"User","site_admin":false},"body":"This PR is meant to gather additional requirements for how the _Institutions Panel_ is used. Initially, just documentation about the data model is provided, to elicit comments from subject matter experts on what is missing or should be corrected. After a few iterations a prototype with possible approaches to coding the institutions database APIs will be presented for discussion. ","created_at":"2016-06-06T14:01:20Z","updated_at":"2016-06-15T20:54:17Z","closed_at":null,"merged_at":null,"merge_commit_sha":"34e5cf3a851759318e812f8258050b76ecc4e507","assignee":null,"milestone":{"url":"https://api.github.com/repos/cfpb/hmda-platform/milestones/10","html_url":"https://github.com/cfpb/hmda-platform/milestones/Sprint%209","labels_url":"https://api.github.com/repos/cfpb/hmda-platform/milestones/10/labels","id":1798876,"number":10,"title":"Sprint 9","description":"","creator":{"login":"ericspry","id":2027141,"avatar_url":"https://avatars.githubusercontent.com/u/2027141?v=3","gravatar_id":"","url":"https://api.github.com/users/ericspry","html_url":"https://github.com/ericspry","followers_url":"https://api.github.com/users/ericspry/followers","following_url":"https://api.github.com/users/ericspry/following{/other_user}","gists_url":"https://api.github.com/users/ericspry/gists{/gist_id}","starred_url":"https://api.github.com/users/ericspry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ericspry/subscriptions","organizations_url":"https://api.github.com/users/ericspry/orgs","repos_url":"https://api.github.com/users/ericspry/repos","events_url":"https://api.github.com/users/ericspry/events{/privacy}","received_events_url":"https://api.github.com/users/ericspry/received_events","type":"User","site_admin":false},"open_issues":44,"closed_issues":29,"state":"open","created_at":"2016-05-31T14:06:32Z","updated_at":"2016-06-15T15:42:23Z","due_on":"2016-06-12T04:00:00Z","closed_at":null},"commits_url":"https://api.github.com/repos/cfpb/hmda-platform/pulls/381/commits","review_comments_url":"https://api.github.com/repos/cfpb/hmda-platform/pulls/381/comments","review_comment_url":"https://api.github.com/repos/cfpb/hmda-platform/pulls/comments{/number}","comments_url":"https://api.github.com/repos/cfpb/hmda-platform/issues/381/comments","statuses_url":"https://api.github.com/repos/cfpb/hmda-platform/statuses/044be679a7f5ee652b7d90311f5f92ed66f9af0c","head":{"label":"jmarin:institutions-prototype","ref":"institutions-prototype","sha":"044be679a7f5ee652b7d90311f5f92ed66f9af0c","user":{"login":"jmarin","id":438146,"avatar_url":"https://avatars.githubusercontent.com/u/438146?v=3","gravatar_id":"","url":"https://api.github.com/users/jmarin","html_url":"https://github.com/jmarin","followers_url":"https://api.github.com/users/jmarin/followers","following_url":"https://api.github.com/users/jmarin/following{/other_user}","gists_url":"https://api.github.com/users/jmarin/gists{/gist_id}","starred_url":"https://api.github.com/users/jmarin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmarin/subscriptions","organizations_url":"https://api.github.com/users/jmarin/orgs","repos_url":"https://api.github.com/users/jmarin/repos","events_url":"https://api.github.com/users/jmarin/events{/privacy}","received_events_url":"https://api.github.com/users/jmarin/received_events","type":"User","site_admin":false},"repo":{"id":50183720,"name":"hmda-platform","full_name":"jmarin/hmda-platform","owner":{"login":"jmarin","id":438146,"avatar_url":"https://avatars.githubusercontent.com/u/438146?v=3","gravatar_id":"","url":"https://api.github.com/users/jmarin","html_url":"https://github.com/jmarin","followers_url":"https://api.github.com/users/jmarin/followers","following_url":"https://api.github.com/users/jmarin/following{/other_user}","gists_url":"https://api.github.com/users/jmarin/gists{/gist_id}","starred_url":"https://api.github.com/users/jmarin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmarin/subscriptions","organizations_url":"https://api.github.com/users/jmarin/orgs","repos_url":"https://api.github.com/users/jmarin/repos","events_url":"https://api.github.com/users/jmarin/events{/privacy}","received_events_url":"https://api.github.com/users/jmarin/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/jmarin/hmda-platform","description":"","fork":true,"url":"https://api.github.com/repos/jmarin/hmda-platform","forks_url":"https://api.github.com/repos/jmarin/hmda-platform/forks","keys_url":"https://api.github.com/repos/jmarin/hmda-platform/keys{/key_id}","collaborators_url":"https://api.github.com/repos/jmarin/hmda-platform/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/jmarin/hmda-platform/teams","hooks_url":"https://api.github.com/repos/jmarin/hmda-platform/hooks","issue_events_url":"https://api.github.com/repos/jmarin/hmda-platform/issues/events{/number}","events_url":"https://api.github.com/repos/jmarin/hmda-platform/events","assignees_url":"https://api.github.com/repos/jmarin/hmda-platform/assignees{/user}","branches_url":"https://api.github.com/repos/jmarin/hmda-platform/branches{/branch}","tags_url":"https://api.github.com/repos/jmarin/hmda-platform/tags","blobs_url":"https://api.github.com/repos/jmarin/hmda-platform/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/jmarin/hmda-platform/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/jmarin/hmda-platform/git/refs{/sha}","trees_url":"https://api.github.com/repos/jmarin/hmda-platform/git/trees{/sha}","statuses_url":"https://api.github.com/repos/jmarin/hmda-platform/statuses/{sha}","languages_url":"https://api.github.com/repos/jmarin/hmda-platform/languages","stargazers_url":"https://api.github.com/repos/jmarin/hmda-platform/stargazers","contributors_url":"https://api.github.com/repos/jmarin/hmda-platform/contributors","subscribers_url":"https://api.github.com/repos/jmarin/hmda-platform/subscribers","subscription_url":"https://api.github.com/repos/jmarin/hmda-platform/subscription","commits_url":"https://api.github.com/repos/jmarin/hmda-platform/commits{/sha}","git_commits_url":"https://api.github.com/repos/jmarin/hmda-platform/git/commits{/sha}","comments_url":"https://api.github.com/repos/jmarin/hmda-platform/comments{/number}","issue_comment_url":"https://api.github.com/repos/jmarin/hmda-platform/issues/comments{/number}","contents_url":"https://api.github.com/repos/jmarin/hmda-platform/contents/{+path}","compare_url":"https://api.github.com/repos/jmarin/hmda-platform/compare/{base}...{head}","merges_url":"https://api.github.com/repos/jmarin/hmda-platform/merges","archive_url":"https://api.github.com/repos/jmarin/hmda-platform/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/jmarin/hmda-platform/downloads","issues_url":"https://api.github.com/repos/jmarin/hmda-platform/issues{/number}","pulls_url":"https://api.github.com/repos/jmarin/hmda-platform/pulls{/number}","milestones_url":"https://api.github.com/repos/jmarin/hmda-platform/milestones{/number}","notifications_url":"https://api.github.com/repos/jmarin/hmda-platform/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/jmarin/hmda-platform/labels{/name}","releases_url":"https://api.github.com/repos/jmarin/hmda-platform/releases{/id}","deployments_url":"https://api.github.com/repos/jmarin/hmda-platform/deployments","created_at":"2016-01-22T13:44:02Z","updated_at":"2016-03-04T22:36:21Z","pushed_at":"2016-06-15T19:14:15Z","git_url":"git://github.com/jmarin/hmda-platform.git","ssh_url":"git@github.com:jmarin/hmda-platform.git","clone_url":"https://github.com/jmarin/hmda-platform.git","svn_url":"https://github.com/jmarin/hmda-platform","homepage":"https://github.com/cfpb","size":4302,"stargazers_count":0,"watchers_count":0,"language":"Scala","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"cfpb:master","ref":"master","sha":"e0326216513a06dbfb459d4066c47bfcab0b5e75","user":{"login":"cfpb","id":1071563,"avatar_url":"https://avatars.githubusercontent.com/u/1071563?v=3","gravatar_id":"","url":"https://api.github.com/users/cfpb","html_url":"https://github.com/cfpb","followers_url":"https://api.github.com/users/cfpb/followers","following_url":"https://api.github.com/users/cfpb/following{/other_user}","gists_url":"https://api.github.com/users/cfpb/gists{/gist_id}","starred_url":"https://api.github.com/users/cfpb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cfpb/subscriptions","organizations_url":"https://api.github.com/users/cfpb/orgs","repos_url":"https://api.github.com/users/cfpb/repos","events_url":"https://api.github.com/users/cfpb/events{/privacy}","received_events_url":"https://api.github.com/users/cfpb/received_events","type":"Organization","site_admin":false},"repo":{"id":50141662,"name":"hmda-platform","full_name":"cfpb/hmda-platform","owner":{"login":"cfpb","id":1071563,"avatar_url":"https://avatars.githubusercontent.com/u/1071563?v=3","gravatar_id":"","url":"https://api.github.com/users/cfpb","html_url":"https://github.com/cfpb","followers_url":"https://api.github.com/users/cfpb/followers","following_url":"https://api.github.com/users/cfpb/following{/other_user}","gists_url":"https://api.github.com/users/cfpb/gists{/gist_id}","starred_url":"https://api.github.com/users/cfpb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cfpb/subscriptions","organizations_url":"https://api.github.com/users/cfpb/orgs","repos_url":"https://api.github.com/users/cfpb/repos","events_url":"https://api.github.com/users/cfpb/events{/privacy}","received_events_url":"https://api.github.com/users/cfpb/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/cfpb/hmda-platform","description":"","fork":false,"url":"https://api.github.com/repos/cfpb/hmda-platform","forks_url":"https://api.github.com/repos/cfpb/hmda-platform/forks","keys_url":"https://api.github.com/repos/cfpb/hmda-platform/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cfpb/hmda-platform/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cfpb/hmda-platform/teams","hooks_url":"https://api.github.com/repos/cfpb/hmda-platform/hooks","issue_events_url":"https://api.github.com/repos/cfpb/hmda-platform/issues/events{/number}","events_url":"https://api.github.com/repos/cfpb/hmda-platform/events","assignees_url":"https://api.github.com/repos/cfpb/hmda-platform/assignees{/user}","branches_url":"https://api.github.com/repos/cfpb/hmda-platform/branches{/branch}","tags_url":"https://api.github.com/repos/cfpb/hmda-platform/tags","blobs_url":"https://api.github.com/repos/cfpb/hmda-platform/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cfpb/hmda-platform/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cfpb/hmda-platform/git/refs{/sha}","trees_url":"https://api.github.com/repos/cfpb/hmda-platform/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cfpb/hmda-platform/statuses/{sha}","languages_url":"https://api.github.com/repos/cfpb/hmda-platform/languages","stargazers_url":"https://api.github.com/repos/cfpb/hmda-platform/stargazers","contributors_url":"https://api.github.com/repos/cfpb/hmda-platform/contributors","subscribers_url":"https://api.github.com/repos/cfpb/hmda-platform/subscribers","subscription_url":"https://api.github.com/repos/cfpb/hmda-platform/subscription","commits_url":"https://api.github.com/repos/cfpb/hmda-platform/commits{/sha}","git_commits_url":"https://api.github.com/repos/cfpb/hmda-platform/git/commits{/sha}","comments_url":"https://api.github.com/repos/cfpb/hmda-platform/comments{/number}","issue_comment_url":"https://api.github.com/repos/cfpb/hmda-platform/issues/comments{/number}","contents_url":"https://api.github.com/repos/cfpb/hmda-platform/contents/{+path}","compare_url":"https://api.github.com/repos/cfpb/hmda-platform/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cfpb/hmda-platform/merges","archive_url":"https://api.github.com/repos/cfpb/hmda-platform/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cfpb/hmda-platform/downloads","issues_url":"https://api.github.com/repos/cfpb/hmda-platform/issues{/number}","pulls_url":"https://api.github.com/repos/cfpb/hmda-platform/pulls{/number}","milestones_url":"https://api.github.com/repos/cfpb/hmda-platform/milestones{/number}","notifications_url":"https://api.github.com/repos/cfpb/hmda-platform/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cfpb/hmda-platform/labels{/name}","releases_url":"https://api.github.com/repos/cfpb/hmda-platform/releases{/id}","deployments_url":"https://api.github.com/repos/cfpb/hmda-platform/deployments","created_at":"2016-01-21T22:39:17Z","updated_at":"2016-05-18T17:14:26Z","pushed_at":"2016-06-15T20:20:47Z","git_url":"git://github.com/cfpb/hmda-platform.git","ssh_url":"git@github.com:cfpb/hmda-platform.git","clone_url":"https://github.com/cfpb/hmda-platform.git","svn_url":"https://github.com/cfpb/hmda-platform","homepage":"","size":5682,"stargazers_count":3,"watchers_count":3,"language":"Scala","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":9,"mirror_url":null,"open_issues_count":103,"forks":9,"open_issues":103,"watchers":3,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/cfpb/hmda-platform/pulls/381"},"html":{"href":"https://github.com/cfpb/hmda-platform/pull/381"},"issue":{"href":"https://api.github.com/repos/cfpb/hmda-platform/issues/381"},"comments":{"href":"https://api.github.com/repos/cfpb/hmda-platform/issues/381/comments"},"review_comments":{"href":"https://api.github.com/repos/cfpb/hmda-platform/pulls/381/comments"},"review_comment":{"href":"https://api.github.com/repos/cfpb/hmda-platform/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/cfpb/hmda-platform/pulls/381/commits"},"statuses":{"href":"https://api.github.com/repos/cfpb/hmda-platform/statuses/044be679a7f5ee652b7d90311f5f92ed66f9af0c"}}}}
{"actor":{"display_login":"debseidner"}}