|
|
Re: Action done by client on same date of service as a specific procedure code [message #278975 is a reply to message #278973] |
Tue, 06 November 2007 08:43   |
PatrickAylmer
Messages: 4 Registered: December 2005
|
Junior Member |
|
|
Here's what I try:
I query on clients with a procedure code 20111. then I exported the client list and query on clients: but that don't give me the others procedures on same service date.
I've also try this formula:
COUNT_DISTINCT(Procedure Code) OVER(PARTITION BY CLAIMS HISTORY DETAILS2.Provider Number,Client ID,Service Date )
that gives me a count of distinct procedures. Then I query on procedure count greater then 1, but this doesn't proove me that every client have a code 20111 and every actions after.
hope it's clear...thanks
|
|
|
|
|
|
Re: Action done by client on same date of service as a specific procedure code [message #279009 is a reply to message #279007] |
Tue, 06 November 2007 10:29   |
PatrickAylmer
Messages: 4 Registered: December 2005
|
Junior Member |
|
|
"why not just post the query in the forum"
thanks, but what else do you need? I have poste the formula, and what I wanted to result from it, and the fields I am using.
the end result shoud be 'Clients who received any other Procedure Code on the same service date then procedure code 20111'
conditions used are:
-STATUS= PAID
-Provider Region=Quebec
-Dist. Procedure Code Count is greater then 1.
Do you need anything else?
thanks again
sorry I'm not a superuser....
|
|
|
Re: Action done by client on same date of service as a specific procedure code [message #279012 is a reply to message #279009] |
Tue, 06 November 2007 10:56  |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
Quote: | sorry I'm not a superuser....
|
What makes you think we expect you to be a superuser? Have we given you the impression that you will only get an answer if you have enough knowledge to not need us to give you an answer?
We have quite simply, asked you to provide the actual query. That's all, nothing complex, just a cut and paste of the query that you are trying to run.
Quote: | thanks, but what else do you need?
| The query, as previously asked for by Michel.
Quote: | I have poste the formula,
| Well, you posted A formula, but it's not valid Oracle SQL syntax, from the looks of it, it is a Discoverer syntax
Quote: | the end result shou[l]d be 'Clients who received any other Procedure Code on the same service date then procedure code 20111
| Tells us very little. Remember we have No Idea as to your data.
OK, you asked what we need. Supply a test case. i.e. supply create table statements for the relevant tables along with representative data to allow for replication of your issue along with the set of results that you require the query to return.
I'm not going to waste my time to-ing and fro-ing, continually seeking clarifications, or supplying more guesses whereby you say "but what if..." or "Well actually the REAL situation is..."
Do not attach a file, simply paste the code, surrounded by code tags.
Thanks
|
|
|