[MEDITECH-L] random SSN report for random drug screen
Gauntt, Brandon K.
I have a request to create a report that will randomly select x number of employee social security numbers for random drug screening. I actually do not have the slightest idea as to how to write anything in NPR that would randomly pick a field every time it is ran. Does anyone out there have any type of report that would do something like this they would be willing to share? I would appreciate any help with this.
Brandon Gauntt
Director - Information Services
Hopkins County Memorial Hospital
903-439-4054 Office
903-348-2112 Cell
| This e-mail, facsimile, or letter and any files or attachments transmitted with it contains information that is confidential and privileged. This information is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please notify Baylor Health Care System immediately at 1-866-402-1661 or via e-mail at pri...@baylorhealth.edu. Baylor Health Care System, its subsidiaries, and affiliates hereby claim all applicable privileges related to this information. |
Joe Cocuzzo
Check out our 2004 NPR Tips and Tricks on our web site. I show a random sample report for employees and one for patients.
Joe Cocuzzo
Vice President
NPR Services
Iatric Systems, Inc.
Phone/Fax: (978) 805-4115
Email: jo...@iatric.com
Web: www.iatric.com
Robert White
$RN(100)^X,
This assigns a random number between 0 and 99 to the variable X. The argument doesn't need to be 100 - it could be anything - though I think there's an upper limit. But that's just a start. Selecting a random sample from any population can get fairly complicated.
>>> "Gauntt, Brandon K." <Bran...@baylorhealth.edu> 04/06/07 8:56 AM >>>
Brandon Gauntt
Director - Information Services
Hopkins County Memorial Hospital
903-439-4054 Office
903-348-2112 Cell
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
To subscribe or unsubscribe to the meditech-l, visit MTUsers.NET.
To check the status of the meditech-l, visit MTUsers.NET.
For help, email sup...@MTUsers.NET.
Visit the MTUsers WikiPedia at MTUsers.NET/mwiki
______________________________________
meditech-l mailing list
medit...@MTUsers.com
http://mtusers.com/mailman/listinfo/meditech-l
McGaw, Douglas
Brandon – try this report. I recently had a similar request and this was the response. The macro contains the randomization logic:
From:
medit...@MTUsers.com [mailto:medit...@MTUsers.com] On Behalf Of Gauntt, Brandon K.
Sent: Friday, April 06, 2007 7:56
AM
To: medit...@MTUsers.com;
c...@museweb.org
Subject: [MEDITECH-L]
random SSN report for random drug screen
I have a request to create a report that will randomly select x number of employee social security numbers for random drug screening. I actually do not have the slightest idea as to how to write anything in NPR that would randomly pick a field every time it is ran. Does anyone out there have any type of report that would do something like this they would be willing to share? I would appreciate any help with this.
Summers Monica
Monica
Monica
Summers
System Education Consultant
IT&S Learning
Solutions
HCA Information
Technology & Services
490
Metroplex
Nashville TN
37211
t: 615-344-6962
f: 615-344-4144
e:
monica....@hcahealthcare.com
w: www.hcahealthcare.com
From: medit...@MTUsers.com [mailto:medit...@MTUsers.com] On Behalf Of Gauntt, Brandon K.
Sent: Friday, April 06, 2007 7:56 AM
To: medit...@MTUsers.com; c...@museweb.org
Subject: [MEDITECH-L] random SSN report for random drug screen