Qualifacts Connections - User Community

Reporting Warehouse Updates

Loading… Loading feed

Meaningful Use Updates

Loading… Loading feed

New Here?

Here is a quick list of things to do now that you are here.

1. Personalize Your Profile Start a blog, add widgets, and have fun customizing your page for everyone to see.

2. Introduce Yourself Tell us about yourself, and find out about others who share your interests.

3. Post Your Photos Share images of yourself and of your organization.

4. Join a Discussion Group Keep up to date on, and participate in discussions that are meaningful and relevant to you.

Have a question about the community? Ask Drew

Blog Posts

EMDEON & Mobile App

Posted by Sherry Griffith on August 24, 2015 at 3:05pm 0 Comments

We currently are using CareLogic system but are looking into EMDEON for our private insurance.  Can someone please let me know if this is worth looking into?  Also, how are mobile apps working with CareLogic?

Latest Activity

Andrew Davis replied to Angela OBrien's discussion Limit results using two fields in the group Report Building
"I disagree with your method and interpretation here, but I'm not sure how to convince you.  Your query above will give you one result per client for all time.  I don't think that's what Angela wants by my reading.…"
10 hours ago
Andrew Davis replied to Angela OBrien's discussion Limit results using two fields in the group Report Building
"I read it as she want's 'one per client, per day.'   That is, every time a client is DNS, she wants to see it, but not multiple times on the same day if the client has multiple appointments."
10 hours ago
Andrew Davis replied to Angela OBrien's discussion Limit results using two fields in the group Report Building
"select distinctclient_id, service_datefrom rpt_scheduled_activitieswhere status in ('DNS','CBC','CBT')order by service_date, client_id"
10 hours ago
Jennifer Marlar replied to Angela OBrien's discussion Limit results using two fields in the group Report Building
"You could try a count: select c.client_id, c.full_name_alternate, sa.service_date, count(sa.activity_detail_id) as DNScountfrom rpt_client cjoin rpt_scheduled_activities sa on c.client_id = sa.client_idwhere sa.status = 'DNS'and…"
11 hours ago
Charlene Ridenour replied to Angela OBrien's discussion Limit results using two fields in the group Report Building
"Select DISTINCT Max(service_date), Client_ID FROM rpt_scheduled_activities GROUP BY Client_ID"
11 hours ago
Angela OBrien added a discussion to the group Report Building
Thumbnail

Limit results using two fields

My situation is this.  It is possible for a client to have appointments with two staff members in the same day.  I need to track "no shows" however I only need to track one per client, per day.Therefore, if Client A has appointments with Clinician B & Mentor C today, and does not show up for either appointment, I only need to show 1 no show for the day.I can't seem to figure out how to write, if the date of service AND client ID are the same, only give me one result. Thank you in advance.See More
11 hours ago
Profile IconBob Walker, Matthew Brown, Christina Stacy and 5 more joined Qualifacts Connections - User Community
15 hours ago
Brian Newberry replied to Angela OBrien's discussion Error publishing reports via menu link in the group Report Building
"Katy, Not yet.  But the 6 months will start soon from what I understand."
16 hours ago
 
 
 

Welcome to Qualifacts Connections. This site provides the CareLogic community a venue to share ideas and foster collaboration.

Follow Us On

Latest News

Loading… Loading feed

Behavioral Health News

Loading… Loading feed

Mental Health News

© 2015   Created by Gregg.

Badges  |  Report an Issue  |  Terms of Service