Puget Sound VAHCS VA FileMan 3

1
VA FileMan 3Examples for Navigation and Retrieval

• Puget Sound VAHCSSeattle, WAAugust 2000
• Version 3

Contributors Valerie J. Harvey, Ph.D., Computer
Information Systems, Robert Morris College,
Moon Township and Pittsburgh, PA Melissa Hughes,
ISS, Puget Sound VA Health Care System (VAHCS),
Seattle, WA Rick Marshall, ISS, Puget Sound VA
Health Care System (VAHCS), Seattle, WA.
2
FileMan Choices 1

• Where possible, prefer PRINT to SEARCH (both
  offer the opportunity for a SORT)
• Conditions (filters)
• you can include one condition at any one level of
  a sort - example find patients in DX code range
  410.00-411.89
• if you need two or more conditions (filters) to
  be applied to the same field, then SEARCH is
  necessary - example find patients in DX code
  range 410.00-411.89 who are females with age 55
• Reuse search templates in printing (saving search
  results in a template saves a set of record
  identifiers)

3
FileMan Choices 2

• In general, start a print or search using the
  file of major interest
• if the focus is on patients, begin in the patient
  file
• if the focus is on visits, begin in the visit
  file (important for outpatients)
• if the focus is on medications, begin in the drug
  file
• if the focus is on laboratory data, begin in the
  laboratory data file

4
FileMan Choices 3

• Test your ideas in the INQUIRE option
• Avoid unnecessary sorting - when extracting or
  exporting for external (non-FileMan) use, do
  sorts in target system
• If the focus is on patients in diagnostic code
  (sub)ranges, for inpatients begin in the PTF file
  (Principal Diagnosis) for outpatients begin in
  the V POV file
• Consider the size of the initial file used

5
Using Computed Values in Sorts, Searches, and
Print Fields

• In PTF (Patient Treatment File), to determine
  lengths of stay, use computed expression
  discharge date-admission date for duration of
  visit in Visit File, visit/admit datetime-check
  out datetime
• in Prescription File, navigate to drug Drug File
  qtyprice per dispense unit
• Restrict search space by reducing period of time
  covered T-120 (date range in sort for print)

6
Role of Functions

