Închis

Online database

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.

Regards

Aptitudini: Programare baze de date, MySQL, Oracle, PHP, SQL

Vezi mai multe: online database builder, online database examples, free online database hosting, google online database, free online database with api, free online relational database, free online database for android, online database software, online database interface user friendly, online database client log, create online database post csv, php mysql database populate form selected, query online database asp, design online database windows, create online database free, extract online database, build secure online database, save online database, grab data online database, review online database forms

Despre angajator:
( 0 recenzii ) Wembley, United Kingdom

ID Proiect: #18551293

58 freelanceri licitează în medie 1435£ pentru acest proiect

codeguru786

Hi, I've read the project description and definitely can develop the online database. I'll provide you with the highly skilled & dedicated HTML, PHP, JavaScript, MySQL, front & back-end development services and complet Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 20 zile
(418 recenzii)
9.1
r4rony

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 40 zile
(175 recenzii)
8.5
wpoppo

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 20 zile
(181 recenzii)
8.3
vasundhara19

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 30 zile
(58 recenzii)
8.0
augurstech

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 60 zile
(149 recenzii)
8.2
WebInfoSolutions

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 20 zile
(224 recenzii)
7.9
fleetways

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 60 zile
(88 recenzii)
8.0
hiretechexperts

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 20 zile
(44 recenzii)
7.6
VirasatSolutions

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 20 zile
(98 recenzii)
7.9
mmadi

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 24 zile
(46 recenzii)
7.1
mekiho

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 20 zile
(57 recenzii)
7.0
lavizsolutions

Hi, please check I do have worked on very similar two systems one for carer and one for security guard. [login to view URL] (its under development) [login to view URL] Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 20 zile
(22 recenzii)
6.5
AwaisChaudhry

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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 20 zile
(40 recenzii)
6.4
softcarve

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 45 zile
(104 recenzii)
6.0
restinpc

Hello Sir! I'm ready to take part in this project if you ok with my bid. Expert in C++, PHP, MySQL, JavaScript, jQuery, CSS3, HTML5, Java, A-Frame, Node.js, [login to view URL], Java, MQL, CGI, Google API, XML, JSON, SOAP Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 10 zile
(22 recenzii)
6.3
peterkurt

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 7 zile
(30 recenzii)
6.1
cnath

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 45 zile
(32 recenzii)
6.3
Alexander1005

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 20 zile
(11 recenzii)
5.7
fanninson45

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 25 zile
(24 recenzii)
5.9
pvsysgroupinc

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 30 zile
(19 recenzii)
5.9