Statistician: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m New page: Our Statistician Julie Mojica provides data analysis support to the projects that use the CCMDB. The Statistician has full access to all the data. We use various tools for data a...
 
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,545 edits
 
(27 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Our Statistician [[Julie Mojica]] provides data analysis support to the projects that use the [[CCMDB]].  
[[p:Julie Mojica]] is the full time Statistician for the Critical Care and Medicine Database.  


The Statistician has full access to all the data. We use various tools for data analysis, with SAS being the preferred. Some basic analysis can be done by the [[data processor]]s using [[TMSX]], Excel or Access.
She provides '''[[Statistical Analysis]]''' and '''[[Reporting]]''' using our data.  


{{stub}}
The Statistician is a member of the [[Steering Committee]] & the [[Task Team]].
 
== Indicators w questions ==
 
{{#cargo_query:
tables=Indicators,Discussions,_pageData
|join on=Indicators._pageName = Discussions._pageName, Indicators._pageName=_pageData._pageName
|fields=
CONCAT("\[\{\{fullurl:",Discussions._pageName, "{{!}}action=edit\}\} edit]")=edit,
Discussions._pageName=page,
question, Indicators.Description
|where=Discussions.who="Julie" and Discussions._pageName<>"MediaWiki:Common.js"
|order by=Discussions.question
|limit=1000
|offset=some number
|default=No questions found
|format=dynamic table
|rows per page=100
}}
 
== Reports w questions ==
 
{{#cargo_query:
tables=Reports,Discussions,_pageData
|join on=Reports._pageName = Discussions._pageName, Reports._pageName=_pageData._pageName
|fields=
CONCAT("\[\{\{fullurl:",Discussions._pageName, "{{!}}action=edit\}\} edit]")=edit,
Discussions._pageName=page,
question
|where=Discussions.who="Julie" and Discussions._pageName<>"MediaWiki:Common.js"
|order by=Discussions.question
|limit=1000
|offset=some number
|default=No questions found
|format=dynamic table
|rows per page=100
}}
 
==Questions on wiki==
Here is a list of questions driven by the [[Template:Discuss]] that have been flagged for Julie.
 
{{#cargo_query:
tables=Discussions,_pageData
|join on=Discussions._pageName=_pageData._pageName
|fields=
CONCAT("\[\{\{fullurl:",Discussions._pageName, "{{!}}action=edit\}\} edit]")=edit,
Discussions._pageName=page,
question,
_modificationDate=ModDate
|where=Discussions.who="Julie" and Discussions._pageName<>"MediaWiki:Common.js"
|order by=Discussions.question
|limit=1000
|offset=some number
|default=No questions found
|format=dynamic table
|rows per page=100
}}
 
== IT Access used ==
* [[File share HSC Critical Care]]
* [[File share HSC Critical Care CRRT]]
* [[File share Critical Care QIT]]
* [[Critical Care Sharepoint ExtraNet]]
* [[File Locations]]
 
== Related Articles ==
{{Related Articles}}
 
[[Category:Statistician| *]]
[[Category:Steering Committee]]
[[Category:Task Team]]
[[Category:Main Office Team]]

Latest revision as of 08:05, 2023 March 22

p:Julie Mojica is the full time Statistician for the Critical Care and Medicine Database.

She provides Statistical Analysis and Reporting using our data.

The Statistician is a member of the Steering Committee & the Task Team.

Indicators w questions

No questions found

Reports w questions

No questions found

Questions on wiki

Here is a list of questions driven by the Template:Discuss that have been flagged for Julie.

edit page question ModDate
edit page question ModDate
edit ER Delay
  • I just had a look at that sas file (they open as text files) to see how you define transfer delay. If that file is still being used we may have a problem, it still defines tdelay different if a pt goes to a higher level of care, goes AMA or dies, and we changed that some time ago. So is this still the reference of how you calculate this? Ttenbergen 22:50, 2024 November 16 (CST)
 2024-11-17 5:11:10 AM
edit ER Wait
  • no ER Wait concept in Moves for Medicine, so not sure what this means. Ttenbergen 13:53, 2024 November 14 (CST)
    		•  2024-11-17 4:59:36 AM
    edit ER Wait
  • The closest thing I have been able to find to a definition for the earlier state of this is \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\CFE_ERWait_Moves.sas , but that file has a date stamp of 2016-3-17, so it wouldn't have any of the newer developments in it. Is there a definitive file you use? Ttenbergen 22:59, 2024 November 16 (CST)
  • Also, that file uses this project from 2011-06-04 onward, but this project doesn't contain data until 2013-11-23. So we seem to have a gap. Ttenbergen 22:59, 2024 November 16 (CST)
    		•  2024-11-17 4:59:36 AM
    edit Instructions for importing a batch of DSM Data
  • The old process used L_Problems_D_ID table. Does the new process still use and populate it? If so, can we update this with details? If not, can we retire it? Or, in any case, update the data on L_Problems_D_ID table? Ttenbergen 15:15, 2024 October 17 (CDT)
    		•  2024-10-17 8:15:36 PM
    edit ER Delay
  • This data is problematic before 2011-Q2,the only reason there are any is because it derives them for EMIPs. Some data may be available in Moves for Medicine, but that would still leave a gap. Ttenbergen 23:09, 2024 November 16 (CST)
    		•  2024-11-17 5:11:10 AM
    edit DSM Labs data.accdb Emailed Julie:
  • found overlap in old file, what does it mean
  • proposed using labDtTm for split threshold
    • Ttenbergen 16:51, 2024 May 2 (CDT)    		 2024-05-02 9:51:04 PM

    IT Access used

    Related Articles

    Related articles:
    Retrieved from "https://ccmdb.kuality.ca/index.php?title=Statistician&oldid=158666"