Fileman Files attributes

[Bassant Hesham]

I want to know more about fileman, it's files structure and attributes names, Is there any documentation for this ?

[Infant Livingston]

Hi,

Can you please refer this,

http://www.hardhats.org/fileman/u1/index.html

http://code.osehra.org/dox/filemanfiles.html

Thanks,

Livi

On Mon, Oct 24, 2016 at 7:03 PM, Bassant Hesham <bassant...@medstreaming.com> wrote:

I want to know more about fileman, it's files structure and attributes names, Is there any documentation for this ?

--
--
http://groups.google.com/group/Hardhats
To unsubscribe, send email to Hardhats+unsubscribe@googlegroups.com

---
You received this message because you are subscribed to the Google Groups "Hardhats" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hardhats+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Sam Habiel]

If you want to know Fileman internals, this is the page you need to read:

http://www.hardhats.org/fileman/pm/gfs_frm.htm

--Sam

On Mon, Oct 24, 2016 at 6:35 AM, Infant Livingston <inf...@gmail.com> wrote:
> Hi,
>
> Can you please refer this,
>
> http://www.hardhats.org/fileman/u1/index.html
>
> http://code.osehra.org/dox/filemanfiles.html
>
> Thanks,
> Livi
>
> On Mon, Oct 24, 2016 at 7:03 PM, Bassant Hesham
> <bassant...@medstreaming.com> wrote:
>>
>> I want to know more about fileman, it's files structure and attributes
>> names, Is there any documentation for this ?
>>
>> --
>> --
>> http://groups.google.com/group/Hardhats

>> To unsubscribe, send email to Hardhats+u...@googlegroups.com

>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "Hardhats" group.
>> To unsubscribe from this group and stop receiving emails from it, send an

>> email to hardhats+u...@googlegroups.com.

>> For more options, visit https://groups.google.com/d/optout.
>
>

> --
> --
> http://groups.google.com/group/Hardhats
> To unsubscribe, send email to Hardhats+u...@googlegroups.com

>
> ---
> You received this message because you are subscribed to the Google Groups
> "Hardhats" group.
> To unsubscribe from this group and stop receiving emails from it, send an

> email to hardhats+u...@googlegroups.com.

[Bassant Hesham]

I need ti study the relationship between the files for ex. If the patient have allergies where these allergies are stored and how they are attached to a specific  patient 

and didn't reach to this point in the above links 

[David Whitten]

Rather than get involved in the internals of FileMan,

why not just use some of the tools that George Timson has

already written?


Select DATA DICTIONARY UTILITY OPTION:

The MAP POINTER RELATIONS menu option gives you the ties between

various files.

Or you could just ask about the particular relationship you are interested in.  In this case, the allergy information is all in the 120.8 thru 120.9 File number range:
   120.8        PATIENT ALLERGIES         (4945 entries)
   120.82        GMR ALLERGIES            (110 entries)
   120.83        SIGN/SYMPTOMS            (152 entries)
   120.84        GMR ALLERGY SITE PARAMETERS  (1 entry)
   120.85        ADVERSE REACTION REPORTING  (150 entries)
   120.86        ADVERSE REACTION ASSESSMENT  (2721 entries)
   120.87        GMRA DOCUMENT            (1 entry)

and MAP POINTER RELATIONS gives this bit of useful info:

Prints a graph of pointer relations in a database of FileMan files named in the Kernel PACKAGE file (9.4) or given separately. Works best with 132 column output!


I have created a page on http://www.vistapedia.com/index.php/MAP_POINTER_RELATIONS_2_TO_120.8

Best Wishes,

David Whitten
713-870-3834

--
--
http://groups.google.com/group/Hardhats
To unsubscribe, send email to Hardhats+unsubscribe@googlegroups.com

---
You received this message because you are subscribed to the Google Groups "Hardhats" group.

To unsubscribe from this group and stop receiving emails from it, send an email to hardhats+unsubscribe@googlegroups.com.

[Bassant Hesham]

thanks all 

I begin to understand the how to work with fileman schema and read the data 

Now, I want to know the Patient Medication file name bec. I didn't reach to it 

On Monday, October 24, 2016 at 3:33:56 PM UTC+2, Bassant Hesham wrote:

[Nancy Anthracite]

50 DRUG (1790 entries)

50.073 DUE QUESTIONNAIRE (0 entries)

