Legacy - Study numbers: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m m |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
'''''Legacy only, see [[D_ID]] for what is used now. | |||
== Study | The '''study number''' was generated when the data was 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. | ||
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 the know field length allowed. | |||
The study number field was retained for reference as [[L_Log]].Study, but no new study numbers are being generated. | |||
== 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 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 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. | *example 1/1/85 is example of how dates are stored. | ||
There was an actual 99999 in medicine, so I can't just delete the 99999 row. | |||
[[Category: Identification numbers]] | [[Category: Identification numbers]] | ||
Latest revision as of 09:40, 2015 August 24
Legacy only, see D_ID for what is used now.
The study number was generated when the data was 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 field was retained for reference as L_Log.Study, but no new study numbers are being generated.
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.
There was an actual 99999 in medicine, so I can't just delete the 99999 row.