{"id":516,"date":"2014-08-08T14:58:06","date_gmt":"2014-08-08T19:58:06","guid":{"rendered":"https:\/\/www.wisconsin.edu\/sfs\/?page_id=516"},"modified":"2020-07-30T13:55:47","modified_gmt":"2020-07-30T18:55:47","slug":"datamart-data-warehouse","status":"publish","type":"page","link":"https:\/\/www.wisconsin.edu\/sfs\/reporting\/datamart-data-warehouse\/","title":{"rendered":"Datamart Data Warehouse"},"content":{"rendered":"\n\t\t\t\t\t<div id=\"cfct-build-516\" class=\"cfct-build grid\">\n\t\t\t\t\t\t<div class=\"row\"><div class=\"col-md-9 cfct-block\">\n\t\t\t<div class=\"cfct-module uwsa-rich-text\">\n\t\t\t\t<div class=\"cfct-mod-content copy\"><p>The Wisconsin Data Mart (WISDM) is a custom built data warehouse to hold UW financial information. This web-based application has multiple pages that display summary and detail data for selected departments, projects, purchase orders, vouchers, vendors and payroll\/encumbrances.<\/p>\n<p>Below are the data dictionaries for the Data Mart.<\/p>\n<\/div>\n\t\t\t<\/div>\n\t\t\t<div class=\"cfct-module uwsa-doc-list\">\n\t\t\t\t\n<div class=\"doc-list\">\r\n<ul class=\"list-unstyled\"><li><span class=\"doc-icon\"><a class=\"doc-type xlsx\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/APPO-Data-Dictionary.xlsx\" target=\"_blank\">APPO Data Dictionary<span class=\"sr-only\"> xlsx<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/award-certifications.pdf\" target=\"_blank\">Award Certifications<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/award-funding-actions.pdf\" target=\"_blank\">Award Funding Actions<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/award-investigator.pdf\" target=\"_blank\">Award Investigators<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/award-milestones.pdf\" target=\"_blank\">Award Milestones<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/award-terms.pdf\" target=\"_blank\">Award Terms<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/awards-(1).pdf\" target=\"_blank\">Awards<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type xlsx\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/EX_Data_dictionary.xlsx\" target=\"_blank\">Expense Data Dictionary<span class=\"sr-only\"> xlsx<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/gl-star.pdf\" target=\"_blank\">GL Star<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/grants-department-contacts.pdf\" target=\"_blank\">Grants Department Contacts<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/payroll-star.pdf\" target=\"_blank\">Payroll Star<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type xlsx\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/PCard-Data-Dictionary.xlsx\" target=\"_blank\">PCard Data Dictionary<span class=\"sr-only\"> xlsx<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/project-accounting.pdf\" target=\"_blank\">Project Accounting<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/project-commitments.pdf\" target=\"_blank\">Project Commitments<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/project-investigators.pdf\" target=\"_blank\">Project Investigators<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/Project-type-codes.pdf\" target=\"_blank\">Project Types and Definitions<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/projects.pdf\" target=\"_blank\">Projects<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/regent-summary-report.pdf\" target=\"_blank\">Regent Summary Report<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/sponsors.pdf\" target=\"_blank\">Sponsors<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/wisper-document-investigators.pdf\" target=\"_blank\">WISPER Document Investigators<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/wisper-document-personnel.pdf\" target=\"_blank\">WISPER Document Personnel<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/data_mart_dictionaries\/WISPER_DOCUMENTS.pdf\" target=\"_blank\">WISPER Documents<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<\/div>\n\t\t\t<\/div><\/div><div class=\"col-md-3 cfct-block\"><\/div><\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t","protected":false},"excerpt":{"rendered":"","protected":false},"author":18,"featured_media":0,"parent":363,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-516","page","type-page","status-publish","hentry","cfct-can-haz-build"],"_links":{"self":[{"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/pages\/516","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/comments?post=516"}],"version-history":[{"count":1,"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/pages\/516\/revisions"}],"predecessor-version":[{"id":11064,"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/pages\/516\/revisions\/11064"}],"up":[{"embeddable":true,"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/pages\/363"}],"wp:attachment":[{"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/media?parent=516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}