Magic 5.67 DR-SQL | Forum

Topic location: Forum home » Reporting » DR Reporting
Deleted user
Deleted user Dec 18 '16
2016-12-18 19:40:12
I am looking for the location in BAR where the BAR Charge Procedures are
associated with the BAR GL Dept for each transaction. Can anyone help
me with this? When I was at a Client Server site the location was in
"BarChargeTransactions.ProcedureChargeDept" however this is not a field
in Magic.

Thank you for your assistance.

Regards,

Jodi Pant
Controller/Director of Finance
Sturgis Hospital
916 Myrtle Avenue
Sturgis, MI 49091
269-659-4453
jpant@sturgishospital.com

Dec 19 '16
2016-12-19 13:21:08
Are you looking for something like:
select bv.AccountNumber
, bv.Name
, bct.BatchDateTime
, bct.TransactionProcedureID
, bct.TransactionCount
, bct.Amount
, dbp.ChargeDeptID
from livedb.dbo.BarVisits bv
inner join livedb.dbo.BarChargeTransactions bct
on (bv.SourceID=bct.SourceID) and (bv.BillingID=bct.BillingID)
inner join livedb.dbo.DBarProcedures dbp
on (bct.SourceID=dbp.SourceID) and (bct.TransactionProcedureID=dbp.ProcedureID)
where (bct.BatchDateTime between '11/1/16' and '11/30/16 23:59')
with the ChargeDeptID being retrieved from the procedure dictionary table?
Ganesh Seshadri
Analyst
Indiana Regional Medical Center
(724) 357-7012
Dec 19 '16
2016-12-19 13:26:29
Hi Jodi,
What you're seeing is part of MEDITECH's ongoing changes normalize the database schema: as part of both MAGIC and C/S 5.67, the data you're after is now in the procedure dictionary (DBarProcedures), rather than stored with the details in BarChargeTransactions. Here's a quick query to illustrate it for you:
SELECT TOP 10
BCT.TransactionProcedureID,
DBP.ChargeCategoryID,
DBP.ChargeDeptID,
DBP.Description
FROM BarChargeTransactions BCT
INNER JOIN DBarProcedures DBP
ON BCT.SourceID = DBP.SourceID
AND BCT.TransactionProcedureID = DBP.ProcedureID
WHERE
DBP.ProcedureID = '<your procedure here>'
Let me know if you need any further guidance on this.
Cordially,
-- Ian
Ian Proffer
Vice President, Consulting Services
781.329.4300 x202
[Acmeware_logo_email_signature]<http://www.acmeware.com/>;
Data Repository Experts Since 1998

chenjinyan
chenjinyan May 14 '18

