Program: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 10: Line 10:


=== Data ===
=== 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 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]].  


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

Revision as of 15:11, 11 March 2025

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 s_dispo.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: