{"id":1323,"date":"2022-09-02T14:22:47","date_gmt":"2022-09-02T18:22:47","guid":{"rendered":"https:\/\/myapps.northcarolina.edu\/insight\/?p=1323"},"modified":"2022-09-07T10:31:32","modified_gmt":"2022-09-07T14:31:32","slug":"dyk-unc-ipeds-submission-data-in-redshift","status":"publish","type":"post","link":"https:\/\/myapps.northcarolina.edu\/insight\/2022\/09\/02\/dyk-unc-ipeds-submission-data-in-redshift\/","title":{"rendered":"Did You Know: UNC&#8217;s IPEDS submission data is in Redshift"},"content":{"rendered":"<p>The data that UNC submits to IPEDS is now available through Insight in the AWS Redshift environment. There are new tables in the third_party_data schema following the format:<strong>\u00a0ipeds_submissions_{submission file name and year}<\/strong><\/p>\n<p>To assist with blending to existing IPEDS reporting tables and views, we have also created a series of views in the third_party_data schema:<\/p>\n<ul>\n<li><strong>ipeds_submissions_{submission file name}:<\/strong> These views union all the yearly submission files together into one view<\/li>\n<li><strong>admyyyy, cyyyya, cyyy_b, effyyyyy, etc<\/strong>: These views convert the submission file format to the IPEDS reporting format.<\/li>\n<li><strong>sub_ipeds_{name} : <\/strong>The goal of this view is to pivot certain columns for improved ease of reporting on IPEDS Submission Data. They should match the<em> ipeds_{name} <\/em>IPEDS reporting views<\/li>\n<li><strong>sub_ipeds_{name}_vw:<\/strong> The goal of this view is to take the the results of <em>sub_ipeds_{name}<\/em> and join in the Directory Information details from the HDYYYY files. These views should match the <em>ipeds_{name}_vw <\/em>IPEDS reporting views.<\/li>\n<\/ul>\n<p>For a more detailed description of each new view created, please refer to the &#8220;<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1jFfxU6oTfmz9Y5UXD3o57RLfBLch_r6ffxKOHhvurF8\/edit#gid=1914404397\">HelioCampus IPEDS Views<\/a>&#8221; and &#8220;<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1jFfxU6oTfmz9Y5UXD3o57RLfBLch_r6ffxKOHhvurF8\/edit#gid=1737203501\">IPEDS Raw Tables<\/a>&#8221; tabs in the <a href=\"https:\/\/myapps.northcarolina.edu\/insight\/resources\/?table_filter=datasets\">Insight Data Contents available from the Insight Resources page<\/a>.<\/p>\n<p>As always, your feedback is welcome and encouraged via email to <a href=\"mailto:insight@northcarolina.edu?subject=Dictionary info linked from datasets list\" target=\"_blank\" rel=\"noopener\">insight@northcarolina.edu<\/a>.<\/p>\n<p>The Insight Team<br \/>\n<a href=\"https:\/\/myapps.northcarolina.edu\/insight\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-844\" src=\"https:\/\/myapps.northcarolina.edu\/insight\/wp-content\/uploads\/sites\/19\/2019\/11\/insight-logo.png\" alt=\"UNC Insight logo\" width=\"260\" height=\"84\" \/><\/a><br \/>\nYou can\u00a0<a href=\"https:\/\/lists.northcarolina.edu\/postorius\/lists\/insight-info.lists.northcarolina.edu\/\">subscribe directly<\/a>\u00a0to receive email notices about Insight and Did You Know. <a href=\"https:\/\/myapps.northcarolina.edu\/insight\/did-you-know\/\">Past DYK posts are available on\u00a0a blog<\/a>. If you have Insight access issues or dashboard content questions or concerns, please email\u00a0<a href=\"mailto:insight@northcarolina.edu\">insight@northcarolina.edu<\/a>\u00a0to open a ticket.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The data that UNC submits to IPEDS is now available through Insight in the AWS Redshift environment. There are new tables in the third_party_data schema following the format:\u00a0ipeds_submissions_{submission file name and year} To assist with blending to existing IPEDS reporting tables and views, we have also created a series of views in the third_party_data schema: [&hellip;]<\/p>\n","protected":false},"author":6221,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[28,40],"tags":[67,61],"class_list":["post-1323","post","type-post","status-publish","format-standard","hentry","category-accouncement","category-did-you-know","tag-ipeds","tag-redshift"],"acf":[],"_links":{"self":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts\/1323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/users\/6221"}],"replies":[{"embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/comments?post=1323"}],"version-history":[{"count":1,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts\/1323\/revisions"}],"predecessor-version":[{"id":1324,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts\/1323\/revisions\/1324"}],"wp:attachment":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/media?parent=1323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/categories?post=1323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/tags?post=1323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}