Med Var 2 - Discharge-to Ward: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 1: Line 1:
'''Med Var 2''' is used track the specific ward a patient was '''[[Admit From & Discharged To|discharged to]] ''within the same center'''''. If a patient is discharged to a ward '''''outside''''' your hospital and you know the ward they went to, please code, if not, leave Var 2 blank.
'''Med Var 2''' is used track the specific ward a patient was '''[[Admit From & Discharged To|discharged to]] ''within the same center'''''. If a patient is discharged to a ward '''''outside''''' your hospital and you know the ward they went to, please code, if not, leave Var 2 blank.  
** The purpose of this variable is for Julie to link profiles from one ward to another when both wards are within the database program.  If the ward you send to is not in the drop down list just leave variable 2 blank because this information is only used for wards within the program.  I have added this clarification after discussion with Julie. --[[User:LKolesar|LKolesar]] 11:31, 13 October 2011 (CDT) 


Possible values are listed in the Var 2 dropdown box in the CCMDB.mdb, which is driven by the [[S varOptions]] table.
Possible values are listed in the Var 2 dropdown box in the CCMDB.mdb, which is driven by the [[S varOptions]] table.


== Discussion - Can't enter code for other hospital ==
{{Discussion}}
*I don't know if this is an error or bug in the system but if I try and enter in Var 1 or 2 slot the ward of a patient coming from or going to a ward outside my hospital it will not let me send this data in Access. I can only add the specific ward in Var 1 or 2 for transfers within my hospital.[[User:TAngell|TAngell]] 09:16, 30 March 2009 (CDT)
** As mentioned in [[Med Var 1 - Admit-from Ward]], the CCMDB.mdb by design won't let you enter variables for another hospital. If we want to make these universally enterable, we need to add all wards for all locations into [[S varOptions]]. Is that what we want? [[User:Ttenbergen|Ttenbergen]] 14:34, 2 November 2010 (CDT)
== Discussion - discharge to Labour and Delivery ==
{{discussion}}
* there currently is no option for L&D in the dropdowns for the hospitals. Do we want to add this? If so, do we want to add it by name or by ward number (or both, e.g. a1 L&D)? (original question from Fran Lindell, progressing discussion with Laura, Julie and Tina) [[User:Ttenbergen|Ttenbergen]] 11:17, 13 October 2011 (CDT)


== Data Structure ==
== Data Structure ==
Line 16: Line 9:


== Data Integrity Checks ==
== Data Integrity Checks ==
Any patient who is discharged to a medicine ward from a medicine ward at the same hospital must have Var 2 entered.  
Any patient who is discharged to a medicine ward from a medicine ward at the same hospital must have Var 2 entered if the option exists in the drop down list.  


[[Category:Medicine Variable Codes]]
[[Category:Medicine Variable Codes]]
[[Category:Data Integrity Rules]]
[[Category:Data Integrity Rules]]
[[Category:Questions General Collection]]
[[Category:Questions General Collection]]

Revision as of 11:31, 2011 October 13

Med Var 2 is used track the specific ward a patient was discharged to within the same center. If a patient is discharged to a ward outside your hospital and you know the ward they went to, please code, if not, leave Var 2 blank.

    • The purpose of this variable is for Julie to link profiles from one ward to another when both wards are within the database program. If the ward you send to is not in the drop down list just leave variable 2 blank because this information is only used for wards within the program. I have added this clarification after discussion with Julie. --LKolesar 11:31, 13 October 2011 (CDT)

Possible values are listed in the Var 2 dropdown box in the CCMDB.mdb, which is driven by the S varOptions table.


Data Structure

See Category:Variable_codes_1_to_6 for details

Data Integrity Checks

Any patient who is discharged to a medicine ward from a medicine ward at the same hospital must have Var 2 entered if the option exists in the drop down list.