Children’s Long-Term Support (CLTS) Program: SAS
SAS Institute has developed the Wisconsin Department of Health Services (DHS) new Enterprise Data Warehouse/Data Analytics and Reporting (EDW/DAR) Solution, referred to as SAS. SAS will house data pulled from different Wisconsin Medicaid systems such as Program Participation System (PPS), ForwardHealth interChange, and Functional Screen Information Access (FSIA).
For more information on using SAS for CLTS reference the Wisconsin County Waiver Agency (CWA) Children’s Long-Term Support (CLTS) Program Guide to SAS (PDF). You can also watch the January 2024 training recording or view the January 2024 training slides.
How to access SAS
To access SAS, go to https://prod.widhs.cloudanalytics.sas.com/SASDrive/.
Note: SAS can only be accessed from an approved IP address. You must be on an approved network (either physically or by a virtual private network or VPN) to access the DHS data warehouse through SAS. Please contact the SAS helpdesk at widhs-helpdesk@sas.com if you are not able to connect.
Recommendation: Save the link to access SAS as a favorite to get into SAS. To do this, right click on the link to access SAS and choose copy link. Open your browser and enter the link into the address bar. Save it as a favorite for that browser. Do not save the “login page” (prod.widhs.cloudanalytics.sas.com/SASLogon/login) as your favorite. You cannot access SAS from that webpage.
Resources
Watch the Logging into SAS, Finding Reports, and Downloading Reports video
Available CLTS Program reports
Contains the following tabs:
- Currently Enrolled Tab—Lists kids who had active enrollment in the past week. Report includes:
- Address
- CARES case number
- Date of birth
- Katie Beckett details
- Medicaid benefit plans
- Waiver enrollment
- Predicted Disenrollments Tab—Lists kids scheduled for disenrollment at the end of the current and next calendar months. Must be for these reasons:
- The child ages out of the program. This happens on the last day of the month they turn 22.
- The child loses functional eligibility.
- The child’s Medicaid ends.
- The recertification due date falls within the reporting period.
- A yearly functional screen or level of care determination is due.
Watch the Weekly CLTS Waiver video
Lists kids with more than one ID who had records linked in the past month used to identify MCI changes.
Watch the Link report video
Combines ForwardHealth Enrollment and Functional Screen data. Used to find kids who have annual rescreens due based on last screen calculated date. Also has tabs for:
- Aging out (17 1/2 -18 years old)
- Disenrolled current month
- Disenrolled last month
- Disenrolled next month
- Enrolled within last 90 days
Watch the Monthly Rescreen report video
Uses the same data as the rescreen report except this report looks at program recertification due date from the enrollment record. Also has tabs for:
- Aging out (17 1/2-18 years old)
- Disenrolled current month
- Disenrolled last month
- Disenrolled next month
- Enrolled within last 90 days
Watch the Monthly Recertification report video
Includes several ways to query the WPS service authorization (auth) data:
- By auth number
- By exclusion period (suspension)
- By provider
- By date
Watch the CLTS Service Authorization report video
Each spring, county waiver agencies (CWAs) work with DHS to reconcile the CLTS Program’s service and administrative expenditures for the prior calendar year. This report can also be used as a flexible template query of CLTS claims data outside of the reconciliation process.
Watch the CLTS Reconciliation report video
The CLTS Advanced Query Builder (AQB) is a graphical user interface to query CLTS service authorization and claims data. When you use the AQB, you get to decide which columns you want and how to filter the data.
For more information on using the CLTS Service Authorization and Claims Data in SAS you can either watch the June 2024 training recording or view the June 2024 training slides (PDF).
SAS Virtual Learning Environment
The SAS Virtual Learning Environment (VLE) is somewhere you go to retrieve training content and materials, access job aids and documentation, and register for live online classes.