Program: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
In the context of the critical care and medicine database, the ''program'' is either critical care (CC) or medicine (med), ie the program that a record is collected on.  
In the context of the critical care and medicine database, the ''program'' is either the [[Critical Care program]]  or the [[Medicine program]], ie the program that a record is collected on.  


In [[CCMDB.mdb]], the program is stored in [[Settings (CCMBD.mdb)]].  
=== Collection ===
The program dictates what data is collected, which instructions on this wiki apply, and how [[Data Integrity Checks]] are run.  


The program dictates what data is collected, which instructions on this wiki apply, and what cross checks are run.
See the general and program specific curriculum pages for details on what is collected for all or only some:
* [[Critical Care and Medicine Database Core Curriculum]]
* [[ICU Curriculum]]
* [[Medicine Curriculum]]


== Tmp Projects ==
=== Data ===
Medicine:
In our data, the program can be determined based on the [[Service/Location field]], and on what is in the corresponding [[s_dispo.program]] field in the [[s_dispo table]].
{{#ask: [[ProjectProgram::Med]]
|?ProjectActive=Currently active
|sort=ProjectActive
|format=broadtable
|limit=100}}


Critical care:
=== Software functionality ===
{{#ask: [[ProjectProgram::CC]]
In [[CCMDB.accdb]] the program of a patient should be accessed via [[Query admission_program]] and VBA [[Function admission_program(Pat ID)]].
|?ProjectActive=Currently active
 
|sort=ProjectActive
These are used to
|default=none found
* affect visibility of user interface elements such as [[ADL]]s only being visible for [[Medicine program]] patients; this is handled in [[Sub Check_Forms.Legacy_Hider()]]
|format=broadtable
* filter [[Data Integrity Checks]] that should only trigger for the right program
|limit=100}}
 
== Related articles ==  
{{Related Articles}}

Latest revision as of 16:31, 11 March 2025

In the context of the critical care and medicine database, the program is either the Critical Care program or the Medicine program, ie the program that a record is collected on.

Collection

The program dictates what data is collected, which instructions on this wiki apply, and how Data Integrity Checks are run.

See the general and program specific curriculum pages for details on what is collected for all or only some:

Data

In our data, the program can be determined based on the Service/Location field, and on what is in the corresponding s_dispo.program field in the s_dispo table.

Software functionality

In CCMDB.accdb the program of a patient should be accessed via Query admission_program and VBA Function admission_program(Pat ID).

These are used to

Related articles

Related articles: