Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

User Who Created Specific Appointment Books

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

7 Posts

3 Users

0 Reactions

74 Views

RSS

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

Is there a way to find out or a report that can be run to find out which user(s) created specific appointment books in Centricity 9.12?

Posted : May 17, 2021 8:45 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

It doesn't look like it. There is no field in the BOOK table with that information and I didn't see an event that looked appropriate in the AUDIT_EVENT_TYPE table.

Posted : May 17, 2021 10:11 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

you can get the workstation id for the workstation that created it the books table, might help you, only thing think i could think of.

Posted : May 17, 2021 1:33 pm

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

@petemarkey I am not seeing workstation id field in the Books table. Can you provide more details on where the workstation id field is and how to link it back to the Books table? Thank you!

Posted : May 18, 2021 12:23 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

The last 6 digits of the ID field in the book table are the workstation ID. It is certainly not an absolute way to determine what you are looking for (especially in a terminal services environment), but about all you have to go on. Match to the wsid in the worksta table.

Posted : May 18, 2021 1:50 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

@petemarkey Thank you for that information. It seems like the the ID in Book table last 6 digits is not consistent. Since there is usually only one user that creates the appt books. So the last 6 digits of the ID should be the same correct since the user is using the same workstation each time an appt book gets created. Also, when i add in the worksta table it says table or view doesn't exist.

Posted : May 18, 2021 2:05 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

yeah depending on your environment it can be inconsistent, in mine it is very consistent. the wsid in the worksta table probably isn't the full 6 digits, just fyi you would have to trim the zero's of the front of the 6 digits in the id field to get a sql match.

Posted : May 18, 2021 3:01 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0