11-06-2009 3:49 PM
Hi,
Would anyone be able to give me a list of IS-H tables and a general description of the table functions - like what data it stores, etc.? I am more specifically looking for information to process a) Doctor Management b) Patient Management c) Cash collection d) Doctor Fee processing.
Thanks in advance for your help.
Zubair
11-12-2009 11:43 AM
Hi Zubair
Following are some of the tables used in patient management.
NPAT Patient Master Data(general)
NPAE Patient Master Data(Institute related)
NFAL Cases
NGPA Business Partners(Referring Hospital)
NORG Organisational Units
NFPZ Assignment of a case to a person.
N1VKG Item of clinical order(Pre-registration)
NBEW Movements for Case
NADR Addresses(Central address management)
NFFZ Assignment of a case to a another case.
NGEB Birth data of new borns
NKSD Treatment certificate details
NKSK Insurance verification/certificate
NPER Persons(External physician,nurses).
Hope will help you.
03-01-2011 6:49 PM
Hello,
I reached your reply from searching for some info about visit data. I use the TNMN table to look for a patient, episode and surgery visit, then I link the visit with the NAPP to obtain the details: TNMN.TNMID = NAPP.LNRAPP, however I still cannot link the info about the surgerian which is recorded both in the tables "N1LSTEAM" and "NPLZ". I see the better way is to link with N1LSTEAM.LNRLS but I don't know what other table will have the clear reference to that field.
03-02-2011 3:07 PM
Hi Zubair
To access to table NFPZ - where the phisicians are related to cases an movements you should do the following.
Read NTMN an take the FALNR and TMNLB (Movement Number)
Then go table NFPZ where falnr = ntmn-falnr and LFDBW = ntmn-tmnlb.
Please, try with that query and let me know.
With best regards
Matías
05-09-2014 8:05 PM
12-16-2009 1:02 PM
Some additional important ones:
N1CORDER IS-H: Clinical Order
NAPP IS-H: Provisional appointments for visit planning
NBAU IS-H: Building Units
NLEI IS-H: Services Performed
NLEM IS-H*MED: Medical Service
NTMN IS-H: Patient-Specific Appointments (Header Table for NAPP)
NTPK IS-H: Header Data of Service Item
09-12-2016 5:37 PM
Hi
Can I know the list of tables in ecc for clinical trials
For related data below
Patient data
Descripancy
Study data
Site
Users
Event
Audit
Organisations