50.0731 DUE ANSWER SHEET (0 entries)

50.0732 DUE QUESTION (0 entries)

50.0733 DUE SECTION (0 entries)

50.2 IV CATEGORY (0 entries)

50.3 PRIMARY DRUG (0 entries)

50.35 DRUG APPLICATION (7 entries)

50.4 DRUG ELECTROLYTES (5 entries)

50.416 DRUG INGREDIENTS (4998 entries)

50.6 VA GENERIC (5041 entries)

50.605 VA DRUG CLASS (579 entries)

50.606 DOSAGE FORM (316 entries)

50.607 DRUG UNITS (368 entries)

50.608 PACKAGE TYPE (529 entries)

50.609 PACKAGE SIZE (5240 entries)

50.612 NATIONAL DRUG TRANSLATION (20 entries)

50.621 PMI-ENGLISH (0 entries)

50.622 PMI-SPANISH (0 entries)

50.623 PMI MAP-ENGLISH (0 entries)

50.624 PMI MAP-SPANISH (0 entries)

50.625 WARNING LABEL-ENGLISH (0 entries)

50.626 WARNING LABEL-SPANISH (0 entries)

50.627 WARNING LABEL MAP (0 entries)

50.64 VA DISPENSE UNIT (64 entries)

50.67 NDC/UPN (223372 entries)

50.68 VA PRODUCT (26326 entries)

50.7 PHARMACY ORDERABLE ITEM (1109 entries)

50.8 IV STATS (0 entries)

50.9 DRUG COST (0 entries)

51 MEDICATION INSTRUCTION (0 entries)

51.1 ADMINISTRATION SCHEDULE (24 entries)

51.15 ADMINISTRATION SHIFT (0 entries)

51.2 MEDICATION ROUTES (240 entries)

51.23 STANDARD MEDICATION ROUTES (51 entries)

51.24 DOSE UNITS (53 entries)

51.5 ORDER UNIT (33 entries)

51.7 DRUG TEXT (123 entries)

52 PRESCRIPTION (12 entries)

52.11 PATIENT NOTIFICATION (Rx READY) (0 entries)

52.4 RX VERIFY (0 entries)

52.41 PENDING OUTPATIENT ORDERS (13 entries)

52.43 PRESCRIPTION REFILL REQUEST (0 entries)

52.5 RX SUSPENSE (0 entries)

52.51 PHARMACY EXTERNAL INTERFACE (0 entries)

52.52 CLOZAPINE PRESCRIPTION OVERRIDES (0 entries)

52.53 PHARMACY AUTOMATED DISPENSING DEVICES (0 entries)

52.6 IV ADDITIVES (137 entries)

52.7 IV SOLUTIONS (35 entries)

52.8 PHARMACY ARCHIVE (0 entries)

52.85 EPHARMACY MEDICATION PROFILE PREFERENCES

(0 entries)

52.86 EPHARMACY SITE PARAMETERS (0 entries)

52.87 PSO AUDIT LOG (0 entries)

52.9 PHARMACY PRINTED QUEUE (1 entry)

52.91 TPB ELIGIBILITY (0 entries)

52.92 TPB INSTITUTION LETTERS (0 entries)

53 RX PATIENT STATUS (15 entries)

53.1 NON-VERIFIED ORDERS (0 entries)

53.2 UNIT DOSE ORDER SET (0 entries)

53.3 ACTIVITY LOG REASON (90 entries)

53.4 PRE-EXCHANGE NEEDS (0 entries)

53.41 MAR LABELS (0 entries)

53.42 INPATIENT BACKGROUND JOB (0 entries)

53.43 MISCELLANEOUS REPORT FILE (0 entries)

53.44 PHYSICIANS' ORDERS (0 entries)

53.45 INPATIENT USER PARAMETERS (0 entries)

53.46 CLINIC DEFINITION (0 entries)

53.47 INFUSION INSTRUCTIONS (0 entries)

53.5 PICK LIST (0 entries)

53.55 UNIT DOSE/ATC MEDS (0 entries)

53.66 BCMA IV PARAMETERS (0 entries)

53.68 BCMA MISSING DOSE REQUEST (0 entries)

53.69 BCMA REPORT REQUEST (928 entries)

53.7 BCMA BACKUP DATA (0 entries)

53.71 BCMA BACKUP PARAMETERS (1 entry)

53.77 BCMA UNABLE TO SCAN LOG (0 entries)

