Closed maurya closed 1 year ago
Interval is configurable, so we'd either need to figure out how intervals are defined and automatically convert the set interval to human-friendly text or simply change the name of the concept(s) to include the interval.
Create a new column called interval_description
on patientportal_pcg and patientportal_guideline tables. e.g. repeat at least once/year, at least once, at least once every 5 years, etc
ALTER TABLE patientportal_pcg ADD COLUMN interval_description VARCHAR(256);
ALTER TABLE patientportal_guideline ADD COLUMN interval_description VARCHAR(256);
UPDATE patientportal_guideline SET interval_description = 'After 1 year and at 4 years' WHERE name = 'Colonoscopy';
UPDATE patientportal_guideline SET interval_description = 'Every 6 months' WHERE name = 'History and Physical';
UPDATE patientportal_guideline SET interval_description = 'Every 6 months' WHERE name = 'CEA Tests';
UPDATE patientportal_guideline SET interval_description = 'Once a year' WHERE name = 'CT Scan';
UPDATE patientportal_guideline SET interval_description = 'Once a year' WHERE name = 'CT Scan Pelvis';
UPDATE patientportal_pcg SET interval_description = 'Once a year' WHERE pcg_name = 'Influenza Vaccine';
UPDATE patientportal_pcg SET interval_description = 'At least once' WHERE pcg_name = 'Pneumococcal Vaccine';
UPDATE patientportal_pcg SET interval_description = 'Once a year' WHERE pcg_name = 'Blood Pressure Screening';
UPDATE patientportal_pcg SET interval_description = 'At least once' WHERE pcg_name = 'HIV Screening';
UPDATE patientportal_pcg SET interval_description = 'Every 2 years' WHERE pcg_name = 'Screening Mammography';
UPDATE patientportal_pcg SET interval_description = 'Every 3 years' WHERE pcg_name = 'Cervical Cancer Screening';
UPDATE patientportal_pcg SET interval_description = 'Every 5 years' WHERE pcg_name = 'Cholesterol Screening';
It helps to realize that the db is MySQL, not Postgres 🤪
Under Preventive Care appointment types, change the names of the preventive care options to include the interval after the name.