Our Customer - Children's Hospital at Westmead

Australian Paediatric Surveillance Unit


The Project - Eosinophilic Eosophagitis (EoE) Database

Eosinophilic oesophagitis is a rare disease which results in an inflamed oesophagus.


Project Brief

A database was required to retain and manage patient data which was collected for Eosinophilic oesophagitis sufferers.

Data collection included diagnoses, medical history, condition management, investigations, food advice and health services usage.

A user initiated data extract needed to be provided.

Constraints

Data entry needed to be managed by various staff members and not necessarily dedicated data entry personnel.

Extracts were to be formatted and targeted for an SPSS analyst.

Categorical variables were to be explicitly set in the extract process rather than left to the statistician.

Methodology

A relatively straight forward project - the database was built from scratch which is often easier than dealing with existing software.

Questionnaires supplied by the research team provided an outline for the database schema.

Discussions with statistician provided information which identified the preferred categorical coding methods and the preferred extract file type - MS-Excel.

Solution

A database was presented to the research team which provided them with tight data validation rules, intelligent default values and an easy to use interface.

Sample of MS-Access application - Screen 1
Sample of MS-Access application - Screen 2
Sample of MS-Access application - Screen 3
Sample of MS-Access application - Screen 4

Our Customer - Children's Hospital at Westmead


The Project - Food Protein Induced Enterocolitis Syndrome (FPIES) Database

Food Protein Induced Enterocolitis Syndrome is a severe food allergic reaction to food protein ingestion affecting the gastrointestinal tract


Project Brief

Existing data entry functionality required streamlining.

Creation of a data extract was required.

Constraints

New functionality was required to conform to the existing database look-and-feel

Initiation of extracts to be managed by researchers.

Extracts were to be targeted for an SPSS user, and categorical variables were to be explicitly set in the extract process rather than the statistician.

Methodology

Business requirements were gathered by reviewing questionnaires and speaking to the statistical analysts.

Additional data entry functionality was constructed.

Solution

The data was preserved in the database during the modifications.

Users were presented with the new database applications.

A short period of instruction was provided during the User Acceptance Testing (UAT) to familiarise users with the new functionality.

Sample of MS-Access application - Screen 1
Sample of MS-Access application - Screen 2
Sample of MS-Access application - Screen 3
Sample of MS-Access application - Screen 4

Our Customer - Children's Hospital at Westmead


The Project - BEATS Database

Project Brief

Modifications were required to an existing database to minimise time required for statistical analysis.

Constraints

Target analytical software was SAS, so modifications had to streamline inter-operability between SAS and MS-Access.

Methodology

Review of questionnaires for data similarities and possible groupings.

Discussions with SAS user to ascertain available connectivity functionality

Solution

The database schema was modified to allow meaningful groupings allowing direct access for the SAS software to the MS-Access database

.