• NUMMONTH(date-type field name) to get month
  number (i.e. 6 for June for value like 6/14/2000
• INTERNAL(set-of-codes-type field name) to use the
  internal code instead of the external value
• RANGEDATE to get overlapping number of days for 2
  ranges (inclusive)

7
Role of Functions 2

• COUNT, LAST, MAXIMUM, MINIMUM, nTH, NEXT,
  PREVIOUS, TOTAL to deal with multiple as a whole
• TODAY to get todays date
• NOW for date and time now (timestamp)
• Special needs functions that will be reused can
  be requested

8
Data DictionariesList Attributes
Choose from 1 STANDARD 2
BRIEF 3 CUSTOM-TAILORED 4
MODIFIED STANDARD 5
TEMPLATES ONLY 6 GLOBAL MAP 7
CONDENSED 8 INDEXES ONLY
9 KEYS ONLY
Following are examples of portions of the Data
Dictionary List Attributes listings for Standard,
Brief, and Condensed listings
9
Standard Data Dictionary - 1
Selected portions STANDARD DATA DICTIONARY
9000010 -- VISIT FILE IDENTIFIED BY PATIENT
NAME (.05),HOSPITAL LOCATION (.22),VISIT ID
(15001) POINTED TO BY VISIT field (27) of
the EXAMINATIONS sub-field (70.03) of the
R EGISTERED EXAMS sub-field (70.02) of the
RAD/NUC MED PATIENT File (70)
VISIT field (.015) of the SURGERY File (130)
VISIT field (.03) of the CLAIMS
TRACKING File (356) VISIT FILE
ENTRY field (.27) of the PATIENT MOVEMENT File
(405) VISIT FILE ENTRY field
(.05) of the OUTPATIENT ENCOUNTER File
( 409.68) PCC POINTER field
(900) of the ECHO File (691) PCC
POINTER field (900) of the CARDIAC
CATHETERIZATION File (69 CROSS REFERENCED BY
PATIENT NAME(AA), VISIT/ADMIT DATETIME(AA-TOO),
SERVICE CATEGORY (AAH), VISIT/ADMIT
DATETIME(AAHTOO), PATIENT NAME(AAHTOO2), PARENT
VISIT LINK(A D), DEPENDENT ENTRY COUNT(ADEL),
VISIT/ADMIT DATETIME(ADEL2), ENCOUNTER
TYPE(AE T), VISIT/ADMIT
DATETIME(AET1), PATIENT NAME(AET2), HOSPITAL
LOCATIO N(AET3), HOSPITAL LOCATION(AHL),
VISIT/ADMIT DATETIME(AHL2), PARENT VISIT
LINK( APV), ELIGIBILITY(AVAA2), VISIT/ADMIT
DATETIME(B), PATIENT NAME(C), VISIT ID(VI D)
10
Standard Data Dictionary - 2
Selected examples - fields fields pointed to
templates 9000010,.01 VISIT/ADMIT DATETIME
01 DATE (Required) VISIT DATE
TIME 9000010,.05 PATIENT NAME 05
POINTER TO PATIENT/IHS FILE (9000001) (Required)
FILES POINTED TO
FIELDS CLINIC STOP (40.7) DSS ID
(.08) ELIGIBILITY CODE (8)
ELIGIBILITY (.21) HOSPITAL LOCATION (44)
HOSPITAL LOCATION (.22) LOCATION
(9999999.06) LOC. OF ENCOUNTER
(.06) NEW PERSON (200) CREATED
BY USER (.23) OPTION (19)
OPTION USED TO CREATE (.24) PACKAGE (9.4)
PACKAGE (81202) PATIENT/IHS
(9000001) PATIENT NAME (.05) PCE
DATA SOURCE (839.7) DATA SOURCE
(81203) PROTOCOL (101)
PROTOCOL (.25) VISIT (9000010)
PARENT VISIT LINK (.12) INPUT TEMPLATE(S)
PRINT TEMPLATE(S) 136A1 (ENCREG1)
MAY 02, 1997_at_2156 USER 13458

VISIT LIST 136A1 TEST2
MAR 09, 1999_at_2230 USER 53
11
Brief Data Dictionary
BRIEF DATA DICTIONARY 9000010 -- VISIT FILE
08/20/00 PAGE 1 SITE SEATTLE, WA
UCI VAH,ROU
(VERSION 2.0) ------------------------------------
------------------------------------------- VISIT/
ADMIT DATETIME 9000010,.01 DATE
VISIT DATE TIME DATE VISIT CREATED
9000010,.02 DATE
SYSTEM GENERATED TYPE
9000010,.03 SET
'I' FOR IHS
'C' FOR CONTRACT
'T' FOR
TRIBAL
'O' FOR OTHER
'6' FOR 638 PROGRAM
'V' FOR VA PATIENT NAME
9000010,.05 POINTER
TO PATIENT/IHS FILE
(9000001) PATIENT/IHS LOC. OF ENCOUNTER
9000010,.06 POINTER
TO LOCATION FILE
(9999999.06) SERVICE CATEGORY
9000010,.07 SET
'A' FOR AMBULATORY
'H' FOR HOSPITALIZATION
continues ELIGIBILITY
9000010,.21 POINTER
TO ELIGIBILITY CODE FILE
(8) Select the eligibility which best describes
the patient's entitlement to care
for this visit. HOSPITAL
LOCATION 9000010,.22 POINTER
TO HOSPITAL
LOCATION FILE (44) Answer with the name of
the hospital location where this visit occurred.
12
Condensed Data Dictionary
Select LISTING FORMAT STANDARD//
CONDENSED DEVICE 0250999999999 HOME (CRT)
CONDENSED DATA DICTIONARY---VISIT FILE
(9000010)UCI VAH,ROU VERSION 2.0 STORED
IN AUPNVSIT(
08/20/00 PAGE 1 ------------------------------
--------------------------------------------------

FILE SECURITY
DD SECURITY DELETE SECURITY
READ SECURITY
LAYGO SECURITY
WRITE SECURITY CROSS REFERENCED BY
PATIENT NAME(AA) VISIT/ADMIT DATETIME(AA-TOO)
SERVICE CATEGORY(AAH) VISIT/ADMIT
DATETIME(AAHTOO) PATIENT NAME(AAHTOO2)
PARENT VISIT LINK(AD) DEPENDENT ENTRY
COUNT(ADEL) VISIT/ADMIT DATETIME(ADEL2)
ENCOUNTER TYPE(AET) VISIT/ADMIT DATETIME(AET1)
PATIENT NAME(AET2) HOSPITAL LOCATION(AET3)
HOSPITAL LOCATION(AHL) VISIT/ADMIT
DATETIME(AHL2) PARENT VISIT LINK(APV)
ELIGIBILITY(AVAA2) VISIT/ADMIT DATETIME(B)
PATIENT NAME(C) VISIT ID(VID)
FILE STRUCTURE FIELD
FIELD NUMBER NAME .01 VISIT/ADMIT
DATETIME (RDX), 01 .02 DATE VISIT
CREATED (RDXI), 02 .03 TYPE (RS),
03 .05 PATIENT NAME (RP9000001'I), 05
continues
13
Template List
TEMPLATE LIST -- FILE 99017
08/27/00 PAGE -----------------------
-------------------------- INPUT
TEMPLATE(S) PRINT TEMPLATE(S) CAPTIONED
USER
0 HLISTBYSOL1 JUN 27,
2000_at_1318 USER 0 HORMONE
LIST BY SOLUBLE STAT SORT TEMPLATE(S) FORM(S)/BLO
CK(S)
14
Indexes Only
INDEX AND CROSS-REFERENCE LIST -- FILE 99017
08/27/00 PAGE 1 -------------------------------
------------------------------------- File
99017 Traditional Cross-References B
REGULAR Field NAME (99017,.01)
1) S DIZ(99017,"B",E(X,1,30),DA
)"" 2) K DIZ(99017,"B",E(X
,1,30),DA) Subfile 99017.01 Traditional
Cross-References B REGULAR
Field SOURCE (99017.01,.01)
1) S DIZ(99017,DA(1),1,"B",E(X,1,30),DA)""
2) K DIZ(99017,DA(1),1,"B",E(
X,1,30),DA) C REGULAR WHOLE FILE
(99017) Field SOURCE
(99017.01,.01) 1) S
DIZ(99017,"C",E(X,1,30),DA(1),DA)""
2) K DIZ(99017,"C",E(X,1,30),DA(1),DA)
15
Enrollment/Patient
Select OPTION SEARCH FILE ENTRIES OUTPUT FROM
WHAT FILE VISIT// CBOC ENROLLMENT (963
entries) -A- SEARCH FOR CBOC ENROLLMENT
FIELD .01 -A- SEARCH FOR PATIENT FIELD
AGE 1 AGE 2 AGENCY/ALLIED
COUNTRY Press to see more, '' to exit
this list, OR CHOOSE 1-2 1 AGE
16
Enrollment/Patient - Search
-A- CONDITION GREATER THAN -A- GREATER THAN
45 -B- SEARCH FOR PATIENT FIELD -B-
SEARCH FOR CBOC ENROLLMENT FIELD IF A//
PATIENT AGE GREATER THAN 45 STORE RESULTS OF
SEARCH IN TEMPLATE PATAGE Are you adding
PATAGE' as a new SORT TEMPLATE? No// Y (Yes)
17
Enrollment/Patient - Print
SORT BY NUMBER// START WITH NUMBER
FIRST// FIRST PRINT FIELD .01 PATIENT NAME THEN
PRINT FIELD .01 THEN PRINT PATIENT FIELD
AGE 1 AGE 2 AGENCY/ALLIED
COUNTRY Press to see more, '' to exit
this list, OR CHOOSE 1-2 1 AGE THEN PRINT
PATIENT FIELD THEN PRINT FIELD
18
Enrollment/Patient - Results
Heading (S/C) CBOC ENROLLMENT SEARCH
Replace DEVICE Home HOME (CRT) Right
Margin 80// PATIENT AGE SEARCH AUG 16,2000
2026 PAGE 1 PATIENT NAME
AGE ----------------------------------------------
--- NUMBER 1 FRY,JIMMY L
50 NUMBER 3 LAHOOD,STEVEN
62
19
Patient/Patient Movement
OUTPUT FROM WHAT FILE PATIENT//
(245384 entries) SORT BY NAME// _at_CURRENT
ADMISSION START WITH CURRENT ADMISSION FIRST//
T-120 (APR 18, 2000) GO TO CURRENT ADMISSION
LAST// WITHIN CURRENT ADMISSION, SORT BY
_at_NAME START WITH NAME FIRST// WITHIN NAME,
SORT BY
20
Prescription/Drug PrintTested Using Inquire
Option
OUTPUT FROM WHAT FILE PRESCRIPTION// Select
PRESCRIPTION RX 178642A
HYDROCHLOROTHIAZIDE 25MG TAB ANOTHER
ONE STANDARD CAPTIONED OUTPUT? Yes// N
(No) FIRST PRINT FIELD QTY THEN PRINT FIELD
DRUG THEN PRINT DRUG FIELD PRICE 1
PRICE PER DISPENSE UNIT 2 PRICE PER ORDER
UNIT CHOOSE 1-2 1 PRICE PER DISPENSE UNIT
THEN PRINT DRUG FIELD QTYPRICE PER DISPENSE
UNIT THEN PRINT DRUG FIELD THEN PRINT FIELD
21
Prescription/Drug Results
Heading (S/C) PRESCRIPTION LIST// STORE PRINT
LOGIC IN TEMPLATE DEVICE HOME (CRT) Right
Margin 80// PRESCRIPTION LIST
AUG 18,2000 0750 PAGE 1
QTYPRICE PRICE PER
PER DISPENSE DISPENSE
QTY UNIT UNIT -----------------------------
------------------------ 30.00
0.0360 1.08
22
Patient/Patient Movement - Print
FIRST PRINT FIELD NAME THEN PRINT FIELD CURRENT
ADMISSION THEN PRINT PATIENT MOVEMENT FIELD
.01 DATE/TIME THEN PRINT PATIENT MOVEMENT
FIELD DIAG 1 DIAGNOSIS
(word-processing) 2 DIAGNOSIS
SHORT CHOOSE 1-2 2 DIAGNOSIS SHORT THEN
PRINT PATIENT MOVEMENT FIELD WARD LOCATION
THEN PRINT PATIENT MOVEMENT FIELD AGE THEN
PRINT PATIENT MOVEMENT FIELD THEN PRINT FIELD
23
Patient/Patient Movement - Results
Heading (S/C) PATIENT LIST// START AT PAGE
1// DEVICE HOME (CRT) Right Margin
80// PATIENT LIST AUG 16,2000 2043
PAGE 1 NAME
DATE/TIME DIAGNOSIS SHORT
WARD LOCATION
AGE --------------------------------------------
COX,MILES WALLACE MAY 26,2000
0440 TEST 7 WEST
(SEA) 68 BROWN,DAVID A
MAY 26,2000 0900 davids disease
SA DOM (AL)
39 OVERTON,LARNELL VADEN MAY 26,2000
1300 PARANOIA 7B (AL)
55 STRAUCH,GEORGE E
MAY 26,2000 1400 big toe pimple
MTU (SEA)
88 TEST,PATIENT FIVE MAY 26,2000
1700 FELL OFF THE STAIRS CWT/TR
(PUG-PRRTP) 3 TIMMONS,STEPHEN CRAIG
MAY 27,2000 0900 PTSD
7B (AL)
52 TURNER,DONALD E MAY 27,2000
1200 sob MICU
(SEA) 81
24
Visit/Drug/DX Navigation
VISIT V POV .05
V POV POV ICD NARRATIVE
PATIENT/IHS .01
PHARMACY PATIENT PRESCRIPTION PROFILE
subfile DRUG
PATIENT PHARMACY PATIENT
PHARMACY PATIENT PRESCRIPTION PROFILE subfile
25
Visit/Drug/DX
OUTPUT FROM WHAT FILE VISIT// SORT BY
VISIT/ADMIT DATETIME// START WITH VISIT/ADMIT
DATETIME FIRST// FIRST PRINT FIELD .05
PATIENT NAME THEN PRINT FIELD .05 THEN PRINT
PATIENT/IHS FIELD .01 THEN PRINT PATIENT
FIELD PHARMACY PATIENT By 'PHARMACY
PATIENT', do you mean the PHARMACY PATIENT File,
pointing via its 'NAME' Field? Yes//
(Yes) THEN PRINT PHARMACY PATIENT FIELD
PRESCRIPTION PROFILE (multiple) THEN
PRINT PRESCRIPTION PROFILE SUB-FIELD DRUG
THEN PRINT PRESCRIPTION PROFILE SUB-FIELD
THEN PRINT PHARMACY PATIENT FIELD THEN PRINT
PATIENT FIELD THEN PRINT PATIENT/IHS
FIELD THEN PRINT FIELD V POV By 'V POV', do
you mean the V POV File, pointing via its
'VISIT' Field ("AD" Cross-reference)? Yes//
(Yes) THEN PRINT V POV FIELD .01 POV THEN
PRINT V POV FIELD .019 ICD NARRATIVE THEN
PRINT V POV FIELD
26
Visit/Drug/DX
VISIT LIST AUG
16,2000 2121 PAGE 1 PATIENT NAME
DRUG POV
ICD NARRATIVE ------------------------------------
-----------------------------------
VISIT/ADMIT DATETIME APR 25,1997
1100 SMITH,SUSAN
DIPHENHYDRAMINE HCL 25MG CAP
ASPIRIN 325MG EC TAB
DIPHENHYDRAMINE HCL 25MG CAP
BPM 12
PHENYLPROPANOLAMINE 75MG
CHLORHEXIDINE 0.12 MOUTHWASH 48
MICONAZOLE CREAM 2 30GM
TRAZODONE HCL 50MG
TAB NIACIN 100MG
TAB NIACIN 500MG
TAB BPM 12
PHENYLPROPANOLAMINE 75MG
CHLORHEXIDINE GLUCONATE 0.12 MO
SIMVASTATIN 5MG TAB
SULFAMETHOXAZOLE
800/TRIMETH 160
IBUPROFEN 800MG TAB
IBUPROFEN 800MG TAB
METRONIDAZOLE 250MG TAB 309.28
ADJ REACT-MIXED EMOTION
27
Multiple Conditions Example

