Welcome to the NEW Community Healthcare User Group ( the new CHUG)— your ultimate destination for insights and discussions at the intersection of healthcare and technology.

Please scroll to the bottom for “Centricity” related topics from the previous forum.

Notifications

Clear all

What Table

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

86 Views

RSS

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Topic starter

Does anyone know what table contains the CPT list and categories for the Orders Codes and Categories?

I am going to run a report, but need the table.

Posted : November 26, 2014 6:11 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Take a look at ORDERCODES

SELECT "ORDERCODES"."ORDERTYPE", "ORDERCODES"."CODE", "ORDERCODES"."DESCRIPTION"
FROM "ML"."ORDERCODES" "ORDERCODES"

Posted : November 26, 2014 6:17 am

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Topic starter

Thank you.

My query is:

SELECT ORDERCAT.CATTYPE, ORDERCAT.CATNAME, ORDERCODES.CODE, ORDERCODES.DESCRIPTION

FROM ORDERCODES ORDERCODES INNERJOIN ORDERCAT ORDERCAT ON ORDERCODES.ORDCATID=ORDERCAT.ORDCATID

ORDERBY ORDERCAT.CATNAME, ORDERCAT.CATTYPE

Posted : November 26, 2014 7:48 am

Share:

24 Forums
9,943 Topics
39.9 K Posts
6 Online
6,472 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.1