53.78 BCMA MEDICATION VARIANCE LOG (0 entries)

53.79 BCMA MEDICATION LOG (0 entries)

54 RX CONSULT (20 entries)

55 PHARMACY PATIENT (3 entries)

55.95 DRUG MANUFACTURER (4693 entries)

56 DRUG INTERACTION (16573 entries)

57.1 PHARMACY QUICK ORDER (0 entries)

57.5 WARD GROUP (0 entries)

57.6 UNIT DOSE PICK LIST STATS (0 entries)

57.7 MEDICATION ADMINISTERING TEAM (0 entries)

57.8 CLINIC GROUP (0 entries)

58.1 PHARMACY AOU STOCK (0 entries)

58.16 AOU INVENTORY TYPE (0 entries)

58.17 AOU ITEM LOCATION (0 entries)

58.19 PHARMACY AOU INVENTORY (0 entries)

58.2 AOU INVENTORY GROUP (0 entries)

58.3 PHARMACY BACKORDER (0 entries)

58.35 RETURN DRUG (0 entries)

58.36 RETURN DRUG CONTRACTOR (0 entries)

58.4 SPMP ASAP RECORD DEFINITION (1 entry)

58.41 SPMP STATE PARAMETERS (0 entries)

58.42 SPMP EXPORT BATCH (0 entries)

58.5 AR/WS STATS FILE (0 entries)

58.8 DRUG ACCOUNTABILITY STATS (1 entry)

58.81 DRUG ACCOUNTABILITY TRANSACTION (0 entries)

58.811 DRUG ACCOUNTABILITY ORDER (0 entries)

58.812 DA UPLOAD (1 entry)

58.82 CS ORDER STATUS (14 entries)

58.83 CS COMPLETION STATUS (6 entries)

58.84 DRUG ACCOUNTABILITY TRANSACTION TYPE (24 entries)

58.85 CS WORKSHEET (0 entries)

58.86 CS DESTRUCTION (0 entries)

58.87 CS CORRECTION LOG (0 entries)

58.88 CS IRL PROGRAM (1 entry)

58.89 CS ERROR LOG (0 entries)

59 OUTPATIENT SITE (1 entry)

59.1 OUTPATIENT AMIS DATA (0 entries)

59.12 OUTPATIENT PHARMACY MANAGEMENT DATA (0 entries)

59.2 WAITING TIME (0 entries)

59.3 GROUP DISPLAY (0 entries)

59.4 INPATIENT SITE (0 entries)

59.5 IV ROOM (0 entries)

59.6 INPATIENT WARD PARAMETERS (0 entries)

59.7 PHARMACY SYSTEM (1 entry)

59.73 VENDOR DISABLE/ENABLE (0 entries)

59.74 VENDOR INTERFACE DATA (0 entries)

59.8 OUTPATIENT CLINIC SORT GROUP (0 entries)

59.9 PBM PATIENT DEMOGRAPHICS (2 entries)

 

 

--

Nancy Anthracite

--
--
http://groups.google.com/group/Hardhats
To unsubscribe, send email to Hardhats+u...@googlegroups.com

---
You received this message because you are subscribed to the Google Groups "Hardhats" group.

To unsubscribe from this group and stop receiving emails from it, send an email to hardhats+u...@googlegroups.com.

[Bassant Hesham]

Can  I know how do you make this search ? 

what about the Problems file in which I can read all problems stored in the Vista

To unsubscribe from this group and stop receiving emails from it, send an email to hardhats+unsubscribe@googlegroups.com.

[Nancy Anthracite]

An easy way to do it is to pick something, and then put a ? And if at the ? you know what number you want to start on, you can put an ^ followed by the number. In this case, I knew the drug file was 50, so I started there. Lab begins with 60 for instance. Big sections of VistA tend to be confined to one number listing, like all lab in 60 and all drug and pharmacy in 50, etc. If you choose a full lising at the ? point, you will get the idea.

 

File 1 is the file of files, so that has information about all of the files and sub files, but you can find the same thing at inquire or enter like shown below. It gives you the same listing as you get at the ? using File 1.

 

 

 

GTM>D P^DI

 

 

VA FileMan 22.0

 

 

Select OPTION: 1 ENTER OR EDIT FILE ENTRIES

NPUT TO WHAT FILE: LAB// ?

Answer with FILE NUMBER, or NAME

