Program: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 12: Line 12:
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 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)]].
=== 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
* 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()]]
* filter [[Data Integrity Checks]] that should only trigger for the right program


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

Revision as of 16:19, 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.

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: