244H:VI Intermediate Fileman Digging Further

1
244HVI Intermediate Fileman - Digging Further

• Michele Krajewski
• Chief Vista Operations
• Philadelphia VAMC
• David W. Massey
• Product Support Specialist
• Clinical 3 Team, Imaging Support

2
Introduction

• VA FileMan What is it?
• Create a TeleRad Partners file
• Explore different field types
• Multiples
• Data Dictionary
• Populate file
• Templates
• Looping
• Pull data from file
• Relational jumping
• Create menu options
• References Links
• Questions?

3
Creating a File

• To create a new file, use the Modify File
  Attributes option
• File names 3 to 45 characters in length
• FileMan automatically creates the .01 field
• The .01 field should be the key attribute of an
  entry used to identify it and to order the
  entries for lookups

4
Creating Fields

• Utilize the Modify File Attributes option to
  create or change fields
• A field can only be one type of data the choices
  are listed in the following section
• For some data types, a default "HELP" prompt is
  automatically composed
• There are nine field data types

5
Field Data Types
6
TELERAD PARTNERS FILE
7
Global Data Dictionary
GLOBAL MAP DATA DICTIONARY 520206 -- TELERAD
PARTNERS FILE
STORED IN DIZ(520206, NO DATA
STORED YET -----------------------------------
--------------------------------------------------
--------------------------- CROSS REFERENCED BY
TELERAD NAME(B) DIZ(520206,D0,0) (.01)
TELERAD NAME 1F (1) SHORT DESCRIPTION 2F
(2) OPERATIONAL STATUS 3S
DIZ(520206,D0,1,0)520206.03V (3) ROUTING
TYPE DIZ(520206,D0,1,D1,0) (.01) ROUTING TYPE
1V DIZ(520206,D0,2,0)520206.04 (4)
POINT OF CONTACT DIZ(520206,D0,2,D1,0) (.01)
POINT OF CONTACT 1F (1) OFFICE PHONE 2F
DIZ(520206,D0,3,0)520206.05P (5) DICOM
SOP CLASS DIZ(520206,D0,3,D1,0) (.01) DICOM
SOP CLASS 1P2006.532 DIZ(520206,D0,4,0)52
0206.06 (6) TELERAD NOTES DIZ(520206,D0,4,D1,
0) (.01) TELERAD NOTES 1W
8
Start Hands-onLets Build a File!
Enter or Edit File Entries
Print File Entries Search File Entries
Modify File Attributes Inquire
to File Entries Utility Functions ...
Data Dictionary Utilities ...
Transfer Entries Other Options
... Select VA FileMan Option
9
Modify File Attributes
Select OPTION 4 MODIFY FILE ATTRIBUTES Do you
want to use the screen-mode version? YES//
? 'YES' will invoke the ScreenMan editor. The
same questions are asked in both screen
scrolling mode. Do you want to use the
screen-mode version? YES// NO MODIFY WHAT FILE
REMOTE PROCEDURE// TELERAD PARTNERS Are you
adding 'TELERAD PARTNERS' as a new FILE? No// Y
(Yes) FILE NUMBER 520206// (accept
recommended default) INTERNAL GLOBAL REFERENCE
DIZ(520206,// (accept recommended
default) ...EXCUSE ME, LET ME PUT YOU ON 'HOLD'
FOR A SECOND... A FreeText NAME Field (.01)
has been created.
10
Edit .01 Field TELERAD NAME
Select FIELD .01 NAME LABEL NAME// TELERAD
NAME TITLE AUDIT AUDIT CONDITION READ
ACCESS (OPTIONAL) DELETE ACCESS (OPTIONAL)
WRITE ACCESS (OPTIONAL) SOURCE Select
DESTINATION Select GROUP DESCRIPTION No
existing text Edit? NO// TECHNICAL
DESCRIPTION No existing text Edit? NO//
DATA TYPE OF TELERAD NAME FREE TEXT// ? start
edit of data type information MINIMUM LENGTH 3//
MAXIMUM LENGTH 30// (OPTIONAL) PATTERN MATCH
(IN 'X') X'?1P.E// IS TELERAD NAME ENTRY
MANDATORY (Y/N) Y// YES 'HELP'-PROMPT Answer
must be 3-30 characters in length. XECUTABLE
'HELP'
11
Adding Field Short Description
Select FIELD 1 LABEL SHORT DESCRIPTION DATA
TYPE OF SHORT DESCRIPTION POINTER TO A FILE//
FREE TEXT MINIMUM LENGTH 1 MAXIMUM LENGTH 30
IS SHORT DESCRIPTION ENTRY MANDATORY (Y/N) NO//
NO Note - If you answer YES to Entry
Mandatory, the user of your file will not be
allowed to skip the field without entering data
for a particular entry.
12
Adding Field Operational Status
Select FIELD 2 Are you adding a new FIELD (the
3RD)? No// Y (Yes) LABEL OPERATIONAL STATUS
FIELD NUMBER 2// DATA TYPE OF OPERATIONAL
STATUS SET OF CODES INTERNALLY-STORED CODE
? For Example Internal Code 'M' could stand for
'MALE' DATA TYPE OF OPERATIONAL STATUS SET OF
CODES INTERNALLY-STORED CODE 1 WILL STAND
FOR ON-LINE INTERNALLY-STORED CODE 0 WILL
STAND FOR OFF-LINE INTERNALLY-STORED CODE
SHOULD 'OPERATIONAL STATUS' ENTRIES BE SCREENED?
No// (No) WILL OPERATIONAL STATUS FIELD BE
MULTIPLE? No// (No) SUBSCRIPT 0// (accept
recommended default) -PIECE POSITION 3//
(accept recommended default) IS OPERATIONAL
STATUS ENTRY MANDATORY (Y/N) NO// NO
13
Adding Field Routing Type
Select FIELD 3 Are you adding a new FIELD (the
4TH)? No// Yes LABEL ROUTING TYPE FIELD
NUMBER 3// DATA TYPE OF ROUTING TYPE
VARIABLE-POINTER Select VARIABLE-POINTER
2005.2 NETWORK LOCATION Are you adding
'NETWORK LOCATION' as a new VARIABLE-POINTER
(the 1ST)? No// Yes VARIABLE-POINTER NETWORK
LOCATION// MESSAGE VISTARAD SITE ORDER
1 PREFIX V SHOULD USER BE ALLOWED TO ADD A NEW
ENTRY NO SHOULD ENTRIES BE SCREENED YES SCREEN
S DIC("S")"I P((0),U,9)1" EXPLANATION OF
SCREEN Allow only routing entries continue
14
Adding Field Routing Type (cont)
Select VARIABLE-POINTER 2006.587 DICOM TRANSMIT
DESTINATION Are you adding 'DICOM TRANSMIT
DESTINATION' as a new VARIABLE-POINTER (the
2ND)? No// Yes VARIABLE-POINTER DICOM TRANSMIT
DESTINATION// MESSAGE DICOM SITES ORDER
2 PREFIX D SHOULD USER BE ALLOWED TO ADD A NEW
ENTRY NO SHOULD ENTRIES BE SCREENED NO Select
VARIABLE-POINTER WILL ROUTING TYPE FIELD BE
MULTIPLE? No// Yes SUBSCRIPT 1// (accept
recommended default) IS ROUTING TYPE ENTRY
MANDATORY (Y/N) NO// NO SHOULD USER SEE AN
"ADDING A NEW ROUTING TYPE?" MESSAGE FOR NEW
ENTRIES (Y/N) YES HAVING ENTERED OR EDITED ONE
ROUTING TYPE, SHOULD USER BE ASKED ANOTHER (Y/N)
NO SUB-DICTIONARY NUMBER 520206.03// (accept
recommended default) 'HELP'-PROMPT XECUTABLE
'HELP' DESCRIPTION
15
Adding Field Point of Contact
Select FIELD 4 POINT OF CONTACT
(multiple) LABEL POINT OF CONTACT DATA TYPE OF
POINT OF CONTACT FREE TEXT MINIMUM LENGTH
3// MAXIMUM LENGTH 30// (OPTIONAL) PATTERN
MATCH (IN 'X') IS POINT OF CONTACT ENTRY
MANDATORY (Y/N) NO// NO SHOULD USER SEE AN
"ADDING A NEW POINT OF CONTACT?" MESSAGE FOR NEW
ENTRIES (Y/N) Y// YES HAVING ENTERED OR EDITED
ONE POINT OF CONTACT, SHOULD USER BE ASKED
ANOTHER (Y/N) N// NO Select POINT OF CONTACT
SUB-FIELD 1 LABEL OFFICE PHONE DATA TYPE OF
OFFICE PHONE FREE TEXT MINIMUM LENGTH 1//
MAXIMUM LENGTH 20// (OPTIONAL) PATTERN MATCH
(IN 'X') X?3N1"-"3N1"-"4N IS OFFICE PHONE ENTRY
MANDATORY (Y/N) NO// NO 'HELP'-PROMPT Enter
office phone as 000-000-0000
16
Adding Field DICOM SOP Class
Select FIELD 5 Are you adding a new FIELD (the
6TH)? No// Yes LABEL DICOM SOP CLASS FIELD
NUMBER 5// DATA TYPE OF DICOM SOP CLASS
POINTER TO A FILE POINT TO WHICH FILE DICOM
SOP CLASS SHOULD 'ADDING A NEW DICOM SOP CLASS
FILE ENTRY' ("LAYGO") BE ALLOWED WHEN ANSWERING
THE DICOM SOP CLASS' QUESTION? NO SHOULD 'DICOM
SOP CLASS' ENTRIES BE SCREENED? No// No WILL
DICOM SOP CLASS FIELD BE MULTIPLE? No//
Yes SUBSCRIPT 3// IS DICOM SOP CLASS ENTRY
MANDATORY (Y/N) NO// NO SHOULD USER SEE AN
"ADDING A NEW DICOM SOP CLASS?" MESSAGE FOR NEW
ENTRIES (Y/N) YES// YES HAVING ENTERED OR EDITED
ONE DICOM SOP CLASS, SHOULD USER BE ASKED ANOTHER
(Y/N) YES SUB-DICTIONARY NUMBER 520206.05//
(accept recommended default)
17
Adding Field TeleRad Notes
Select FIELD 6 Are you adding a new FIELD (the
7TH)? No// Yes LABEL TELERAD NOTES FIELD
NUMBER 6// DATA TYPE OF TELERAD NOTES
WORD-PROCESSING SUBSCRIPT 4// SHALL THIS
TEXT NORMALLY APPEAR IN WORD-WRAP MODE? Yes//
Yes SUB-DICTIONARY NUMBER 520206.06// (accept
recommended default)
18
Data Input

