Program: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
mNo edit summary
 
(One intermediate revision 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 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 9: Line 8:
* [[ICU Curriculum]]
* [[ICU Curriculum]]
* [[Medicine Curriculum]]
* [[Medicine Curriculum]]
=== 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}}

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: