Parent Directory | Revision Log
Links to HEAD: | (view) (download) (annotate) |
Sticky Tag: |
- allow different doc to write the exact same progress note
- robustify somewhat - the old v_pat_narrative was correct after all, but Syan's new one is still useful and faster for SOAP-only progress note narrative so keep it as v_pat_narrative_soap
- added Syan's faster version of clin.v_pat_narrative
- drop constraints before adding - comment out trigger doubling unique index - comment out rarely used indices
- improve Syan's unique(narrative) trigger constraint - move it to the dynamic schema part
- remove age calculation from clin.v_pat_items as it wastes cycles, only calculate age if actually needed, that is, on demand in the SELECT
- remove "order by age" from clin.v_pat_items which would certainly slow down queries
- adjust to better vacc view names
- spell out rfe/aoe
- add clin.operation - move dynamic stuff into view definition file
- indexing on clin.clin_narrative(narrative) directly was prone to buffer overrun since it's a text field of unlimited length, so, index on md5(narrative) now
- move the rest of the dynamic vacc stuff from gmClinicalViews.sql into gmClin-Vaccination-dynamic.sql - add vaccination schedule constraint enumeration data - add is_active to clin.vacc_regime - add clin.vacc_regime_constraint - add clin.lnk_constraint2vacc_reg - proper grants
- factor out EMR structure clinical schema into its own set of files
- factor our vaccination stuff into its own set of files - remove clin.lnk_vacc_ind2code in favour of clin.coded_term usage - improve comments as discussed on the list
- move reviewed_test_results here
- staff.sign -> .short_alias
update permissions for views
- add missing grants - add_table_for_audit() now in "audit" schema - demographics now in "dem" schema - add view v_inds4vaccine - move staff_role from clinical into demographics - put add_coded_term() into "clin" schema - put German things into "de_de" schema
- move auditing to its own schema "audit"
- move vacc_def constraints around - add trigger constraint to make sure there's always base immunization definitions for boosters
- clin.vaccine.id -> pk - remove clin.vaccine.last_batch_no - add clin.vaccine_batches - adjust test data and country data
- with the help of the postgresql list fix the "add missing from" error in v_hx_family
- clin.clin_encounter -> clin.encounter - also id -> pk
- clin_episode -> episode
- clin.clin_health_issue -> clin.health_issue - properly use new add_table_for_notifies()
- explicitely delete public.* tables from notify table and re-insert clin.* tables since add_table_for_notifies doesn't support schema yet
- comment out referral/constituent for now
- create schema "clin" and move all things clinical into it
- review status tracking
- add start of current/previous encounter to waiting list view
- removed left-over reference to clin_encounter.fk_provider
- remove clin_encounter.fk_provider - add v_waiting_list
- waiting list grants
- cleanup - support rfe/aoe in clin_encounter and adjust to that
- cleanup/comments
- cleanup - display provider sign in v_pat_narrative, not db account
- include provider in v_pat_narrative
- cleanup - enforce "only one open episode per health issue at any time"
- partially use improved schema revision tracking
- allow updating clin_root_item directly as Syan showed it to be working - fix problem list to only include real problems
- missing grants on hx_family_item
- refine clin_narrative row mapping in v_emr_journal to display is_rfe status
- add missing coalesce in v_emr_journal
- improve clin_health_issue display in v_emr_journal
- fix faulty index drop - add l10n_type to v_problem_list
- dramatically speed up (read: make usable) v_most_recent_encounters - add three indices on clin_encounter for v_most_recent_encounters - index on coded_narrative - function add_coded_term() - rewrite diagnosis views based on coded_narrative
- soap_cat_ranks grant
- move strings to data
- cleanup, remove dead code - add v_emr_journal - enhance several views to include modified_when/modified_by for v_emr_journal - improve v_pat_narrative - v_compl_narrative -> v_narrative4search - grants
- v_patient_items -> v_pat_items for consistency - add v_hx_family and include in v_compl_narrative
- properly protect clin_root_item and be verbose about it - v_hx_family needs to be rewritten
- store time zone of insert into clin_encounter as a reasonable approximation for other timestamp time zones
- missing variable declaration in f_rfi_type2item
- episode naming much simplified hence simplified views - add episode name into v_compl_narrative - some id_patient -> pk_patient - v_hx_family and grants - apparently lnk_type2item cannot foreign key its fk_item to clin_root_item and expect to work with *child* tables of clin_root_item :-( so add custom referential integrity trigger, this lacks on update/delete support, though, naturally
- cleanup - carry over provider into narrative view
- require name for all episodes thereby fixing not being able to refetch unnamed episodes in the Python middleware
- test_result.id -> pk
- identity.id -> identity.pk - allow NULL for identity.fk_marital_status - subsequent schema changes
- v_test_type_local -> v_test_type_unified - old v_test_type_unified -> v_unified_test_types - follow-on changes, grants - remove cruft
- clin_episode has fk_patient, not id_patient
- clin_health_issue does not yet follow primary key == pk
- add 2 missing "end if;"
- add trigger to announce episode changes
- cleanup - Ian's enhancements to address and forms tables
- carry pk of narrative in episode views so business objects can update it (eg rename the episode)
- v_test_results.unified_target_* from val_target_* first or val_normal_* second
- eventually properly implement episode naming via deferred constraint trigger
- adjust to clin_episode.fk_clin_narrative instead of clin_narrative.is_episode_name
- always hard to get quoting right for dynamic pl/pgsql
- trigger/func _name_new_episode
- clin_episode does not have clinically_relevant anymore as per discussion on list
- fix chi.is_open to be is_active
- episode: is_active -> is_open
- adjust to episode name now living in clin_narrative - v_named_episodes still needs work to properly account for erronously unnamed episodes
- propagate xmin to the relevant views to business classes can use it for concurrency conflict detection - fix v_problem_list to properly display a patient's problems
- enhance v_vacc_regimes -> add "shots" field holding number of shots for regime
- clean up v_pat_allergies
- fix typos and grants
- measurement views rewritten to match current discussion
- add pk_vacc_def to v_vaccs_scheduled4pat
- is_significant -> clinically_relevant
- add rules to protect clin_root_item from direct insert/update/delete, this prevents child table coherency issues
- remove cruft, fix grants - retire lnk_vacc2vacc_def for now as we seem to not need it
- fix missing patient pk in v_compl_narrative
- add v_compl_narrative - add v_problem_list - include is_significant in v_pat_episodes
- remove cruft - in v_pat_episodes UNION pull data from correct places ...
- PG 7.4 is helpful: fix UNION
- curr_medication -> clin_medication + propagate - partial index on clin_episode.fk_health_issue where fk_health_issue not null - index on clin_medication.discontinued where discontinued not null - rework v_pat_episodes since episode can now have fk_health_issue = null - add val_target_* to v_test_results - fix grants - improve clin_health_issue datatypes + comments - clin_episode: add fk_patient, fk_health_issue nullable - but constrain: if fk_health_issue null then fk_patient NOT none or vice versa - form_instances are soaP - start rework of clin_medication (was curr_medication)
- add comments to views - rewrite v_vacc_regimes to be distinct on fk_regime - add v_vacc_defs4reg to list vaccination events for all known schedules, this used to be v_vacc_regimes - add v_vacc_regs4pat to list schedules a given patient is on - add v_vaccs_scheduled4pat to list vaccination events that are scheduled for a patient according to the schedules that patient is on - rewrite v_pat_missing_vaccs/boosters based on the above - matching grants
- added v_pat_narrative by Carlos
- added v_pat_item_types/v_types4item
- added arbitrary typing of clin_root_items
- don't use user/_user workaround anymore as we dropped supporting it (but we did NOT drop supporting readonly connections on > 7.3)
- allow for coding any SOAP row - adjust views/tables to that
- v_pat_diag_codes - v_codes4diag
- added pk_diag to v_coded_diag
- fix grants
- v_rfe/aoe -> v_pat_rfe/aoe
- fix v_coded_diags: fk_diag=pk_diag
- add grants - I'm getting old
- DROP INDEX cannot have ON clause, duh
- add v_aoe/v_rfe
- can't name all indexes the same :-)
- indexes on clin_narrative
- bring rfe/aoe/diag/coded_diag tables/views up to snuff and use them
- clin_working_diag -> clin_coded_diag + index fixes therof - v_pat_diag rewritten for clin_coded_diag, more useful now - v_patient_items.id_item -> pk_item - grants fixed - clin_rfe/aoe folded into clin_narrative, that enhanced by is_rfe/aoe with appropriate check constraint logic - test data adapted to schema changes
- clin_note -> clin_narrative - remove v_i18n_curr_encounter - add clin_rfe, clin_aoe
- add pk_item to v_lab_requests
- fixed on fk_ -> pk_
- add view on lab_request -> v_lab_requests so we can fk_ -> pk_
- indices on clin_root_item fields in descendants - id_* -> fk/pk_*
- id_episode -> fk/pk_episode
- pull in some more PKs in views for episode/encounter/issue sorting
- vpep.episode now vpep.description
- fix grants re allergy_state - include soap_cat in v_patient_items
- encounter_type.id -> encounter_type.pk
- cleanup signal handling on allergy table
- allow test results with lab_request.is_pending is True in v_results4lab_req
- eventually seem to have fixed latest_due/amount_overdue in v_pat_missing_boosters
- remove v_i18n_enum_encounter_type - _enum_encounter_type -> encounter_type - add some _() uses - improve v_pat_missing_vaccs/v_pat_missing_boosters - cleanup/grants
- first cut at amount_overdue for missing boosters (eg, now() - (last_given + min_interval)) but doesn't work as expecte for last_given is null despite coalesce(..., min_interval)
- test_type_uni -> test_type_local
- adapt to progress_note <-> description reversal in clin_working_diag
new referral table some changes to old medications tables, but still need more work
- add v_pat_diag, grants
- fk description clin_working_diag -> clin_aux_note - v_pat_diag
- rework diagnosis tables + grants for them
- fix v_test_org_profile
- enhance test_org_profile
- all shiny and new, vastly improved vaccinations handling via clinical item objects - mainly thanks to Carlos Moro
new referral table (do we still need gmclinical.form_data then?)
- fix coalesce on unified_name/code in v_results4lab_req - add unified_val
- allergies API revamped, kudos to Carlos
- add v_pat_encounters
- v_patient_episodes -> v_pat_episodes
- move grants into re-runnable scripts - update *.conf accordingly
- support and use optionally cross-provider unified test names
- comments/constraints/references on test_result, also result_when -> clin_when - v_results4lab_req, v_test_org_profile, grants
- remove allergy.reaction -> use clin_root_item.narrative instead
- adjust to id_ -> fk_/pk_
- add v_most_recent_encounters
- remove v_patient_vaccinations, v_pat_due_vaccs, v_pat_overdue_vaccs - add v_pat_missing_vaccs, v_pat_missing_boosters
- fk_recommended_by as pk_recommended_by
- add/rename some FKs in views
- v_patient_vacc4ind - reformatting DDLs
- __default__ -> xxxDEFAULTxxx
- rebuild v_vacc_regimes/v_patient_vaccinations/v_pat_due|overdue_vaccs due to vaccination/vacc_def link normalization - grants
- we want UNIQUE indices on names.active etc - add some i18n to views as well as some coalesce()
- improve vaccination views
- add views *_overdue_vaccs and *_due_vaccs
- lnk_vaccdef2reg does not exist anymore
- clin_date -> clin_when in v_patient_items
- make partial index on __default__ encounters optional, fails on 7.1
- clin_when in clin_root_item
- use clin_date instead of date_given in vaccination
- curr_encounter doesn't have id_patient anymore, fix trigger funcs
- update view defs
- clin_encounter now has fk_patient, hence v_i18n_patient_encounters not needed anymore - add v_i18n_curr_encounter view - add v_patient_vaccinations view
- truncate -> delete from
- even better vaccination tables
- add vaccination views (still flaky)
- added measurements views
- add clin_root_item triggers - modify NOTIFY triggers so they include the patient ID as per Ian's suggestion
- add clin_health_issue triggers and functions
- now clin_root_item inherits from audit_fields we can add extract(epoch from modified_when) as age to v_patient_items and order by that :-)
- curr_encounter tracking triggers + grants
- reorder v_patient_episodes/*_items for clarity
- fix spelling of definate -> definite
- notify triggers should come last, so make them zz*
- adapt to changes in gmclinical.sql, particularly the narrative/item merge
- gmI18N, gmServices and gmSchemaRevision are imported globally at the database level now, don't include them in individual schema file anymore
- pkey_ -> pk_
- adapt to clin_narrative being an ancestor table
- add grants
- add as to encounter types
- we do need the v_i18n_ on encounter types
- major reworking to follow the formal EMR structure writeup
- make patient allergies view work
- make trigger return happy - tweak v_i18n_patient_allergies - not done yet
- function/trigger to announce insertion/deletion of allergy - allergy.id_substance -> allergy.substance_code
- v_i18n_patient_allergies - new_allergy -> allergy_new
- added more views + grants
- cleanups and GRANTs
- this can safely be dropped and recreated even with data in the tables
This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, select a symbolic revision name using the selection box, or choose 'Use Text Field' and enter a numeric revision.
savannah-hackers-public@gnu.org | ViewVC Help |
Powered by ViewVC 1.1.26 |