/[gnumed]/gnumed/gnumed/server/sql/gmClinicalViews.sql
ViewVC logotype

Log of /gnumed/gnumed/server/sql/gmClinicalViews.sql

Parent Directory Parent Directory | Revision Log Revision Log


Links to HEAD: (view) (download) (annotate)
Sticky Tag:

Revision 1.184 - (view) (download) (annotate) - [select for diffs]
Tue Jun 20 15:49:30 2006 UTC (17 years, 10 months ago) by ncq
Branch: MAIN
CVS Tags: HEAD, client, frozen4conversion2git, rel-0-2, rel-0-2-2, rel-0-2-2-real, rel-0-2-3-0, rel-0-2-3-rc, rel-0-2-4-0, rel-0-2-4-1, rel-0-2-4-2, rel-0-2-4-rc, rel-0-2-5-0, rel-0-2-5-1, rel-0-2-5-rc, rel-0-2-5-rc1, rel-0-2-5-rc2, rel-0-2-5-rc3, rel-0-2-5-rc4, rel-0-2-6, rel-0-2-6-0, rel-0-2-6-1, rel-0-2-6-2, rel-0-2-6-3, rel-0-2-6-rc1, rel-0-2-7, rel-0-2-7-0, rel-0-2-7-1, rel-0-2-8, rel-0-2-8-0, rel-0-2-8-1, rel-0-2-8-10, rel-0-2-8-11, rel-0-2-8-12, rel-0-2-8-2, rel-0-2-8-3, rel-0-2-8-4, rel-0-2-8-5, rel-0-2-8-6, rel-0-2-8-7, rel-0-2-8-8, rel-0-2-8-9, rel-0-2-8-rc1, rel-0-3, rel-0-3-0, rel-0-3-1, rel-0-3-10, rel-0-3-11, rel-0-3-12, rel-0-3-2, rel-0-3-3, rel-0-3-4, rel-0-3-5, rel-0-3-6, rel-0-3-7, rel-0-3-8, rel-0-3-8-10, rel-0-3-9, rel-0-4, rel-0-4-1, rel-0-4-2, rel-0-4-3, rel-0-4-4, rel-0-4-5, rel-0-4-6, rel-0-4-7, rel-0-5, rel-0-5-0, rel-0-5-1, rel-0-5-2, rel-0-5-rc1, rel-0-5-rc2, rel-0-5-rc3, rel-0-5-rc4, rel-0-5-rc5, rel-0-6, rel-0-6-0, rel-0-6-1, rel-0-6-rc1, rel-0-6-rc2, rel-0-6-rc3, rel-0-6-rc4, rel-0-6-rc5, rel-0-6-rc6
Branch point for: rel-0-2-3-patches, rel-0-2-4-patches, rel-0-2-5-patches, rel-0-2-6-patches, rel-0-2-7-patches, rel-0-2-8-patches, rel-0-2-patches, rel-0-3-patches, rel-0-4-patches, rel-0-5-patches, rel-0-6-patches
Changes since 1.183: +9 -3 lines
Diff to previous 1.183
- allow different doc to write the exact same progress note