Do you want the entire FILE List? ^50

Choose from:

50 DRUG (1790 entries)

50.073 DUE QUESTIONNAIRE (0 entries)

 

**********

As for your Problem Problem, I tried this to track it down. There were two files called PROBLEM, I think you want the second.

 

If you want all of the possible problems you can choose from, then you are talking looking at SNOMED, ICD10, and for old problems, ICD9.

 

*********

GTM>D P^DI

 

 

VA FileMan 22.0

 

 

Select OPTION: 8 DATA DICTIONARY UTILITIES

Select DATA DICTIONARY UTILITY OPTION: 1 LIST FILE ATTRIBUTES

START WITH WHAT FILE: PROBLEM// PROBLEM

1 PROBLEM (29 entries)

2 PROBLEM (12 entries)

3 PROBLEM LIST AUDIT (0 entries)

4 PROBLEM LIST SITE PARAMETERS (1 entry)

5 PROBLEM SELECTION CATEGORY (0 entries)

Press <RETURN> to see more, '^' to exit this list, OR

CHOOSE 1-5: 1 PROBLEM (29 entries)

GO TO WHAT FILE: PROBLEM//

Select LISTING FORMAT: STANDARD// GLOBAL MAP

DEVICE: ;;999 TELNET

GLOBAL MAP DATA DICTIONARY #620 -- PROBLEM FILE NOV 6,2016@08:19:01 PAGE 1

