Data dictionary: Difference between revisions

Line 1:

== Is this it? ==

{{Discuss | who=Julie | question=Attempt at a easier to follow data dictionary. Is this what you had in mind?

Yes, this is what I have in mind. Thanks. Some suggestions:

* I just notice some start dates are not the actual start dates - It is important for the users to know how far back the data are available so they can decide the covered period of their study. is it possible to change the date to actual earliest collection start date (not 1 Jan 1900)~~. For the ICD10 and CCI, we can use the 1 Jan 2019 as the official start date~~. ~~we can do similarly for the end dates of some discontinued table (similar in L_Labs).~~ --[[User:JMojica|JMojica]] 10:05, 2019 January 3 (CST)

* I just notice some start dates are not the actual start dates - It is important for the users to know how far back the data are available so they can decide the covered period of their study. is it possible to change the date to actual earliest collection start date (not 1 Jan 1900). --[[User:JMojica|JMojica]] 10:05, 2019 January 3 (CST)

** The start and end dates are stored on the individual pages. If the list shows 1900 then they were not filled in. If you know what they are and fill them in then this page will list them. Ttenbergen 14:49, 2019 January 3 (CST)

** The start and end dates are stored on the individual pages. If the list shows 1900 then they were not filled in. If you know what they are and fill them in then this page will list them. I can also change the default if-not-filled value in templates to something other than 1900-01-01. I just needed a value for ranges and filters to work. Ttenbergen 14:49, 2019 January 3 (CST)}}

{{Discuss | who=Julie | question=

* add a column for program (Critical care only or Medicine only or both).

** I can do that, but the table is already getting quite wide for a web page. Can we lose any of the columns we currently have? The info you mean is always visible in the pages themselves as well, in case that's sufficient. But, yes, we can tweak what the tables should show. It is done in [[Template:DataDictionaryQuery]] (details visible once you edit it...) and removing fields would be easy enough. I can show you how to add fields. Or I can add them once we confirm what we want.

}}

{{DT | I will change

*For the ICD10 and CCI, we can use the 1 Jan 2019 as the official start date. we can do similarly for the end dates of some discontinued table (similar in L_Labs).}}

On any of the tables below, click on the links in the left columns to find out our definitions and instructions for those fields.

@@ Line 1: / Line 1: @@
+== Is this it? ==
 {{Discuss | who=Julie | question=Attempt at a easier to follow data dictionary. Is this what you had in mind?
    Yes, this is what I have in  mind. Thanks.  Some suggestions:
-* I just notice some start dates are not the actual start dates - It is important for the users to know how far back the data are available so they can decide the covered period of their study. is it possible to change the date to actual earliest  collection start date (not 1 Jan 1900). For the ICD10 and CCI, we can use the 1 Jan 2019 as the official start date.  we can do similarly for the end dates of some discontinued table (similar in L_Labs). --[[User:JMojica|JMojica]] 10:05, 2019 January 3 (CST)
+* I just notice some start dates are not the actual start dates - It is important for the users to know how far back the data are available so they can decide the covered period of their study. is it possible to change the date to actual earliest  collection start date (not 1 Jan 1900).  --[[User:JMojica|JMojica]] 10:05, 2019 January 3 (CST)
-** The start and end dates are stored on the individual pages. If the list shows 1900 then they were not filled in. If you know what they are and fill them in then this page will list them. Ttenbergen 14:49, 2019 January 3 (CST)
+** The start and end dates are stored on the individual pages. If the list shows 1900 then they were not filled in. If you know what they are and fill them in then this page will list them. I can also change the default if-not-filled value in templates to something other than 1900-01-01. I just needed a value for ranges and filters to work. Ttenbergen 14:49, 2019 January 3 (CST)}}
+{{Discuss | who=Julie | question=
 * add a column for program (Critical care only or Medicine only or both).
 ** I can do that, but the table is already getting quite wide for a web page. Can we lose any of the columns we currently have? The info you mean is always visible in the pages themselves as well, in case that's sufficient. But, yes, we can tweak what the tables should show. It is done in [[Template:DataDictionaryQuery]] (details visible once you edit it...) and removing fields would be easy enough. I can show you how to add fields. Or I can add them once we confirm what we want.
 }}
+{{DT | I will change
+*For the ICD10 and CCI, we can use the 1 Jan 2019 as the official start date.  we can do similarly for the end dates of some discontinued table (similar in L_Labs).}}
 On any of the tables below, click on the links in the left columns to find out our definitions and instructions for those fields.