Hammersmith Registry>Follow-up>Progression

[afzalkhan500]

It looks like REDCap is choosing Lympoid when it should be blank:

For patient 1360 it looks like when BC type exists it is choosing the right one but in above example when blank it reverts to Lymphoid:

[fhosking]

Fixed incorrect incoding of blank BC type

[afzalkhan500]

That works but I notice for patient 254 when only the date is entered and nothing else it picks Yes for "progr to AP/BC" when is should be No and picks Blastic phase when it should be blank.

[fhosking]

This is a side issue, maybe i should make it a separate issue, but there's something funny that I can see happening with record 254:

When I search the raw data from access for records with progression date #3 above 15-08-2006, it can't find record 254:

When I search the raw data for episodes for record 254, it only finds 3

I've done a basic check that I have haven't made some sort of basic error in this import section. Please could you double check that the screenshot from above definitely belongs to record with baselineid 254 ?}

I'm quite confused by this issue! It's like the data in my export doesn't really seem match your screenshots!

[afzalkhan500]

The reason you can only see three records is probably because the MS Access database has been updated since I sent you a copy a year ago, hence 4 rows, but the important thing is for record 15/01/2008 there should be no blast phase chosen. Hope this makes sense.

[afzalkhan500]

Just realised it is possible I may have deleted the Yes and Blast phase in my MS Access database hence the difference?

[fhosking]

It does seem that that is the way the data is being represented in the raw dataset:

I can't really seem to identify a mark in the data that could help me identify when a record should or shouldn't be blastic phase

[fhosking]

We could try again with a fresher dataset if you like?

[afzalkhan500]

Leave it for now I think it is probably due to my MS Access database being modified hence the discrepancies.