ICD9 to ICD10 Conversion
Run the following PHP scripts:
To aggregate all tables ending in `_diagnostics` into a new table called `$final_table` for selected database called `$dbname`:
Aggregate all tables into one automatically v0.1.php
Deletes non leading ICD9 codes starting with a 0 to 9, assigns an ICD10 to the ICD9 code that's 3 to 5 digits long, processes the duplicates and leaves `year`, `serial`, `ammap_region`, `icd10`, `cases` columns:
Convert ICD9 (0 to 9 codes )to ICD10 - Stripping ICD9 to 4 Char & processing duplicates v0.2.php RENAME AS WAS NOT NESSARY TO STRIP BACK ICD9
PHP Scripts:
1.Table Aggregation Script: To aggregate tables ending in '_diagnostics' from the database '$dbname' into a new table called '$final_table', you can use the script 'Aggregate all tables into one automatically v0.1.php'.
2.ICD9 to ICD10 Conversion Script: For converting ICD9 codes to ICD10 codes, removing leading non-ICD9 codes (0-9), mapping ICD10 to 3 to 5 digit ICD9 codes, eliminating duplicates, and retaining 'year', 'serial', 'ammap_region', 'icd10', and 'cases' columns, you can utilize 'Convert ICD9 to ICD10 - Stripping ICD9 to 4 Char & processing duplicates v0.2.php'. Note that the renaming of ICD9 codes might not be necessary based on your requirements.