Program: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
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 critical care (CC) or medicine (med), ie the program that a record is collected on.  


In [[CCMDB.accdb]], the program is stored in [[Settings (CCMBD.mdb)]].
=== Collection ===
 
The program dictates what data is collected, which instructions on this wiki apply, and how cross 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:  
See the general and program specific curriculum pages for details on what is collected for all or only some:  
Line 10: Line 9:
* [[Medicine Curriculum]]
* [[Medicine Curriculum]]


The program of specific locations is in the "program" field in the [[s_dispo table]].  
=== Data ===
In our data, the program can be determined based on the [[Service/Location field]], and on what is in the corresponding "program" field in the [[s_dispo table]].
 
In [[CCMDB.accdb]] this is done by [[Query admission_program]] / [[Function admission_program(Pat ID)]].


== Related articles ==  
== Related articles ==  
{{Related Articles}}
{{Related Articles}}

Latest revision as of 11:19, 2024 January 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.

Collection

The program dictates what data is collected, which instructions on this wiki apply, and how cross 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 "program" field in the s_dispo table.

In CCMDB.accdb this is done by Query admission_program / Function admission_program(Pat ID).

Related articles

Related articles: