{"action":"created","comment":{"url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls/comments/192440992","pull_request_review_id":125224668,"id":192440992,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDE5MjQ0MDk5Mg==","diff_hunk":"@@ -561,6 +617,53 @@ sql:\n                 USING staging_exam se\n               WHERE se.id = exam_id and se.deleted = true;\n \n+      # ------------ exam_target_score -----------------------------------------------------------------------\n+        exam_target_score:\n+          sql:\n+            insert: >-\n+              INSERT INTO exam_target_score (\n+                id,\n+                exam_id,\n+                target_id,\n+                asmt_id,\n+                student_id,\n+                school_year,\n+                student_relative_residual_score,\n+                standard_met_relative_residual_score,\n+                completed_at,\n+                updated,\n+                update_import_id,\n+                migrate_id\n+                )\n+                SELECT DISTINCT\n+                  sts.id,\n+                  sts.exam_id,\n+                  sts.target_id,\n+                  se.asmt_id,\n+                  se.student_id,\n+                  se.school_year,\n+                  sts.student_relative_residual_score,\n+                  sts.standard_met_relative_residual_score,\n+                  se.completed_at,\n+                  se.updated,\n+                  se.update_import_id,\n+                  se.migrate_id\n+                FROM staging_exam_target_score sts\n+                  JOIN staging_exam se ON se.id = sts.exam_id\n+                  LEFT JOIN exam_target_score e ON e.student_id = se.student_id and e.asmt_id = se.asmt_id and e.school_year = se.school_year\n+                WHERE se.type_id = 3 AND se.latest = true AND e.exam_id IS NULL;","path":"migrate-olap/src/main/resources/application.staging.to.reporting.sql.yml","position":123,"original_position":123,"commit_id":"d9f7aa0331b234818f864ba5d861f1976b6f0cc6","original_commit_id":"d9f7aa0331b234818f864ba5d861f1976b6f0cc6","user":{"login":"malaffoon","id":5097710,"node_id":"MDQ6VXNlcjUwOTc3MTA=","avatar_url":"https://avatars0.githubusercontent.com/u/5097710?v=4","gravatar_id":"","url":"https://api.github.com/users/malaffoon","html_url":"https://github.com/malaffoon","followers_url":"https://api.github.com/users/malaffoon/followers","following_url":"https://api.github.com/users/malaffoon/following{/other_user}","gists_url":"https://api.github.com/users/malaffoon/gists{/gist_id}","starred_url":"https://api.github.com/users/malaffoon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/malaffoon/subscriptions","organizations_url":"https://api.github.com/users/malaffoon/orgs","repos_url":"https://api.github.com/users/malaffoon/repos","events_url":"https://api.github.com/users/malaffoon/events{/privacy}","received_events_url":"https://api.github.com/users/malaffoon/received_events","type":"User","site_admin":false},"body":"This won't hurt of course but shouldn't warehouse-to-staging already have filtered to just summative exam targets?","created_at":"2018-06-01T15:58:28Z","updated_at":"2018-06-01T15:58:28Z","html_url":"https://github.com/SmarterApp/RDW_Ingest/pull/507#discussion_r192440992","pull_request_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls/507","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls/comments/192440992"},"html":{"href":"https://github.com/SmarterApp/RDW_Ingest/pull/507#discussion_r192440992"},"pull_request":{"href":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls/507"}}},"pull_request":{"url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls/507","id":191934185,"node_id":"MDExOlB1bGxSZXF1ZXN0MTkxOTM0MTg1","html_url":"https://github.com/SmarterApp/RDW_Ingest/pull/507","diff_url":"https://github.com/SmarterApp/RDW_Ingest/pull/507.diff","patch_url":"https://github.com/SmarterApp/RDW_Ingest/pull/507.patch","issue_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/issues/507","number":507,"state":"open","locked":false,"title":"Target data migration to Redshift.","user":{"login":"agorina","id":16457484,"node_id":"MDQ6VXNlcjE2NDU3NDg0","avatar_url":"https://avatars2.githubusercontent.com/u/16457484?v=4","gravatar_id":"","url":"https://api.github.com/users/agorina","html_url":"https://github.com/agorina","followers_url":"https://api.github.com/users/agorina/followers","following_url":"https://api.github.com/users/agorina/following{/other_user}","gists_url":"https://api.github.com/users/agorina/gists{/gist_id}","starred_url":"https://api.github.com/users/agorina/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agorina/subscriptions","organizations_url":"https://api.github.com/users/agorina/orgs","repos_url":"https://api.github.com/users/agorina/repos","events_url":"https://api.github.com/users/agorina/events{/privacy}","received_events_url":"https://api.github.com/users/agorina/received_events","type":"User","site_admin":false},"body":"","created_at":"2018-06-01T04:56:08Z","updated_at":"2018-06-01T15:58:28Z","closed_at":null,"merged_at":null,"merge_commit_sha":"8747bec5b67f54d989b0487751dcab7fd760902d","assignee":null,"assignees":[],"requested_reviewers":[{"login":"jtreuting","id":341584,"node_id":"MDQ6VXNlcjM0MTU4NA==","avatar_url":"https://avatars0.githubusercontent.com/u/341584?v=4","gravatar_id":"","url":"https://api.github.com/users/jtreuting","html_url":"https://github.com/jtreuting","followers_url":"https://api.github.com/users/jtreuting/followers","following_url":"https://api.github.com/users/jtreuting/following{/other_user}","gists_url":"https://api.github.com/users/jtreuting/gists{/gist_id}","starred_url":"https://api.github.com/users/jtreuting/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jtreuting/subscriptions","organizations_url":"https://api.github.com/users/jtreuting/orgs","repos_url":"https://api.github.com/users/jtreuting/repos","events_url":"https://api.github.com/users/jtreuting/events{/privacy}","received_events_url":"https://api.github.com/users/jtreuting/received_events","type":"User","site_admin":false},{"login":"wtritch","id":617828,"node_id":"MDQ6VXNlcjYxNzgyOA==","avatar_url":"https://avatars3.githubusercontent.com/u/617828?v=4","gravatar_id":"","url":"https://api.github.com/users/wtritch","html_url":"https://github.com/wtritch","followers_url":"https://api.github.com/users/wtritch/followers","following_url":"https://api.github.com/users/wtritch/following{/other_user}","gists_url":"https://api.github.com/users/wtritch/gists{/gist_id}","starred_url":"https://api.github.com/users/wtritch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wtritch/subscriptions","organizations_url":"https://api.github.com/users/wtritch/orgs","repos_url":"https://api.github.com/users/wtritch/repos","events_url":"https://api.github.com/users/wtritch/events{/privacy}","received_events_url":"https://api.github.com/users/wtritch/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls/507/commits","review_comments_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls/507/comments","review_comment_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls/comments{/number}","comments_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/issues/507/comments","statuses_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/statuses/d9f7aa0331b234818f864ba5d861f1976b6f0cc6","head":{"label":"SmarterApp:feature/target-olap-migrate","ref":"feature/target-olap-migrate","sha":"d9f7aa0331b234818f864ba5d861f1976b6f0cc6","user":{"login":"SmarterApp","id":7026395,"node_id":"MDEyOk9yZ2FuaXphdGlvbjcwMjYzOTU=","avatar_url":"https://avatars0.githubusercontent.com/u/7026395?v=4","gravatar_id":"","url":"https://api.github.com/users/SmarterApp","html_url":"https://github.com/SmarterApp","followers_url":"https://api.github.com/users/SmarterApp/followers","following_url":"https://api.github.com/users/SmarterApp/following{/other_user}","gists_url":"https://api.github.com/users/SmarterApp/gists{/gist_id}","starred_url":"https://api.github.com/users/SmarterApp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SmarterApp/subscriptions","organizations_url":"https://api.github.com/users/SmarterApp/orgs","repos_url":"https://api.github.com/users/SmarterApp/repos","events_url":"https://api.github.com/users/SmarterApp/events{/privacy}","received_events_url":"https://api.github.com/users/SmarterApp/received_events","type":"Organization","site_admin":false},"repo":{"id":81141193,"node_id":"MDEwOlJlcG9zaXRvcnk4MTE0MTE5Mw==","name":"RDW_Ingest","full_name":"SmarterApp/RDW_Ingest","owner":{"login":"SmarterApp","id":7026395,"node_id":"MDEyOk9yZ2FuaXphdGlvbjcwMjYzOTU=","avatar_url":"https://avatars0.githubusercontent.com/u/7026395?v=4","gravatar_id":"","url":"https://api.github.com/users/SmarterApp","html_url":"https://github.com/SmarterApp","followers_url":"https://api.github.com/users/SmarterApp/followers","following_url":"https://api.github.com/users/SmarterApp/following{/other_user}","gists_url":"https://api.github.com/users/SmarterApp/gists{/gist_id}","starred_url":"https://api.github.com/users/SmarterApp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SmarterApp/subscriptions","organizations_url":"https://api.github.com/users/SmarterApp/orgs","repos_url":"https://api.github.com/users/SmarterApp/repos","events_url":"https://api.github.com/users/SmarterApp/events{/privacy}","received_events_url":"https://api.github.com/users/SmarterApp/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/SmarterApp/RDW_Ingest","description":"RDW ingest applications","fork":false,"url":"https://api.github.com/repos/SmarterApp/RDW_Ingest","forks_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/forks","keys_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/keys{/key_id}","collaborators_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/teams","hooks_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/hooks","issue_events_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/issues/events{/number}","events_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/events","assignees_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/assignees{/user}","branches_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/branches{/branch}","tags_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/tags","blobs_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/git/refs{/sha}","trees_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/git/trees{/sha}","statuses_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/statuses/{sha}","languages_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/languages","stargazers_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/stargazers","contributors_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/contributors","subscribers_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/subscribers","subscription_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/subscription","commits_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/commits{/sha}","git_commits_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/git/commits{/sha}","comments_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/comments{/number}","issue_comment_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/issues/comments{/number}","contents_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/contents/{+path}","compare_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/compare/{base}...{head}","merges_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/merges","archive_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/downloads","issues_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/issues{/number}","pulls_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls{/number}","milestones_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/milestones{/number}","notifications_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/labels{/name}","releases_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/releases{/id}","deployments_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/deployments","created_at":"2017-02-06T22:41:51Z","updated_at":"2018-05-29T22:30:38Z","pushed_at":"2018-06-01T04:56:09Z","git_url":"git://github.com/SmarterApp/RDW_Ingest.git","ssh_url":"git@github.com:SmarterApp/RDW_Ingest.git","clone_url":"https://github.com/SmarterApp/RDW_Ingest.git","svn_url":"https://github.com/SmarterApp/RDW_Ingest","homepage":null,"size":3412,"stargazers_count":1,"watchers_count":1,"language":"Java","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":1,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":1,"watchers":1,"default_branch":"develop"}},"base":{"label":"SmarterApp:develop","ref":"develop","sha":"8f574d2f4b314ca0c36d7480a12cd6c85626bf7d","user":{"login":"SmarterApp","id":7026395,"node_id":"MDEyOk9yZ2FuaXphdGlvbjcwMjYzOTU=","avatar_url":"https://avatars0.githubusercontent.com/u/7026395?v=4","gravatar_id":"","url":"https://api.github.com/users/SmarterApp","html_url":"https://github.com/SmarterApp","followers_url":"https://api.github.com/users/SmarterApp/followers","following_url":"https://api.github.com/users/SmarterApp/following{/other_user}","gists_url":"https://api.github.com/users/SmarterApp/gists{/gist_id}","starred_url":"https://api.github.com/users/SmarterApp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SmarterApp/subscriptions","organizations_url":"https://api.github.com/users/SmarterApp/orgs","repos_url":"https://api.github.com/users/SmarterApp/repos","events_url":"https://api.github.com/users/SmarterApp/events{/privacy}","received_events_url":"https://api.github.com/users/SmarterApp/received_events","type":"Organization","site_admin":false},"repo":{"id":81141193,"node_id":"MDEwOlJlcG9zaXRvcnk4MTE0MTE5Mw==","name":"RDW_Ingest","full_name":"SmarterApp/RDW_Ingest","owner":{"login":"SmarterApp","id":7026395,"node_id":"MDEyOk9yZ2FuaXphdGlvbjcwMjYzOTU=","avatar_url":"https://avatars0.githubusercontent.com/u/7026395?v=4","gravatar_id":"","url":"https://api.github.com/users/SmarterApp","html_url":"https://github.com/SmarterApp","followers_url":"https://api.github.com/users/SmarterApp/followers","following_url":"https://api.github.com/users/SmarterApp/following{/other_user}","gists_url":"https://api.github.com/users/SmarterApp/gists{/gist_id}","starred_url":"https://api.github.com/users/SmarterApp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SmarterApp/subscriptions","organizations_url":"https://api.github.com/users/SmarterApp/orgs","repos_url":"https://api.github.com/users/SmarterApp/repos","events_url":"https://api.github.com/users/SmarterApp/events{/privacy}","received_events_url":"https://api.github.com/users/SmarterApp/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/SmarterApp/RDW_Ingest","description":"RDW ingest applications","fork":false,"url":"https://api.github.com/repos/SmarterApp/RDW_Ingest","forks_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/forks","keys_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/keys{/key_id}","collaborators_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/teams","hooks_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/hooks","issue_events_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/issues/events{/number}","events_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/events","assignees_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/assignees{/user}","branches_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/branches{/branch}","tags_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/tags","blobs_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/git/refs{/sha}","trees_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/git/trees{/sha}","statuses_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/statuses/{sha}","languages_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/languages","stargazers_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/stargazers","contributors_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/contributors","subscribers_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/subscribers","subscription_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/subscription","commits_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/commits{/sha}","git_commits_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/git/commits{/sha}","comments_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/comments{/number}","issue_comment_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/issues/comments{/number}","contents_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/contents/{+path}","compare_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/compare/{base}...{head}","merges_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/merges","archive_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/downloads","issues_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/issues{/number}","pulls_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls{/number}","milestones_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/milestones{/number}","notifications_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/labels{/name}","releases_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/releases{/id}","deployments_url":"https://api.github.com/repos/SmarterApp/RDW_Ingest/deployments","created_at":"2017-02-06T22:41:51Z","updated_at":"2018-05-29T22:30:38Z","pushed_at":"2018-06-01T04:56:09Z","git_url":"git://github.com/SmarterApp/RDW_Ingest.git","ssh_url":"git@github.com:SmarterApp/RDW_Ingest.git","clone_url":"https://github.com/SmarterApp/RDW_Ingest.git","svn_url":"https://github.com/SmarterApp/RDW_Ingest","homepage":null,"size":3412,"stargazers_count":1,"watchers_count":1,"language":"Java","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":1,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":1,"watchers":1,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls/507"},"html":{"href":"https://github.com/SmarterApp/RDW_Ingest/pull/507"},"issue":{"href":"https://api.github.com/repos/SmarterApp/RDW_Ingest/issues/507"},"comments":{"href":"https://api.github.com/repos/SmarterApp/RDW_Ingest/issues/507/comments"},"review_comments":{"href":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls/507/comments"},"review_comment":{"href":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/SmarterApp/RDW_Ingest/pulls/507/commits"},"statuses":{"href":"https://api.github.com/repos/SmarterApp/RDW_Ingest/statuses/d9f7aa0331b234818f864ba5d861f1976b6f0cc6"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"malaffoon"}}