{"id":117,"date":"2025-11-14T14:05:35","date_gmt":"2025-11-14T14:05:35","guid":{"rendered":"https:\/\/www.wisconsin.edu\/education-reports-statistics-new\/?page_id=117"},"modified":"2026-02-16T20:17:52","modified_gmt":"2026-02-16T20:17:52","slug":"cdr-database-views","status":"publish","type":"page","link":"https:\/\/www.wisconsin.edu\/education-reports-statistics\/data-management\/central-data-request\/cdr-database-views\/","title":{"rendered":"Database Views"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:25%\"><nav class=\"is-responsive wp-block-navigation is-layout-flex wp-block-navigation-is-layout-flex\" aria-label=\"CDR Quick Links\" \n\t\t data-wp-interactive=\"core\/navigation\" data-wp-context='{\"overlayOpenedBy\":{\"click\":false,\"hover\":false,\"focus\":false},\"type\":\"overlay\",\"roleAttribute\":\"\",\"ariaLabel\":\"Menu\"}'><button aria-haspopup=\"dialog\" aria-label=\"Open menu\" class=\"wp-block-navigation__responsive-container-open\" \n\t\t\t\tdata-wp-on--click=\"actions.openMenuOnClick\"\n\t\t\t\tdata-wp-on--keydown=\"actions.handleMenuKeydown\"\n\t\t\t><svg width=\"24\" height=\"24\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M4 7.5h16v1.5H4z\"><\/path><path d=\"M4 15h16v1.5H4z\"><\/path><\/svg><\/button>\n\t\t\t\t<div class=\"wp-block-navigation__responsive-container\"  id=\"modal-1\" \n\t\t\t\tdata-wp-class--has-modal-open=\"state.isMenuOpen\"\n\t\t\t\tdata-wp-class--is-menu-open=\"state.isMenuOpen\"\n\t\t\t\tdata-wp-watch=\"callbacks.initMenu\"\n\t\t\t\tdata-wp-on--keydown=\"actions.handleMenuKeydown\"\n\t\t\t\tdata-wp-on--focusout=\"actions.handleMenuFocusout\"\n\t\t\t\ttabindex=\"-1\"\n\t\t\t>\n\t\t\t\t\t<div class=\"wp-block-navigation__responsive-close\" tabindex=\"-1\">\n\t\t\t\t\t\t<div class=\"wp-block-navigation__responsive-dialog\" \n\t\t\t\tdata-wp-bind--aria-modal=\"state.ariaModal\"\n\t\t\t\tdata-wp-bind--aria-label=\"state.ariaLabel\"\n\t\t\t\tdata-wp-bind--role=\"state.roleAttribute\"\n\t\t\t>\n\t\t\t\t\t\t\t<button aria-label=\"Close menu\" class=\"wp-block-navigation__responsive-container-close\" \n\t\t\t\tdata-wp-on--click=\"actions.closeMenuOnClick\"\n\t\t\t><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\" aria-hidden=\"true\" focusable=\"false\"><path d=\"m13.06 12 6.47-6.47-1.06-1.06L12 10.94 5.53 4.47 4.47 5.53 10.94 12l-6.47 6.47 1.06 1.06L12 13.06l6.47 6.47 1.06-1.06L13.06 12Z\"><\/path><\/svg><\/button>\n\t\t\t\t\t\t\t<div class=\"wp-block-navigation__responsive-container-content\" \n\t\t\t\tdata-wp-watch=\"callbacks.focusFirstElement\"\n\t\t\t id=\"modal-1-content\">\n\t\t\t\t\t\t\t\t<ul class=\"wp-block-navigation__container is-responsive wp-block-navigation\"><li class=\" wp-block-navigation-item wp-block-navigation-link\"><a class=\"wp-block-navigation-item__content\"  href=\"https:\/\/www.wisconsin.edu\/education-reports-statistics\/data-management\/central-data-request\/cdr-liaisons\/\"><span class=\"wp-block-navigation-item__label\">CDR Liaisons<\/span><\/a><\/li><li class=\" wp-block-navigation-item wp-block-navigation-link\"><a class=\"wp-block-navigation-item__content\"  href=\"https:\/\/www.wisconsin.edu\/education-reports-statistics\/data-management\/central-data-request\/cdr-manual\/\"><span class=\"wp-block-navigation-item__label\">CDR Manual<\/span><\/a><\/li><li class=\" wp-block-navigation-item wp-block-navigation-link\"><a class=\"wp-block-navigation-item__content\"  href=\"https:\/\/www.wisconsin.edu\/education-reports-statistics\/data-management\/central-data-request\/submission-schedules\/\"><span class=\"wp-block-navigation-item__label\">Submission Schedules<\/span><\/a><\/li><li class=\" wp-block-navigation-item wp-block-navigation-link\"><a class=\"wp-block-navigation-item__content\"  href=\"https:\/\/www.wisconsin.edu\/education-reports-statistics\/data-management\/central-data-request\/cdr-database-views\/\"><span class=\"wp-block-navigation-item__label\">Database Views<\/span><\/a><\/li><\/ul>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div><\/nav><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:75%\">\n<p>Data submitted through the Central Data Request (CDR) are stored in a data warehouse maintained by the Universities of Wisconsin Administration (UWSA). Authorized staff at Universities of Wisconsin may access the data warehouse through several database views.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Authorization<\/h2>\n\n\n\n<p>As data custodian, OPAR reserves the right to grant or deny access to CDR database views. Because the CDR contains individual student records subject to federal privacy laws, access to CDR database views is granted only to UW staff whose assigned duties include working with equivalent student records at their UW institution. To request data access, complete a&nbsp;<a href=\"https:\/\/www.wisconsin.edu\/uwsa\/ots-helpdesk\/make-a-request\/\" target=\"_blank\" rel=\"noreferrer noopener\">Data Access Authorization Request form<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Accessing<\/strong>&nbsp;the<strong>&nbsp;Views<\/strong><\/h2>\n\n\n\n<p>Authorized users can access CDR database views in several ways.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the CEUS or IAIS applications, if you already have them installed<\/li>\n\n\n\n<li>Use other database and statistical software packages, once an Oracle connection client is installed. For assistance, contact&nbsp;<a href=\"mailto:jennifer.white@wisconsin.edu\">Jennifer White<\/a>, in OPAR.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tips for<\/strong>&nbsp;Using<strong>&nbsp;CDR Database Views<\/strong><\/h2>\n\n\n\n<p>The CDR database is very large. It contains student and curricular data from all institutions starting in 1973-74 and financial aid data from 1977-78. Here are some tips to make access go more smoothly:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Filter or aggregate data before you download it. Many client tools typically retrieve all the data to the local computer before running an analysis. Since the CDR is a very large database, use the WHERE or GROUP BY clauses of the initial SQL retrieval statement to filter or aggregate the data before downloading it to your local computer.<\/li>\n\n\n\n<li>Test your queries on a single year. Some queries \u2013 even those that filter or aggregate data \u2013 may take as long as 30 minutes to run if they select many years of data. Before querying all years of interest, test your query on a single year.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Documentation<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.wisconsin.edu\/education-reports-statistics\/wp-content\/uploads\/sites\/364\/2025\/11\/Views_Shortlist_11-2023.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Overview of CDR Views and Computed Fields<\/a>\u00a0. Contact\u00a0<a href=\"mailto:jennifer.white@wisconsin.edu\" target=\"_blank\" rel=\"noreferrer noopener\">Jennifer White<\/a>\u00a0, in OPAR, with questions about this document.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.wisconsin.edu\/education-reports-statistics\/wp-content\/uploads\/sites\/364\/2025\/11\/dataviews_MAAD.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">MAAD View Documentation<\/a>&nbsp;. Contact&nbsp;<a href=\"mailto:daniel.younan@wisconsin.edu\" target=\"_blank\" rel=\"noreferrer noopener\">Dan Younan<\/a>, in OPAR, with questions about this document.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.wisconsin.edu\/education-reports-statistics\/wp-content\/uploads\/sites\/364\/2025\/11\/DataViews_Retention.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Retention and Graduation Analysis System<\/a>&nbsp;. Contact&nbsp;<a href=\"mailto:daniel.younan@wisconsin.edu\" target=\"_blank\" rel=\"noreferrer noopener\">Dan Younan<\/a>&nbsp;or&nbsp;<a href=\"mailto:david.blough@wisconsin.edu\" target=\"_blank\" rel=\"noreferrer noopener\">David Blough<\/a>, in OPAR, with questions about this document.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Data submitted through the Central Data Request (CDR) are stored in a data warehouse maintained by the Universities of Wisconsin Administration (UWSA). Authorized staff at Universities of Wisconsin may access the data warehouse through several database views. Authorization As data custodian, OPAR reserves the right to grant or deny access to CDR database views. Because [&hellip;]<\/p>\n","protected":false},"author":6468,"featured_media":0,"parent":47,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-117","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.wisconsin.edu\/education-reports-statistics\/wp-json\/wp\/v2\/pages\/117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wisconsin.edu\/education-reports-statistics\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.wisconsin.edu\/education-reports-statistics\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.wisconsin.edu\/education-reports-statistics\/wp-json\/wp\/v2\/users\/6468"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wisconsin.edu\/education-reports-statistics\/wp-json\/wp\/v2\/comments?post=117"}],"version-history":[{"count":4,"href":"https:\/\/www.wisconsin.edu\/education-reports-statistics\/wp-json\/wp\/v2\/pages\/117\/revisions"}],"predecessor-version":[{"id":920,"href":"https:\/\/www.wisconsin.edu\/education-reports-statistics\/wp-json\/wp\/v2\/pages\/117\/revisions\/920"}],"up":[{"embeddable":true,"href":"https:\/\/www.wisconsin.edu\/education-reports-statistics\/wp-json\/wp\/v2\/pages\/47"}],"wp:attachment":[{"href":"https:\/\/www.wisconsin.edu\/education-reports-statistics\/wp-json\/wp\/v2\/media?parent=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}