[MT-L] Detail Trial Balance info from DR

[Laura Wilson]

I am needing to access Detail Trial Balance information in Data Repository and have no idea where to begin. The report is run out of GL, but it seems that I will need information from AP,MM,PR and perhaps others. Has anyone done this and/or can you offer some guidance as to the tables that I need to use?

Thank you in advance!!

Laura Wilson Asst. Director
[cid:image0...@01CC4149.918F2FC0]
INFORMATION SYSTEMS
770.836.9791 | www.tanner.org<http://www.tanner.org/>

The measure of a man's real character is what he would do if he knew he would never be found out. ~T.B. Macaulay<http://www.great-quotes.com/quote/47499>

[Tumminello, Gloria]

Please post.

From: Laura Wilson [mailto:lwi...@tanner.org]
Sent: Wednesday, July 13, 2011 10:54 AM
To: Meditech L (medit...@mtusers.com); SISUList serve
(CSLis...@sisunet.org)
Subject: Detail Trial Balance info from DR

I am needing to access Detail Trial Balance information in Data
Repository and have no idea where to begin. The report is run out of
GL, but it seems that I will need information from AP,MM,PR and perhaps
others. Has anyone done this and/or can you offer some guidance as to
the tables that I need to use?

Thank you in advance!!

Laura Wilson Asst. Director

INFORMATION SYSTEMS

[Barrett, Joanne]

Laura, you may already know some of this but if not I hope you can use it. The first thing you probably would need to now is what information you will need from the different DPM's, i.e AP, GL, MM, etc. Example if you know you would need GL.AMOUNT.balance then you can go to DR in MEDITECH, use the Field Inquiry NPR element GL.AMOUNT.balance hit enter and it will show you the DR table you need to use. You can also look at the DR in MEDITECH and do a Table Inquiry and that would give you all the fields within the specific DR tables.

If you have Microsoft Access you can created a database then a query

Get 2 tables dbo_SysDrColumns and dbo_SysDrTables link them by TableID, add all the fields you need from both tables including the NPR information and this will give you the DR Columns and Tables names and also their equivalent in NPR, example DPM ADM.PAT, segment Main, field ADM.PAT.discharge.date equals DR Column name is DischargeDateTime, table is AdmDischarge.

Here is the actual query for this:

SELECT dbo_SysDrColumns.Name, dbo_SysDrTables.Name, dbo_SysDrColumns.TableID, dbo_SysDrColumns.DataType, dbo_SysDrColumns.Length, dbo_SysDrColumns.SortKey, dbo_SysDrColumns.NprDpm, dbo_SysDrColumns.NprSegment, dbo_SysDrColumns.NprElement, dbo_SysDrColumns.RowUpdateDateTime, dbo_SysDrColumns.ColumnPosition

FROM dbo_SysDrColumns INNER JOIN dbo_SysDrTables ON dbo_SysDrColumns.TableID = dbo_SysDrTables.TableID

WHERE (((dbo_SysDrTables.Name)="EdmPatientStatusEvents"))

ORDER BY dbo_SysDrColumns.Name, dbo_SysDrTables.Name, dbo_SysDrColumns.NprSegment;

Joanne Barrett-Haramis

Sr. Programmer/Analyst

Data Management and User Provisioning

Halifax Health-IT

World Class Care Right Where You Live

From Outside (386-425-1115) Internal X 51115

E-Mail: Joanne....@Halifax.org

Learn IT, Use IT, Love IT

P please consider the environment before printing this email

Electronic communications originating from or sent to Halifax Community Health System (HCHS) are subject to monitoring and public inspection under § 119.07, Florida Statutes. This message and any attachments are the property of HCHS and are intended to be received only by the individuals or entities identified in the message. If you have received this message in error, please take notice: 1) that any use, copying, printing, forwarding or distribution of this message in any form is strictly prohibited, and 2) please notify the HCHS Compliance Department at (386) 254-4278 and/or forward the message to compl...@halifax.org, and please delete or destroy all copies of the message and any attachments.

Please post.

(CSLis...@sisunet.org)

Thank you in advance!!

Laura Wilson Asst. Director

INFORMATION SYSTEMS

770.836.9791 | www.tanner.org <http://www.tanner.org/>

<http://www.great-quotes.com/quote/47499>

===###===###===###===###===###===###===

Please do NOT send messages that ask "Please post to the list" or "I'd like to see your answers" or "Send that info to me, too" These are useless messages that just waste the email server's resources. Instead, email the original requester and ask that they send you or post the results of their question.

To UNSUBSCRIBE or to SUBSCRIBE, go to http://MTUsers.net for information.

You can locate the:
1) meditech-l archives
2) NPR/Magic/CS tips
3) job opportunities in the Meditech community
http://mtusers.net

Do NOT send email to meditech...@MTUsers.com. This is a system email box that is NOT monitored by a human. If you need help or advice on how to use the meditech-l, email lo...@MTUsers.com or ju...@MTUsers.net. Both of these people help manage the meditech-l, so they are your best resource.

===***===***===***===***===***===***===

[Barrett, Joanne]

Laura in my query below I was only looking to get information for one table but if you take out the WHERE you can get all tables.

Joanne Barrett-Haramis

Sr. Programmer/Analyst

Data Management and User Provisioning

Halifax Health-IT

World Class Care Right Where You Live

From Outside (386-425-1115) Internal X 51115

E-Mail: Joanne....@Halifax.org <mailto:Joanne....@Halifax.org>

Learn IT, Use IT, Love IT

P please consider the environment before printing this email

Electronic communications originating from or sent to Halifax Community Health System (HCHS) are subject to monitoring and public inspection under § 119.07, Florida Statutes. This message and any attachments are the property of HCHS and are intended to be received only by the individuals or entities identified in the message. If you have received this message in error, please take notice: 1) that any use, copying, printing, forwarding or distribution of this message in any form is strictly prohibited, and 2) please notify the HCHS Compliance Department at (386) 254-4278 and/or forward the message to compl...@halifax.org, and please delete or destroy all copies of the message and any attachments.

________________________________