• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer

Fulton Street Software

Social service is in our DNA

  • About
    • Our Story
    • Board of Directors
    • Partners
    • Team
  • Modules
    • Multi-Services
    • Referral & Intake
    • Foster Care Activity and Status
    • Case Management
    • Resource & Home Member Management
    • Domestic Violence
    • Customized Form Data Collection
    • Financial Management
    • Reporting and Data Export
  • Services
    • Conversion & Implementation
    • Training
  • Testimonials
  • News
  • Contact
  • Request A Demo

Status Reports: Use Asara to Easily Run Your Own

October 26, 2018 by Fulton Street Software

It is a familiar scenario to many of us…you need to figure out census and service numbers. For example, you may need to pull a report showing:

  • How many clients received services last fiscal year?
  • Or ‘as of’ a specific date?
  • How many clients had at least one active day in care between July 2017 and June 2018?
  • How many clients did you serve for FY19 first quarter? Quarterly reports due?

Pulling this data is easy using Asara tools. You do not need special skills or IT help! Simply follow these steps. If you run into trouble, give us a call.

Run a Child Status Export for ‘As Of’ Reporting:

Navigate to:

  • Client Menu
  • Child Status Update

Use filter to create your “as of” reporting. Keep in mind:

You need to select a status radio button, enter dates AND select status to filter for

  • Click Filter
    • Results appear on grid
  • Click Export
  • You ran your own query! WOO HOO!

You data will appear in a spreadsheet.

Explanation of Status Selections

“In-Status”

  • Produces a list of clients that HELD the specific status you selected for at least one day during the date range
  • If From Date = To Date, list will contain all clients with the specified status as of that date.

*** Other filter criteria are applied after the list of clients is selected based on In-Status.

  • Example 1: if you enter From Date/To Date = 7/1/2017 and status = active,
    • Receive a list of all clients Active on 7/1/2017
  • Example 2: if you enter from date = 7/1/2017 and end date = 6/30/2018 and status = active
    • Receive a list of all clients who had at least one active day between July 2017 and June 2018
      • If child was active prior to 5/1 and stayed active they will appear
      • If child was in and out of absences they will appear (only once)
        • Note there is current status and last status in the export
        • Filter is current status – last status gives you extra data

“Entered Status”

  • Produces a list of clients that ENTERED the specific status you selected during the date range
  • If From Date = To Date, list will contain all clients with a movement on that date resulting in the status.

***Other filter criteria are applied after the list of clients is selected based on Entered Status.

  • Example 1: if you enter from date = 5/1/2015 and end date = 9/30/2015 and status = active
    • List of clients who entered the status of ‘active during that range’
      • Placed client
      • Client came back from an inactive status during that time period
      • This is used for activity queries
    • Example 2: if you enter From date/To date = 5/1/2015 and status = active
      • You will get a list of any child who became active that day
        • Placed that day
        • Came back from inactive status that day

Filed Under: Asara Tagged With: active children in a date range, as of report, census, export, fiscal year, how to, reporting

Primary Sidebar

Recent Posts

  • Integrating Your Data Management with EHR Systems
  • Asara Makes Audits Great Again
  • A Calculating Trick! Insert an Excel Spreadsheet into MS Word
  • Create Customized Data Collection Forms Like a Pro
  • Productivity Hacks: Keyboard Shortcuts to Save You Time

Search

Footer

Fulton Logo

Phone: 212.233.0702
Email: info@fultonsts.com

© fulton street software llc |  all rights reserved