Need Help

[arun_kumar75]

Hello Gurus,

I need to know the relations and functionality between

NBEW (IS-H: Movements for Case),

NFAL (IS-H: Cases) and

NDOC (IS-H: Assignment of IS-H Objects to Documents in DMS) tables.

We are making a report in BI, there we want to know patient/case/movements details , So i like to know whether NDOC table information is enough to serve the other two table information like NBEW and NFAL.

Your ideas would be highly appreciated.

Thanks and regards

Arun S

[aracelychavez · Accepted solution]

Hola,

I am not a guru, I've worked with detail patient reports require by ish users but I haven't use

table NDOC.. I can get all the information with:

NPAT (ISH-H: Patient) NPAT-PATNR

NFAL (IS-H: Cases) NFAL-PATNR = NFAL-PATNR

NBEW (IS-H: Movements ), NBEW-FALNR = NFAL-FALNR and if I want to know services:

NLEI (ISH-H: Services) NLEI-LFDBEW = NBEW-LDFNR

And with Episode and movement number I can get:

NFPZ : Relation between doctors and movs

NGPA : Persons. NGPA-GPART = NFPZ-PERNR

NICP: Procedures

NDIA: Diagnostics ...

Also, there a view with informatión from npat, nfal and nbew: V_NBEW.

Hope it helps.

[Former Member]

Hi Arun,

I'm trying to help you:

Global patient information you can find in NPAT (not listed in your post). For every patient case that is created one entry in NFAL is inserted (1:n). Key is the field PATID. And for each movement of a patient case one entry in NBEW is inserted (1:n). Key is the field FALNR.

In table NDOC you can find all administration information of documents which can be related to a patient, a case or a movement. So the information in NDOC concerning NFAL and NBEW is not allways the same because not every NDOC data set has information about the patient case or a movement.

But if you want to display information about docs and where they are related to it may be enough.

Hope I can help you.

Regards

Christopher

[arun_kumar75]

Thanks a lot.

[arun_kumar75]

thanks a lot