Revision 1.183 - (view) (download) (annotate) - [select for diffs]
Sun May 28 15:22:25 2006 UTC (17 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.182: +28 -15 lines
Diff to previous 1.182
- 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


Revision 1.182 - (view) (download) (annotate) - [select for diffs]
Sat May 27 14:52:07 2006 UTC (17 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.181: +51 -3 lines
Diff to previous 1.181
- added Syan's faster version of clin.v_pat_narrative


Revision 1.181 - (view) (download) (annotate) - [select for diffs]
Wed May 3 21:30:56 2006 UTC (17 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.180: +49 -41 lines
Diff to previous 1.180
- drop constraints before adding
- comment out trigger doubling unique index
- comment out rarely used indices


Revision 1.180 - (view) (download) (annotate) - [select for diffs]
Sat Apr 29 18:14:42 2006 UTC (18 years ago) by ncq
Branch: MAIN
Changes since 1.179: +37 -2 lines
Diff to previous 1.179
- improve Syan's unique(narrative) trigger constraint
- move it to the dynamic schema part


Revision 1.179 - (view) (download) (annotate) - [select for diffs]
Sun Apr 23 16:51:39 2006 UTC (18 years ago) by ncq
Branch: MAIN
Changes since 1.178: +6 -3 lines
Diff to previous 1.178
- 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


Revision 1.178 - (view) (download) (annotate) - [select for diffs]
Mon Mar 13 17:32:09 2006 UTC (18 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.177: +5 -4 lines
Diff to previous 1.177
- remove "order by age" from clin.v_pat_items which would certainly slow down queries


Revision 1.177 - (view) (download) (annotate) - [select for diffs]
Wed Mar 8 09:24:28 2006 UTC (18 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.176: +6 -3 lines
Diff to previous 1.176
- adjust to better vacc view names


Revision 1.176 - (view) (download) (annotate) - [select for diffs]
Mon Feb 27 22:39:33 2006 UTC (18 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.175: +9 -5 lines
Diff to previous 1.175
- spell out rfe/aoe


Revision 1.175 - (view) (download) (annotate) - [select for diffs]
Mon Feb 27 11:28:12 2006 UTC (18 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.174: +34 -6 lines
Diff to previous 1.174
- add clin.operation
- move dynamic stuff into view definition file


Revision 1.174 - (view) (download) (annotate) - [select for diffs]
Mon Feb 20 10:22:32 2006 UTC (18 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.173: +14 -3 lines
Diff to previous 1.173
- 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


Revision 1.173 - (view) (download) (annotate) - [select for diffs]
Sun Feb 19 13:45:05 2006 UTC (18 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.172: +5 -302 lines
Diff to previous 1.172
- 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


Revision 1.172 - (view) (download) (annotate) - [select for diffs]
Fri Feb 10 14:08:58 2006 UTC (18 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.171: +9 -334 lines
Diff to previous 1.171
- factor out EMR structure clinical schema into its own set of files


Revision 1.171 - (view) (download) (annotate) - [select for diffs]
Wed Feb 8 15:15:39 2006 UTC (18 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.170: +42 -276 lines
Diff to previous 1.170
- 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


Revision 1.170 - (view) (download) (annotate) - [select for diffs]
Fri Jan 27 22:24:45 2006 UTC (18 years, 3 months ago) by ncq
Branch: MAIN
Changes since 1.169: +10 -2 lines
Diff to previous 1.169
- move reviewed_test_results here


Revision 1.169 - (view) (download) (annotate) - [select for diffs]
Mon Jan 23 22:10:57 2006 UTC (18 years, 3 months ago) by ncq
Branch: MAIN
Changes since 1.168: +17 -13 lines
Diff to previous 1.168
- staff.sign -> .short_alias


Revision 1.168 - (view) (download) (annotate) - [select for diffs]
Tue Jan 10 23:22:17 2006 UTC (18 years, 3 months ago) by sjtan
Branch: MAIN
Changes since 1.167: +13 -3 lines
Diff to previous 1.167
update permissions for views


Revision 1.167 - (view) (download) (annotate) - [select for diffs]
Fri Jan 6 10:12:02 2006 UTC (18 years, 3 months ago) by ncq
Branch: MAIN
Changes since 1.166: +90 -54 lines
Diff to previous 1.166
- 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


Revision 1.166 - (view) (download) (annotate) - [select for diffs]
Thu Jan 5 16:04:37 2006 UTC (18 years, 3 months ago) by ncq
Branch: MAIN
Changes since 1.165: +8 -3 lines
Diff to previous 1.165
- move auditing to its own schema "audit"


Revision 1.165 - (view) (download) (annotate) - [select for diffs]
Sun Jan 1 20:41:06 2006 UTC (18 years, 3 months ago) by ncq
Branch: MAIN
Changes since 1.164: +117 -4 lines
Diff to previous 1.164
- move vacc_def constraints around
- add trigger constraint to make sure there's always base
  immunization definitions for boosters


Revision 1.164 - (view) (download) (annotate) - [select for diffs]
Thu Dec 29 21:48:09 2005 UTC (18 years, 4 months ago) by ncq
Branch: MAIN
Changes since 1.163: +16 -10 lines
Diff to previous 1.163
- clin.vaccine.id -> pk
- remove clin.vaccine.last_batch_no
- add clin.vaccine_batches
- adjust test data and country data


Revision 1.163 - (view) (download) (annotate) - [select for diffs]
Wed Dec 7 16:28:18 2005 UTC (18 years, 4 months ago) by ncq
Branch: MAIN
Changes since 1.162: +9 -5 lines
Diff to previous 1.162
- with the help of the postgresql list fix the "add missing from"
  error in v_hx_family


Revision 1.162 - (view) (download) (annotate) - [select for diffs]
Tue Dec 6 13:26:55 2005 UTC (18 years, 4 months ago) by ncq
Branch: MAIN
Changes since 1.161: +36 -33 lines
Diff to previous 1.161
- clin.clin_encounter -> clin.encounter
- also id -> pk


Revision 1.161 - (view) (download) (annotate) - [select for diffs]
Mon Dec 5 19:05:59 2005 UTC (18 years, 4 months ago) by ncq
Branch: MAIN
Changes since 1.160: +26 -22 lines
Diff to previous 1.160
- clin_episode -> episode


Revision 1.160 - (view) (download) (annotate) - [select for diffs]
Sun Dec 4 09:42:06 2005 UTC (18 years, 4 months ago) by ncq
Branch: MAIN
Changes since 1.159: +36 -34 lines
Diff to previous 1.159
- clin.clin_health_issue -> clin.health_issue
- properly use new add_table_for_notifies()


Revision 1.159 - (view) (download) (annotate) - [select for diffs]
Tue Nov 29 19:06:13 2005 UTC (18 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.158: +8 -3 lines
Diff to previous 1.158
- explicitely delete public.* tables from notify table and re-insert
  clin.* tables since add_table_for_notifies doesn't support schema yet


Revision 1.158 - (view) (download) (annotate) - [select for diffs]
Sun Nov 27 12:59:09 2005 UTC (18 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.157: +5 -8 lines
Diff to previous 1.157
- comment out referral/constituent for now


Revision 1.157 - (view) (download) (annotate) - [select for diffs]
Fri Nov 25 15:07:28 2005 UTC (18 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.156: +816 -320 lines
Diff to previous 1.156
- create schema "clin" and move all things clinical into it


Revision 1.156 - (view) (download) (annotate) - [select for diffs]
Wed Oct 26 21:33:25 2005 UTC (18 years, 6 months ago) by ncq
Branch: MAIN
Changes since 1.155: +10 -13 lines
Diff to previous 1.155
- review status tracking


Revision 1.155 - (view) (download) (annotate) - [select for diffs]
Sun Sep 25 17:49:24 2005 UTC (18 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.154: +12 -6 lines
Diff to previous 1.154
- add start of current/previous encounter to waiting list view


Revision 1.154 - (view) (download) (annotate) - [select for diffs]
Sat Sep 24 09:07:02 2005 UTC (18 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.153: +11 -8 lines
Diff to previous 1.153
- removed left-over reference to clin_encounter.fk_provider


Revision 1.153 - (view) (download) (annotate) - [select for diffs]
Thu Sep 22 15:43:48 2005 UTC (18 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.152: +38 -23 lines
Diff to previous 1.152
- remove clin_encounter.fk_provider
- add v_waiting_list


Revision 1.152 - (view) (download) (annotate) - [select for diffs]
Wed Sep 21 10:20:51 2005 UTC (18 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.151: +32 -2 lines
Diff to previous 1.151
- waiting list grants


Revision 1.151 - (view) (download) (annotate) - [select for diffs]
Mon Sep 19 16:19:58 2005 UTC (18 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.150: +12 -104 lines
Diff to previous 1.150
- cleanup
- support rfe/aoe in clin_encounter and adjust to that


Revision 1.150 - (view) (download) (annotate) - [select for diffs]
Tue Sep 13 11:56:20 2005 UTC (18 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.149: +15 -9 lines
Diff to previous 1.149
- cleanup/comments


Revision 1.149 - (view) (download) (annotate) - [select for diffs]
Sun Sep 11 17:41:20 2005 UTC (18 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.148: +9 -11 lines
Diff to previous 1.148
- cleanup
- display provider sign in v_pat_narrative, not db account


Revision 1.148 - (view) (download) (annotate) - [select for diffs]
Thu Sep 8 17:02:37 2005 UTC (18 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.147: +7 -2 lines
Diff to previous 1.147
- include provider in v_pat_narrative


Revision 1.147 - (view) (download) (annotate) - [select for diffs]
Mon Aug 15 16:30:42 2005 UTC (18 years, 8 months ago) by ncq
Branch: MAIN
CVS Tags: rel-0-1
Branch point for: rel-0-1-patches
Changes since 1.146: +122 -225 lines
Diff to previous 1.146
- cleanup
- enforce "only one open episode per health issue at any time"


Revision 1.146 - (view) (download) (annotate) - [select for diffs]
Thu Jul 14 21:31:42 2005 UTC (18 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.145: +6 -2 lines
Diff to previous 1.145
- partially use improved schema revision tracking


Revision 1.145 - (view) (download) (annotate) - [select for diffs]
Sun Jun 19 13:36:10 2005 UTC (18 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.144: +19 -12 lines
Diff to previous 1.144
- allow updating clin_root_item directly as Syan showed it to be working
- fix problem list to only include real problems


Revision 1.144 - (view) (download) (annotate) - [select for diffs]
Wed Jun 1 23:18:48 2005 UTC (18 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.143: +7 -2 lines
Diff to previous 1.143
- missing grants on hx_family_item


Revision 1.143 - (view) (download) (annotate) - [select for diffs]
Tue May 17 08:17:04 2005 UTC (18 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.142: +9 -3 lines
Diff to previous 1.142
- refine clin_narrative row mapping in v_emr_journal to display is_rfe status


Revision 1.142 - (view) (download) (annotate) - [select for diffs]
Wed Apr 27 20:00:11 2005 UTC (19 years ago) by ncq
Branch: MAIN
Changes since 1.141: +6 -3 lines
Diff to previous 1.141
- add missing coalesce in v_emr_journal


Revision 1.141 - (view) (download) (annotate) - [select for diffs]
Sun Apr 17 16:33:49 2005 UTC (19 years ago) by ncq
Branch: MAIN
Changes since 1.140: +9 -3 lines
Diff to previous 1.140
- improve clin_health_issue display in v_emr_journal


Revision 1.140 - (view) (download) (annotate) - [select for diffs]
Tue Apr 12 10:08:34 2005 UTC (19 years ago) by ncq
Branch: MAIN
Changes since 1.139: +14 -5 lines
Diff to previous 1.139
- fix faulty index drop
- add l10n_type to v_problem_list


Revision 1.139 - (view) (download) (annotate) - [select for diffs]
Fri Apr 8 09:59:34 2005 UTC (19 years ago) by ncq
Branch: MAIN
Changes since 1.138: +67 -51 lines
Diff to previous 1.138
- 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


Revision 1.138 - (view) (download) (annotate) - [select for diffs]
Sun Apr 3 20:14:04 2005 UTC (19 years ago) by ncq
Branch: MAIN
Changes since 1.137: +6 -2 lines
Diff to previous 1.137
- soap_cat_ranks grant


Revision 1.137 - (view) (download) (annotate) - [select for diffs]
Thu Mar 31 18:02:35 2005 UTC (19 years ago) by ncq
Branch: MAIN
Changes since 1.136: +10 -32 lines
Diff to previous 1.136
- move strings to data


Revision 1.136 - (view) (download) (annotate) - [select for diffs]
Thu Mar 31 17:46:00 2005 UTC (19 years ago) by ncq
Branch: MAIN
Changes since 1.135: +293 -166 lines
Diff to previous 1.135
- 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


Revision 1.135 - (view) (download) (annotate) - [select for diffs]
Mon Mar 21 20:10:20 2005 UTC (19 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.134: +208 -106 lines
Diff to previous 1.134
- v_patient_items -> v_pat_items for consistency
- add v_hx_family and include in v_compl_narrative


Revision 1.134 - (view) (download) (annotate) - [select for diffs]
Sun Mar 20 18:07:47 2005 UTC (19 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.133: +50 -39 lines
Diff to previous 1.133
- properly protect clin_root_item and be verbose about it
- v_hx_family needs to be rewritten


Revision 1.133 - (view) (download) (annotate) - [select for diffs]
Mon Mar 14 17:47:55 2005 UTC (19 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.132: +28 -2 lines
Diff to previous 1.132
- store time zone of insert into clin_encounter as a
  reasonable approximation for other timestamp time zones


Revision 1.132 - (view) (download) (annotate) - [select for diffs]
Mon Mar 14 15:16:04 2005 UTC (19 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.131: +14 -4 lines
Diff to previous 1.131
- missing variable declaration in f_rfi_type2item


Revision 1.131 - (view) (download) (annotate) - [select for diffs]
Mon Mar 14 14:45:40 2005 UTC (19 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.130: +319 -138 lines
Diff to previous 1.130
- 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


Revision 1.130 - (view) (download) (annotate) - [select for diffs]
Fri Mar 11 22:55:50 2005 UTC (19 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.129: +13 -46 lines
Diff to previous 1.129
- cleanup
- carry over provider into narrative view


Revision 1.129 - (view) (download) (annotate) - [select for diffs]
Tue Mar 1 20:40:10 2005 UTC (19 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.128: +87 -36 lines
Diff to previous 1.128
- require name for all episodes thereby fixing not being able to
  refetch unnamed episodes in the Python middleware


Revision 1.128 - (view) (download) (annotate) - [select for diffs]
Tue Feb 15 18:26:41 2005 UTC (19 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.127: +9 -4 lines
Diff to previous 1.127
- test_result.id -> pk


Revision 1.127 - (view) (download) (annotate) - [select for diffs]
Sat Feb 12 13:49:14 2005 UTC (19 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.126: +11 -5 lines
Diff to previous 1.126
- identity.id -> identity.pk
- allow NULL for identity.fk_marital_status
- subsequent schema changes


Revision 1.126 - (view) (download) (annotate) - [select for diffs]
Mon Feb 7 13:02:41 2005 UTC (19 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.125: +57 -129 lines
Diff to previous 1.125
- v_test_type_local -> v_test_type_unified
- old v_test_type_unified -> v_unified_test_types
- follow-on changes, grants
- remove cruft


Revision 1.125 - (view) (download) (annotate) - [select for diffs]
Mon Jan 31 20:16:39 2005 UTC (19 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.124: +6 -3 lines
Diff to previous 1.124
- clin_episode has fk_patient, not id_patient


Revision 1.124 - (view) (download) (annotate) - [select for diffs]
Mon Jan 31 19:49:39 2005 UTC (19 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.123: +7 -4 lines
Diff to previous 1.123
- clin_health_issue does not yet follow primary key == pk


Revision 1.123 - (view) (download) (annotate) - [select for diffs]
Mon Jan 31 19:42:53 2005 UTC (19 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.122: +7 -2 lines
Diff to previous 1.122
- add 2 missing "end if;"


Revision 1.122 - (view) (download) (annotate) - [select for diffs]
Mon Jan 31 19:12:26 2005 UTC (19 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.121: +49 -2 lines
Diff to previous 1.121
- add trigger to announce episode changes


Revision 1.121 - (view) (download) (annotate) - [select for diffs]
Mon Jan 24 17:57:43 2005 UTC (19 years, 3 months ago) by ncq
Branch: MAIN
Changes since 1.120: +9 -7 lines
Diff to previous 1.120
- cleanup
- Ian's enhancements to address and forms tables


Revision 1.120 - (view) (download) (annotate) - [select for diffs]
Wed Dec 15 10:48:32 2004 UTC (19 years, 4 months ago) by ncq
Branch: MAIN
Changes since 1.119: +7 -2 lines
Diff to previous 1.119
- carry pk of narrative in episode views so business objects can
  update it (eg rename the episode)


Revision 1.119 - (view) (download) (annotate) - [select for diffs]
Tue Dec 14 20:06:59 2004 UTC (19 years, 4 months ago) by ncq
Branch: MAIN
Changes since 1.118: +17 -2 lines
Diff to previous 1.118
- v_test_results.unified_target_* from val_target_* first or val_normal_* second


Revision 1.118 - (view) (download) (annotate) - [select for diffs]
Mon Dec 6 21:09:38 2004 UTC (19 years, 4 months ago) by ncq
Branch: MAIN
Changes since 1.117: +60 -30 lines
Diff to previous 1.117
- eventually properly implement episode naming via deferred constraint trigger


Revision 1.117 - (view) (download) (annotate) - [select for diffs]
Sun Nov 28 14:37:00 2004 UTC (19 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.116: +36 -39 lines
Diff to previous 1.116
- adjust to clin_episode.fk_clin_narrative instead of clin_narrative.is_episode_name


Revision 1.116 - (view) (download) (annotate) - [select for diffs]
Fri Nov 26 13:51:18 2004 UTC (19 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.115: +15 -14 lines
Diff to previous 1.115
- always hard to get quoting right for dynamic pl/pgsql


Revision 1.115 - (view) (download) (annotate) - [select for diffs]
Fri Nov 26 12:18:04 2004 UTC (19 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.114: +43 -2 lines
Diff to previous 1.114
- trigger/func _name_new_episode


Revision 1.114 - (view) (download) (annotate) - [select for diffs]
Wed Nov 24 15:39:33 2004 UTC (19 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.113: +10 -13 lines
Diff to previous 1.113
- clin_episode does not have clinically_relevant anymore as per discussion on list


Revision 1.113 - (view) (download) (annotate) - [select for diffs]
Sun Nov 21 21:38:31 2004 UTC (19 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.112: +6 -3 lines
Diff to previous 1.112
- fix chi.is_open to be is_active


Revision 1.112 - (view) (download) (annotate) - [select for diffs]
Sun Nov 21 21:02:48 2004 UTC (19 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.111: +14 -9 lines
Diff to previous 1.111
- episode: is_active -> is_open


Revision 1.111 - (view) (download) (annotate) - [select for diffs]
Tue Nov 16 19:01:27 2004 UTC (19 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.110: +76 -34 lines
Diff to previous 1.110
- adjust to episode name now living in clin_narrative
- v_named_episodes still needs work to properly account for
  erronously unnamed episodes


Revision 1.110 - (view) (download) (annotate) - [select for diffs]
Fri Oct 29 22:37:02 2004 UTC (19 years, 6 months ago) by ncq
Branch: MAIN
Changes since 1.109: +54 -27 lines
Diff to previous 1.109
- 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


Revision 1.109 - (view) (download) (annotate) - [select for diffs]
Tue Oct 12 09:50:21 2004 UTC (19 years, 6 months ago) by ncq
Branch: MAIN
Changes since 1.108: +6 -2 lines
Diff to previous 1.108
- enhance v_vacc_regimes -> add "shots" field holding number of shots for regime


Revision 1.108 - (view) (download) (annotate) - [select for diffs]
Mon Oct 11 19:32:19 2004 UTC (19 years, 6 months ago) by ncq
Branch: MAIN
Changes since 1.107: +9 -6 lines
Diff to previous 1.107
- clean up v_pat_allergies


Revision 1.107 - (view) (download) (annotate) - [select for diffs]
Wed Sep 29 19:17:24 2004 UTC (19 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.106: +11 -5 lines
Diff to previous 1.106
- fix typos and grants


Revision 1.106 - (view) (download) (annotate) - [select for diffs]
Wed Sep 29 10:38:22 2004 UTC (19 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.105: +254 -26 lines
Diff to previous 1.105
- measurement views rewritten to match current discussion


Revision 1.105 - (view) (download) (annotate) - [select for diffs]
Tue Sep 28 12:29:29 2004 UTC (19 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.104: +8 -3 lines
Diff to previous 1.104
- add pk_vacc_def to v_vaccs_scheduled4pat


Revision 1.104 - (view) (download) (annotate) - [select for diffs]
Sat Sep 25 13:25:56 2004 UTC (19 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.103: +16 -10 lines
Diff to previous 1.103
- is_significant -> clinically_relevant


Revision 1.103 - (view) (download) (annotate) - [select for diffs]
Wed Sep 22 14:12:19 2004 UTC (19 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.102: +33 -2 lines
Diff to previous 1.102
- add rules to protect clin_root_item from direct insert/update/delete,
  this prevents child table coherency issues


Revision 1.102 - (view) (download) (annotate) - [select for diffs]
Mon Sep 20 21:14:11 2004 UTC (19 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.101: +7 -8 lines
Diff to previous 1.101
- remove cruft, fix grants
- retire lnk_vacc2vacc_def for now as we seem to not need it


Revision 1.101 - (view) (download) (annotate) - [select for diffs]
Sat Sep 18 13:49:32 2004 UTC (19 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.100: +25 -20 lines
Diff to previous 1.100
- fix missing patient pk in v_compl_narrative


Revision 1.100 - (view) (download) (annotate) - [select for diffs]
Sat Sep 18 00:19:24 2004 UTC (19 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.99: +122 -3 lines
Diff to previous 1.99
- add v_compl_narrative
- add v_problem_list
- include is_significant in v_pat_episodes


Revision 1.99 - (view) (download) (annotate) - [select for diffs]
Fri Sep 17 20:59:58 2004 UTC (19 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.98: +6 -108 lines
Diff to previous 1.98
- remove cruft
- in v_pat_episodes UNION pull data from correct places ...


Revision 1.98 - (view) (download) (annotate) - [select for diffs]
Fri Sep 17 20:28:05 2004 UTC (19 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.97: +17 -3 lines
Diff to previous 1.97
- PG 7.4 is helpful: fix UNION


Revision 1.97 - (view) (download) (annotate) - [select for diffs]
Fri Sep 17 20:14:06 2004 UTC (19 years, 7 months ago) by ncq
Branch: MAIN
Changes since 1.96: +57 -13 lines
Diff to previous 1.96
- 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)


Revision 1.96 - (view) (download) (annotate) - [select for diffs]
Mon Aug 16 19:31:49 2004 UTC (19 years, 8 months ago) by ncq
Branch: MAIN
Changes since 1.95: +278 -56 lines
Diff to previous 1.95
- 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


Revision 1.95 - (view) (download) (annotate) - [select for diffs]
Wed Aug 11 08:59:54 2004 UTC (19 years, 8 months ago) by ncq
Branch: MAIN
Changes since 1.94: +28 -2 lines
Diff to previous 1.94
- added v_pat_narrative by Carlos


Revision 1.94 - (view) (download) (annotate) - [select for diffs]
Wed Aug 4 10:07:49 2004 UTC (19 years, 8 months ago) by ncq
Branch: MAIN
Changes since 1.93: +42 -2 lines
Diff to previous 1.93
- added v_pat_item_types/v_types4item


Revision 1.93 - (view) (download) (annotate) - [select for diffs]
Sun Jul 18 11:50:19 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.92: +19 -11 lines
Diff to previous 1.92
- added arbitrary typing of clin_root_items


Revision 1.92 - (view) (download) (annotate) - [select for diffs]
Sat Jul 17 20:57:53 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.91: +17 -49 lines
Diff to previous 1.91
- don't use user/_user workaround anymore as we dropped supporting
  it (but we did NOT drop supporting readonly connections on > 7.3)


Revision 1.91 - (view) (download) (annotate) - [select for diffs]
Mon Jul 12 17:23:09 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.90: +24 -29 lines
Diff to previous 1.90
- allow for coding any SOAP row
- adjust views/tables to that


Revision 1.90 - (view) (download) (annotate) - [select for diffs]
Wed Jul 7 15:07:34 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.89: +33 -18 lines
Diff to previous 1.89
- v_pat_diag_codes
- v_codes4diag


Revision 1.89 - (view) (download) (annotate) - [select for diffs]
Mon Jul 5 22:47:34 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.88: +15 -2 lines
Diff to previous 1.88
- added pk_diag to v_coded_diag


Revision 1.88 - (view) (download) (annotate) - [select for diffs]
Mon Jul 5 18:46:51 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.87: +13 -10 lines
Diff to previous 1.87
- fix grants


Revision 1.87 - (view) (download) (annotate) - [select for diffs]
Mon Jul 5 17:47:13 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.86: +15 -12 lines
Diff to previous 1.86
- v_rfe/aoe -> v_pat_rfe/aoe


Revision 1.86 - (view) (download) (annotate) - [select for diffs]
Sun Jul 4 16:31:09 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.85: +7 -3 lines
Diff to previous 1.85
- fix v_coded_diags: fk_diag=pk_diag


Revision 1.85 - (view) (download) (annotate) - [select for diffs]
Sun Jul 4 16:14:41 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.84: +7 -2 lines
Diff to previous 1.84
- add grants
- I'm getting old


Revision 1.84 - (view) (download) (annotate) - [select for diffs]
Sun Jul 4 16:12:44 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.83: +12 -9 lines
Diff to previous 1.83
- DROP INDEX cannot have ON clause, duh


Revision 1.83 - (view) (download) (annotate) - [select for diffs]
Sun Jul 4 16:10:29 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.82: +47 -4 lines
Diff to previous 1.82
- add v_aoe/v_rfe


Revision 1.82 - (view) (download) (annotate) - [select for diffs]
Sat Jul 3 17:24:08 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.81: +9 -5 lines
Diff to previous 1.81
- can't name all indexes the same :-)


Revision 1.81 - (view) (download) (annotate) - [select for diffs]
Sat Jul 3 17:17:41 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.80: +29 -4 lines
Diff to previous 1.80
- indexes on clin_narrative


Revision 1.80 - (view) (download) (annotate) - [select for diffs]
Fri Jul 2 15:00:10 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.79: +43 -20 lines
Diff to previous 1.79
- bring rfe/aoe/diag/coded_diag tables/views up to snuff and use them


Revision 1.79 - (view) (download) (annotate) - [select for diffs]
Fri Jul 2 00:28:52 2004 UTC (19 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.78: +36 -38 lines
Diff to previous 1.78
- 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


Revision 1.78 - (view) (download) (annotate) - [select for diffs]
Wed Jun 30 15:43:52 2004 UTC (19 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.77: +17 -33 lines
Diff to previous 1.77
- clin_note -> clin_narrative
- remove v_i18n_curr_encounter
- add clin_rfe, clin_aoe


Revision 1.77 - (view) (download) (annotate) - [select for diffs]
Mon Jun 28 15:04:31 2004 UTC (19 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.76: +19 -14 lines
Diff to previous 1.76
- add pk_item to v_lab_requests


Revision 1.76 - (view) (download) (annotate) - [select for diffs]
Mon Jun 28 12:38:30 2004 UTC (19 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.75: +6 -3 lines
Diff to previous 1.75
- fixed on fk_ -> pk_


Revision 1.75 - (view) (download) (annotate) - [select for diffs]
Mon Jun 28 12:15:38 2004 UTC (19 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.74: +35 -4 lines
Diff to previous 1.74
- add view on lab_request -> v_lab_requests so we can fk_ -> pk_


Revision 1.74 - (view) (download) (annotate) - [select for diffs]
Sat Jun 26 23:42:44 2004 UTC (19 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.73: +115 -35 lines
Diff to previous 1.73
- indices on clin_root_item fields in descendants
- id_* -> fk/pk_*


Revision 1.73 - (view) (download) (annotate) - [select for diffs]
Sat Jun 26 07:33:55 2004 UTC (19 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.72: +19 -16 lines
Diff to previous 1.72
- id_episode -> fk/pk_episode


Revision 1.72 - (view) (download) (annotate) - [select for diffs]
Sun Jun 13 08:08:35 2004 UTC (19 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.71: +18 -5 lines
Diff to previous 1.71
- pull in some more PKs in views for episode/encounter/issue sorting


Revision 1.71 - (view) (download) (annotate) - [select for diffs]
Wed Jun 2 00:05:51 2004 UTC (19 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.70: +7 -3 lines
Diff to previous 1.70
- vpep.episode now vpep.description


Revision 1.70 - (view) (download) (annotate) - [select for diffs]
Tue Jun 1 08:43:21 2004 UTC (19 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.69: +14 -7 lines
Diff to previous 1.69
- fix grants re allergy_state
- include soap_cat in v_patient_items


Revision 1.69 - (view) (download) (annotate) - [select for diffs]
Sun May 30 20:58:13 2004 UTC (19 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.68: +15 -10 lines
Diff to previous 1.68
- encounter_type.id -> encounter_type.pk


Revision 1.68 - (view) (download) (annotate) - [select for diffs]
Sat May 22 11:54:23 2004 UTC (19 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.67: +5 -38 lines
Diff to previous 1.67
- cleanup signal handling on allergy table


Revision 1.67 - (view) (download) (annotate) - [select for diffs]
Tue May 11 01:34:51 2004 UTC (19 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.66: +37 -36 lines
Diff to previous 1.66
- allow test results with lab_request.is_pending is True in v_results4lab_req


Revision 1.66 - (view) (download) (annotate) - [select for diffs]
Sat May 8 20:43:48 2004 UTC (19 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.65: +26 -7 lines
Diff to previous 1.65
- eventually seem to have fixed latest_due/amount_overdue in v_pat_missing_boosters


Revision 1.65 - (view) (download) (annotate) - [select for diffs]
Sat May 8 17:39:54 2004 UTC (19 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.64: +76 -106 lines
Diff to previous 1.64
- 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


Revision 1.64 - (view) (download) (annotate) - [select for diffs]
Fri May 7 14:27:46 2004 UTC (19 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.63: +37 -24 lines
Diff to previous 1.63
- 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)


Revision 1.63 - (view) (download) (annotate) - [select for diffs]
Thu May 6 23:34:52 2004 UTC (19 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.62: +24 -21 lines
Diff to previous 1.62
- test_type_uni -> test_type_local


Revision 1.62 - (view) (download) (annotate) - [select for diffs]
Sun May 2 19:25:21 2004 UTC (19 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.61: +14 -7 lines
Diff to previous 1.61
- adapt to progress_note <-> description reversal in clin_working_diag


Revision 1.61 - (view) (download) (annotate) - [select for diffs]
Fri Apr 30 12:22:31 2004 UTC (20 years ago) by ihaywood
Branch: MAIN
Changes since 1.60: +13 -2 lines
Diff to previous 1.60
new referral table
some changes to old medications tables, but still need more work


Revision 1.60 - (view) (download) (annotate) - [select for diffs]
Fri Apr 30 09:20:09 2004 UTC (20 years ago) by ncq
Branch: MAIN
Changes since 1.59: +37 -2 lines
Diff to previous 1.59
- add v_pat_diag, grants


Revision 1.59 - (view) (download) (annotate) - [select for diffs]
Fri Apr 30 09:12:30 2004 UTC (20 years ago) by ncq
Branch: MAIN
Changes since 1.58: +8 -5 lines
Diff to previous 1.58
- fk description clin_working_diag -> clin_aux_note
- v_pat_diag


Revision 1.58 - (view) (download) (annotate) - [select for diffs]
Tue Apr 27 15:18:38 2004 UTC (20 years ago) by ncq
Branch: MAIN
Changes since 1.57: +21 -23 lines
Diff to previous 1.57
- rework diagnosis tables + grants for them


Revision 1.57 - (view) (download) (annotate) - [select for diffs]
Mon Apr 26 21:17:10 2004 UTC (20 years ago) by ncq
Branch: MAIN
Changes since 1.56: +13 -13 lines
Diff to previous 1.56
- fix v_test_org_profile


Revision 1.56 - (view) (download) (annotate) - [select for diffs]
Mon Apr 26 09:38:43 2004 UTC (20 years ago) by ncq
Branch: MAIN
Changes since 1.55: +17 -6 lines
Diff to previous 1.55
- enhance test_org_profile


Revision 1.55 - (view) (download) (annotate) - [select for diffs]
Sat Apr 24 12:59:17 2004 UTC (20 years ago) by ncq
Branch: MAIN
Changes since 1.54: +6 -2 lines
Diff to previous 1.54
- all shiny and new, vastly improved vaccinations
  handling via clinical item objects
- mainly thanks to Carlos Moro


Revision 1.54 - (view) (download) (annotate) - [select for diffs]
Wed Apr 21 15:35:23 2004 UTC (20 years ago) by ihaywood
Branch: MAIN
Changes since 1.53: +6 -5 lines
Diff to previous 1.53
new referral table (do we still need gmclinical.form_data then?)


Revision 1.53 - (view) (download) (annotate) - [select for diffs]
Wed Apr 21 15:30:24 2004 UTC (20 years ago) by ncq
Branch: MAIN
Changes since 1.52: +15 -5 lines
Diff to previous 1.52
- fix coalesce on unified_name/code in v_results4lab_req
- add unified_val


Revision 1.52 - (view) (download) (annotate) - [select for diffs]
Tue Apr 20 00:17:56 2004 UTC (20 years ago) by ncq
Branch: MAIN
Changes since 1.51: +21 -13 lines
Diff to previous 1.51
- allergies API revamped, kudos to Carlos


Revision 1.51 - (view) (download) (annotate) - [select for diffs]
Sat Apr 17 12:42:09 2004 UTC (20 years ago) by ncq
Branch: MAIN
Changes since 1.50: +36 -7 lines
Diff to previous 1.50
- add v_pat_encounters


Revision 1.50 - (view) (download) (annotate) - [select for diffs]
Sat Apr 17 11:54:16 2004 UTC (20 years ago) by ncq
Branch: MAIN
Changes since 1.49: +16 -12 lines
Diff to previous 1.49
- v_patient_episodes -> v_pat_episodes


Revision 1.49 - (view) (download) (annotate) - [select for diffs]
Wed Apr 7 18:16:06 2004 UTC (20 years ago) by ncq
Branch: MAIN
Changes since 1.48: +110 -2 lines
Diff to previous 1.48
- move grants into re-runnable scripts
- update *.conf accordingly


Revision 1.48 - (view) (download) (annotate) - [select for diffs]
Tue Mar 23 17:34:49 2004 UTC (20 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.47: +12 -6 lines
Diff to previous 1.47
- support and use optionally cross-provider unified test names


Revision 1.47 - (view) (download) (annotate) - [select for diffs]
Tue Mar 23 02:33:13 2004 UTC (20 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.46: +116 -35 lines
Diff to previous 1.46
- comments/constraints/references on test_result, also result_when -> clin_when
- v_results4lab_req, v_test_org_profile, grants


Revision 1.46 - (view) (download) (annotate) - [select for diffs]
Fri Mar 19 10:55:40 2004 UTC (20 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.45: +7 -5 lines
Diff to previous 1.45
- remove allergy.reaction -> use clin_root_item.narrative instead


Revision 1.45 - (view) (download) (annotate) - [select for diffs]
Fri Mar 12 23:15:04 2004 UTC (20 years, 1 month ago) by ncq
Branch: MAIN
Changes since 1.44: +13 -25 lines
Diff to previous 1.44
- adjust to id_ -> fk_/pk_


Revision 1.44 - (view) (download) (annotate) - [select for diffs]
Wed Feb 18 15:29:05 2004 UTC (20 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.43: +46 -9 lines
Diff to previous 1.43
- add v_most_recent_encounters


Revision 1.43 - (view) (download) (annotate) - [select for diffs]
Mon Feb 2 16:17:42 2004 UTC (20 years, 2 months ago) by ncq
Branch: MAIN
Changes since 1.42: +62 -145 lines
Diff to previous 1.42
- remove v_patient_vaccinations, v_pat_due_vaccs, v_pat_overdue_vaccs
- add v_pat_missing_vaccs, v_pat_missing_boosters


Revision 1.42 - (view) (download) (annotate) - [select for diffs]
Mon Jan 26 20:08:16 2004 UTC (20 years, 3 months ago) by ncq
Branch: MAIN
Changes since 1.41: +6 -3 lines
Diff to previous 1.41
- fk_recommended_by as pk_recommended_by


Revision 1.41 - (view) (download) (annotate) - [select for diffs]
Mon Jan 26 18:26:04 2004 UTC (20 years, 3 months ago) by ncq
Branch: MAIN
Changes since 1.40: +14 -9 lines
Diff to previous 1.40
- add/rename some FKs in views


Revision 1.40 - (view) (download) (annotate) - [select for diffs]
Sun Jan 18 21:56:38 2004 UTC (20 years, 3 months ago) by ncq
Branch: MAIN
Changes since 1.39: +39 -7 lines
Diff to previous 1.39
- v_patient_vacc4ind
- reformatting DDLs


Revision 1.39 - (view) (download) (annotate) - [select for diffs]
Tue Jan 6 23:44:40 2004 UTC (20 years, 3 months ago) by ncq
Branch: MAIN
Changes since 1.38: +8 -3 lines
Diff to previous 1.38
- __default__ -> xxxDEFAULTxxx


Revision 1.38 - (view) (download) (annotate) - [select for diffs]
Mon Dec 29 15:31:53 2003 UTC (20 years, 4 months ago) by uid66147
Branch: MAIN
Changes since 1.37: +105 -60 lines
Diff to previous 1.37
- rebuild v_vacc_regimes/v_patient_vaccinations/v_pat_due|overdue_vaccs due
  to vaccination/vacc_def link normalization
- grants


Revision 1.37 - (view) (download) (annotate) - [select for diffs]
Tue Dec 2 02:13:25 2003 UTC (20 years, 4 months ago) by ncq
Branch: MAIN
Changes since 1.36: +13 -11 lines
Diff to previous 1.36
- we want UNIQUE indices on names.active etc
- add some i18n to views as well as some coalesce()


Revision 1.36 - (view) (download) (annotate) - [select for diffs]
Fri Nov 28 10:07:52 2003 UTC (20 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.35: +24 -6 lines
Diff to previous 1.35
- improve vaccination views


Revision 1.35 - (view) (download) (annotate) - [select for diffs]
Fri Nov 28 01:03:48 2003 UTC (20 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.34: +60 -2 lines
Diff to previous 1.34
- add views *_overdue_vaccs and *_due_vaccs


Revision 1.34 - (view) (download) (annotate) - [select for diffs]
Wed Nov 26 23:54:51 2003 UTC (20 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.33: +14 -10 lines
Diff to previous 1.33
- lnk_vaccdef2reg does not exist anymore


Revision 1.33 - (view) (download) (annotate) - [select for diffs]
Tue Nov 18 17:52:37 2003 UTC (20 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.32: +6 -3 lines
Diff to previous 1.32
- clin_date -> clin_when in v_patient_items


Revision 1.32 - (view) (download) (annotate) - [select for diffs]
Sun Nov 16 19:34:29 2003 UTC (20 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.31: +14 -7 lines
Diff to previous 1.31
- make partial index on __default__ encounters optional, fails on 7.1


Revision 1.31 - (view) (download) (annotate) - [select for diffs]
Sun Nov 16 19:32:17 2003 UTC (20 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.30: +11 -24 lines
Diff to previous 1.30
- clin_when in clin_root_item


Revision 1.30 - (view) (download) (annotate) - [select for diffs]
Thu Nov 13 09:47:29 2003 UTC (20 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.29: +55 -47 lines
Diff to previous 1.29
- use clin_date instead of date_given in vaccination


Revision 1.29 - (view) (download) (annotate) - [select for diffs]
Sun Nov 9 22:45:45 2003 UTC (20 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.28: +5 -45 lines
Diff to previous 1.28
- curr_encounter doesn't have id_patient anymore, fix trigger funcs


Revision 1.28 - (view) (download) (annotate) - [select for diffs]
Sun Nov 9 14:54:56 2003 UTC (20 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.27: +53 -7 lines
Diff to previous 1.27
- update view defs


Revision 1.27 - (view) (download) (annotate) - [select for diffs]
Fri Oct 31 23:27:06 2003 UTC (20 years, 5 months ago) by ncq
Branch: MAIN
Changes since 1.26: +58 -27 lines
Diff to previous 1.26
- 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


Revision 1.26 - (view) (download) (annotate) - [select for diffs]
Sun Oct 26 09:41:03 2003 UTC (20 years, 6 months ago) by ncq
Branch: MAIN
Changes since 1.25: +10 -7 lines
Diff to previous 1.25
- truncate -> delete from


Revision 1.25 - (view) (download) (annotate) - [select for diffs]
Sun Oct 19 15:43:00 2003 UTC (20 years, 6 months ago) by ncq
Branch: MAIN
Changes since 1.24: +9 -11 lines
Diff to previous 1.24
- even better vaccination tables


Revision 1.24 - (view) (download) (annotate) - [select for diffs]
Sun Oct 19 12:59:42 2003 UTC (20 years, 6 months ago) by ncq
Branch: MAIN
Changes since 1.23: +91 -4 lines
Diff to previous 1.23
- add vaccination views (still flaky)


Revision 1.23 - (view) (download) (annotate) - [select for diffs]
Sun Aug 3 14:06:45 2003 UTC (20 years, 8 months ago) by ncq
Branch: MAIN
Changes since 1.22: +67 -2 lines
Diff to previous 1.22
- added measurements views


Revision 1.22 - (view) (download) (annotate) - [select for diffs]
Sat Jul 19 20:23:47 2003 UTC (20 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.21: +85 -18 lines
Diff to previous 1.21
- add clin_root_item triggers
- modify NOTIFY triggers so they include the patient ID
  as per Ian's suggestion


Revision 1.21 - (view) (download) (annotate) - [select for diffs]
Wed Jul 9 16:23:21 2003 UTC (20 years, 9 months ago) by ncq
Branch: MAIN
Changes since 1.20: +26 -2 lines
Diff to previous 1.20
- add clin_health_issue triggers and functions


Revision 1.20 - (view) (download) (annotate) - [select for diffs]
Sun Jun 29 15:24:22 2003 UTC (20 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.19: +14 -2 lines
Diff to previous 1.19
- 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 :-)


Revision 1.19 - (view) (download) (annotate) - [select for diffs]
Sun Jun 22 16:23:35 2003 UTC (20 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.18: +45 -2 lines
Diff to previous 1.18
- curr_encounter tracking triggers + grants


Revision 1.18 - (view) (download) (annotate) - [select for diffs]
Tue Jun 3 13:49:06 2003 UTC (20 years, 10 months ago) by ncq
Branch: MAIN
Changes since 1.17: +8 -5 lines
Diff to previous 1.17
- reorder v_patient_episodes/*_items for clarity


Revision 1.17 - (view) (download) (annotate) - [select for diffs]
Sun Jun 1 11:38:12 2003 UTC (20 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.16: +6 -3 lines
Diff to previous 1.16
- fix spelling of definate -> definite


Revision 1.16 - (view) (download) (annotate) - [select for diffs]
Sat May 17 18:40:24 2003 UTC (20 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.15: +7 -4 lines
Diff to previous 1.15
- notify triggers should come last, so make them zz*


Revision 1.15 - (view) (download) (annotate) - [select for diffs]
Wed May 14 22:07:13 2003 UTC (20 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.14: +17 -18 lines
Diff to previous 1.14
- adapt to changes in gmclinical.sql, particularly the narrative/item merge


Revision 1.14 - (view) (download) (annotate) - [select for diffs]
Mon May 12 12:43:39 2003 UTC (20 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.13: +5 -7 lines
Diff to previous 1.13
- gmI18N, gmServices and gmSchemaRevision are imported globally at the
  database level now, don't include them in individual schema file anymore


Revision 1.13 - (view) (download) (annotate) - [select for diffs]
Tue May 6 13:06:25 2003 UTC (20 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.12: +7 -4 lines
Diff to previous 1.12
- pkey_ -> pk_


Revision 1.12 - (view) (download) (annotate) - [select for diffs]
Mon May 5 11:59:50 2003 UTC (20 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.11: +24 -23 lines
Diff to previous 1.11
- adapt to clin_narrative being an ancestor table


Revision 1.11 - (view) (download) (annotate) - [select for diffs]
Mon May 5 00:31:28 2003 UTC (20 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.10: +7 -2 lines
Diff to previous 1.10
- add grants


Revision 1.10 - (view) (download) (annotate) - [select for diffs]
Mon May 5 00:27:34 2003 UTC (20 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.9: +7 -4 lines
Diff to previous 1.9
- add as to encounter types


Revision 1.9 - (view) (download) (annotate) - [select for diffs]
Mon May 5 00:19:12 2003 UTC (20 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.8: +18 -2 lines
Diff to previous 1.8
- we do need the v_i18n_ on encounter types


Revision 1.8 - (view) (download) (annotate) - [select for diffs]
Sun May 4 23:35:59 2003 UTC (20 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.7: +82 -18 lines
Diff to previous 1.7
- major reworking to follow the formal EMR structure writeup


Revision 1.7 - (view) (download) (annotate) - [select for diffs]
Sat May 3 00:44:05 2003 UTC (20 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.6: +7 -8 lines
Diff to previous 1.6
- make patient allergies view work


Revision 1.6 - (view) (download) (annotate) - [select for diffs]
Fri May 2 15:06:19 2003 UTC (20 years, 11 months ago) by ncq
Branch: MAIN
Changes since 1.5: +13 -6 lines
Diff to previous 1.5
- make trigger return happy
- tweak v_i18n_patient_allergies - not done yet


Revision 1.5 - (view) (download) (annotate) - [select for diffs]
Thu May 1 15:05:36 2003 UTC (21 years ago) by ncq
Branch: MAIN
Changes since 1.4: +25 -3 lines
Diff to previous 1.4
- function/trigger to announce insertion/deletion of allergy
- allergy.id_substance -> allergy.substance_code


Revision 1.4 - (view) (download) (annotate) - [select for diffs]
Wed Apr 30 23:30:29 2003 UTC (21 years ago) by ncq
Branch: MAIN
Changes since 1.3: +40 -37 lines
Diff to previous 1.3
- v_i18n_patient_allergies
- new_allergy -> allergy_new


Revision 1.3 - (view) (download) (annotate) - [select for diffs]
Tue Apr 29 12:34:54 2003 UTC (21 years ago) by ncq
Branch: MAIN
Changes since 1.2: +41 -4 lines
Diff to previous 1.2
- added more views + grants


Revision 1.2 - (view) (download) (annotate) - [select for diffs]
Mon Apr 28 21:39:49 2003 UTC (21 years ago) by ncq
Branch: MAIN
Changes since 1.1: +17 -5 lines
Diff to previous 1.1
- cleanups and GRANTs


Revision 1.1 - (view) (download) (annotate) - [select for diffs]
Mon Apr 28 20:40:48 2003 UTC (21 years ago) by ncq
Branch: MAIN
- 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.

  Diffs between and
  Type of Diff should be a

Sort log by:

savannah-hackers-public@gnu.org
ViewVC Help
Powered by ViewVC 1.1.26