{"id":1104,"date":"2021-01-06T09:55:21","date_gmt":"2021-01-06T14:55:21","guid":{"rendered":"https:\/\/myapps.northcarolina.edu\/insight\/?p=1104"},"modified":"2021-08-19T09:37:28","modified_gmt":"2021-08-19T13:37:28","slug":"dyk-columns-dropped","status":"publish","type":"post","link":"https:\/\/myapps.northcarolina.edu\/insight\/2021\/01\/06\/dyk-columns-dropped\/","title":{"rendered":"Did You Know: Effective 1\/31, columns will be dropped from Insight datasets"},"content":{"rendered":"<p>As mentioned during the previous two monthly Insight community calls on 11\/13 and 12\/11\/2020, some columns will be dropped from the following datasets effective 1\/31\/2021:<br \/>\n\u2022 Applications<br \/>\n\u2022 Career<br \/>\n\u2022 Completions Student<br \/>\n\u2022 Credit Awarded<br \/>\n\u2022 Enrollments<br \/>\n\u2022 Financial Aid Award Detail Full<br \/>\n\u2022 Term<br \/>\n\u2022 Tests<\/p>\n<p>The columns being dropped do not appear in the Student Data Mart (SDM) data dictionary, and were added early on to facilitate dashboard development. Since then, other columns have been added to SDM or used to develop the dashboards. Additionally, some IPEDS directory information was added to some SDM datasets that will be dropped; that will continue to be available in the IPEDS datasets. The complete list of columns to be dropped appears below<strong>***<\/strong>.<\/p>\n<p>In December, anyone impacted with content on Tableau Server, or in a campus&#8217; Redshift sandbox schema that use any of these datasets, or anyone identifying automation or processes that rely on any of these objects, was notified directly. Anyone interested or responding was provided testing datasets or a testing schema environment with campus versions of the new SDM objects for assessing the impact of these changes, and planning the updates required by 1\/31\/2021.<\/p>\n<p>A preview of the new datasets is available if you&#8217;d like to access it. To do so, or if you have any questions or need assistance, please feel free to reach out to <a href=\"mailto:insight@northcarolina.edu\">insight@northcarolina.edu<\/a>.<\/p>\n<p>The Insight Team<\/p>\n<p><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\" \/><\/p>\n<p><strong>***<\/strong> List of columns being dropped<strong> ***<\/strong><\/p>\n<div class=\"wptm_table tablesorter-bootstrap \" data-id=\"4\" data-hightlight=\"0\">\n<div class=\"wptm_buttons buttons_wptmTbl4\"><\/div>\n<p>table is empty<script>window.wptm_ajaxurl = 'https:\/\/myapps.northcarolina.edu\/insight\/wp-admin\/admin-ajax.php?juwpfisadmin=false&action=Wptm&'; window.wptm_front = 'https:\/\/myapps.northcarolina.edu\/insight\/wp-content\/plugins\/wp-table-manager\/app\/site\/assets\/'; window.wptm_style = 'https:\/\/myapps.northcarolina.edu\/insight\/wp-content\/uploads\/sites\/19\/wptm\/';<\/script><\/div>\n<style><\/style>\n<p>You 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. Past DYK posts are available on\u00a0<a href=\"https:\/\/myapps.northcarolina.edu\/insight\/did-you-know\/\">a blog here<\/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>As mentioned during the previous two monthly Insight community calls on 11\/13 and 12\/11\/2020, some columns will be dropped from the following datasets effective 1\/31\/2021: \u2022 Applications \u2022 Career \u2022 Completions Student \u2022 Credit Awarded \u2022 Enrollments \u2022 Financial Aid Award Detail Full \u2022 Term \u2022 Tests The columns being dropped do not appear in [&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":[],"class_list":["post-1104","post","type-post","status-publish","format-standard","hentry","category-accouncement","category-did-you-know"],"acf":[],"_links":{"self":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts\/1104","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=1104"}],"version-history":[{"count":5,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts\/1104\/revisions"}],"predecessor-version":[{"id":1243,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts\/1104\/revisions\/1243"}],"wp:attachment":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/media?parent=1104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/categories?post=1104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/tags?post=1104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}