Var 1 - Admit-from Ward: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
 
(23 intermediate revisions by 6 users not shown)
Line 1: Line 1:
'''Var 1''' is used track the specific ward a patient was admitted from ''within the same center''. If a patient is admitted from a ward '''''outside''''' your hospital, leave Var 1 blank.
{{LegacyContent
|explanation=was eliminated as part of 2016 registry data change.
|successor=Previous Location field
|content=


Possible values are listed in the dropdown box in the [[CCMDB.mdb]], which is driven by the [[S varOptions]] table.
'''''Legacy info as of 2016-07-01'''''


If the specific ward you are admitting from is not available on this list use "OTH". Please also note down the ward that was missing on this page.  
<onlyinclude>'''Var 1''' was used track the specific ward a patient was admitted from ''within the same center''. </onlyinclude> If a patient is admitted from a ward '''''outside''''' your hospital, leave Var 1 blank.


The [[statistician]] uses this variable to detect patients with a [[Continuous Stay | continuous hospital stay]].
Possible values are listed in the dropdown box in the [[CCMDB.mdb]], which is driven by the S varOptions table.
 
If the specific ward you are admitting from is not available on this list use "OTH".
 
The [[statistician]] used to use this variable to detect patients with a [[Continuous Stay | continuous hospital stay]].


=== OTH entry ===
=== OTH entry ===
Line 12: Line 19:
**any wards in we need to add?  This same list Tina would apply to: [[Var 2 - Discharge-to Ward]]
**any wards in we need to add?  This same list Tina would apply to: [[Var 2 - Discharge-to Ward]]


{{Potential Change}}
=== Wards where we don't collect ===
===='''CON wards list needed''' ====
The Var1/2 data is collected to allow us to match ward admissions into a continuous stay record, where the "to" and "from" fields should match the location fields in the counterpart records.  
'''Dec 23.14''' - For CON ICU, wards will not be added at this time. Only use OTH if Admit FROM or discharge TO your own hospital ward
*N1
*S1
*E2
*E3
*W2
*W3
 
===='''OAK ward list needed''' ====
'''Dec 23.14''' - For OAK ICU, wards will not be added at this time. Only use OTH if Admit FROM or discharge TO your own hospital ward.
 
Note: Oak wards: these are arranged in PODS of 10 beds on every floor.  would have to list 40 units or more.....!!
*3U1-3 - 30 beds - 10 beds per POD - Medicine
*3U4-8 - Surgical
*3U10-12 - psych Health, general
*4U1-7
*4U8-12
*5U1-7
*5U8
 
====STB WARDS missing, need to add====
 
====HSC WARDS missing need to add====
 
 
 
====GRA WARDS missing need to add====
*N1
*S2
*E2
*E3
 
====VIC WARDS missing need to add====


 
==CCMDB Data Integrity Checks==  
=={{CCMDB Data Integrity Checks}}==  
Any patient who is admitted to a ward at the same hospital must have Var 1 entered.
Any patient who is admitted to a ward at the same hospital must have Var 1 entered.
* implemented by function AdFrom_Var1_reconcile()
* implemented by function AdFrom_Var1_reconcile()
Line 59: Line 32:
See [[:Category:Variable_codes_1_to_6]] for details
See [[:Category:Variable_codes_1_to_6]] for details


== Start Date ==
== Start/Stop Dates ==
*Medicine: ages ago
* Start:
*ICU: 2014-Dec-18
**Medicine: ages ago
 
**ICU: 2014-Dec-18
* Stop:
** 2016-07-01


== Legacy Data ICU ==
== Legacy Data ICU ==
Line 86: Line 61:
**P4 - needs review to verify that no drugs were given during ICU admission
**P4 - needs review to verify that no drugs were given during ICU admission


== Moving legacy to tmp ==
{{Potential Change}} - See [[Change Priorities]]
*need to discuss later to move out into TMP - main office issue. 19:37, 2014 December 17 (CST) [[User:TOstryzniuk|Trish Ostryzniuk]]


[[Category: Multiple Encounter linking]]
 
 
[[Category: Medicine Variable Codes]]
[[Category: Medicine Variable Codes]]
[[Category: ICU Variable Codes]]
[[Category: ICU Variable Codes]]
[[Category: Legacy Data Collection]]
}}
[[Category: Legacy Data]]

Latest revision as of 15:56, 2018 December 22

Legacy Content

This page contains Legacy Content.
  • Explanation: was eliminated as part of 2016 registry data change.
  • Successor: Previous Location field

Click Expand to show legacy content.

Legacy info as of 2016-07-01

Var 1 was used track the specific ward a patient was admitted from within the same center. If a patient is admitted from a ward outside your hospital, leave Var 1 blank.

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

If the specific ward you are admitting from is not available on this list use "OTH".

The statistician used to use this variable to detect patients with a continuous hospital stay.

OTH entry

OTH mean - other ward in your OWN hospital that is not on your dropped down list for Var 1 or 2.

  • if you must list OTH, please list here, what ward you are missing within your own hospital and Tina can add it to the list.

Wards where we don't collect

The Var1/2 data is collected to allow us to match ward admissions into a continuous stay record, where the "to" and "from" fields should match the location fields in the counterpart records.

CCMDB Data Integrity Checks

Any patient who is admitted to a ward at the same hospital must have Var 1 entered.

  • implemented by function AdFrom_Var1_reconcile()

Data Use

Used for Category: Multiple Encounter linking

Data Structure

See Category:Variable_codes_1_to_6 for details

Start/Stop Dates

  • Start:
    • Medicine: ages ago
    • ICU: 2014-Dec-18
  • Stop:
    • 2016-07-01

Legacy Data ICU

OBS

  • OBS - Tags an ICU patient at CON who is in the observation unit in the ER (emergency department) while under ICU attending care. Concordia ICU patients has frequently sent ICU patients to the telemetry unit in their ER while still under ICU attending care. TOTAL tagged: 6.
  • Start Date: Jul 2006
  • Stop Date: July 2007

Comanaged patients

  • C - Co-managed patients. Cardiology & ICU attending looking after a patient in MICU.
  • Was used at HSC and STB only, starting ???, ending ??? 2008

"M"

We have CC entries with Var 1 "M" from 1998 - 2003; what are they? Ttenbergen 13:17, 2014 December 5 (CST)

  • Trish thinks this might be medical type, can't remember details... Ttenbergen 19:37, 2014 December 17 (CST)

P1, P2, P3, P4

Used between: 1988-1995

  • We have CC entries with Var 1 =
    • P1 - pharmacy data collection combined under ONE encounter
    • P2 - no study drugs during admission
    • P3 - lost drug profile
    • P4 - needs review to verify that no drugs were given during ICU admission