• Query list all patients
• in the range of DX codes 410.00 through 411.99
• A PTFDXLS contains 410.
• B PTFDXLS contains 411.
• who are males with age 45
• C PATIENTSEXMALE
• D PATIENTAGE45
• or are females with age
• E PATIENTSEXFEMALE
• F PATIENTSEX65

28
Multiple ConditionsExample Logic
29
Multiple Conditions - 1
OUTPUT FROM WHAT FILE PTF// -A- SEARCH FOR
PTF FIELD DXLS -A- CONDITION CONTAINS
-A- CONTAINS 410. -B- SEARCH FOR PTF FIELD
DXLS -B- CONDITION CONTAINS -B- CONTAINS
411. -C- SEARCH FOR PTF FIELD PATIENT
-C- SEARCH FOR PATIENT FIELD SEX -C-
CONDITION EQUALS -C- EQUALS MALE
30
Multiple Conditions - 2
-D- SEARCH FOR PATIENT FIELD AGE 1 AGE
2 AGENCY/ALLIED COUNTRY Press to see
more, '' to exit this list, OR CHOOSE 1-2 1
AGE -D- CONDITION GREATER THAN -D-
GREATER THAN 45 -E- SEARCH FOR PATIENT
FIELD SEX -E- CONDITION EQUALS -E-
EQUALS FEMALE
31
Multiple Conditions - 3
-F- SEARCH FOR PATIENT FIELD AGE 1 AGE
2 AGENCY/ALLIED COUNTRY Press to see
more, '' to exit this list, OR CHOOSE 1-2 1
AGE -F- CONDITION GREATER THAN -F-
GREATER THAN 65 -G- SEARCH FOR PATIENT
FIELD -G- SEARCH FOR PTF FIELD
32
Multiple Conditions - 4
IF AEF DXLS CONTAINS "410." and PATIENT
SEX EQUALS "F" (FEMALE) together
with PATIENT AGE GREATER THAN 65 OR BEF Or
DXLS CONTAINS "411." and PATIENT SEX EQUALS
"F" (FEMALE) together with
PATIENT AGE GREATER THAN 65 OR CDA Or
PATIENT SEX EQUALS "M" (MALE)
together with PATIENT AGE GREATER THAN 45
and DXLS CONTAINS "410." OR CDB
Or PATIENT SEX EQUALS "M" (MALE)
together with PATIENT AGE GREATER THAN 45
and DXLS CONTAINS "411."
33
Multiple Conditions - 5
SORT BY NUMBER// _at_PATIENT START WITH PATIENT
FIRST// WITHIN PATIENT, SORT BY FIRST PRINT
FIELD PATIENT THEN PRINT PATIENT FIELD .01
NAME THEN PRINT PATIENT FIELD AGEL3 1
AGE 2 AGENCY/ALLIED COUNTRY Press
to see more, '' to exit this list, OR CHOOSE
1-2 1 AGE THEN PRINT PATIENT FIELD SEXL1
THEN PRINT PATIENT FIELD THEN PRINT FIELD
DXLS THEN PRINT FIELD ADMISSION DATE THEN PRINT
FIELD DISCHARGE DATE THEN PRINT FIELD DISCHARGE
DATE-ADMISSION DATE THEN PRINT FIELD Heading
(S/C) PTF SEARCH// STORE PRINT LOGIC IN
TEMPLATE DEVICE HOME (CRT) Right Margin
80//
34
Multiple Conditions - 6
When using CONTAINS, choose search value
carefully. CONTAINS treats values as strings.
410. here is chosen to make sure the correct
range of DX codes/numbers is found. Check you
data to make sure you have a good choice. -A-
SEARCH FOR PTF FIELD DXLS -A- CONDITION
CONTAINS -A- CONTAINS 410.
35
Surgical Query A
List patient ID, age, discharge date, and ward at
discharge for all orthopedic surgery patients
(last 180 days) Navigation logic begin with
PTFget orthopedics from surgical specialty
file Sort by patientnumber (ID in patient file)
and start sort with discharge date of T-180 end
sort with T
36
Surgical Query A - 1Search
Select OPTION SEARCH FILE ENTRIES OUTPUT FROM
WHAT FILE PTF// -A- SEARCH FOR PTF FIELD 401
(multiple) -A- SEARCH FOR PTF 401 SUB-FIELD
3 By '3', do you mean 401 'SURGICAL
SPECIALTY'? Yes// (Yes) -A- SEARCH FOR
SURGICAL SPECIALTY FIELD 1 SPECIALTY -A-
CONDITION EQUALS -A- EQUALS ORTHOPEDICS
-B- SEARCH FOR SURGICAL SPECIALTY FIELD
-B- SEARCH FOR PTF 401 SUB-FIELD -B- SEARCH
FOR PTF FIELD IF A SURGICAL SPECIALTY
SPECIALTY EQUALS "ORTHOPEDICS"
37
Surgical Query A - 2Sort
DO YOU WANT THIS SEARCH SPECIFICATION TO BE
CONSIDERED TRUE FOR CONDITION -B- 1) WHEN
AT LEAST ONE OF THE '401' MULTIPLES SATISFIES IT
2) WHEN ALL OF THE '401' MULTIPLES SATISFY
IT CHOOSE 1-2 1// SORT BY _at_DISCHARGE
DATE START WITH DISCHARGE DATE FIRST// T-180
(FEB 20, 2000) GO TO DISCHARGE DATE LAST// T
(AUG 18, 2000_at_2400) WITHIN DISCHARGE DATE,
SORT BY
38
Surgical Query A - 2Print
FIRST PRINT FIELD PATIENT THEN PRINT PATIENT
FIELD NUMBER THEN PRINT PATIENT FIELD AGE
1 AGE 2 AGENCY/ALLIED COUNTRY Press
to see more, '' to exit this list,
OR CHOOSE 1-2 1 AGE THEN PRINT PATIENT
FIELD THEN PRINT FIELD DISCHARGE DATE THEN
PRINT FIELD WARD AT DISCHARGE Heading (S/C) PTF
SEARCH//
39
Surgical Query A - 2Results
PTF SEARCH
AUG 18,2000 1135 PAGE 1 NUMBER AGE
DISCHARGE DATE WARD AT DISCHARGE ------------
---------------------------------------------
1645768 74 FEB 10,2000 1015 3 EAST
(SEA) 1757478 68 FEB 18,2000 1120 3
EAST (SEA)
40
Surgical Query B - 1Search
Select OPTION SEARCH FILE ENTRIES OUTPUT FROM
WHAT FILE SURGERY// -A- SEARCH FOR SURGERY
FIELD .011 IN/OUT-PATIENT STATUS -A-
CONDITION EQUALS -A- EQUALS INPATIENT -B-
SEARCH FOR SURGERY FIELD .04 SURGERY SPECIALTY
-B- CONDITION EQUALS -B- EQUALS LOCAL
SURGICAL SPECIALTY ORTHOPEDICS 54 -C-
SEARCH FOR SURGERY FIELD
41
Surgical Query B - 2Search/Sort
IF AB IN/OUT-PATIENT STATUS EQUALS "I"
(INPATIENT) and SURGERY SPECIALTY EQUALS
ORTHOPEDICS OR SORT BY NUMBER// _at_DATE OF
PROCEDURE START WITH DATE OF PROCEDURE FIRST//
T-180 (FEB 20, 2000) GO TO DATE OF PROCEDURE
LAST// T (AUG 18, 2000_at_2400) WITHIN DATE OF
PROCEDURE, SORT BY
42
Surgical Query B - 3Print
FIRST PRINT FIELD PATIENT THEN PRINT PATIENT
FIELD NUMBER THEN PRINT PATIENT FIELD THEN
PRINT FIELD SURGERY SPECIALTY THEN PRINT FIELD
DATE OF PROCEDURE THEN PRINT FIELD PRIN
DIAGNOSIS CODE
43
Patient Location Query - 1
Finding patients enrolled in clinic location
53040 Select OPTION SEARCH FILE ENTRIES OUTPUT
FROM WHAT FILE VISIT// -A- SEARCH FOR VISIT
FIELD .05 -A- SEARCH FOR PATIENT/IHS FIELD
.01 -A- SEARCH FOR PATIENT FIELD
ENROLLMENT CLINIC (multiple) -A-
SEARCH FOR PATIENT ENROLLMENT CLINIC SUB-FIELD
.01 -A- SEARCH FOR HOSPITAL LOCATION
FIELD NAME -A- CONDITION EQUALS
-A- EQUALS 53040 -B- SEARCH FOR
HOSPITAL LOCATION FIELD -B- SEARCH FOR
PATIENT ENROLLMENT CLINIC SUB-FIELD -B-
SEARCH FOR PATIENT FIELD -B- SEARCH FOR
PATIENT/IHS FIELD -B- SEARCH FOR VISIT
FIELD IF A// HOSPITAL LOCATION NAME EQUALS
53040
44
Patient Location Query - 2
DO YOU WANT THIS SEARCH SPECIFICATION TO BE
CONSIDERED TRUE FOR CONDITION -A- 1) WHEN
AT LEAST ONE OF THE 'ENROLLMENT CLINIC' MULTIPLES
SATISFIES IT 2) WHEN ALL OF THE
'ENROLLMENT CLINIC' MULTIPLES SATISFY IT
CHOOSE 1-2 1// SORT BY VISIT/ADMIT
DATETIME// START WITH VISIT/ADMIT DATETIME
FIRST// T-365 (AUG 19, 1999) GO TO VISIT/ADMIT
DATETIME LAST// T (AUG 18, 2000_at_240000)
WITHIN VISIT/ADMIT DATETIME, SORT BY FIRST
PRINT FIELD .05 PATIENT NAME THEN PRINT FIELD
VISIT 1 VISIT DATE TIME VISIT/ADMIT
DATETIME 2 VISIT ID CHOOSE 1-2 1
VISIT/ADMIT DATETIME THEN PRINT FIELD Heading
(S/C) VISIT SEARCH// START AT PAGE 1//
45
Lab - Mapping Patient Ids - 1
The PATIENT file contains a LABORATORY REFERENCE
field needed to map from PATIENT numbers to lab
reference numbers in the LAB DATA file
(LDRFNs) OUTPUT FROM WHAT FILE PATIENT// SORT
BY NAME// START WITH NAME FIRST// FIRST PRINT
FIELD NAME THEN PRINT FIELD NUMBER THEN PRINT
FIELD LABORATORY REFERENCE
46
Lab - Mapping Patient Ids - 2
OUTPUT FROM WHAT FILE PATIENT// Select PATIENT
NAME TEST,PATIENT EIGHT 5-3-29
000001929 SVAMC NO NON-VETERAN
(OTHER) 81S (AL) Warning You have
selected a test patient. ANOTHER ONE STANDARD
CAPTIONED OUTPUT? Yes// N (No) FIRST PRINT
FIELD NUMBER THEN PRINT FIELD LABORATORY
REFERENCE THEN PRINT FIELD Heading (S/C)
PATIENT LIST// DEVICE HOME (CRT) Right
Margin 80// PATIENT LIST
AUG 18,2000 1332 PAGE 1
LABORATORY NUMBER
REFERENCE ----------------------------------------
--------------------------- 57688
15004
47
Validate Results