• Fileman Enter/Edit Options
• Enter by stepping through all the fields
• Use Looping to loop through a group of entries,
  without having to select each entry individually,
  and enter data for other specific fields

19
Data Input

• Fileman Enter/Edit Options (contd)
• Use an Input Template for entry of specific
  fields
• Use an Input Template with branching certain
  fields will present for data entry based on
  responses to other field entries
• Lets Enter Some Data!

20
Data Output

• Use Fileman functions
• Use Print File Entries option print specified
  data based on a Sort criteria
• Use Search File Entries option print specified
  data based on searching the file for specific
  entries
• Use Inquire to File Entries use to print
  specific entries for specific known file entries

21
Data Output

• Printing Fields
• Standard Caption Output prints the fields that
  have data entered in them
• Print computed findings print fields that set
  up to do calculations based on data entered in
  other fields
• Specific fields select fields to print. Can
  use fields in the main file or any fields in
  pointer files using jumping functions
• Print Statistics getting just the total, count,
  mean, maximum, minimum, and/or standard deviation
  data instead of the data using Fileman (M codes)
  , , !, or
• Lets See What Data We Have!

22
Other 2008 VeHU Classes

• 153H VI Basic FileMan - Getting to the Bottom Of
  the Data
• 268H Getting the Clinical out of VA Filemanager
• Poster 9917 Using Fileman to Obtain More
  Accurate Times for Surgeries by Surgeon

23
Helpful Links

• http//www.hardhats.org/fileman/FMmain.html
• http//vista.med.va.gov/fileman/index.asp
• http//www.va.gov/vdl/application.asp?appid5
• http//vaww.vehu.va.gov/Default.cfm

24
Resources

• VA FileMan manuals Technical, User, Advanced
  User and Programmer
• VA FileMan v. 22.0 website
• Hardhats website

25
Questions?