KI Tx Follow Up Import

Scandiatransplant: KI Tx Follow Up Import

Import files must be in Microsoft Excel, .xls-format ([BIFF8]) or .xlsx

Import files must contain these columns in the designated order:

Renal repl. treatment at tx. types:

1 Hospital haemodialysis or haemofiltration

2 Home haemodialysis or haemofiltration

3 Intermittent peritoneal dialysis

4 Continuous peritoneal dialysis

5 Transplantation

6 pre-emptive is only for kidney tx. with no dialysis (if graft loss, the graft loss date must be the same as next tx date)

Import files should contain one header row. The first data row must follow immediately after the header row.

Follow up dates
Death date = follow up date
Graft loss date = follow up date
Both Death date and graft loss date –> graft loss date = follow up date
All others 01-01-20xx/31-12-20xx (first day of this year/or last date of last year)
Validation rules (done by the Scandiatransplant office)

Logging
- All import records are logged in a CSV format log file
- Database values deviating from the import values are logged

Import actions:

Date of Follow Up will be overwritten if a record already exists
Onset date will be overwritten
Graft loss cause will NOT be overwritten.
Graft loss date will be overwritten if a record already exists.
Death cause will NOT be overwritten.
Death date will be overwritten if a record already exists.
Date of first renal replacement treatment will be overwittten
Renal replacement treatment type (dialysis or tx) will be overwittten
Cold iscemia time will be overwritten if a record already exists.

Update Follow Up Status =

1 if no graft loss and death records exists
2 if only graft loss record exists
3 if only death records exists
4 if graft loss and death records exists