slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Welcome CFBHN IT/IS all Hand Meeting August 3, 2012 PowerPoint Presentation
Download Presentation
Welcome CFBHN IT/IS all Hand Meeting August 3, 2012

Loading in 2 Seconds...

play fullscreen
1 / 43

Welcome CFBHN IT/IS all Hand Meeting August 3, 2012 - PowerPoint PPT Presentation


  • 196 Views
  • Uploaded on

Welcome CFBHN IT/IS all Hand Meeting August 3, 2012. Agenda Data due date – 7 th of the Month Prevention data still submitted to KIT Solution Performance Outcomes June 2012 – not final New Performance Outcomes for FY 12-13 FTPS Site – Where/How to submit SAMHIS data to CFBHN

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Welcome CFBHN IT/IS all Hand Meeting August 3, 2012' - arlen


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Welcome

CFBHN IT/IS all Hand Meeting

August 3, 2012

slide2

Agenda

  • Data due date – 7th of the Month
    • Prevention data still submitted to KIT Solution
  • Performance Outcomes
    • June 2012 – not final
    • New Performance Outcomes for FY 12-13
  • FTPS Site – Where/How to submit SAMHIS data to CFBHN
  • Excel Format - Direct Data Entry sheets
  • Contracts
    • Data vs. Billing 95% accuracy
  • Utilization Management
    • Acute Care Registration
    • Residential Services Registering all levels
slide3

Performance Measures FY 11-12

  • The Network is meeting or exceeding all but the following Performance Measures
  • (DCF Dashboard 8/2/2012 YTD through 6/30/2012- current – not final)
    • Measure Actual vs. Target
    • SPMI Stable Housing - 92.42% vs. 93%
    • MH Crisis Stable Housing - 89.14% vs. 98%
    • ED who improve level of function – 56.08% vs. 64%
    • SED who improve level of function – 58.73% vs. 65%
slide4

Performance Measures FY 12-13

Changes and what has stayed the same

Refer to the Exhibit A

ftps transfer files to cfbhn

FTPS Transfer Files to CFBHN

Instructions on how to submit data to CFBHN via FTPS

ftp program
FTP Program
  • There are many ftp programs out there but for this demonstration we will use one called FileZilla.
  • This program is free and can be downloaded at http://download-filezilla-ftp-free.com/
  • Or one can find a link via a Google search
filezilla configuration
Filezilla Configuration
  • Host: ftp.cfbhn.org
  • Username: “00username” SharePoint
  • Password: “your password” same as SharePoint
  • Port: “990”
  • Click “Quickconnect”
filezilla certificate
FileZilla Certificate
  • After that you will get a certificate.
  • Check “Always trust this certificate in future sessions.”
filezilla data upload
FileZilla Data upload
  • The left side of the window is your local site
  • Right side of the windows is your remote site
  • Navigate one the left side to the folder that holds the data you want to upload.
filezilla data upload download
FileZilla Data upload/download
  • Double click the file you want to upload on the left, when it has successfully been uploaded, it will show up on the right side.
  • To download data from CFBHN, double click on the files to the right.
  • You will be automatically disconnected from our server after 3 minutes of inactivity.
file naming convention
File Naming Convention
  • All files must be in the standard dcf file structure
  • Name the file starting with your 2 digit agency code
  • Next put your file type, ie Demo
  • Last put a date stamp of the date in “MMDD” format
  • If submitting multiple file of the same type on the same day, put a sequence number behind it
  • Submission order
  • Example: 00delDemo08031_3.txt
data entry spreadsheet templates

Data entry spreadsheet templates

Using Central Florida Behavioral Health Network’s

slide13

Central Florida Behavioral Health Network (CFBHN) has built a means for agencies that have been using DDE(direct data entry) screens in SAMHIS to create SAMH data files that can be uploaded.

slide14

The Data Entry Spreadsheets are available to your agency on the CFBHN Share Point portalhttp://cfbhn.org/agency-resources.aspResources / Agency Shared Documents/ Manual Input Templates (ZIP file)

There are 11 sheets: one for each primary data set for SAMH data

You may download the templates to any location on your PC that you choose. Just be sure that the location is one that you will remember and can get to easily.

slide16