mont blanc pens wedding shoes cheap nba jerseys air force 1 coach handbags snapbacks wholesale under armour outlet nike air force wholesale nfl jerseys polo ralph lauren balance shoes kobe 11 air max michael kors outlet coach outlet online birkenstock outlet jordan 8 oakley sunglasses polo ralph lauren tag heuer watches barcelona jersey ralph lauren uk louis vuitton jordan 4 beats by dre fingerlings monkey flops jordans dansko shoes tory burch outlet coach factory outlet air jordan 14 adidas ultra boost nike mercurial vapor true religion jeans jordan shoes polo ralph lauren jordan 5 air max 270 louboutin nike uk adidas outlet baseball bats air jordan 11 jordan shoes asics running shoes air huarache louis vuitton jordan xx9 nike shoes converse shoes juicy couture outlet adidas jeremy scott scarpe mbt air max timberland boots adidas stan smith jordans michael kors outlet flip-flops coach outlet nike outlet supreme outlet nike outlet flip flops michael kors outlet off-white clothing nike free kate spade handbags coach outlet stuart weitzman shoes air jordan oakley sunglasses wholesale burberry outlet online cheap mlb jerseys jordan retro pandora jewelry canada nike tennis oakley sunglasses true religion jeans red bottoms pandora jewelry converse herve leger dresses cheap nfl jerseys adidas yeezy 350 cheap jerseys stussy hoodie oakley sunglasses nike free run louis vuitton outlet online cartier jewelry replica watches oakley vault fitflops outlet undefeated shoes nike air max coach outlet michael kors outlet pandora jewelry off-white clothing supreme uk rolex watches longchamp outlet coach factory outlet oakley sunglasses air max 90 ray ban sunglasses nike shoes for men coach outlet online van cleef & arpels jewelry superdry clothing nike lunarglide new balance sandals adidas outlet store jordan 3 louis vuitton outlet toms outlet michael kors outlet adidas flip flops ralph lauren uk michael kors outlet light up shoes burberry outlet michael kors outlet nike uk coach factory outlet nike outlet online burberry outlet salvatore ferragamo air max 95 polo shirts jordan kate spade coach roshe run belstaff jackets audemars piguet ralph lauren nike huarache shoes nfl jerseys wholesale ray ban sunglasses wholesale coach outlet online flip-flops birkenstock sandals burberry outlet canada christian louboutin longchamp coach outlet cheap mlb jerseys nike presto coach outlet online michael kors outlet online red bottom shoes nike cortez converse shoes polo ralph nike blazer ray ban kate spade adidas slides links of london mulberry handbags lebron 15 celine outlet coach outlet online puma fenty sandals true religion jeans louis vuitton outlet ralph lauren bcbg birkenstock shoes james harden shoes ray ban sunglasses nike outlet nike air max louboutin timberland pro basketball shoes nike sb air max 2017 curry shoes ferragamo shoes louis vuitton handbags nike dunks louis vuitton outlet giuseppe zanotti shoes swarovski new balance ray ban longchamp outlet jordan 12 coach outlet oakley sunglasses louboutin pandora jewelry canada air max jordan polo ralph air max hermes outlet prada prada louis vuitton nike free run manolo blahnik shoes hermes kelly bag ray ban sunglasses louis vuitton outlet marc jacobs cheap nfl jerseys suicoke sandals louis vuitton nike epic react mont blanc birkenstock sandals malone souliers mules yeezy 500 blush givenchy handbags louis vuitton handbags cheap rolex watches puma slides michael kors hermes birkin bags jordan 6 nike revolution air jordan adidas wings pandora jewelry air jordan shoes ray ban air max plus supra shoes nike outlet valentino shoes oakley sunglasses bottega veneta hollister outlet nfl jerseys mont blanc pens nike shox nike free swarovski jewelry polo outlet cheap oakley sunglasses longchamp handbags mac cosmetics supreme coach outlet online cheap nfl jerseys adidas football boots asics timberland boots yeezy shoes hermes uk timberland boots louis vuitton dior handbags air jordan nike shoes bvlgari rings birkenstock cheap nhl jerseys michael kors handbags air max 2018 ray ban sunglasses michael kors handbags ray ban nike outlet store tod's shoes flip flops ralph lauren nhl jerseys tory burch outlet nike tn toms outlet online mishka clothing alexander mcqueen shoes breitling watches coach handbags jordans balenciaga shoes ralph lauren balenciaga sandals coach factory outlet online rolex watches michael kors ferragamo outlet ray ban louboutin michael kors handbags outlet louis vuitton mbt shoes adidas uk pandora uk louis vuitton handbags true religion jeans gucci slides jordan 1 nike air max coach factory online vibram five fingers breguet watches michael kors outlet clearance air max 97 nike roshe prada handbags baseball jerseys adidas superstar hermes balenciaga shoes vans shoes oakley sunglasses polo outlet louis vuitton adidas shoes jimmy choo shoes vans shoes ray ban nike blazer flops cheap ray bans true religion jeans true religion tory burch adidas nmd supreme polo outlet miu miu shoes air jordan cheap replica watches pandora outlet gucci outlet michael kors taschen dolce and gabbana nike kyrie 3 beats by dre mizuno running shoes michael kors uk mlb jerseys longchamp soccer jerseys adidas yeezy nike air huarache louis vuitton outlet michael kors handbags jordan shoes nike air pandora charms coach outlet online polo ralph lauren timberland outlet kate spade cheap rolex watches adidas nmd carnival shoes michael kors outlet adidas outlet swarovski crystal adidas outlet store burberry scarf kate spade outlet pandora charms louis vuitton outlet jordans manchester united jersey harden vol 1 fitflops coach kate spade y3 shoes asics running shoes coach factory outlet online polo ralph lauren outlet mcm bags longchamp nike flip-flops kevin durant shoes adidas stan smith shoes oakley canada fila sneakers louis vuitton jordan pas cher air max 1 michael kors outlet blackhawks jersey ralph lauren uk louboutin christian louboutin outlet christian louboutin christian louboutin shoes christian louboutin outlet coach outlet coach outlet online michael kors outlet store kobe 12 nfl jerseys wholesale tory burch tory burch bags prada bags prada handbags columbia sportswear 20185.15chenjinyan 
wqwq
wqwq Aug 30 '18

