We are a small recruitment agency that supplies temporary care workers into care homes. We looking at having a Database custom built for organising and logging our staff bookings and producing reports along with general data management.
Currently we subscribe to a software provider and would like to be able to replicate most of the functions of that system to our new database.
Please could you quote us on having this system designed and built, there would normally be 1 user using the system , however would be good to have a multi user system in case 2 people access at any time, also if we wanted to migrate this system to the cloud so we can work from any location.
I have attached a screen shots of the current system we are using, it is built using oracle and is hosted in the cloud.
From the front end Fig 1 you may be able to get a good idea of the general detail.
The way we operate is normally shifts are emailed to us sometimes in an excel attachment which we can upload by amending the spreadsheets so that it maps the template provided by the current software. They can also just be emailed and occasionally over the phone.
We then log this information into our system, firstly we select the home in the first column using the drop box, we then select the date using the calendar tool, then we select the shift type using the drop box(there are several shift types abbreviated e.g. a long day would be LD, an early shift would be E, and a Late would be L and so on, etc). Then we type the start and finish time of the shift, the total units/hours is automatically calculated, then the staff is selected using the drop box and after we select the status( this could be covered/cancelled/no show/outstanding etc). We then type the reference number in the PO field and we have a couple of columns for notes then final column states the name of the user who has input the data or made the last change. The PO Ref tab should not accept duplicate numbers, finally we can tailor a report by filtering any column and hitting the refresh button, this report can them be downloaded to a excel spreadsheet.
• The back end would be to Input homes that we supply see fig 2,
• Report tab Fig 3 should filter the data to a customised excel spreadsheet that we can download, we will supply the format that we want the data in( the system we are currently using does not do the reporting as the developer has not fixed the system)
• Enter Staff Tab Fig 4 is where we can enter all information on staff and upload docs, there are sections where we can input visa and DBS expiry dates this should flag up and not allow us to book the staff if their Visas have expired etc, the current software does not actually do any of that as developer hasn’t gotten around to fix that. However I will leave this to your selves to advise if it can or not be done.
• The view staff tab simply shows the status of data that we had input in enter staff tab along with an action tab as in the attachment.
• Lastly the data load tab Fig 6 is used when homes send shifts on a spreadsheet, we normally copy the data onto the template and upload it from here.
What I am looking for is a system that doesn’t necessarily have to be exactly as the one described, if it could be done in a more efficient way to capture the data that we need and maybe improve on this model as we have been using it for a few years without any updates or changes.
Would be good to have more useful features such as being able to know who can work in which home and if they would be available, although our current system has a tab stating who is available, it doesn’t work or do anything.
I would be grateful if you could let me know if there is a solution that can be created using sql and all costs associated with that, I am open to different ideas as there may be better solutions and more advance features we can have.
58 freelanceri licitează în medie 1435£ pentru acest proiect
Hello, I have checked your requirement with attached PDF files. We will definitely assist you on your Online database creation project. I am very much confident to deliver you desired work solution. PAST PROVEN Mai multe
Hello, Apropos your requirement, you need an Online database, we have shared our company portfolio please go through it: We have a team of professional Full Stack developers with an experience of more than 8+ yea Mai multe
Hello, We are here a professional at web-crafting on various platforms as web development, mobile application development (IOS / Android). I went through your requirements and red all PDF you attached. It looks p Mai multe
Dear Employer, Greetings of the Day! Thanks for sharing your requirements with us. For your project scope, I would be really glad to let you know that you can hire from our team,skilled developers and profess Mai multe
Respected Sir/Madam, No need to go to cloud as it will cost you alot. Lets discuss Working in below technologies => Server Side Languages: VB.NET, C#, Delphi, Cold Fusion, PHP, ASP.NET MVC Razor => Client Sid Mai multe
Thank you for looking at our bid, sorry for exceeding max budget. Would like to propose a multiple admin CRM - something web based that can be hosted on cloud. We probably have to replicate all of the features you ha Mai multe
Sure, can custom built database for logging staff bookings and reports , but need to ask some points. So please send me a text message when you have some time to discuss further. For Now I am submitting a placeholder b Mai multe
Hello, Greetings!!! As per your requirement, you want a Developer who had knowledge of Database & Oracle so Developer can assist you Database Migration & Management. You have a website for a small recruitment Mai multe
Hello, we are experts in Database Programming, MySQL, Oracle, PHP, SQL, we can build your project "Online database" within your budget in freelancer prpvar_budget. Please contact for further details. Kind Regards, M Mai multe
Dear employer. I have read your detailed description carefully. As a senior database programmer I'm very confident building efficient sql database. I worked 2 million records before so that I know how I can optimize d Mai multe
Hi there, I have checked the details I have rich experienced with Database Programming, MySQL, Oracle, PHP, SQL. Please initiate chat so we can discuss this job.
Hi, I see you’re looking for somebody to create a software to be used online for managing the staff. I have checked all the attached screens and reports. We have good experience in doing such web applications. fo Mai multe
Hi, I can build this online database with usage of PHP 7.3 and Nette Framework + MySQL. As checked description and attached PDF all seems to be clear. In case you want some improvements different approaches (as you wr Mai multe
Hello, We believe in small recruitment agency that supplies temporary care workers into care homes and that is why we had already build a CRM on (Healthcare Relationship Management Application) which focuses on all Mai multe
Hello, How are you? I have read your requirements carefully and being an experienced developer who has done extensive work in this part. I am confident that I am 100% suitable for your project. Look forward to worki Mai multe
INTRODUCTION I can see you are interested in building database application for care and nursing home. I have studied your attachments and I have dome similar projects before. I can develop your database and schedul Mai multe
Dear Sir, we made lots of crawler before and which is running in the market also we have team of data so please let us know how we can proceed for the same Thanks