Databases

Personal Database

Personnel Database

The Personnel Database integrates 17 staff and volunteer related Registers, lists and schedules into the one spreadsheet with tabs for:

  • Board members
  • Administration
  • Nurses
  • Personal Carers
  • Lifestyle
  • Catering
  • Cleaning, Laundry & Maintenance
  • Health Professionals (Employed, not contractors)
  • Volunteers

The purpose of the database is to maintain accurate records of key information relevant for each work group:

  • Contact details  and emergency contact details
  • Appointment details
  • Orientation dates (organizational & departmental)
  • Appraisal initial and annual
  • Police checking details & Statutory Declaration date
  • Driver’s licenses (car / bus)
  • Qualifications
  • Annual Mandatory training
  • Competencies completed for the year
  • Education Attendance for year
  • Immunisation for Flu
  • Termination date 

Once data has been entered into the spreadsheet various columns can be selected to create and print lists and reports as required.   Whilst a Printing Instructions Guide is provided to assist with printing customized lists staff using the spread  sheet will need to have some idea of how to use Excel.  The spreadsheet can be saved and updated for each year.

Price: $150 (ex. GST)

 

 

 

Database

Consumer Database

The purpose of the database is to maintain accurate records of key resident information.  The Resident Database integrates the following 19 resident related Registers, lists and schedules into the one spreadsheet:

  • Consumer Details List
  • Medical Practitioner List
  • Health Check Monitoring
  • Care Plan Evaluation Schedule
  • Handover Sheet
  • Care Plan Consultation Contact List
  • ACFI Summary and Reappraisal Due Dates
  • Physical Therapy List
  • Continence Products
  • Activity Groups
  • Birthday List
  • Cultural & Religious Requirements
  • Religious Visitors List
  • Evacuation List
  • Immunisation Register
  • Dietary Requirements List
  • Drinks List
  • Meal Choices
  • Do Not Serve List
The columns and data entry drop down lists can be customised to meet your organisational needs. Once data has been entered into the spreadsheet various columns can be selected to create and print lists and reports as required.

Whilst a Guide is provided to assist with data entry and printing customized lists staff using the spread  sheet will need to have some idea of how to use Excel.

Price: $150 (ex. GST)

Supplier List

Approved Suppliers List

  • This spreadsheet has tabs for suppliers for each service area
  • The following information about each approved supplier can been entered:
  • Supplier details including; goods/service provided
  • Contact details
  • Registration/qualifications/licenses
  • Police check requirements
  • Insurances
  • Agreement cycle dates
  • Induction date
  • Date of last annual evaluation.

                                                                                                                        Price: $30 (ex. GST)