Florida Health Status Indicators Web Portal User Manual
Contents
1. Family Data Center College of Medicine University of Florida i Florida Health Status Indicators Web Portal User Manual 2013 1 0 GENERAL INFORMATION 1 1 System Overview The University of Florida Family Data Center UF FDC annually produces the Florida Medicaid Maternal and Child Health Status Indicators Report HSI chartbook for the Florida Agency for Health Care Administration Agency The chartbook is a paper report that consists of a fixed set of tables and charts describing the Florida population for 35 health indicators on various demographic and programmatic characteristics useful to the Agency The statewide chartbook is effective in summarizing key information in ways that are actionable to the Agency However the value created by the usability of the paper report naturally offsets the benefits of scalability and portability of information collected by state government To address the needs of the Agency in having both usable and accessible information UF FDC developed a website capable of producing custom reports that extend the access to data resources beyond information presented in the chartbook The major function of the website is to display and manipulate the latest available population level trend data on outcome indicators available in the Maternal Child and Health MCH data warehouse operated by UF FDC under contract with the Agency It allows county comparison of Medicaid status and eligibility subgroups race2. Florida 16 Florida Health Status Indicators Web Portal User Manual Maternal Child Health Status Indicators Repo 2 sate _ _ Export PDF ite Cou Layout Paper Size juired Neo scl 2011 Birt t Letter vy A j Scaling e l Portrait Landscape Automatic l v fia 99 Content b 8 6 than 2 4 7 9 with an TTA 4 i 7 pnate w a 7 2 This Dashboard Sheets in Dashboard Sheets in Workbook 8 Sheets to Export Svs Screenshot 23 PDF export Family Data Center College of Medicine University of Florida 17
3. ethnicity classifications Medicaid Length of Coverage Medicaid Delivery Systems and Health Maintenance Organizations HMO participation for each outcome indicator In addition to health care costs per county for each outcome indicator the expanded functionality allows the website to report metrics on hospitalization charges and length of stay The website is under continuous development This user manual refers to the current development build November 2013 UF FDC is responsible for maintaining and updating the website 1 2 Organization of the User s Manual This Website User Manual describes e The basic functionality of the website e How to access and navigate the website s pages e How information is displayed on the dashboards 1 3 System Environment The web portal uses Tableau a provider of business analytics software as its software platform UF FDC uses a customized version of the software to create the interface between Agency users and the data warehouse maintained by the UF FDC The software provides Family Data Center College of Medicine University of Florida 1 Florida Health Status Indicators Web Portal User Manual 2013 users with common controls e g check boxes and drop down menus and functionality e g tool tips and mouse clicks which should be familiar to users of the Microsoft Windows operating system This User Manual assumes that a user has access to a computer with internet connectivity as well
4. map due to a higher level of aggregation when compared to tabular reports Florida Medicaid Maternal Child Health Status Indicators 2007 2011 Birth Cohorts Family Data Center University of Florida August 15 2013 Screenshot 10 Report menu view 3 3 1 Report Menu View Indicator Type Filter Clicking on the drop down menu c r Select Indicator Type pir under Select Indicator Type aaa provides users with the option of Infant Indicators displaying either maternal or infant ematea a a screenshot 11 Indicator type filter indicators on the Select Indicator drop down menu below tt When infant indicators is selected under indicator type the Select Indicator filter below it is populated with a list of infant indicators When Maternal Indicators is selected in this filter the Select Indicator filter below it is populated with a list of maternal indicators Family Data Center College of Medicine University of Florida 9 gt Florida Health Status Indicators Web Portal User Manual 3 3 2 Report Menu View Indicator Filter Select Indicator Type Select Indicator Type Maternal Indicators Infant Indicators Select Indicator ai Select Indicator PET Indicator 1 Deliveries Indicator 19 Births x Indicator 1 Deliveries Indicator 19 Births Indicator 2 Pre term Delivenes Indicator 3 Deliveries for Women with First Trimester Entry into Prenatal Care Indicator 4 Delive
5. warnings appear Revocation information for the security certificate for this site is not available Do you want to proceed View Certificate _ Screenshot 1 Security warning message 3 When the portal login screen appears enter username and password information Family Data Center College of Medicine University of Florida 2 Florida Health Status Indicators Web Portal User Manual 2013 4 Click on the red Login rectangle to enter the web portal Login H obleoau Enter your Tableau Server usemame and password to log in Username lahca Remember Me Password eee Screenshot 2 Portal login screen 2 2 System Navigation Menu Fitters idi sac Screenshot 3 System navigation menu The system navigation menu on the left side includes Projects Workbooks Views and Data Sources see Screenshot 3 AS more reports are added to the navigation structure this menu is useful for navigating the web environment By using this menu users can navigate a hierarchy of connected reports The navigation hierarchy places projects at the top level where each project can have multiple workbooks and each workbook can have one or more views or dashboards see Figure 1 Views are at the lowest level of the system navigation hierarchy and can display combinations of text tabular and graphical information Screenshot 3 shows a workbook that contains 17 views and Screenshot 10 sh
6. MED 146 Deliverable 2 7 Updated Website User Manual for Reporting Outcome Indicators by Year Geography and Subgroup Prepared for Florida Agency for Health Care Admunistration FLORIDA AGENCY FOR HEALTH CARE ADMINS TRATIOM by FLORIDA Family Data Center UF Final January 7 2014 FLORIDA HEALTH STATUS INDICATORS WEB PORTAL USER MANUAL Table of Contents 1 0 GENERAL INFORMATION cx neecioe ceanesekone se naneninancnenesenaskackakanasanancncns Del ey te OVE VIEW cea nd edt tees a re ace Setting iaece ee ee aeeenieds 1 1 2 Organization of the User s Manual c ccccccccecceeeeeeseeeeeeceeeeeeceeeseeeeeeseeeeeeeeeseeeseeseeeseees 1 120 Sye ENVrONMEN i E 1 1 4 A thornzed Use PermiSsSio Micca a eae 2 159 OME O CONAC sirpana A 2 2 0 SYSTEM SUMMAR Y rrer e ea e aAA NREN 2A MOGGING ID estas ans sete nE E E E E EEE EEEE E RE E EE 2 RAZOS EN Menera aa O S ated ias a 3 2 Ot TOM V E aa A A A O 5 30 USING THE WEBSITE vewonevseenununenanwknnnenn E N 3 1 Dashboard Organization and Selection cccccccceecceceeeeceeeeeseeeecseeeeseeeeseeeeesaeeeseneesseeesees 6 32 DOCUMENTATION VICWS nsyi aa a a 8 3 9 REPO MNU VICW eniai oideounl cident aieeuntGidenent oadementcideienl cideounl cidacemantnents 8 3 3 1 Report Menu View Indicator Type Filter cccccccseccseceeeeeseeeneeeneeeneeeneeeneeeneeeaeeenaes 9 3 3 2 Report Menu View Indicator Filter nicsuisctrw cacteauieeeweatews tw etiw twats 10 3 3 3 Repor
7. as some familiarity with navigating a website through employing radio buttons drop down menus and check boxes 1 4 Authorized Use Permission Only Agency and UF FDC staff members are currently authorized to access the web portal At any time the Agency can request UF FDC to create additional access accounts To obtain the username s and link please contact the Agency s contract manager 1 5 Point of Contact Jeffrey Roth PhD Principal Investigator for the MED146 contract is the primary point of contact for this project He can be reached by phone at 352 334 1368 by email at roth peds ufl edu or in writing at 1701A SW 16 Avenue Room 3121 Gainesville FL 32608 Dr Roth may direct inquiries to UF FDC staff members with knowledge of specific content areas of the website 2 0 SYSTEM SUMMARY The portal utilizes dashboards which is a display format that assembles output data from a variety of sources onto a single screen The dashboards allow for interactivity on the part of users The web portal allows policymakers to query linked longitudinal health and financial data to create custom tables charts and maps using a point and click interface 2 1 Logging In 1 Open a web browser such as Internet Explorer Firefox or Google Chrome and copy and paste the web address provided by the Agency contract manager into the address window and press the enter key 2 Click OK Yes Continue or Proceed if any security
8. ation with the layout of the HSI report a set of seven documentation views is available with narrative sections on Overview Methodology Structure Definitions Maternal Indicators and Infant Indicators These documentation views are illustrated in Figure 2 using a blue color For users who are either experienced with the layout of the HSI report or feel ready to create a custom report after reviewing the documentation a Report Menu dashboard yellow in Figure 2 provides selection menus including interactive maps to define parameters used to customize the rest of the views comprising tables and charts There are a total of nine views that display combinations of tabular and chart data based on selections made in the Report Menu view These quantitative views can be categorized in three groups Distribution orange Rate red and Financial purple see Figure 2 Each of these groups of dashboards provides a different perspective towards the selected outcome indicator or geography From the web portal landing page clicking on a thumbnail image see Screenshot 3 or in the list view the name of any of the views in the column marked Title see Screenshot 5 will open the selected dashboard Once a dashboard opens a set of tabs appears across the top for all available dashboards ordered from left to right based on Sheet as on the landing page see Screenshot 7 Clicking on any tab will disp
9. calability benefit of this geography filter enables the web portal to generate 68 reports 67 counties plus statewide per outcome indicator currently 35 indicators or over 2 300 nine page reports of only tables and charts A report in this context means a collection of views that are modified by the filter which are the nine data sheets available in the current build If views are disaggregated from reports and treated as independent entities the scalability improvement associated with the geography filter reaches over 21 400 one page reports 68 35 9 of only tables and charts 3 3 6 Report Menu View Statewide Report Button Clicking the Statewide Report button allows the county map filter to be cleared R and all views to be reset to report on statewide values see Screenshot 15 All E titles and footers return to show Florida Screenshot 17 Statewide report button labels and the county map recovers its full range of colors Family Data Center College of Medicine University of Florida 12 Florida Health Status Indicators Web Portal User Manual 3 4 Distribution Views Tables and Charts Screenshot 18 Tabs for distribution views Eligibility Clicking on this tab will generate a view that provides the number and percent distribution of the selected indicator and geography per menu view filters sections 3 3 2 and 3 3 5 by Medicaid classification and by trend year Each table is followed by two figures that graph tre
10. color gradation is used to compare counties based on their rate of a selected indicator during the time period of the workbook The map also functions as a filter to other tabular views in the workbook by responding to selections of one or multiple counties Share Remember my changes Edit as Co Download Menu i Medicaid Maternal Child Health Status Indicators Reports Indicator 35 Infants who required Neonatal Intensive Care in Florida Select Indicator Type Select County to Create County Report infant indicators v Map Shows Percent of Births to Infants who required Neonatal Intensive Care of All Births by County for 2007 2011 Births Select Indicator i indicator 35 Infants who required Neonatal Intensive Care Definition Infants who had a birth weight of less than 2500 grams or were discharged from their birth hospitalization with an AHCA Discharge Diagnosis of DRG 389 full term neonate with major problems Percent Rate About Tableau maps weww tableausoftware com mapdata Notes Results are suppressed for counties where the case count is greater than 0 and under 5 High percents rates in certain counties are due to very small Genomin For indicators where the population size is small the total five year number of cases from which the rate is calculated in certain counties may be different to the total five year number of cases on tabular reports since fewer cells need to be suppressed in the
11. e in the indicator filter section 3 3 2 In the lower left corner of the map a legend is displayed illustrating the color Percent Rate Number 15 579 correspondence with the values of the proportions The numbers in each ji county represent the actual value of Percent Rate the proportion The tooltip feature H shown for Miami Dade county in Noes Results are suppressed for countes vere Ie cas count js greater han 9 and under S Screenshot 15 allows users to see the Esashi Chae ej tel ena a ed Gale ae A ee age D fewer cells need to be suppressed in the map due to a higher level of aggregation when compared to tabular reports name of the county and the number of observations Number in the outcome Screenshot 15 County map as a report indicator in addition to proportions This number is also the numerator used to derive the proportion The tooltip can be displayed by mouse hovering over any county in the map In this map we observe that 15 579 children born 2007 2011 required Neonatal Intensive Care and accounted for 9 6 of births during that period of time Using the color gradation feature we also observe that high proportions of 2007 2011 births requiring Neonatal Intensive Care tend to concentrate in the East segment of the Florida Panhandle Family Data Center College of Medicine University of Florida 11 Florida Health Status Indicators Web Portal User Manual 2013 3 3 5 Report Menu View Coun
12. es ago Edit C Methodology 3 administrator 32 minutes ago Edit Filters E Structure 4 administrator 32 minutes ago Edit F Definitions 5 administrator 32 minutes ago Edit a Maternal Indicators 6 administrator 32 minutes ago Edit C Infant Indicators 7 administrator 2 minutes ago Edit Any Project a Report Menu 2 administrator 32 minutes ago Edit F Distribution By Eligibility 9 administrator 32 minutes ago Edit Any Publisher a Distribution By Race 10 administrator 32 minutes ago Edit C Distribution By Coverage 11 administrator 2 minutes ago Edit Any Tag a Rate By Eligibility 12 administrator 32 minutes ago Edit C Rate By Race 13 administrator 32 minutes ago Edit Any Date C Rate By Coverage 14 administrator 32 minutes ago Edit C Rate By HMO plan 15 administrator 32 minutes ago Edit Any Date CI Hospitalization Charges 16 administrator 32 minutes ago Edit C Medicaid Reimbursement 17 administrator 31 minutes ago Edit Show Only Favorites z5 Show Only Recently Used Florida Health Status Indicators Web Portal User Manual Screenshot 5 List view mode As illustrated on Screenshot 6 below the user name in this case Agency for Health Care Administration is hyperlinked across the top of the screen to the right Clicking on the user name opens up a new screen where users have access to options whereby they can manage their account Users can change the login password change the default language and change the default landing page vi
13. ew The Help hyperlink to the immediate left of the user name is context sensitive and displays basic topics that guide users for browsing and searching the current page Agency for Health Care Administration Help rY Screenshot 6 User account and help controls 2 3 Exiting the System A header with the user name in this case Agency for Health Care Administration is always visible at the top right of each screen see Screenshot 6 When the user name header is Family Data Center College of Medicine University of Florida 5 Florida Health Status Indicators Web Portal User Manual 2013 clicked a drop down menu shows with the option to log out or exit the system The user is logged out and the Tableau login screen is displayed 3 0 USING THE WEBSITE When the web portal landing page opens a total of 17 dashboards in the current workbook are displayed in the center of the browser window in either the list or thumbnail view sorted in ascending order by the Sheet column see Screenshot 5 It is important to keep the ascending sheet number as the sorting parameter for the landing page to reflect the flow in which the dashboards were designed 3 1 Dashboard Organization and Selection UF FDC organized the views in the Web Portal to serve two types of users those who are not familiar with the structure of the HSI report and those who are For users who access the portal without previous familiariz
14. ile es Nk eimb UrSsement Screenshot 20 Tabs for financial views Hospitalization Charges Clicking on this tab will generate a view that provides mean inpatient hospitalization charges and length of stay for mother delivery and infant birth of the selected indicator and geography per menu view filters Sections 3 3 2 and 3 3 5 To answer questions about the financial impact of a certain health condition these tables group together hospitalization charges and length of stay for both mother and child Medicaid Reimbursement Clicking on this tab will generate a view that provides mean Medicaid Claims Reimbursement for delivery and birth hospitalizations by Medicaid Subgroup The Mean Total Claims Amount is the average sum that Medicaid paid for mothers and infants who had the health condition represented by the selected indicator and geography per Menu View Filters sections 3 3 2 and 3 3 5 4 0 CUSTOMIZING A VIEW 4 1 Dashboard Controls for Views The web portal interface includes several options located at the top of the screen just above the tabs see Screenshots 21 23 Family Data Center College of Medicine University of Florida 14 Florida Health Status Indicators Web Portal User Manual 2013 Ht Web Portal 2007 2011 Birth Cohorts Back Workbook Download Menu ribut gt Medicaid Maternal Child Health Status Indicators Reports v Int Select Indicator Type Select County to Create County Repo
15. is the Pause Automatic Updates icon an open circle with a radius Clicking on this icon allows the dashboard to pause real time updating of the dashboard When paused this feature allows a user to make a series of checkbox selections without having to wait for an update after each selection is made Refresh Icon The fourth icon from the left is the Refresh icon two semi circular arrows one clockwise one counterclockwise Clicking on this icon directs the computer to re establish a connection to UF FDC server Download Button On the far right of the dashboard is a rectangle marked Download with an arrow pointing down Clicking on this rectangle allows the dashboard currently being viewed to be saved as a Tableau file Tableau would need to be installed on the user s workstation for this utility to function Family Data Center College of Medicine University of Florida 15 Florida Health Status Indicators Web Portal User Manual 2013 Tool Tips By hovering over a selected area on the map a tool tip will appear The details for the tool tip were selected to show pertinent information for the current dashboard Tool tipos dynamically change based on the selection criteria If a tool tip disappears a user may reveal the tool tip again by moving the mouse away from the selection of interest and positioning the mouse on top of the selection again No clicking is necessary to display a tool tip Map Controls By hovering
16. lay the corresponding dashboard tEh Web Portal 2007 2011 Birth Cohorts Back Workbook G 0 Share Remember my changes Edit 7 Overview Screenshot 7 Tab based view selection menu Family Data Center College of Medicine University of Florida 6 Florida Health Status Indicators Web Portal User Manual Workbook Web Portal 2007 2011 Birth Cohorts Rate by Eligibility Rate by Race Rate by Coverage Rate by HMO Plan Note Green boxes are not elements of the web site navigation They are used in the diagram to show conceptual differences among views Figure 2 Diagram of views in the web portal Family Data Center College of Medicine University of Florida 7 Florida Health Status Indicators Web Portal User Manual 2013 3 2 Documentation Views Seven documentation views are designed to familiarize the user with the content and structure of tabular and chart data generated by the web portal They consist of narrative sections addressing the way the reports are structured Screenshot 8 below shows how documentation tabs look across the top once any view is opened from the landing page Screenshot 8 Documentation tabs Documentation views are described below Cover Shows the cover of the HSI report that corresponds to the workbook Overview Provides an introduction to categorical groupings used throughout the report and a definition to Medicaid Status and nine Medicaid Eligibility Subgrou
17. nd lines for the indicator Race Clicking on this tab will generate a view that provides the number and percent distribution of the selected indicator and geography per menu view filters sections 3 3 2 and 3 3 5 for Non Medicaid and Medicaid women by the following race ethnicity categories Caucasian African American Hispanic Asian Native American and Other Each table is followed by two figures that graph the relative distribution of the indicator among race ethnicity and Medicaid subgroups Coverage Clicking on this tab will generate a view that provides the number and percent distribution of the selected indicator and geography per menu view filters sections 3 3 2 and 3 3 5 by Medicaid Delivery System FFS HMO MediPass or PSN and length of time women were enrolled in a Medicaid Delivery System during pregnancy High Exposure includes women who had coverage in Medicaid for 180 days or more during pregnancy Low Exposure includes women who had coverage in Medicaid for less than 180 days during pregnancy 3 5 Rate Views Tables and Charts Distribution By Coverage Screenshot 19 Tabs for rate views Eligibility Clicking on this tab will generate a view that provides the number and rate of the selected indicator and geography per menu view filters sections 3 3 2 and 3 3 5 by Medicaid classification and by trend year Each table is followed by two figures that graph trend lines for the indicator Race Clicking
18. on this tab will generate a view that provides the number and rate of the selected indicator and geography per menu view filters sections 3 3 2 and 3 3 5 for Non Medicaid and Medicaid women by the following race ethnicity categories Caucasian African American Hispanic Asian Native American and Other Each table is followed by two figures that graph the relative distribution of the indicator among race ethnicity and Medicaid subgroups Family Data Center College of Medicine University of Florida 13 Florida Health Status Indicators Web Portal User Manual 2013 Coverage Clicking on this tab will generate a view that provides the number and rate of the selected indicator and geography per menu view filters sections 3 3 2 and 3 3 5 by Medicaid Delivery System FFS HMO MediPass or PSN and length of time women were enrolled in a Medicaid Delivery System during pregnancy High Exposure includes women who had coverage in Medicaid for 180 days or more during pregnancy Low Exposure includes women who had coverage in Medicaid for less than 180 days during pregnancy HMO Plan Clicking on this tab will generate a view that provides the number and rate of the selected indicator and geography per menu view filters sections 3 3 2 and 3 3 5 for women who were enrolled in the same Medicaid HMO for greater than 180 days or for at least 2 3 of their pregnancy 3 6 Financial Views male OY wW E o F C male Oy H it H cll USP do W
19. over the upper left corner of the map display plus and minus icons allow the map image to be enlarged or reduced A selection tool a rectangular icon with a plus sign in the lower right corner allows the user to draw a box around a portion of a map image and a Home icon restores the image to its default display Clicking on the water also restores the map to its default display Clicking a point and drawing a box is another method to select a group of counties 4 2 Exporting the Dashboard View Any dashboard can be exported in the following formats Image Data Crosstab and PDF 1 Select Export from the left most of the four icons in the middle at the top of the dashboard see Screenshot 22 2 Select your choices for page layout paper size and other options and click Export see Screenshot 23 ex Web Portal 2007 2011 Birth Cohorts Back Workbook Remember my changes Edit fas 4w 4 Menu gt Medicaid Maternal Child Health Status Indicators Reports Indicator 35 Infants who required Neonatal Intensive Care in Florida Select Indicator Type Select County to Create County Report who Neona infant Indicators v Map Shows Percent of Births to Infants tal Intensive Care of All Births by County for 2007 2011 Births Select Indicator indicator 35 infants who required Neonatal intensive Care Screenshot 22 Export controls Family Data Center College of Medicine University of
20. ows an example of the contents of a view Filters are also available as part of the system navigation menu to narrow the number of reports listed in response to users searching for specific information Family Data Center College of Medicine University of Florida 3 Florida Health Status Indicators Web Portal User Manual 2013 Login https hsi mch peds ufl edu Select Project Florida Health Status Indicators Report Select Workbook Web Portal 2007 2011 Birth Cohorts Select View ee a aa aa poa a aa a oa Figure 1 Diagram of system navigation As of November 2013 the web portal contains one project Florida Health Status Indicators HSI Report and has one workbook Web Portal 2007 2011 Birth Cohorts with a total of 17 views or dashboards as shown on Screenshot 3 Once the 2008 2012 birth cohorts web portal is released in June 2014 for instance another workbook will appear under the Florida Health Status Indicators Report project This update will allow the workbook level of the navigation hierarchy to provide its designed functionality The available workbook can be navigated at the view level There are two ways to display views contained in the Web Portal 2007 2011 Birth Cohorts workbook the thumbnails view and the list view The thumbnails view is shown on Screenshot 3 Thumbnails are miniature images of what the dashboard looks like Users must scroll down to see all the dashboards Clicking on a thumbnail image or
21. ps SOBRA Non SOBRA CMS High Risk OB Medically Needy Medicaid SSI Alien Medicaid lt less than 8 days or No PNC Prenatal Care Non Medicaid and Temporarily Eligible Methodology Lists the data sources used to construct the HSI report describes data suppression techniques used to mask cells with low counts and addresses general limitations of the HSI report Structure Describes the layout of eight different types of tables used to stratify information in the HSI report Tables A through H Definitions Provides definitions to additional categorical groupings Medicaid Delivery Systems Length of Coverage and Financial Benchmarks Maternal Provides definitions to 18 maternal health indicators available for custom reporting Infant Provides definitions to 17 infant health indicators available for custom reports 3 3 Report Menu View Definitions Maternal Infant Distribution By Eligibility Distr Screenshot 9 Report menu tab The report menu view see Screenshot 10 is the starting point of report construction once the documentation is reviewed This interactive page allows users to make selections on several parameters available for customizing an HSI report In addition to selection menus such as type of indicator and the specific outcome indicator the view shows a Florida map Family Data Center College of Medicine University of Florida 8 Florida Health Status Indicators Web Portal User Manual where
22. ries for Women with Inadequate Prenatal Care Indicator 5 Deliveries for Pregnant Women Screened by Healthy Start Indicator 6 Deliveries for Pregnant Women Screened at High Risk by Healthy Start Indicator 7 Deliveries for Women Who Reported Smoking during Pregnancy Indicator amp Deliveries with Obese Prepregnancy Body Mass Index BMI Indicator 9 Deliveries to Adolescents Age up to 18 Years Indicator 10 Vaginal Deliveries without Physical Complications Indicator 11 Vaginal Delivenes with Physical Complications Indicator 12 Cesarean Delivenes Indicator 13 Deliveries to Women in Women Infants and Children WIC Indicator 14 Deliveries with an Interpregnancy Intervals IPI less than 18 months Indicator 15 Mothers diagnosed with a Mental Health Condition Indicator 16 Mothers who Plan to Breastfeed Indicator 17 Matemal Deaths Indicator 18 Mothers who participated in the Family Planning Waiver Program ti Screenshot 12 Indicator filter values Maternal Screenshot 13 Indicator filter values Infant Indicator 20 Births with Low Birth Weight Indicator 21 Births with Very Low Birth Weight Indicator 22 Term Births with Low Birth Weight Indicator 23 Pre term Births with Low Birth Weight Indicator 24 Births for Infants Screened for Health and Developmental Risk Indicator 25 Births for Infants Screened At Risk for Health and Development Indicator 26 Infant Mortality Indicator 27 Neonatal Mortality Indica
23. rt Infant Indicators bd Map Shows Percent of Births to Infants who required Neonatal Intensive Care of All Births by County for 2007 2011 Births Select Indicator Indicator 35 Infants who required Neonatal Intensive Care p 8 4 78 83 8 3 8 0 l A R1 on 2 y Screenshot 21 Dashboard controls Share Button At the far left of the dashboard is a Share button icon of curved arrow facing right see Screenshots 21 Clicking on this arrow opens a window called Share Viz which contains two options Users can choose to either 1 email a hyperlink to the dashboard page currently being viewed which has been automatically generated or 2 copy and paste the HTML code for the dashboard which can be added to a web page Sharing the hyperlink will require that the recipient is an approved user of the portal who will have to login with a username and password to retrieve the information Export icon In the middle at the top of the dashboard is a set of four icons The first one Starting from the left is the Export icon right facing arrow over half box Clicking on it allows the user to save the data on the dashboard in a variety of formats such as an Excel spreadsheet a PDF or an image Revert All Icon The second from the left is the Revert All icon a counter clockwise arrow icon Clicking on this icon restores all settings back to their default values Pause Automatic Updates Icon The third icon from the left
24. t Menu View Dynamic Definition WiINdOW ccccccseeeseeeseeeneeeseeeneeeneeeneeenes 10 3 3 4 Report Menu View County Map as a Report ccccceeccseecceeeceeeeeeseeeeseeesaeeeseees 11 3 3 5 Report Menu View County Map as a Filter ccc cccscsseesesesescscecseeteseseseseseseeseneeenees 12 3 3 6 Report Menu View Statewide Report Button uc cccscesesesesesceceteteesesesesessseeneneeees 12 3 4 Distribution Views Tables and ChafrtS occ So aonar CTCE TNC ETORT ERCOR N 13 3 5 Rate Views Tables and Charts cccccccccscscsscsssesesescscscsessssesesesescssscscsscscscsesescscscsceussesesescseseeceeeeeees 13 fo yal wal 72 g t 1 fo eee ee ee te ee er ee ee ee ee ee ee ee ee ee ee ee ee eee ee ee en ee 14 40 CUSTOMIZING A VIEW oasis cect sent cast castenet yssvaretaaisa ue caaeeies aaestes se as asta seve eee 14 AA DASADO AFG GOMTUOIS TOW QWS sissors E iden ea es ee eee 14 MEDO Renee ete en CR ce SR St ee See eee ere ee emer a Pe eee 15 EX DOM IGOMstelanaseisad p E E T E EG 15 Rever Al ICON cii a e a a ea eeeteied 15 Pause Aulomatle Updates ICom aati eee a ee ee ee ae 15 ROTESC fit aces seahtcateted sa theater dace a a Dae teen beast aaa 15 Downoad TUTTO Ix cites eecisachenttitescencitanhenisiiten eexcitanhensiten AE 15 Ao Is 0 emer earner ener E E E eee nee etn meen Trt ete 16 MaD CONTOS sossts see cate tices sete O E E 16 4 2 EXporing Me Dashboard VIEW suncn ecm ecm wenn nebe wenn wenn wenn wenn ween Rene wenn weneKek 16
25. the title of any one of the dashboards will launch that dashboard To change the view mode of the contents of the workbook from thumbnails to list users can click the view mode icons located on the top left corner of the landing page below the workbook title marked by the red rectangle see Screenshot 4 As users hover the mouse over these icons a tooltip appears indicating which view mode they identify Once clicked the icon that identifies the current view mode turns orange indicating that the active view mode is currently thumbnails Workbook Web Portal 2007 2011 Birth Cohorts in t Florida Health Status Indicators Report all J Sort By Title Sheet T Modified Publisher Screenshot 4 View mode controls When the view mode icon on the right side of the area marked by the red rectangle in screenshot 4 is clicked the page changes to the list view mode see Screenshot 5 A list view is a more condensed view than the thumbnails view where only the titles of the dashboards that comprise the workbook are shown Clicking on the name of any one of the dashboard views will launch that dashboard Family Data Center College of Medicine University of Florida 4 iy tableau Workbook Web Portal 2007 2011 Birth Cohorts in Project Florida Health Status Indicators Report Projects Download Workbook J Workbooks a Title Sheet Publisher Modified Edit Views F Cover Page 1 administrator 2 minutes ago Edit ii Ssi C Overview 2 administrator 32 minut
26. tor 25 Post Neonatal Mortality Indicator 30 Infants Placed Under Foster Care Indicator 31 Infants Diagnosed with Birth Anomalies Indicator 32 Infants with Verified Malireatment Indicator 33 Infants Diagnosed with a Mental Health Condition Indicator 34 Medicaid Infant Readmitied to Hospital after Birth Indicator 35 Infants who required Neonatal Intensive Care Clicking on the drop down menu Select Indicator populates a list of outcome indicators of the type defined by the Select Indicator Type filter above it Screenshots 12 and 13 show the contents of the filter menu for both choices of indicator types maternal indicators or infant indicators as defined in maternal and infant documentation views in Section 3 2 When an indicator infant or maternal is selected from the list the map in the menu page will change to display corresponding proportions for the selected indicator In addition to changing the map this filter changes the dynamic definition window see Section 3 3 3 and the title of the indicator the dark blue text box or Indicator 35 Infants who require Neonatal Intensive Care in Florida in the menu view provided in Screenshot 10 Outside the menu page this filter also changes all nine tabular views to display data distributions rates and financials only for the selected outcome indicator Titles of the nine tabular views are also changed by the selection made on this filter 3 3 3 Report Men
27. ty Map as a Filter As described in section 3 3 4 the county map can be used as a report that allows comparison of counties based on proportions of a selected outcome indicator but more importantly the map can also be used as a geography filter for all other views in the workbook Screenshot 16 shows how the map looks after clicking on Miami Dade county When a county is clicked Miami Dade for instance the J rest of the counties will turn dark blue and only the county A that was clicked will remain with the original color In Screenshot 16 County map as a filter addition to changing the colors of the map this selection will propagate the geography filter to the title of the menu page In this example the title on Screenshot 10 changes from Indicator 35 Infants who require Neonatal Intensive Care in Florida to Indicator 35 Infants who require Neonatal Intensive Care in Miami Dade County as a result of clicking Miami Dade in the map Also in the menu page the footer which previously read Florida Medicaid Maternal and Child Health Status Indicators changes to Miami Dade County Medicaid Maternal and Child Health Status Indicators This geography filter selection changes all calculations in all nine data views Distribution Rate and Financial to display only information pertaining to the selected county Titles and page footers are also changed in all data views according to the County filter selection The s
28. u View Dynamic Definition Window This window responds to a selection made on the Indicator filter Section 3 3 2 Depending on the indicator selection the Definition Infants who had a birth weight of less than 2500 grams or i were discharged from their birth hospitalization with an AHCA window will display its definition as in the Discharge Diagnosis of DRG 389 full term neonate with major problems maternal or infant documentation views as described in section 3 2 The definition displayed on Screenshot 14 indicates that Indicator 35 Infants who require Neonatal Intensive Care was the selected outcome indicator before the Screenshot was produced Screenshot 14 Dynamic definition window Family Data Center College of Medicine University of Florida 10 Florida Health Status Indicators Web Portal User Manual 2013 3 3 4 Report Menu View County Map as a Report The map responds to a selection made on the Indicator filter Section 3 3 2 Select County to Create County Report Depending on the indicator selected leas er e ie Go ence d by County for 2007 2011 Births the map will display the proportion by county of the selected indicator during the period covered in the workbook ap f For example in this particular workbook 2007 2011 a color yellow through brown in ascending order was used to illustrate this proportion The title of the map also responds to a 86 a aa change mad
Download Pdf Manuals
Related Search