Legacy - Study numbers: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
TOstryzniuk (talk | contribs)
No edit summary
Line 1: Line 1:
The '''study number''' is generated when the data is appended to [[TMSX]] or [[MedTMS]] to uniquely identify a patient ''encounter'', i.e. one ward or unit stay. The study number is unique across the entire data set.
The '''study number''' is generated when the data is appended to [[TMSX]] or [[MedTMS]] to uniquely identify a patient ''encounter'', i.e. one ward or unit stay. The study number is unique across the entire data set.


== Study 99999 ==
== Study 99,999 ==
When registry dat is exported as a csv file from [[TMSX]] or [[MedTMS]] the third row of data indicated the number of characters allowed in the column.  Julie uses this marker in her SAS program for the know field length allowed.
When registry dat is exported as a csv file from [[TMSX]] or [[MedTMS]] the third row of data indicated the number of characters allowed in the column.  Julie uses this marker in her SAS program for the know field length allowed.
*example 999: is for numerics and for this example 3 are allowed in the column
*example 999: is for numerics and for this example 3 are allowed in the column
Line 8: Line 8:


{{discussion}}
{{discussion}}
*Can I assume that there will be no actual study 99999 then? Ttenbergen 12:09, 2013 November 19 (CST)
*Can I assume that there will be no actual study 99,999 then? Ttenbergen 12:09, 2013 November 19 (CST)
**Yes, there is a study 99,999 in Medicine.  See [[Total_admissions_ICU/Med]]-[[User:TOstryzniuk|Trish Ostryzniuk]] 19:12, 2013 November 19 (CST)
 
 




[[Category: Identification numbers]]
[[Category: Identification numbers]]

Revision as of 19:12, 2013 November 19

The study number is generated when the data is appended to TMSX or MedTMS to uniquely identify a patient encounter, i.e. one ward or unit stay. The study number is unique across the entire data set.

Study 99,999

When registry dat is exported as a csv file from TMSX or MedTMS the third row of data indicated the number of characters allowed in the column. Julie uses this marker in her SAS program for the know field length allowed.

  • example 999: is for numerics and for this example 3 are allowed in the column
  • example ZZ: is for characters and for this example, two are allowed in the column
  • example 1/1/85 is example of how dates are stored.

Template:Discussion

  • Can I assume that there will be no actual study 99,999 then? Ttenbergen 12:09, 2013 November 19 (CST)