allergies
|
ID |
PatientID |
Description |
FirstFound |
|
110 |
2 |
Pollen |
2007-06-05 20:33:58.0 |
|
111 |
2 |
Penicillin |
2007-06-04 20:33:58.0 |
cptcodes:
standard code for medical procedures and description
|
Code |
Description |
|
1270F |
Injection procedure |
|
87 |
Diagnostic Radiology |
hospitals
|
HospitalID |
HospitalName |
|
9191919191 |
Test Hospital 9191919191 |
|
8181818181 |
Test Hospital 8181818181 |
|
1 |
Test Hospital 1 |
icdcodes:
standard code for diagnoses and immunization with descrition
|
Code |
Description |
|
250.10 |
Diabetes with ketoacidosis |
|
487.00 |
Influenza |
|
79.10 |
Echovirus |
|
84.50 |
Malaria |
|
79.30 |
Coxsackie |
|
11.40 |
Tuberculosis of the lung |
|
15.00 |
Tuberculosis of vertebral column |
|
42.00 |
Human Immunodeficiency Virus |
|
70.10 |
Viral hepatitis A, infectious |
labprocedure
|
LaboratoryProcedureID |
PatientMID |
LaboratoryProcedureCode |
Rights |
Status |
Commentary |
Results |
OfficeVisitID |
UpdatedDate |
|
314 |
1 |
10763-1 |
ALLOWED |
NOT YET RECEIVED |
11 |
2008-05-19 00:00:00.0 |
||
|
315 |
1 |
10666-6 |
RESTRICTED |
PENDING |
Performed the procedure |
11 |
2008-05-18 00:00:00.0 |
|
|
316 |
1 |
10640-1 |
ALLOWED |
COMPLETED |
Performed the procedure |
Patient checks out ok |
11 |
2007-05-17 00:00:00.0 |
|
317 |
2 |
10640-1 |
ALLOWED |
COMPLETED |
Performed the procedure |
Patient needs more tests |
902 |
2007-05-19 00:00:00.0 |
|
318 |
2 |
10763-1 |
RESTRICTED |
NOT YET RECEIVED |
Performed the procedure |
Patient needs more tests |
905 |
2007-07-20 00:00:00.0 |
|
319 |
4 |
10763-1 |
ALLOWED |
COMPLETED |
905 |
2008-11-01 14:10:31.0 |
loginfailures
|
ipaddress |
failureCount |
lastFailure |
|
68.180.63.127 |
0 |
2008-11-02 23:14:25.0 |
|
71.77.43.89 |
0 |
2008-11-03 05:04:07.0 |
|
152.14.243.76 |
0 |
2008-11-03 10:42:41.0 |
|
152.14.242.165 |
0 |
2008-11-03 11:08:47.0 |
|
152.14.242.198 |
0 |
2008-11-03 11:36:17.0 |
|
152.14.241.230 |
0 |
2008-11-03 14:37:15.0 |
|
152.14.86.184 |
0 |
2008-11-03 15:10:17.0 |
|
152.14.86.189 |
0 |
2008-11-03 17:24:46.0 |
|
66.253.198.46 |
0 |
2008-11-03 19:39:18.0 |
|
152.1.222.64 |
0 |
2008-11-03 20:18:00.0 |
|
152.14.235.24 |
0 |
2008-11-04 13:23:53.0 |
|
152.14.247.33 |
0 |
2008-11-04 14:34:01.0 |
|
152.14.243.135 |
0 |
2008-11-04 14:53:40.0 |
|
152.14.246.129 |
0 |
2008-11-04 15:57:42.0 |
|
152.7.23.128 |
0 |
2008-11-04 19:40:03.0 |
|
64.146.153.71 |
0 |
2008-11-04 20:14:48.0 |
|
152.7.61.27 |
0 |
2008-11-05 01:31:35.0 |
ndcodes:
standard medication codes with description
|
Code |
Description |
|
009042407 |
Tetracycline |
|
081096 |
Aspirin |
|
647641512 |
Prioglitazone |
officevisits
|
ID |
visitDate |
HCPID |
notes |
PatientID |
HospitalID |
|
11 |
2005-10-10 |
9000000000 |
Yet another office visit. |
1 |
|
|
902 |
2007-06-09 |
9000000000 |
Yet another office visit. |
2 |
1 |
|
903 |
2005-10-10 |
9000000000 |
Yet another office visit. |
2 |
1 |
|
904 |
2005-10-10 |
9000000000 |
Yet another office visit. |
2 |
1 |
|
905 |
2007-06-10 |
9000000000 |
Yet another office visit. |
2 |
1 |
|
906 |
2005-10-10 |
9000000000 |
Yet another office visit. |
2 |
1 |
|
907 |
2005-10-10 |
9000000000 |
Yet another office visit. |
2 |
1 |
|
908 |
2005-10-10 |
9000000000 |
Yet another office visit. |
2 |
1 |
|
909 |
2006-10-10 |
9000000000 |
Yet another office visit. |
2 |
1 |
|
910 |
1985-10-10 |
9000000000 |
Yet another office visit. |
2 |
|
|
111 |
2005-10-10 |
9000000000 |
Old office visit. |
3 |
|
|
1 |
2005-10-10 |
9000000000 |
Generated for Death for Patient: 1 |
1 |
1 |
ovdiagnosis:
office visit diagnoses
|
ID |
VisitID |
DiscretionaryAccess |
PrivacyLevel |
ICDCode |
|
271 |
11 |
1 |
All |
350.00 |
|
272 |
11 |
1 |
All |
250.00 |
|
100 |
905 |
1 |
All |
250.10 |
|
101 |
910 |
0 |
All |
79.30 |
|
102 |
910 |
1 |
Declared HCP Only |
250.10 |
|
103 |
910 |
1 |
No One |
250.10 |
|
104 |
910 |
1 |
No One |
11.40 |
|
105 |
910 |
1 |
Declared HCP Only |
15.00 |
|
273 |
111 |
1 |
All |
459.99 |
ovmedication:
office visit medication prescription
|
ID |
VisitID |
NDCode |
StartDate |
EndDate |
Dosage |
Instructions |
|
161 |
905 |
009042407 |
2006-10-10 |
2006-10-11 |
5 |
Take twice daily |
|
162 |
905 |
009042407 |
2006-10-10 |
2006-10-11 |
5 |
Take twice daily |
|
163 |
905 |
647641512 |
2006-10-10 |
2020-10-11 |
5 |
Take twice daily |
ovprocedure:
office visit medical procedure
|
ID |
VisitID |
CPTCode |
|
58 |
905 |
1270F |
ovsurvey:
office visit survey results
|
VisitID |
SurveyDate |
WaitingRoomMinutes |
ExamRoomMinutes |
VisitSatisfaction |
TreatmentSatisfaction |
|
902 |
2008-03-01 12:00:00.0 |
null |
20 |
1 |
5 |
|
904 |
2008-03-02 13:00:00.0 |
25 |
55 |
2 |
4 |
patients
|
MID |
lastName |
firstName |
email |
address1 |
address2 |
city |
state |
zip1 |
zip2 |
phone1 |
phone2 |
phone3 |
eName |
ePhone1 |
ePhone2 |
ePhone3 |
iCName |
iCAddress1 |
iCAddress2 |
iCCity |
ICState |
iCZip1 |
iCZip2 |
iCPhone1 |
iCPhone2 |
iCPhone3 |
iCID |
DateOfBirth |
DateOfDeath |
CauseOfDeath |
MotherMID |
FatherMID |
BloodType |
Ethnicity |
Gender |
TopicalNotes |
|
1 |
Person |
Random |
nobody@gmail.com |
1247 Noname Dr |
Suite 106 |
Raleigh |
NC |
27606 |
1234 |
919 |
971 |
0000 |
Mommy Person |
704 |
532 |
2117 |
Aetna |
1234 Aetna Blvd |
Suite 602 |
Charlotte |
NC |
28215 |
704 |
555 |
1234 |
ChetumNHowe |
1950-05-10 |
null |
1 |
0 |
AB+ |
African American |
Female |
|||
|
2 |
Programmer |
Andy |
andy.programmer@gmail.com |
344 Bob Street |
Raleigh |
NC |
27607 |
555 |
555 |
5555 |
Mr Emergency |
555 |
555 |
5551 |
IC |
Street1 |
Street2 |
City |
PA |
19003 |
2715 |
555 |
555 |
5555 |
1 |
1984-05-19 |
null |
1 |
0 |
O- |
Caucasian |
Male |
This person is absolutely crazy. Do not touch them. |
|||
|
3 |
Needs |
Care |
fake@email.com |
1247 Noname Dr |
Suite 106 |
Raleigh |
NC |
27606 |
1234 |
919 |
971 |
0000 |
Mum |
704 |
532 |
2117 |
Aetna |
1234 Aetna Blvd |
Suite 602 |
Charlotte |
NC |
28215 |
704 |
555 |
1234 |
ChetumNHowe |
1950-05-10 |
null |
1 |
0 |
AB+ |
African American |
Male |
|||
|
4 |
Has |
NoRecords |
fake@email.com |
1247 Noname Dr |
Suite 106 |
Raleigh |
NC |
27606 |
1234 |
919 |
971 |
0000 |
Mum |
704 |
532 |
2117 |
Aetna |
1234 Aetna Blvd |
Suite 602 |
Charlotte |
NC |
28215 |
704 |
555 |
1234 |
ChetumNHowe |
1950-05-10 |
null |
1 |
0 |
AB+ |
African American |
Male |
personalhealthinformation
|
PatientID |
Height |
Weight |
Smoker |
BloodPressureN |
BloodPressureD |
CholesterolHDL |
CholesterolLDL |
CholesterolTri |
HCPID |
AsOfDate |
|
1 |
72 |
180 |
0 |
100 |
100 |
40 |
100 |
100 |
9000000000 |
2007-06-07 20:33:58.0 |
|
2 |
60 |
200 |
0 |
190 |
100 |
500 |
239 |
290 |
9000000000 |
2007-06-07 20:33:58.0 |
|
2 |
62 |
210 |
1 |
195 |
250 |
36 |
215 |
280 |
9000000000 |
2007-06-07 20:34:58.0 |
|
3 |
72 |
180 |
0 |
100 |
100 |
40 |
100 |
100 |
9000000000 |
2005-06-07 20:33:58.0 |
personnel
|
MID |
role |
enabled |
lastName |
firstName |
address1 |
address2 |
city |
state |
zip |
zip1 |
zip2 |
phone |
phone1 |
phone2 |
phone3 |
specialty |
email |
|
9000000000 |
hcp |
0 |
Doctor |
Kelly |
4321 My Road St |
PO BOX 2 |
CityName |
NY |
12345-1234 |
12345 |
1234 |
999-888-7777 |
999 |
888 |
7777 |
surgeon |
kdoctor@iTrust.org |
|
9000000003 |
hcp |
0 |
Stormcrow |
Gandalf |
4321 My Road St |
PO BOX 2 |
CityName |
NY |
12345-1234 |
12345 |
1234 |
999-888-7777 |
999 |
888 |
7777 |
null |
gstormcrow@iTrust.org |
|
9000000001 |
admin |
0 |
Shifter |
Shape |
4321 My Road St |
PO BOX 2 |
CityName |
NY |
12345-1234 |
12345 |
1234 |
999-888-7777 |
999 |
888 |
7777 |
administrator |
|
|
9000000002 |
admin |
0 |
Bob |
Marley |
4321 My Road St |
PO BOX 2 |
CityName |
NY |
12345-1234 |
12345 |
1234 |
999-888-7777 |
999 |
888 |
7777 |
administrator |
|
|
8000000009 |
admin |
0 |
LastUAP |
FirstUAP |
100 Ave |
Raleigh |
NC |
27607 |
111 |
111 |
1111 |
null |
transactionlog
|
transactionID |
loggedInMID |
secondaryMID |
transactionCode |
timeLogged |
addedInfo |
|
2255 |
1 |
0 |
6 |
2008-11-02 23:14:36.0 |
Authenticated, requesting home page |
|
2256 |
1 |
0 |
6 |
2008-11-02 23:16:06.0 |
Authenticated, requesting home page |
|
2257 |
1 |
0 |
6 |
2008-11-03 10:42:44.0 |
Authenticated, requesting home page |
|
2258 |
1 |
0 |
6 |
2008-11-03 10:42:57.0 |
Authenticated, requesting home page |
|
2259 |
1 |
0 |
6 |
2008-11-03 10:43:08.0 |
Authenticated, requesting home page |
|
2260 |
1 |
0 |
6 |
2008-11-03 10:43:19.0 |
Authenticated, requesting home page |
|
2261 |
1 |
0 |
6 |
2008-11-03 10:43:35.0 |
Authenticated, requesting home page |
|
2262 |
1 |
9000000000 |
1 |
2008-11-03 10:43:57.0 |
Patient viewed personnel 9000000000 |
|
2263 |
1 |
9000000003 |
2 |
2008-11-03 10:44:26.0 |
patient undeclared hcp |
|
2264 |
1 |
1 |
1 |
2008-11-03 10:44:46.0 |
Viewed |
|
2265 |
1 |
0 |
33 |
2008-11-03 10:45:09.0 |
searched results by HCP hospital ID |
|
2266 |
1 |
0 |
6 |
2008-11-03 10:45:22.0 |
Authenticated, requesting home page |
|
2267 |
1 |
0 |
4 |
2008-11-03 10:45:32.0 |
for dates between 11/03/2008 and 11/03/2008 |
|
2268 |
1 |
0 |
6 |
2008-11-03 10:45:33.0 |
Authenticated, requesting home page |
|
2269 |
9000000000 |
0 |
6 |
2008-11-03 11:08:49.0 |
Authenticated, requesting home page |
|
2270 |
9000000000 |
2 |
22 |
2008-11-03 11:08:56.0 |
viewed emergency report |
|
2271 |
2 |
0 |
6 |
2008-11-03 11:28:21.0 |
Authenticated, requesting home page |
|
2272 |
2 |
9000000000 |
1 |
2008-11-03 11:28:24.0 |
Patient viewed personnel 9000000000 |
|
2273 |
2 |
9000000000 |
1 |
2008-11-03 11:28:30.0 |
Patient viewed personnel 9000000000 |
|
2274 |
2 |
9000000000 |
1 |
2008-11-03 11:29:29.0 |
Patient viewed personnel 9000000000 |
|
2275 |
2 |
0 |
6 |
2008-11-03 11:29:41.0 |
Authenticated, requesting home page |
|
2276 |
2 |
2 |
1 |
2008-11-03 11:29:54.0 |
Viewed |
|
2277 |
2 |
0 |
33 |
2008-11-03 11:30:01.0 |
searched results by HCP hospital ID |
|
2278 |
9000000000 |
0 |
6 |
2008-11-03 11:36:18.0 |
Authenticated, requesting home page |
|
2279 |
9000000000 |
2 |
1 |
2008-11-03 11:36:35.0 |
Viewed |
|
2280 |
1 |
0 |
6 |
2008-11-03 14:37:20.0 |
Authenticated, requesting home page |
|
2281 |
1 |
1 |
1 |
2008-11-03 14:37:33.0 |
Viewed |
|
2282 |
9000000000 |
0 |
6 |
2008-11-03 14:37:56.0 |
Authenticated, requesting home page |
|
2283 |
1 |
0 |
6 |
2008-11-03 15:10:22.0 |
Authenticated, requesting home page |
|
2284 |
1 |
0 |
6 |
2008-11-03 16:04:22.0 |
Authenticated, requesting home page |
|
2285 |
1 |
0 |
33 |
2008-11-03 16:04:51.0 |
searched results by HCP hospital ID |
|
2286 |
1 |
0 |
33 |
2008-11-03 16:04:54.0 |
searched results by HCP hospital ID |
|
2287 |
1 |
0 |
6 |
2008-11-03 16:05:02.0 |
Authenticated, requesting home page |
|
2288 |
1 |
1 |
1 |
2008-11-03 16:05:05.0 |
Viewed |
|
2289 |
2 |
0 |
6 |
2008-11-03 16:07:37.0 |
Authenticated, requesting home page |
|
2290 |
1 |
0 |
6 |
2008-11-03 16:08:27.0 |
Authenticated, requesting home page |
|
2291 |
1 |
0 |
6 |
2008-11-03 19:39:30.0 |
Authenticated, requesting home page |
|
2292 |
3 |
0 |
6 |
2008-11-03 20:19:57.0 |
Authenticated, requesting home page |
|
2293 |
3 |
0 |
6 |
2008-11-03 20:20:10.0 |
Authenticated, requesting home page |
|
2294 |
3 |
0 |
6 |
2008-11-03 20:20:17.0 |
Authenticated, requesting home page |
users
|
MID |
Password |
Role |
sQuestion |
sAnswer |
|
9000000000 |
pw |
hcp |
first letter? |
a |
|
9000000003 |
pw |
hcp |
first letter? |
a |
|
1 |
pw |
patient |
what is your favorite color? |
blue |
|
2 |
pw |
patient |
how you doin? |
good |
|
3 |
pw |
patient |
opposite of yin |
yang |
|
4 |
pw |
patient |
opposite of yin? |
yang |
|
9000000001 |
pw |
admin |
first letter? |
a |
|
9000000002 |
pw |
admin |
first letter? |
a |
|
8000000009 |
uappass1 |
uap |
opposite of yin |
yang |
|
9999999999 |
pw |
tester |