Visit Admit DtTm field: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (19 intermediate revisions by 4 users not shown) | |||
| Line 3: | Line 3: | ||
| CCMDB_label = Visit Admit DtTm | | CCMDB_label = Visit Admit DtTm | ||
| CCMDB_tab = Dispo | | CCMDB_tab = Dispo | ||
| element_description = | | element_description = This field is used only as an identifier to combine data from the same hospitalization and should not be used as a date. | ||
| in_table = L_Log table | | in_table = L_Log table | ||
| data_type = date | | data_type = date | ||
| Line 12: | Line 12: | ||
}} | }} | ||
The field it is automatically populated from [[Cognos EPR Report | The field it is automatically populated from [[Cognos EPR Report]]. For reference only, it contains the first entry in the visit location history in EPR for ''current'' visit at a hospital site. | ||
== Purpose == | == Purpose == | ||
| Line 19: | Line 19: | ||
* uniquely identify patient visits to Manitoba Health when we exchange data with them | * uniquely identify patient visits to Manitoba Health when we exchange data with them | ||
We | We obtain this item from the ADT system (via Cognos) and it does not always accurately identify the timing of hospital admission. THUS, we are only using it as an identifier to link. | ||
* The [[Statistician]] must not give this field to anyone requesting data from the database to avoid being misused. | |||
== Collection Instruction == | == Collection Instruction == | ||
The field is pre-populated by | *The field is pre-populated by [[Cognos2 Service Starter]] and should not be changed or altered | ||
{{Collapsable | {{Collapsable | ||
| always= If a patient needs to be entered other than through Cognos | | always= If a patient needs to be entered other than through Cognos | ||
| full= | | full= | ||
* In [[EPR]] find Patient | * In [[EPR]] find Patient | ||
| Line 43: | Line 43: | ||
This data is used to understand [[:Category:Length of stay| Length of Stay]] and for [[linking]]. | This data is used to understand [[:Category:Length of stay| Length of Stay]] and for [[linking]]. | ||
{{Data Integrity Check List}} | {{Data Integrity Check List}} | ||
| Line 52: | Line 51: | ||
== Start date and early data == | == Start date and early data == | ||
* at some point before 2021-01-01 we started getting this field directly from [[Cognos]], likely from the beginning of using Cognos. | |||
* July 1, 2016 - Data collectors entering the data from EPR | * July 1, 2016 - Data collectors entering the data from EPR | ||
* Jan 1, 2003 to June 30,2016 - generated Pseudo Visit Date_time | * Jan 1, 2003 to June 30,2016 - generated Pseudo Visit Date_time | ||
** Julie has generated "pseudo - Visit Admit DtTm" data for records from Jan 1, 2003 until June 30,2016 to facilitate linking those as well. This data was imported using temporary query 2017-01-17_pseudoVisitAdmit_update in centralized_data.mdb | ** Julie has generated "pseudo - Visit Admit DtTm" data for records from Jan 1, 2003 until June 30,2016 based on "Accept DtTm" or "Arrive DtTm" to facilitate linking those as well. This data was imported using temporary query 2017-01-17_pseudoVisitAdmit_update in centralized_data.mdb | ||
* before Jan 1, 2003 has a Visit Admit DtTm of '''null''' | * before Jan 1, 2003 has a Visit Admit DtTm of '''null''' | ||
| Line 61: | Line 60: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category:2016 Time and Place changes]] | |||
[[Category:Admit/Discharge]] | |||
[[Category: 2016 Time and Place changes]] | [[Category:Multiple Encounter linking]] | ||
[[Category: Admit/Discharge]] | [[Category:Data Collection Guide]] | ||
[[Category: Multiple Encounter linking]] | |||
[[Category: Data Collection Guide]] | |||