CFBHN recommends using Windows Explorer to help you manage the template files and the data files you will create with them.

slide17
Every storage location available to your computer, including your desktop, can be reached by navigating in Windows Explorer.

If you need help to use it, you can do a Google search for “Windows Explorer how to use”. There are many websites covering the topic including instruction videos on YouTube

To use Windows Explorer, Right click the START button in the lower left corner of your screen and select “Open Windows Explorer”.

the template files you download from cfbhn should be considered master copies
The template files you download from CFBHN should be considered master copies.

You will want to keep these ‘clean copies’ without any data in them, to make your regular working files.

SO, After downloading the files, you will want to make another copy of each file, again, use a computer path location you remember and get to easily.

The Templates will be available on the SharePoint site if you ever need to download again.

slide19

And to have the programs in the template files work correctly, you must create a new folder on your computer’s “C” drive.

The name of this folder is

C:\SAMHfiles

Now you are ready to use the spreadsheet template files

slide21

Open Excel

  • move to the FILE tab on the ribbon,
  • left click ‘Open’,
  • navigate to the location where your working copies of the templates files are
  • select one of these files to work in,
  • and click the OPEN button
the xlsm file extension indicates spreadsheets containing macros
The .xlsm file extension indicates spreadsheets containing Macros

If the ‘Security Warning: Macros have been disabled’ message appears on your screen click the Enable Content button to enable the macros.

if you do not click enable content you can still enter and save data
If you do not click “Enable Content”, you can still enter and save data

However, you cannot produce the file to upload to CFBHN unless you enable macros.

So, click the Enable Content button.

slide25
The spreadsheet is formatted with the top rows giving you information about the data to enter in the columns.
the contractorid and contid contract number fields are prepopulated
The ContractorID and CONTID(contract number) fields are prepopulated.

There are at least 300 formatted rows available in each file where you can enter data. (The SERVinputPacker.xlsm – our example, has 600 data entry rows)

slide27
Columns which you do not need to fill in are set so that you will not be able to put your cursor into them.
slide28
Columns are pre-formatted for Text, Numbers and Dates as is required by Pamphlet 155-2. You cannot change the formatting of any cell.
each column has basic data validation built into it
Each column has basic data validation built into it.
  • For example, if a field requires 9 digits, such as the SSN, you must enter 9 digits or you will get an error message.

Drop down lists for selecting a value to enter are not available currently. Use the Pamphlet 155-2 for reference during your data entry as frequently as you wish.

slide30

You may open and use and save a copy of each of the spreadsheets you use as often as you need to while you are preparing your data.

When you have completed your data entry (for the week, or the month) and you are ready to send it to CFBHN, you will run the macro built into the spreadsheet.

slide31

RUNNING THE MACRO

or

BUILDING YOUR OUTPUT FILE FOR CFBHN

slide32

The first action the Macro performs is to save your spreadsheet.

SO…You will not lose any of your data from running the Macro.

slide33

Start the Macro:

Ctrl + Shift + Q

Or

Click button “Run Macro”

Simultaneously depress the Control Key, the Shift Key and the letter Q or click button “Run Macro”

slide34

That’s It !

Short, sweet and simple.

you started with this
You started with this

You will have noticed while the Macro runs, your screen changes many times

slide39

C:\SAMHfiles\DEMOinput.txt would be the filename instead if you had prepared demographics data….etc!

steps to take now are
Steps to take now are:
  • Rename the file according to the prescribed naming convention (next slide)
  • Copy or Move your new C:\SAMHfiles\XXXX.txt file to a permanent storage location that is not in the C:\SAMHfiles\ data pathway
  • Send a copy of each of your ‘XXXX.txt’ files to CFBHN
file naming convention1
File Naming Convention
  • All files must be in the standard dcf file structure
  • Name the file starting with your 2 digit agency code
  • Next put your file type, ie Demo
  • Last put a date stamp of the date in “MMDD” format
  • If submitting multiple file of the same type on the same day, put a sequence number behind it
  • Submission order
  • Example: 00delDemo08031_3.txt
slide42

Get ready for the next month by:

  • Archiving the previous month spreadsheets
  • Making a copy of the master spreadsheets
  • Start entering data for the current month