Legacy - Study numbers: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 2: | Line 2: | ||
== Study 99999 == | == Study 99999 == | ||
When | 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. | ||
*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 | ||
Revision as of 14:06, 2013 September 26
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
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.
- 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.