How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask LogicPro Your Own Question

LogicPro
LogicPro, Computer Software Engineer
Category: Programming
Satisfied Customers: 12507
Experience:  Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
29751445
Type Your Programming Question Here...
LogicPro is online now
A new question is answered every 9 seconds

I have a query that I need to write and I am having trouble

Customer Question

I have a query that I need to write and I am having trouble with writing it. I need to Get number of admissions for 2015 with the admission date by facility and bedtype
Submitted: 10 months ago.
Category: Programming
Expert:  LogicPro replied 10 months ago.

Hi

please provide me table structure

Customer: replied 10 months ago.
Let me know if this helps
SELECT [Process Date]
,[Date File Created]
,[Action Code]
,[ProcCode]
,[WaiverCode]
,[LTCCode]
,[Payer Identifier Code]
,[Payer]
,[Maintenance Type Code]
,[MaintenanceReason]
,[Subcriber#/RIN#]
,[HICNumber]
,[MemberLastName]
,[MemberFirstName]
,[MemberAddress1]
,[MemberCity]
,[MemberState]
,[MemberZip]
,[Member Birthday]
,[DeathDate]
,[Gender]
,[MemberRace]
,[Race Desc]
,[Comm Qual Type]
,[Communication Nbr#]
,[Effective Date]
,[Policy Number]
,[PolicyName]
,[Medicaid Qualifier]
,[Medicaid Period Format]
,[Medicaid Begin]
,[Medicaid End]
,[Product/Service ID Qualifier]
,[Maintenance Type Code1]
,[Plan Coverage Description]
,[Benefit Qual]
,[Benefit Format]
,[Benefit Begin]
,[Benefit End]
,[InsuranceLine]
,[ResponsibleCode]
,[Entity Type Qual]
,[RespLastName]
,[RespFirstName]
,[RespCommQual1]
,[RespCommNumber1]
,[RespAddress1]
,[RespAddress2]
,[ResponsibleCity]
,[ResponsibleState]
FROM [HIN_SERVERA].[dbo].[AuditFiles_MI]
Expert:  LogicPro replied 10 months ago.

Please provide table structure also

Customer: replied 10 months ago.
I'm thinking I may need to join to get by facility and bed type
Expert:  LogicPro replied 10 months ago.

Provide table structure of all tables you are referring

Customer: replied 10 months ago.
Ok I will get back to you tomorrow with this. What time will you be back on here?
Thanks for responding.
Expert:  LogicPro replied 10 months ago.

I am available almost all the time.

Customer: replied 10 months ago.
Ok perfect, it's pretty late here. I will definitely get back to you. Have a good night.
Expert:  LogicPro replied 10 months ago.

Thank you

good night

Expert:  LogicPro replied 10 months ago.

let me know if you are available to proceed

Customer: replied 10 months ago.
Hi,Please disregard last structure, here's the new one where I need to get number of admissions by facility, by bed type and using group by for 2012 for the state of Nebraska and NJ. The Benefit group for Nebraska is N6721 and NJ NIC56Select
Facility name
Facility ID
Admission date
MemberID
Member first
Member last
Authorization_number
Admission_type_description
Actual_discharge date
Authorized admission date
Provider first name
Provider last name
Admission reason
Line of service
Clinical day type
Admission procedure 1
Admission procedure 2
Admission procedure 3
Authorized admissions date
Benefit group
Benefit plan
From Hin_quest.dbo.spauthLet me know if you need anything else.
Customer: replied 10 months ago.
Include count of authorizations
Expert:  LogicPro replied 10 months ago.

It can be better done on your computer

I will have to see your screen. I'm going to make an offer for remote service that you can use. When you accept it, I'll be immediately notified and can do the work to help you while you watch. After accepting, let me know

Customer: replied 10 months ago.
My computer is protected and not personal because it is company property. Because of these protections, it will not allow me to share my screen. Is there another way?
Expert:  LogicPro replied 10 months ago.

I will have to see the data too.

Which columns have these data:

facility

bed type

2012 for the state of Nebraska and NJ.

What is meant by:

The Benefit group for Nebraska is N6721 and NJ NIC56

Customer: replied 10 months ago.
Hi LogicPro, I am unable to share my screen because it's company policy. I was told that it should be maybe 4 lines, maybe to look like the below but just need help. If you have any idea with the information given. Can you provide me with an idea of what that query might look like, then I can run it and see what my output is?Select count (authorizations) Auth
From Spauth table
Where
And
Group by
Expert:  LogicPro replied 10 months ago.

can you provide this information:

Which columns have these data:

facility

bed type

2012 for the state of Nebraska and NJ.

What is meant by:

The Benefit group for Nebraska is N6721 and NJ NIC56

Customer: replied 10 months ago.
Here are the columns below where I need number of admissions by facility and bedtype, MemberID for the year of 2015. As for the state code that column is benefit group, so if I only want to look at all my admissions for Nebraska then I will need to specify. Admissions type is bed type.Facility name
Facility ID
Admission date
MemberID
Member first
Member last
Authorization_number
Admission_type_description
Actual_discharge date
Authorized admission date
Provider first name
Provider last name
Admission reason
Line of service
Clinical day type
Admission procedure 1
Admission procedure 2
Admission procedure 3
Authorized admissions date
Benefit group
Benefit plan
Expert:  LogicPro replied 10 months ago.

My apologies, I am out of ideas and opting out for other Professionals to answer. Please wait. You will be notified by email as soon as any Professional joins you.

I would be happy to help you with your other questions though.

Thank you for your patience.

Customer: replied 10 months ago.
If I can take a snapshot, would that help.
Customer: replied 10 months ago.
Ok thanks