Care worker database
- or -
Post a project like this$$$
- Posted:
- Proposals: 24
- Remote
- #1316591
- Expired
Retired academic (PhD) with experience in biochemistry, medical genetics, data analysis, publication and image manipulation
London
Top rated PHP Web Development | WordPress | Magento | Drupal | OpenCart | PrestaShop | Joomla
Leicester
522001140001613996001284588128075412651871218161117980110507541022292660034591186
Description
Experience Level: Expert
Estimated project duration: 3 - 4 weeks
General information for the website: Children's charity
Database management system (DBMS): MySQL
Description of requirements/features: Need a database creating for Care Workers (for a small childrens charity) with ability to add case notes and pull off reports, with triggers for reviews etc.
Ideally, we'd like to host the database system on our existing server which is a LAMP configuration - and it would live on a sub-domain.
Required fields:
Category: RED/AMBER/GREEN
Young Carers details:
Surname/first name/
Gender
Ethnicity
Date of birth
Medical information:
Is the Young Carer on a Child Protection Plan (date, category)
Is the young carer in receipt of other support (specify)
Has parental consent been obtained in line with medical/digital/information sharing?
Main contact details:
Name of parent/guardian
Postal address – incl Ward/Area
Tel number
Mobile
Emergency/alternative contact number
Email
Barriers to contact: ie English not first language/hearing impairment
Siblings: are they also known to young carers?
Is there ability to make connections with siblings on the data base? (for ease of reference)
Other Fields
Cared for person:
Type: drop down options ie. Physical, learning disability, mental health, sensory impairment, substance misuse/other
Impact of caring on the child: severe/moderate/low
Caring activities – brief notes box to describe what they do at home
Education (primary/secondary/college/uni), full address
Main contact at school
Is the young adult carer in employment? Full/part time
Other fields required:
Date of referral:
Name of referrer/contact details
Status: drop down options: for action/open/archived/closed
Name of worker who assessed:
Outcome: assessment/review/referred to other services (Adult Carers Centre, GM Fire and Rescue Children’s Services, Adult Social Care, Other/NFA
Date of assessment
Date of review – with alert flag
Date closed
Types of support offered: support worker/group work/befriending/counselling/cook club/training/transition/holiday lodge/family mediation/other
We need:
Each YC to have a unique ID code and case reference
Support worker able to write case notes and to record any contact made from parents/professionals ie how/when/where – telephone/email/letter/visit to office/home visit
- Ability to pull of reports
- Secure log in for each support worker/employee/someone to have full admin rights
- Ability to edit some of the fields would be useful (unless this makes it really complex)
Design/layouts will be suppled in PSD format (or similar workable files)
Extra notes:
Database management system (DBMS): MySQL
Description of requirements/features: Need a database creating for Care Workers (for a small childrens charity) with ability to add case notes and pull off reports, with triggers for reviews etc.
Ideally, we'd like to host the database system on our existing server which is a LAMP configuration - and it would live on a sub-domain.
Required fields:
Category: RED/AMBER/GREEN
Young Carers details:
Surname/first name/
Gender
Ethnicity
Date of birth
Medical information:
Is the Young Carer on a Child Protection Plan (date, category)
Is the young carer in receipt of other support (specify)
Has parental consent been obtained in line with medical/digital/information sharing?
Main contact details:
Name of parent/guardian
Postal address – incl Ward/Area
Tel number
Mobile
Emergency/alternative contact number
Barriers to contact: ie English not first language/hearing impairment
Siblings: are they also known to young carers?
Is there ability to make connections with siblings on the data base? (for ease of reference)
Other Fields
Cared for person:
Type: drop down options ie. Physical, learning disability, mental health, sensory impairment, substance misuse/other
Impact of caring on the child: severe/moderate/low
Caring activities – brief notes box to describe what they do at home
Education (primary/secondary/college/uni), full address
Main contact at school
Is the young adult carer in employment? Full/part time
Other fields required:
Date of referral:
Name of referrer/contact details
Status: drop down options: for action/open/archived/closed
Name of worker who assessed:
Outcome: assessment/review/referred to other services (Adult Carers Centre, GM Fire and Rescue Children’s Services, Adult Social Care, Other/NFA
Date of assessment
Date of review – with alert flag
Date closed
Types of support offered: support worker/group work/befriending/counselling/cook club/training/transition/holiday lodge/family mediation/other
We need:
Each YC to have a unique ID code and case reference
Support worker able to write case notes and to record any contact made from parents/professionals ie how/when/where – telephone/email/letter/visit to office/home visit
- Ability to pull of reports
- Secure log in for each support worker/employee/someone to have full admin rights
- Ability to edit some of the fields would be useful (unless this makes it really complex)
Design/layouts will be suppled in PSD format (or similar workable files)
Extra notes:
James B.
100% (4)Projects Completed
7
Freelancers worked with
3
Projects awarded
45%
Last project
28 Mar 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello James,
Have you found a developer for your project or are you still looking for one?
Is it possible to see a preview of the PSD file you mentioned?
Thank you. -
Hey James,
When are you planning to start on this ?
Would you like to have it CMS based like WordPress or Custom PHP ?
What would be the ideal completion time ? -
Hi James
Would it be possible to see the PSDs to get more of an idea about how much design work will be required as well as the DB / coding?
Do you have a rough budget for this?
190652182430182428
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies