In Progress

Enforce authorization boundaries

There is a requirement to modify the Progress Note Detail page in an existing C# web application to ensure that if the note is a Medicaid program type then the procedure code used is one that is in the list of authorized procedure codes.

Another validation routine that needs to occur when the note is saved is to make sure that the total number of units authorized is not exceeded with the units that are to be added by the save request. If it does exceed, a message will need to be displayed to the user stating that the number of units authorized has been exceeded.

When the page is loaded with a progress note, the call to the database that gets the note details to go on the page should also get the number of units that have been used as well as the number remaining on the authorization. These two values should be added to the page. A suggestion is to use some type of graphical indicator that shows something like 270 out of 312 units as being the current unit utilization.

There is also a need to create a stored procedure that will return the authorizations that are within X number of units of the maximum number of units authorized or within Y days of the end date of the authorization. For this stored procedure X and Y should be arguments that are passed into the stored procedure but with defaults of X = 30 and Y = 20. Another stored procedure should also return all authorizations that have already exceeded their authorized number units or have Medicaid progress notes that exceed the authorized date range.

There also needs to be a new page that uses this stored procedure so the user can query and identify authorizations that are near or have exceeded their limits in terms of the remaining units or end date of authorization.

Skills: .NET, C# Programming, SQL

See more: sql query to get list of database, sql get date, range query, range maximum query, exceed database, exceed maximum, stored procedure list, database authorization, progress indicator, secure content displayed message remove, stored procedure create sql, modify procedure, authorization, save codes database, range indicator, return authorization program, graphical web application, application limits, modify indicator, stored procedure sql save, sql query date, scrolling message bar cre loaded, save stored procedure, net suggestion, net indicator

About the Employer:
( 76 reviews ) Peachtree City, United States

Project ID: #4707532

Awarded to:


Please find bid amount added. I should have completed code back to you in a week for testing. Thanks, Arpit

$45 USD in 7 days
(48 Reviews)

11 freelancers are bidding on average $192 for this job


I've been developing solutions in C# for over a decade now am am more than certain that I can help you to bring this project to fruition. Please see my private message for more pertinent information. Thank you!

$210 USD in 2 days
(19 Reviews)

Hi, First of all thanks for posting this project, I am available to provide you economical services for web development , I have read and understood all of project details. I am expert in software development and c More

$155 USD in 3 days
(8 Reviews)

Hi, Since last 8.5 years, i am extensively using Asp.Net, C# with Jquery/Ajax and for services using WCF/Rest WCF/Rest Web API and SqlServer 2008/R2 for back-end. Expertize in ASP.Net|C# Win Forms|SharePoint2010| More

$244 USD in 10 days
(9 Reviews)

Let me do this job

$150 USD in 3 days
(7 Reviews)

Hello, We have more than 6+ years of experience in C# with ASP.Net. We can complete the task in 10 working days along with complete testing and we bid 240$ [what we get] for this task. We would like to know which da More

$266 USD in 10 days
(21 Reviews)

Hi, I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-fr More

$300 USD in 7 days
(10 Reviews)

Hi, Please check the PMB. Thanks.

$277 USD in 3 days
(9 Reviews)

hi i got all of your requirement and i would like to complete your work within [url removed, login to view]

$50 USD in 3 days
(5 Reviews)

Hi I am Mahesh. I am having 8 years of hand on experience on web development on Microsoft development stack. Sound experience in web technologies and latest web technologies trends. c# , MVC 4, HTML5 ,jqu More

$166 USD in 10 days
(1 Review)

Certified SQL/JQuery/C#/ freelancer that has 15 years of experience is ready to deliver a perfect solution to your requirements.

$250 USD in 9 days
(0 Reviews)