.C. longchamp -- raiders nfl jersey Rodney swarovski crystal Hood connected from all over jordan jerseys the jimmy choo outlet court jazz jersey while freshman Jabari Parker was busy swatting shots and north face scoring nike in transition. MANHATTAN, asics gel Kan. swarovski canada -- Bill Snyder has always polo ralph lauren outlet online valued continuity, whether belstaff sale on northface the coaching staff air max 90 or marc jacobs in nike air yeezy the huddle.Its pandora why four of his assistants, including co-offensive nike coordinators prada sunglasses Dana redskins nfl jersey Dimel and michael kors outlet Del Miller, have converse spent at least 18 years at free run Kansas State. ralph lauren And why mizuno running relative youngsters thomas sabo on discount shoes the staff, ray ban wayfarer such as Andre cheap jerseys Coleman and Blake Seiler, played for burberry sale the Wildcats before joining ray ban outlet the profession.Its always significant, Snyder said, to have ralph lauren online that kind of continuity michael kors handbags where nike free run you dont have to go through swarovski online the re-teaching jimmy choo shoes or swarovski jewelry changing cheap mlb jerseys of things chaussure timberland you firmly believe in, not that pacers jersey were not open polo ralph lauren to change. juicy couture outlet We burberry sale certainly oakley sunglasses outlet are. oakley canada I love kevin durant jersey to entertain soccer shoes new cheap nhl jerseys thoughts, new tory burch handbags ideas. nfl jerseys ... Sac Hermes But burberry handbags you hear some players iphone 5 cases get up and say, nike air huarache `Well, Ive jets nfl jersey gone occhiali ray ban through four coordinators in four cheap michael kors years, and timberwolves jersey thats kind hermes birkin bag of tumultuous.We have been fortunate not to michael kors taschen have lions nfl jersey to go through that over fred perry uk the burberry handbags outlet last mcm handbags outlet quarter of louboutin outlet a decade.In nba jersey truth, things have been fairly consistent at Kansas true religion State new balance outlet for much max shoes longer, giants nfl jersey and replica rolex Snyder michael kors bags is nike air max the levi's jeans reason for much of north face backpacks it. occhiali oakley Sure, there was his brief christian louboutin shoes retirement converse about a decade ago, but when he returned seahawks nfl jersey to boston celtics the corner office michael kors purses in 49ers nfl jersey the Vanier Football Complex, it true religion outlet was michael kors bags as if nothing had changed.It polo ralph lauren outlet took two years jordans to get back kings jersey to designer handbags a bowl air max game. Now, grizzlies jersey the Wildcats have been to jack wolfskin outlet six ralph lauren polo straight.But as the 76-year-old fossil uhren Snyder ferragamo shoes enters converse sneakers his jordans 26th season, there are growing coach outlet sale rumblings tory burch outlet that it may be his last. He dsquared2 jeans needs burberry seven ray ban outlet wins to reach 200 for his career, hogan a significant nfl jerseys milestone, and the talent returning from coach store an injury-plagued michael kors outlet 2015 season tommy hilfiger means Kansas State cheap nike shoes could air max compete for air max another burberry sale Big 12 babyliss pro title.Perhaps such oakley success would make dolphins nfl jersey it aktienkurse adidas the ralph lauren right time.The nike outlet good nike.com thing about oakley vault Coach Snyder oakley sunglasses is hes new balance canada real consistent. Theres not a lot tn pas cher of long champ surprises, titans nfl jersey said quarterback five finger shoes Jesse Ertz. uggs outlet Its cheap oakley sunglasses the same burberry thing, the coach bags same motto, mont blanc the same work habits. Everything nike Air Max Plaza is, `Work bcbg max hard omega and tods outlet online get better swarovski jewelry each day. cheap oakley I think cavaliers jerseys its rams nfl jersey proven kate spade outlet online with nike canada how our teams usually ray-ban sunglasses do.As the texans nfl jersey Wildcats start another season with Snyder on the sideline, ferragamo shoes here are moncler jackets outlet story lines nba jerseys to nike air max watch:SEASON OPENER: Lambasted cheap jordans for years for scheduling chi hair soft in the new balance non-conference, thee bcbg max azria Wildcats buccaneers nfl jersey will visit ralph lauren outlet online Stanford on michael kors Sept..C. -- Rodney Hood connected from all denver nuggets jersey over nike the court nike roshe while philipp plein clothing freshman versace shoes outlet Jabari Parker was coach sacs busy baseball bats swatting bottega veneta shots timberland boots and scoring in transition. MANHATTAN, cheap true religion Kan. -- Bill Snyder asics shoes outlet has always swarovski valued red bottoms continuity, whether on the coaching staff or in longchamp handbags the oakley vault huddle.Its coach handbags why four of supra footwear his giuseppe shoes assistants, air max one including co-offensive coordinators Dana Dimel burberry outlet online and michael kors handbags Del michael kors canada Miller, givenchy handbags have spent at least coach outlet 18 horloges years at Kansas State. And why relative youngsters kobe bryant shoes on the nike free run 5.0 staff, such barbour outlet online as Andre Coleman and Blake hermes Seiler, played versace clothes for the belstaff jackets Wildcats before joining the profession.Its ralph lauren uk always significant, Snyder said, cheap jerseys to have that adidas outlet kind nike huaraches of dsquared2 outlet continuity christian louboutin where pandora jewelry you hugo boss clothes dont moncler jackets have to go through adidas the re-teaching or changing of things you nike firmly believe colts nfl jersey in, air jordan shoes not that were not open to change. We certainly are. nike I love to barbour jackets entertain new thoughts, new ideas. mcm bags ... But patriots nfl jersey you timberland shoes hear some falcons nfl jersey players get up prada and say, ipad mini cases `Well, Ive dwyane wade jersey gone ed hardy through four coordinators in four cheap nba jerseys years, phoenix suns and ralph lauren thats kind of polo ralph lauren tumultuous.We have been fortunate chrome hearts store not to michael kors have to go through that over skechers the under armour shoes outlet last ralph lauren outlet online quarter of a decade.In truth, things jaguars nfl jersey have been fairly consistent at basketball shoes Kansas State for much longer, nike shoes and uggs on sale Snyder plein outlet is the reason broncos nfl jersey for much of it. Sure, michael kors purses there was montblanc his nike air huarache brief retirement about a tommy hilfiger decade ago, but when beats by dr dre he parajumpers mens jackets returned to the corner office in steelers nfl jersey the katespade Vanier nike air max 2014 Football michael kors handbags Complex, it was as if nothing had vikings nfl jersey changed.It took two coach factory online years to get back to a bowl burberry outlet store game. Now, the coach outlet online Wildcats have knicks jersey been to six straight.But as the nba jerseys 76-year-old Snyder enters ralph lauren polos his 26th timberland outlet season, there charlotte hornets jerseys are jack wolfskin jackets growing stephen curry shoes rumblings ralph lauren outlet that it may be his adidas canada last. He fendi bags needs bucks jersey seven wins to mcm handbags reach 200 for coach factory outlet online his coach store outlet career, a significant milestone, and the adidas talent returning trail blazers jersey from an injury-plagued ralph lauren factory store 2015 season means Kansas State could compete for another Big brooklyn nets jersey 12 cheap ray ban title.Perhaps such calvin klein underwear success ray ban sunglasses outlet would make it the air max right time.The good raptors jersey thing about Coach Snyder is hes mcm bags real barbour jackets consistent. Theres not a lot of surprises, san antonio spurs jersey said quarterback Jesse north face Ertz. Its the ray ban sunglasses outlet same thing, the same motto, the ray bans same pandora charms work habits. Everything is, ray ban `Work ralph lauren outlet hard and get chargers nfl jersey better air jordans each day. I ray ban outlet online think its panthers nfl jersey proven with how cheap nhl jerseys our teams usually do.As fitflop outlet the Wildcats start wizards jersey another ray ban sonnenbrillen season with Snyder on salvatore ferragamo the hogan outlet sideline, cheap oakley sunglasses here are story salvatore ferragamo lines to watch:SEASON OPENER: Lambasted roshe runs for longchamp outlet years for scheduling cowboys nfl jersey soft in the air force non-conference, thee christian louboutin shoes Wildcats will visit azcardinals nfl jersey Stanford nike free on Sept..C. -- Rodney north face jackets Hood hilfiger outlet connected from lunette ray ban all over the court while freshman Jabari Parker was busy swatting shots and true religion jeans women scoring in transition. longchamp MANHATTAN, Kan. packers nfl jersey -- Bill guess outlet online Snyder bears nfl jersey has always belstaff jackets outlet valued continuity, whether on pandora schmuck the coaching staff red bottom shoes or louboutin in the huddle.Its why lacoste outlet four tory burch handbags of his assistants, including co-offensive coordinators jordan Dana Dimel michael kors and Del prada shoes Miller, pandora jewelry have spent puma online at chiefs nfl jersey least 18 tory burch shoes years at nike mercurial Kansas lacoste outlet online State. michael kors outlet And why relative youngsters nike air max on mbt mens shoes the staff, veneta such as Andre Coleman guciheaven women shoes and cheap mlb jerseys Blake Seiler, played converse shoes for the Wildcats before joining the adidas outlet profession.Its always significant, Snyder prada handbags said, to have eyeglasses stores that skechers shoes outlet kind reebok shoes outlet of continuity coach outlet usa where cheap jerseys you dont have to nike air max 2014 go through the hermes bags re-teaching or changing of things you oakley sunglasses firmly believe links of london watches in, not that were the north face outlet not ray ban open to the north face change. We certainly are. I love ray ban to huarache entertain new thoughts, new ideas. katespade ... But nike roche run you supra shoes hear some stone island outlet players ralph lauren polos get kate spade outlet online up and say, `Well, Ive thomas sabo gone nike outlet through armani shoes outlet four mcm handbags coordinators hilfiger online shop in michael kors four bills nfl jersey years, oakley sunglasses outlet and thats kind of lunette oakley tumultuous.We philadelphia 76ers jerseys have been michael kors fortunate not to have to go through that over the last quarter of eagles nfl jersey a decade.In truth, things have oakley sunglasses been ray ban fairly under armour consistent saints nfl jersey at Kansas cheap true religion State for coach purses factory much vans longer, and Snyder is the thomas sabo charms reason atlanta hawks jersey for mizuno wave much of it. Sure, there was his salomon brief retirement about a decade ago, knockoff handbags but when vans shoes outlet he barbour jackets returned to the corner office pandora in the Vanier tommy hilfiger Football Complex, burberry sale it was as north face outlet if nothing prada outlet had changed.It michael kors handbags took two nba jersey years tommy hilfiger to get back to ralph lauren a bowl game. Now, north face the ralph lauren outlet online Wildcats have burberry handbags been to ecco outlet online six true religion jeans men straight.But fred perry outlet as the asics 76-year-old Snyder clippers jersey enters his indoor soccer shoes 26th beats by dr dre season, marc jacobs there are jerseys from china growing new balance rumblings that it may dansko outlet be adidas his beats audio last. He needs kobe bryant jerseys seven cheap glasses wins to michael kors uk reach vans shoes 200 for new balance shoes his career, cheap barbour jackets a significant milestone, and coach outlet online the talent returning browns nfl jersey from an injury-plagued 2015 season means michael kors Kansas michael kors outlet State could coach store online compete for bengals nfl jersey another ralph lauren online shop Big oakley 12 title.Perhaps such success would make guess clothings outlet it the right time.The air max 2015 good thing roshe about Coach Snyder coach handbags outlet is hes real reebok consistent. Theres not woolrich mens jackets a fidget spinner lot giuseppe zanotti sneakers of surprises, said quarterback Jesse nike air force Ertz. Its burberry outlet the same hogan women shoes thing, the c.c beanies same motto, adidas online the same work habits. golden state warriors jerseys Everything puma sneakers is, `Work hard and get better new orleans pelicans each nike mercurial day. I think orlando magic jersey its polo ralph proven handbags outlet with rockets jersey how cheap oakley sunglasses our teams usually do.As the skechers mens shoes Wildcats start another season louboutin outlet with omega watches Snyder dallas mavericks jerseys on the ravens nfl jersey sideline, here are story lines to roshe run watch:SEASON OPENER: vans Lambasted for years hilfiger outlet for scheduling soft coach outlet canada in ferragamo the non-conference, air jordan retro thee juicy couture Wildcats nike roshe will michael kors purses visit Stanford on Sept.