STORED IN ^DIC(620, (29 ENTRIES) SITE: Vista-Office EHR UCI: EHR,EHR (VERSI

ON 5.01)

-------------------------------------------------------------------------------

File stores the 29 clinical problems developed for use by the Mental Health

System.

Exported with data.

 

 

CROSS

REFERENCED BY: PROBLEM(B), PROBLEM(C), UPPER(D)

 

 

 

^DIC(620,D0,0)= (#.01) PROBLEM [1F] ^ (#1) SCREEN [2F] ^

^DIC(620,D0,1)= (#2) UPPER [1F] ^

 

 

INPUT TEMPLATE(S):

 

PRINT TEMPLATE(S):

 

SORT TEMPLATE(S):

 

FORM(S)/BLOCK(S):^

 

 

Select DATA DICTIONARY UTILITY OPTION: 1 LIST FILE ATTRIBUTES

START WITH WHAT FILE: PROBLEM// PROBLEM

1 PROBLEM (29 entries)

2 PROBLEM (12 entries)

3 PROBLEM LIST AUDIT (0 entries)

4 PROBLEM LIST SITE PARAMETERS (1 entry)

5 PROBLEM SELECTION CATEGORY (0 entries)

Press <RETURN> to see more, '^' to exit this list, OR

CHOOSE 1-5: 2 PROBLEM (12 entries)

GO TO WHAT FILE: PROBLEM//

Select SUB-FILE:

Select LISTING FORMAT: STANDARD//

Start with field: FIRST//

DEVICE: ;;999 TELNET

STANDARD DATA DICTIONARY #9000011 -- PROBLEM FILE

NOV 6,2016@08:19:36 PAGE 1

STORED IN ^AUPNPROB( (12 ENTRIES) SITE: Vista-Office EHR UCI: EHR,EHR (VERS

ION 2.0)

 

DATA NAME GLOBAL DATA

ELEMENT TITLE LOCATION TYPE

-------------------------------------------------------------------------------

This file contains patient specific problems entered by the various providers

of service. The PATIENT NAME field (.02) is a backward pointer to the IHS

PATIENT file. This file contains one record for each problem for each patient,

therefore, the KEY field (.01) is duplicated.

As of March 17, 1986 the FACILITY must be entered prior to the NUMBER. If the

NUMBER is entered without previously entering the FACILITY the "AA" index is

created with no FACILITY pointer.

**********

 

Select OPTION: 5 INQUIRE TO FILE ENTRIES

 

 

 

OUTPUT FROM WHAT FILE: TIU PROBLEM LINK// 9000011 PROBLEM

(12 entries)

Select PROBLEM DIAGNOSIS: ?

Answer with PROBLEM, or DIAGNOSIS, or DATE LAST MODIFIED, or

DATE ENTERED

Do you want the entire 12-Entry PROBLEM List? Y (Yes)

Choose from:

300.4 ZZ PATIENT,TEST THREE VOE OFFICE INSTITUTION 3 ICD-9

300.4 DYSTHYMIC DISORDER (Inactive 10/01/2015)

428.9 ZZ PATIENT,TEST ONE VOE OFFICE INSTITUTION 6 ICD-9 42

8.9 HEART FAILURE NOS (Inactive 10/01/2015)

648.02 ZZ PATIENT,TEST ONE VOE OFFICE INSTITUTION 4 ICD-9 6

48.02 DIABETES-DELIVERED W P/P (Major C/C) (Inactive 10/01/2015)

 

//etc.

 

 

 

 

--

Nancy Anthracite

To unsubscribe from this group and stop receiving emails from it, send an email to hardhats+u...@googlegroups.com.

[Steven McPhelan]

Medications are stored in files 52 and 55.

Steve

That you may retain your self-respect, it is better to displease the people by doing what you know is right, than to temporarily please them by doing what you know is wrong. - William JH Boetchker

[Bassant Hesham]

What is the SNOMED ?

To unsubscribe from this group and stop receiving emails from it, send an email to hardhats+unsubscribe@googlegroups.com.

[Bassant Hesham]

thanks, I found in the Prescription file but any can you help me in understand what are the records in this array means or if there are any documentation for this ?

this is first index un the array for example :

 

^PSRX(1,0)=2^3^15^9^2^597^600^90^3^^W^^3050719^^^9^1.970^1^1

^PSRX(1,2)=3050719.112055^3050719^^^3050719^3060720^0054-3010-63^^1

^PSRX(1,3)=3050719^3051007

^PSRX(1,6,0)=^52.0113^1^1

^PSRX(1,6,1,0)=2 TABS^^^^^^1^Q3H^TAKE

^PSRX(1,"A",0)=^52.3DA^3^3

^PSRX(1,"A",1,0)=3050719^G^^0^Patient Instructions Not Sent By Provider.

^PSRX(1,"A",2,0)=3050719.112144^G^9^0^Prescription 2 printed.

^PSRX(1,"A",3,0)=3061225.163621^D^1^0^RX DELETED on 12-25-06

^PSRX(1,"D")=Per Pharmacy Request

^PSRX(1,"OR1")=8^26^^^9

^PSRX(1,"PC")=0

^PSRX(1,"PI",0)=^^1^1^3050719^

^PSRX(1,"PI",1,0)=TAKE 2 TABS PO Q3H

^PSRX(1,"POE")=1

^PSRX(1,"SIG")=^1

^PSRX(1,"SIG1",0)=^52.04A^1^1

^PSRX(1,"SIG1",1,0)=TAKE 2 TABS BY MOUTH EVERY 3 HOURS

^PSRX(1,"STA")=13

^PSRX(1,"TYPE")=0

[Nancy Anthracite]

https://en.wikipedia.org/wiki/SNOMED_CT

 

In CPRS, when you are asked to choose a problem, there should be a drop down list to choose from. You may have to install some more software before it will work as the Lexicon is packaged with licensed products and thus not released in a complete state. If you want to find out more about that, contact me personally.

 

--

Nancy Anthracite

To unsubscribe from this group and stop receiving emails from it, send an email to hardhats+u...@googlegroups.com.

[Nancy Anthracite]

Have you looked at the data dictionary?

 

GTM>S DUZ=1 D ^XUP

 

Setting up programmer environment

This is a TEST account.

 

Terminal Type set to: C-VT100

 

You have 1714 new messages.

Select OPTION NAME:

GTM>D P^DI

 

 

VA FileMan 22.0

 

 

Select OPTION: 8 DATA DICTIONARY UTILITIES

Select DATA DICTIONARY UTILITY OPTION: 1 LIST FILE ATTRIBUTES

START WITH WHAT FILE: PATIENT// PRESCRIPTION

1 PRESCRIPTION (12 entries)

2 PRESCRIPTION EXTRACT (0 entries)

3 PRESCRIPTION REFILL REQUEST (0 entries)

CHOOSE 1-3: 1 PRESCRIPTION (12 entries)

GO TO WHAT FILE: PRESCRIPTION//

Select SUB-FILE:

Select LISTING FORMAT: STANDARD//

Start with field: FIRST//

DEVICE: ;;9999

 

 

--

Nancy Anthracite

[Kevin Toppenberg]

https://en.wikipedia.org/wiki/Systematized_Nomenclature_of_Medicine

Kevin