{"action":"opened","issue":{"url":"https://api.github.com/repos/chap-uzima/DataWarehouse/issues/18","repository_url":"https://api.github.com/repos/chap-uzima/DataWarehouse","labels_url":"https://api.github.com/repos/chap-uzima/DataWarehouse/issues/18/labels{/name}","comments_url":"https://api.github.com/repos/chap-uzima/DataWarehouse/issues/18/comments","events_url":"https://api.github.com/repos/chap-uzima/DataWarehouse/issues/18/events","html_url":"https://github.com/chap-uzima/DataWarehouse/issues/18","id":372443458,"node_id":"MDU6SXNzdWUzNzI0NDM0NTg=","number":18,"title":"TX_NET_NEW Queries","user":{"login":"chris-githu","id":13725334,"node_id":"MDQ6VXNlcjEzNzI1MzM0","avatar_url":"https://avatars2.githubusercontent.com/u/13725334?v=4","gravatar_id":"","url":"https://api.github.com/users/chris-githu","html_url":"https://github.com/chris-githu","followers_url":"https://api.github.com/users/chris-githu/followers","following_url":"https://api.github.com/users/chris-githu/following{/other_user}","gists_url":"https://api.github.com/users/chris-githu/gists{/gist_id}","starred_url":"https://api.github.com/users/chris-githu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chris-githu/subscriptions","organizations_url":"https://api.github.com/users/chris-githu/orgs","repos_url":"https://api.github.com/users/chris-githu/repos","events_url":"https://api.github.com/users/chris-githu/events{/privacy}","received_events_url":"https://api.github.com/users/chris-githu/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-10-22T09:02:29Z","updated_at":"2018-10-22T09:02:29Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"Hi @vogoti \r\nThese are some of the queries used last quarter.\r\nThey are not very well formatted but I hope you'll be able to figure your way around them.\r\nHopefully you still have Q3 DBs (and Q2)  somewhere.\r\n\r\n[CHAP_AllART.txt](https://github.com/chap-uzima/DataWarehouse/files/2500718/CHAP_AllART.txt)\r\n[CHAP_TXNEW_Q3.txt](https://github.com/chap-uzima/DataWarehouse/files/2500719/CHAP_TXNEW_Q3.txt)\r\n[Current Q2 Exits.txt](https://github.com/chap-uzima/DataWarehouse/files/2500720/Current.Q2.Exits.txt)\r\n[FullJoin.txt](https://github.com/chap-uzima/DataWarehouse/files/2500721/FullJoin.txt)\r\n[Graduated.txt](https://github.com/chap-uzima/DataWarehouse/files/2500722/Graduated.txt)\r\n[New ART Exits Line List.txt](https://github.com/chap-uzima/DataWarehouse/files/2500723/New.ART.Exits.Line.List.txt)\r\n[New Exits.txt](https://github.com/chap-uzima/DataWarehouse/files/2500724/New.Exits.txt)\r\n[New Graduated.txt](https://github.com/chap-uzima/DataWarehouse/files/2500725/New.Graduated.txt)\r\n[Reinitiated Q3.txt](https://github.com/chap-uzima/DataWarehouse/files/2500726/Reinitiated.Q3.txt)\r\n[TransferInQ3.txt](https://github.com/chap-uzima/DataWarehouse/files/2500727/TransferInQ3.txt)\r\n[TX_CURR_Q2.txt](https://github.com/chap-uzima/DataWarehouse/files/2500728/TX_CURR_Q2.txt)\r\n[TX_CURR_Q3.txt](https://github.com/chap-uzima/DataWarehouse/files/2500729/TX_CURR_Q3.txt)\r\n[TXCURRQ2-SummaryByAgeGroup.txt](https://github.com/chap-uzima/DataWarehouse/files/2500731/TXCURRQ2-SummaryByAgeGroup.txt)\r\n\r\nLet me know if you need any assistance.\r\n\r\n"}}
{"actor":{"display_login":"chris-githu"}}