MellowoodMedical Online Help
Reports and Data Validation
PLEASE BE AWARE - THIS PAGE IS IN DEVELOPMENT
Reports are only as accurate as the data entered into IDEAS - they will not identify if you have entered incorrect data
Regular validation is essential - to identify where workflow is incorrect and fields are not being completed
To allow use of General Stats report to validate REGISTRY data
FUTURE - enhances quality of data from SMARTS
ensures smooth running of LABPLAN
We need recommended processes for validating both SMARTS data and date generated through Gen Stats report, as;
not everyone will have SMARTS
Some of the detailed lab data will be more easily viewed in a Gen Stats browse worksheet
VALIDATION
Purpose;
To identify missing or incorrect information
Consequently identify potential user training needs
review treatment types in use
Using the Browse function and exporting to Excel sheet. Use the filter function
Examples of validation checks in GenStats report
Are all your treatment cycles being included in your Gen Stats Crystal report?
run the report - are the treatment type column headings match the options you have in your drop down menu in IDEAS? If not, some cycles are not being included in the report.
Some cycles may not be included because they are data exceptions - decide the settings for this, and if you want to include them.
Broad brush checks
Use Browse for GS report, and export to Excel
Example checks using the filter function in Excel
Cycle Names |
|
---|---|
Establish what you want to validate for each Cycle type
| EXAMPLES Egg freeze cycle shouldn’t have data in columns for;
TX and cycle should be complete Freeze all shouldn’t have embryo transfer date should have
Egg recipient
IUI-D
IVF shouldn’t have any injected eggs shouldn’t have ICSI practitioner vice versa for ICSI
|
Cycle Cancelled column |
|
---|---|
if 'Y' and ‘during down reg’ | ensure; reason is present in the data column no egg collection date or future lab data Tx completed is T |
if ‘Y' and 'during stimulation’ | ensure
|
If if no egg collection date is present in the data column in any cycle | investigate is there actually was no egg collection, or if the lab events have just been forgotten if no egg collection happened, cancel the cycle, enter a reason and complete the Tx. |
When to use cycle cancelled and ‘no embryos transferred’ - Tx Cycle M/ment - Cancellation or No embryo Transfer
When to complete treatments and cycles - Treatment & Cycle Completion
No embryos transferred column | T means that no embryo transfer happened F means that the embryo transfer went ahead |
---|---|
if T in the data column |
|
If there is no ET date present |
|
if no embryos transferred is T in the data column, |
e.g. if reason is ‘no sperm available’ ensure that there is no insem data, fert check, embryo numbers etc' |
failed fert |
|
if no eggs collected | check
|
if egg collected number is zero | check
|
if freeze all embryos | check
|
When to use cycle cancelled and ‘no embryos transferred’ - Tx Cycle M/ment - Cancellation or No embryo Transfer
When to complete treatments and cycles - Treatment & Cycle Completion
Lab events |
|
---|---|
if a numbers is in the injected eggs column | check that the performed treatment is icsi |
if a numbers is in the inseminated eggs column | check that the performed treatment is ivf |
if there is a number in the injected eggs or inseminated eggs columns | check that there is a number in the ‘fertilised on Day 1’ column. Even a failed fertilisation will show a 0 (if not, you may have entered the fertilisation check mistakenly on Day 0 or Day 3 |
if gametes source is donor sperm | check
|
check there is a practitioner entered in all fields |
|
Broadly review embryo grades for Embryo transfer and review against day of ET | check that the grade format corresponds with the day of transfer e.g for day 5 or 6 transfer, that the grades are in a format corresponding to blastocysts |
outcomes |
|
---|---|
if embryo transfer date entered | ensure; pregnancy test result is present if positive,
if negative,
|
ensure all pregnancy-related outcomes have an embryo transfer date |
|
if there are fetal hearts | ensure that outcome is ‘pregnant’ and that there is lab data |
if the final outcome is live birth | ensure that; there is a pregnant/not pregnant outcome that there are fetal hearts and sacs recorded. that the Tx and Cycle are completed |
TRAINING - Mellowood Use
should demonstrate
where reports are
query handler and updates
form in which they come - crystal reports and other types
setting which can be adjusted
Browse function
Export function
Validation