• Verify meaning(s) of fields selected consult
  relevant department experts if necessary be
  certain you are using the right data
• Check patient name in files reached by navigation
  - print out patient from each file for each
  patient in a subset in such a validation test
• Select a limited set of test patients from
  results and check values and multiples to make
  sure all search/sort logic is correct

48
Queuing Example
Queuing to start query processing at an optimal
time from a performance standpoint (specify time
and device) DEVICE QUEUE TO PRINT ON DEVICE
IRMB IRMB56-16 1/B28 Requested Time To Print
NOW//T1_at_1800 (AUG 19, 2000_at_1800) REQUEST
QUEUED! Task number 18076 Select DEVICE NAME
IRMB56-16 1/B28 SPOOLUCX_LPDVHAPUG_P_IRM
B56PRT. TXT QUEUING FORCED//
49
Acknowledgements
Participants in the initial VA FileMan seminar
(August 2000) contributed valuable insights and
examples of information and query needs Michael
Beebe, Patrice Brower, Linda Clark, Gin Doctor,
Jeanie Espanto, Larry Hanson, Susan Holme, Denis
Johnson, Sharon LePage-Jones, Nancy Lewis, Sean
Longowski, Mary Jo May, Sheryl Murdoch, Don
Nagorski, Barb Peterson, Cathy Phillips, Betty
Seigal, Jeffrey A. Todd-Stenberg, Bruce Wyllie
50
Contacts

• Valerie Harvey, Ph.D., Professor, Department of
  Computer Information Systems, Robert Morris
  College, Narrows Run Road, Moon Township, PA
  15108-1189 harvey_at_robert-morris.edu - to
  expedite, put VA first in subject line so your
  post will be filtered automatically to a VA
  directory 412-262-8467 (e-mail is best)
• Melissa Hughes, Ideas Team Leader, ISS, Puget
  Sound VAHCS, Seattle, WA ov, 206-764-2726
• Rick Marshall, Computer Specialist/Analyst, ISS,
  Puget Sound VAHCS, Seattle, WA
  , 206-764-2283