Legacy - Study numbers: Difference between revisions
Ttenbergen (talk | contribs) No edit summary |
TOstryzniuk (talk | contribs) |
||
| Line 7: | Line 7: | ||
*example 1/1/85 is example of how dates are stored. | *example 1/1/85 is example of how dates are stored. | ||
'''There still is a 99999 in medicine, so | '''There still is a 99999 in medicine, so I can't just delete the 99999 row. '''Ttenbergen 15:35, 2013 November 20 (CST) | ||
{{Discussion}} | |||
What do you mean by the 99,999 row? [[User:TOstryzniuk|Trish Ostryzniuk]] 17:46, 2013 November 20 (CST) | |||
In Ed's export he has a row that just ID's number of numbers or letters in a column. Is this what you are talking about? | |||
[[Category: Identification numbers]] | [[Category: Identification numbers]] | ||
Revision as of 17:46, 2013 November 20
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.
There still is a 99999 in medicine, so I can't just delete the 99999 row. Ttenbergen 15:35, 2013 November 20 (CST)
Template:Discussion What do you mean by the 99,999 row? Trish Ostryzniuk 17:46, 2013 November 20 (CST) In Ed's export he has a row that just ID's number of numbers or letters in a column. Is this what you are talking about?