There is a table called ACCOUNT, which has information on all accounts (patients) in the system. ACCOUNT_ID, the primary key, is also present in PAT_ENC, the patient_encounter table.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Connolly Sent: Thursday, July 03, 2014 12:09 PM To: [email protected] Subject: RE: [gpc-informatics] #139: insurance status I don't know how to get insurance status from clinic data at KU. Do any other sites have this data? Which part of the clinical workflow do you get it from? Is it stored in Epic? If so, where? If not, where? -- Dan ________________________________________ From: GPC Informatics [[email protected]] Sent: Thursday, July 03, 2014 11:12 AM To: Dan Connolly Cc: Russ Waitman; [email protected] Subject: [gpc-informatics] #139: insurance status #139: insurance status --------------------------+---------------------------- Reporter: dconnolly | Owner: dconnolly Type: enhancement | Status: new Priority: major | Milestone: Component: data-stds | Keywords: obesity-cohort Blocked By: | Blocking: 33 --------------------------+---------------------------- This has come up in recent discussions: Dan Hale Wednesday, July 02, 2014 5:11 PM: > ... > Furthermore during this progression, does the population drift toward > middle class, insured, white, suburban, etc. ... -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/139> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev ________________________________ Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. ________________________________ _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
