# Presentation: 001009

## WELCOME TO BASIC VA FILEMAN 113H

**Tom Fagan Clinical Applications Coordinator at VAMC **
**Richmond, Virginia **
**(804) 675-5298**

**Notes:**
Tom Fagan, a registered pharmacist with MBA from VCU from the VA Medical Center, Richmond, Virginia is a Clinical Application Coordinator for the Computerized Patient Record System (CPRS).  Tom started at the VA as the Pharmacy ADP Coordinator in May 1995. Tom has been active in VISN 6 ADP activities as ADPAC trainer since September 1998, served as Point of Contact for the Barcode Medication Administration (BCMA) for VISN 6.

153H VistA Imaging - Getting to the Bottom of the Data - Basic Fileman WED 8/22/07 at 1:30p

Thank room assistants
145H Detention Hall - Open Lab for VeHU Hands-On Sessions
Wednesday, August 22, 20076:30:00 PM  -8:00:00 PM (EST)  Extra templates begin with H113

Delighted to welcome you 
Who are you, pharmacist-  not a pharmacist,  user -  never used.

## LEARNING OBJECTIVES AND CLASS FORMAT

**Be able to use basic report functions; inquire, print and search.**
**Be able to use List File Attributes to identify file and field numbers or labels and data types**
**Know how to create and use templates for search, sort and print.**
***Understand Intermediate concepts:  point (jump files) and multiples (sub files).***
**Know where to find additional Reference: Fileman Website.**
**Understand Importance of Data Validation and Privacy/Security**

**Notes:**
I am here to learn, why are you here?

Learning Fileman Reports is building process need foundation in basics.

1 -3  Using Fileman to produce reports (not enter edit) is not exact science although functions and  require exact syntax, choice of file, functions and templates is an art, use file attributes from FILEMAN Data Dictionary Utilities 

4 exposure to intermediate concepts
5 additional resources for using fileman reports
6 responsible in the environment of privacy and security

## TERMINOLOGY Most Important

**SYNTAX exact sequence of characters and words for a function to work, may be case sensitive**
**Primary Source of Frustration**

**Notes:**
Either learning occurs or you quit, your choice

## TERMINOLOGY Database Related

**DATABASE collection of files used to store data**
**FILE collection of records**
**RECORDS are unique entries in File**
**FIELDS data type place holders to store information in records**

## TERMINOLOGY Miscellaneous

**IEN NUMBER is the unique number assigned to record by software, contained in the .001 field**
**MULTIPLE is a sub file or a file within a file can contain zero or multiple entries**
**JUMPING(POINTING) **access a field in related file.

**Notes:**
Value of evaluation

## FILES,  RECORDS and FIELD REPORTS

**Relationships for Accurate Reports**
**Paper Analogy: Filing Cabinet with drawers, folder and sheets of paper.**

**Notes:**
Important to understand the relationships next slide- examples

## FILES,  RECORDS and FIELD EXAMPLES

**File:  a collection of related information,  example: the PATIENT FILE **
**Record:  a collection of fields that are related to a single thing, example:  one PATIENT’S Demographics ( ADDRESS, AGE, PHONE...)**
**Field:  a single piece of information in a record,  example: patient phone number**

## Data Dictionary Utility “Display Structure” 
File Number or Label
Field Number or Label
Data Type
Pointers
Suggest Brief format.

**File Number or Label**
**Field Number or Label**
**Data Type**
**Pointers**
**Suggest Brief format.**

**LIST FILE ATTRIBUTES**

**Notes:**
 This option is used to print or view data dictionary description of  data base structures  for a given file, numbers, labels  and data type.

## LIST FILE ATTRIBUTES DATA TYPES

**DATE/TIME****	****	****Date of Birth**
**FREE TEXT****	****	****Address**
**SET OF CODES****	****M=Male F=Female**
**WORD-PROCESSING****	****Comments**
**NUMERIC****	****	****	****Number **
**COMPUTED****	****	****Age**

## POINTERS for JUMPING

**When A Field In The Start File Points To The File We Want To Go To, A **_***FORWARD***_** Pointer Relationship Exists**
**Read access required to **_***RELATED***_** file**

## REPORT FUNCTIONS

** ****Inquire to File Entries**
** ****Print File Entries **
** ****Search File Entries**

**Notes:**
These 3 functions are the work horse for fileman reporting, need a working understanding for basic.

'Inquire to File Entries'  View select fields of one or more known records, must use ] to force print out put template. This option is used to display all the data for a group of specified entries in a file.  This is useful for a quick look at a small number of entries or to design a print output template. 

##  REPORT FUNCTIONS

** ****Inquire to File Entries**
** ****Print  File Entries **
** ****Search File Entries**

**Notes:**
  'Print File Entries' This option is used to print a report from a file, where a number of entries are to be listed in a columnar format.  Each column can be individually controlled for format, tabulation, justification, etc.  Can save sort logic as print sort template.

##  REPORT FUNCTIONS

** ****Inquire to File Entries**
** ****Print File Entries**** **
** ****Search File Entries**
**??? For help**

**Notes:**
'Search File Entries' This option is used to print a report in which entries are to be selected according select set of criteria with logical operators =, < or contains.  After the search criteria is met, a standard report will be generated or can be saved in search template. 

## LIST ALL FIELDS USING INQUIRE

**Drug = SIMVASTATIN 80MG TAB**
**At Print FIRST PRINT FIELD PROMPT ?**
**Answer with FIELD NUMBER, or LABEL**
** ****Do you want the entire 386-Entry FIELD List? y  (Yes) = SORT by FIELD NUMBER**
**Do you want the entire 386-Entry FIELD List?**
** ****^A**** ****=  Sort FIELDS  by LABEL starting with A**

## TEMPLATE COMPARISON

**Search = saved Search Results or Saved Search Logic**
**Print Sort = saved Sort Logic**
**Print Output = saved Print or Display Format**

## SEARCH TEMPLATE

**Static as of Run Date and Time**
**Access Results from Print (Sort)**
**Access Logic from Search**
**Orders from a month**

**Notes:**
Static- if new records meet criteria after search template is saved, will NOT be included in template.
ORDERS example, by nature search without a sort searches entire file and can be SLOW. 

At Richmond there more than 170,000 orders per month

## PRINT (SORT) TEMPLATE

**Dynamic**
**Use to Refine Search Template**
**TIP:  Sort by: ****[ “TEXT”**** = Contains TEXT**

**Notes:**
Same as search only Dynamic- will update when run, new records will be included since last run, will be slow for files with many entries.

Sorting by indexed field in large file will process quicker, see list file attributes for index fields.

## PRINT OUTPUT TEMPLATE 

**Save Print Format**
**Select Fields**
**'****]****' TO FORCE SAVING PRINT TEMPLATE**
**Print ****“TEXT”**
**Print Qualifier syntax is ****FIELD;**** ****CHARACTERS**
**EXAMPLE;Ln (Left Justify (Limit))**
**FIRST PRINT FIELD: ****NAME;L8**** = **
**Print  8 characters of the name**

**Notes:**
Used to save print output can be designed in inquire or print sort, must use ] to force prompt to save.  

## PRINT OUTPUT TEMPLATE

**STANDARD CAPTIONED OUTPUT**
**FIRST PRINT FIELD:***** ******[CAPTIONED******  = SYNTAX***
**Include COMPUTED fields:  (N/Y/R/B):**
**Enter a code from the list.  Select one of the following:**
**  *****N   =  NO - No record number (IEN), no Computed Fields***
***  ******Y   =  Computed Fields***
***  ******R   =  Record Number (IEN)***
***  ******B   = BOTH Computed Fields and Record***** *****Number (IEN)***
**DISPLAYS only populated fields – default with INQUIRE**

**Notes:**
System print output template- always available displays only populated fields

**Notes:**
Violates  geneva convention of powerpoint

Fileman Template Matrix  
The main point is to summarize the  relationship between the fileman function used to create and access different types of templates.

Across the top of matrix slide in red is the type of templates.
SEARCH  and INQUIRE are similar but different.

The second row in green is the fileman function used to create template.

And the third row in blue is the function used to access template or template results.

Note that print file entries can be used to access results from all templates.

Print   SORT and OUTPUT templates are different, print OUTPUT can be created and accessed from any FIRST PRINT FIELD Prompt. 

## SESSION MENU

**VA FileMan Version 22.0**
**          ****Enter or Edit File Entries**
**          ****Print File Entries**
**          ****Search File Entries**
**          ****Modify File Attributes**
**          ****Inquire to File Entries**
**          ****Utility Functions ...**
**          ****Data Dictionary Utilities ... ****List File Attributes**
**          ****Transfer Entries**
**          ****Other Options ...**

**Notes:**
Your station fileman menu may be different. This is full standard menu use with detention hall open LAB in PM
It is always a good idea to check with your local computer department before launching searches on files with a large number of records. 

*** for simplicity most examples will be one condition search or sort without jumping or using a multiple ***

Suggest requesting access in mirror test account for practice.

## LOG IN FOR HANDS ON

**ACCESS: ****00VEHU**
**VERIFY:****VEHU00**

## #1 HANDS ON - LIST FILE ATTRIBUTES

-  ***DATA*** Dictionary Utilities
-            *** ******LIST ***File Attributes
-  START WITH WHAT FILE: ***DRUG ***OR*** 50***  DRUG    (3587 entries)
-       GO TO WHAT FILE: DRUG//
-       Select SUB-FILE:
- Select LISTING FORMAT: STANDARD// ***BRIEF***
- ALPHABETICALLY BY LABEL? No// ***Y  ***(Yes)
- Start with field: FIRST//
- DEVICE:   TELNET PORT    Right Margin: 80//

**Notes:**
File NUMBER or LABEL

## HANDS ON - LIST FILE ATTRIBUTES – SAMPLE OUTPUT

**BRIEF DATA DICTIONARY #50 -- DRUG FILE              MAY 3,2007@15:57:37  PAGE 1**
**SITE: TROY ISC SUPPORT ACCOUNT   UCI: LEC1,ROU                 (VERSION 1.0)   **
**-------------------------------------------------------------------------------**
***ATC CANISTER                  50,212.1    NUMBER **
**  ****ATC CANISTER (OLD)                    **
**                         ****Enter a Number between 1 and 212, 0 Decimal Digits. **
***LAB TEST MONITOR              50,623002    POINTER **
**                                         ****TO LABORATORY TEST FILE (#60) **

**Notes:**
Description of data dictionary attributes
Labels, numbers, data type

## #2 HANDS ON - INQUIRE

***INQUIRE***** to File Entries**
**OUTPUT FROM WHAT FILE:***** DRUG*****/**
**Select DRUG GENERIC NAME: *****`153*****  SIMVASTATIN 40MG TAB         CV350           **
**ANOTHER ONE: **
**STANDARD CAPTIONED OUTPUT? Yes//   (Yes)**
**Include COMPUTED fields:  (N/Y/R/B): NO// b  BOTH Computed Fields and Record Num**
**ber (IEN)**
**DISPLAY AUDIT TRAIL? No//   *****NO***
**OUTPUT**
**GENERIC NAME: SIMVASTATIN 40MG TAB      VA CLASSIFICATION: CV350**
**  ****DEA, SPECIAL HDLG: 6P**
**SYNONYM: ZOCOR                          INTENDED USE: TRADE NAME**
**  ****PHARMACY ORDERABLE ITEM: SIMVASTATIN  APPLICATION PACKAGES' USE: OXU**
**  ****NDC: 000006-0749-54                   CMOP DISPENSE: YES**
**ACTIVITY LOG: FEB 20, 2007@13:21:55     REASON: EDIT**
**  ****INITIATOR OF ACTIVITY: PHARMACIST,THREE**
**  ****FIELD EDITED: CMOP Dispense           NEW VALUE: YES**
**  ****ORDER UNIT: BT                        PRICE PER ORDER UNIT: 504.18**
**  ****DISPENSE UNITS PER ORDER UNIT: 1000   PRICE PER DISPENSE UNIT: 0.5042**
**  ****SOURCE OF SUPPLY: 6U                  DISPENSE UNIT: TAB**
**  ****CURRENT INVENTORY: -10980             STRENGTH: 40**
**  ****UNIT: MG**
**DISPENSE UNITS PER DOSE: 1              DOSE: 40**
**  ****PACKAGE: IO**

**Notes:**
Best way to learn a file without using DD utilities is standard captioned output with inquire, only displays populated fields.

## #3 HANDS ON CREATE PRINT OUTPUT TEMPLATE USING INQUIRE

***INQUIRE*** **to File Entries**
**OUTPUT FROM WHAT FILE: *****DRUG *****OR***** 50*****  DRUG    (3587 entries)**
**Select DRUG GENERIC NAME: *****METFOR,1000*****  METFORMIN HCL 1000MG TAB         HS502   **
**ANOTHER ONE: **
**STANDARD CAPTIONED OUTPUT? Yes// *****N*****  **
**FIRST PRINT FIELD: *****]***
**FIRST PRINT FIELD: *****GENERIC***** NAME  **
**THEN PRINT FIELD: *****3*****  =DEA, SPECIAL **
**THEN PRINT FIELD: *****INACTIVE DATE*****  **
**THEN PRINT FIELD: **
**Heading (S/C): DRUG LIST//**
**STORE PRINT LOGIC IN TEMPLATE:** ***00.DEA***

## #4 HANDS ON - PRINT “SORT”

***PRINT***** File Entries**
**OUTPUT FROM WHAT FILE: *****DRUG***** OR *****50***
**SORT BY: GENERIC NAME//**
**START WITH GENERIC NAME: FIRST// **
**FIRST PRINT FIELD:*****[00.DEA***

**Notes:**
Can sort or access templates- alphabetical order- show appointment multiple.

## #5 HANDS ON - PRINT SORT TO SEARCH

***PRINT*** File Entries
- OUTPUT FROM WHAT FILE: ***DRUG***//
- SORT BY: GENERIC NAME// ***DEA["2”***
- WITHIN DEA["2", SORT BY:
- FIRST PRINT FIELD: ***[00.DEA***
- SORT BY: GENERIC NAME//
- START WITH GENERIC NAME: FIRST//
- FIRST PRINT FIELD:
- Heading (S/C): DRUG SEARCH//
- DEVICE:   TELNET PORT    Right Margin: 80//
- DRUG SEARCH                                    AUG  1,2007  10:08    PAGE 1
- --------------------------------------------------------------------------------
- 3093 MATCHES FOUND.

## #6 HANDS ON – SEARCH

***SEARCH ***File Entries
- OUTPUT FROM WHAT FILE: ***DRUG***
-   -A- SEARCH FOR DRUG FIELD: ***INACTIVE***
-   -A- CONDITION: ***NULL***
- -B- SEARCH FOR DRUG FIELD:
- IF: A//     INACTIVE DATE NULL
- STORE RESULTS OF SEARCH IN TEMPLATE:***00ACTIVE***

## #7 HANDS ON CREATE TEMPLATE PRINT SORT

***PRINT*** File Entries
- OUTPUT FROM WHAT FILE:*** DRUG***
- SORT BY: GENERIC NAME// ***]***
- SORT BY: GENERIC NAME// ***@‘DEA["2"***
-    By 'dea', do you mean DRUG 'DEA, SPECIAL HDLG'?*** Y***
-   WITHIN DEA["2", SORT BY: ***+DEA***, SPECIAL
-   START WITH DEA, SPECIAL HDLG: FIRST//
-     WITHIN DEA, SPECIAL HDLG, SORT BY:
- STORE IN 'SORT' TEMPLATE: ***00DEA***
- Print output next slide

**Notes:**
Harmony SORT-PRINT +field then !field subtotal count

## #8 HANDS ON CREATE TEMPLATE PRINT SORT

- FIRST PRINT FIELD: ***!DEA***, SPECIAL HDLG
- THEN PRINT FIELD:
- DEVICE:   DRUG STATISTICS
-                              MAY 17,2007  15:31    PAGE 1
- -------------------------------------------------------------------------------           DEA, SPECIAL HDLG: 2A
- SUBCOUNT  57
-            DEA, SPECIAL HDLG: 2AP
- SUBCOUNT  19
-            DEA, SPECIAL HDLG: 2APR
- SUBCOUNT  1
-            DEA, SPECIAL HDLG: 2AW
- SUBCOUNT  1
- ..............
- COUNT     89

## # 9 HANDS ON CREATE SEARCH TEMPLATE

***SEARCH*** File Entries
- OUTPUT FROM WHAT FILE: ***DRUG***
- -A- SEARCH FOR DRUG FIELD:   *** DEA***, SPECIAL HDLG
-   -A- CONDITION: ***CONTAINS  ***
-   -A- CONTAINS: ***2***
-   -B- SEARCH FOR DRUG FIELD: ***INACTIVE DATE***
-   -B- CONDITION: ***NULL ***
-   -C- SEARCH FOR DRUG FIELD:
- IF: ***AB***    DEA, SPECIAL HDLG CONTAINS "2"    and INACTIVE DATE NULL
- STORE RESULTS OF SEARCH IN TEMPLATE: ***00ACTDEA2***
-   Are you adding ‘00ACTDEA2' as a new SORT TEMPLATE? No// ***Y***
- SORT BY: GENERIC NAME//
- START WITH GENERIC NAME: FIRST//
- FIRST PRINT FIELD:

**Notes:**
Heading (S/C): DRUG SEARCH// 
DEVICE:   TELNET PORT    Right Margin: 80// 
DRUG SEARCH                                    JUL 29,2007  21:11    PAGE 1
--------------------------------------------------------------------------------

                         73 MATCHES FOUND.

## #10 HANDS ON ACCESS SEARCH TEMPLATE-PROCESS AGAIN

***SEARCH*** File Entries
- OUTPUT FROM WHAT FILE: ***DRUG***
-   -A- SEARCH FOR DRUG FIELD: ***[00ACTDEA2***
-  DEA, SPECIAL HDLG CONTAINS "2"
-             and INACTIVE DATE NULL
- STORE RESULTS OF SEARCH IN TEMPLATE:
- SORT BY: GENERIC NAME//
- START WITH GENERIC NAME: FIRST//
- FIRST PRINT FIELD:

**Notes:**
EXTRA TEMPLATE H113ACTDEA2

Heading (S/C): DRUG SEARCH// 
DEVICE:   TELNET PORT    Right Margin: 80// 
DRUG SEARCH                                    JUL 29,2007  21:28    PAGE 1
--------------------------------------------------------------------------------

                         73 MATCHES FOUND.

## #11 HANDS ON ACCESS SEARCH TEMPLATE-RESULTS

***PRINT*** File Entries
- OUTPUT FROM WHAT FILE: ***DRUG***
- SORT BY: GENERIC NAME// ***[00ACTDEA2 ***
-  WITHIN ‘00ACTDEA2' NUMBER, SORT BY:
- FIRST PRINT FIELD:*** ******[00DEA ******   ***
- WANT TO EDIT ‘00DEA' TEMPLATE?*** ******N***
- Heading (S/C): DRUG LIST//

**Notes:**
DEVICE:   TELNET PORT    Right Margin: 80// 
DRUG LIST                                      JUL 29,2007  21:32    PAGE 1
                                DEA,
                                SPECIAL  INACTIVE
GENERIC NAME                    HDLG     DATE
--------------------------------------------------------------------------------

CODEINE PHOS. 60MG SYRINGE      2AP      
CODEINE SULFATE 30MG C.T.       2AP      
HYDROMORPHONE 2MG TAB           2AP      
MEPERIDINE HCL 50MG TAB         2A       
METHADONE HCL 5MG TAB           2AP      
METHADONE HCL 10MG TAB          2AP      
MORPHINE SULFATE 15MG TUBEX     2AP

## #12 HANDS ON ACCESS PRINT SORT and OUPUT TEMPLATE

***PRINT****** ******File Entries***
***PRESCRIPTION ***OR*** 52***
- SORT BY: RX #//  ***[H113.WORKLOAD***
- * Previous selection: FINISH DATE/TIME from Jun 1,2006 to Jun 12,2007@24:00
- START WITH FINISH DATE/TIME: Jun 1,2006//   (JUN 01, 2006)
- GO TO FINISH DATE/TIME: Jun 12,2007//   (JUN 12, 2007)
- FIRST PRINT FIELD: ***[H113.WORKLOAD***
-   WANT TO EDIT 'H113.WORKLOAD' TEMPLATE?*** N***
- Heading (S/C): PRESCRIPTION STATISTICS  Replace
***DEVICE:   TELNET PORT    Right Margin: 80//***
- PRESCRIPTION STATISTICS                        AUG  1,2007  10:48    PAGE 1
-           FINISHING PERSON
- --------------------------------------------------------------------------------
-            FINISHING PERSON: PHARMACIST,THIRTY
- SUBCOUNT  85
-            FINISHING PERSON: PROVIDER,TWOHUNDREDFORTYEIGHT
- SUBCOUNT  1
-            FINISHING PERSON: PROVIDER,TWOHUNDREDFORTYNINE
- SUBCOUNT  20
- COUNT     106**: **

**Notes:**
Made possible by installation of PSO*7*200
Package : OUTPATIENT PHARMACY      Priority   : MANDATORY
Version : 7 SEQ #231                        Status     : RELEASED
                         Compliance Date: MAY 17, 2007 
MISCELLANEOUS ENHANCEMENTS:
---------------------------
1. A new field FINISH DATE/TIME field (#38.3) is added to the
PRESCRIPTION file (#52).

Inspired by class iii enhancements with similar field name.

## #13 HANDS ON ACCESS PRINT SORT and OUPUT TEMPLATE EDIT VIEW

- OUTPUT FROM WHAT FILE: ***52***
- SORT BY: RX #// ***[H113.WORKLOAD***
- WANT TO EDIT 'H113.WORKLOAD' TEMPLATE? NO//*** y***
- NAME: H113.WORKLOAD//
- READ ACCESS:       WRITE ACCESS:
- SORT BY: '@FINISH DATE/TIME//
- * Previous selection: FINISH DATE/TIME from Jun 1,2006 to Jun 12,2007@24:00
- START WITH FINISH DATE/TIME: Jun 1,2006//   (JUN 01, 2006)
- GO TO FINISH DATE/TIME: Jun 12,2007//   (JUN 12, 2007)
-   WITHIN FINISH DATE/TIME, SORT BY: +FINISHING PERSON//
-   START WITH FINISHING PERSON: FIRST//
-     WITHIN FINISHING PERSON, SORT BY:
- STORE IN 'SORT' TEMPLATE:
- FIRST PRINT FIELD:*** [H113.WORKLOAD    ***
- WANT TO EDIT 'H113.WORKLOAD' TEMPLATE? No//*** y***
- NAME: H113.WORKLOAD//
- READ ACCESS:      WRITE ACCESS:
- FIRST PRINT FIELD: FINISHING PERSON!//
- THEN PRINT FIELD:
- Heading (S/C): PRESCRIPTION STATISTICS  Replace
- STORE PRINT LOGIC IN TEMPLATE:
- DEVICE:

## HANDS ON JUMP  PRINT  OUTPUT TEMPLATE EXAMPLE (optional)

**PRESCRIPTION//  inquire or print sort all**
**Select PRESCRIPTION RX #:    500508 [  **** H113.BEERSAGECHECK  ****  **
**                              ****(Jul 13, 2007@11:21) User #1  File #52  **
**WANT TO EDIT 'H113.BEERSAGECHECK' TEMPLATE? No// y  (Yes)**
**NAME: H113.BEERSAGECHECK// **
**FIRST PRINT FIELD: patient://**** **
**  ****THEN PRINT PATIENT FIELD: $S(AGE>65:"BEERS WARNING",1:"YOUNG PATIENT")**
**  ****Replace **
**  ****THEN PRINT PATIENT FIELD: // **
**THEN PRINT FIELD: RX #;C25//   **
**THEN PRINT FIELD: DRUG//   **
**THEN PRINT FIELD: PATIENT//   **
**THEN PRINT FIELD: patient:age****// **
**   ****By 'patient', do you mean PRESCRIPTION 'PATIENT'? Yes//   (Yes)**
**   ****By 'age', do you mean PATIENT 'AGE'? Yes//   (Yes)**
**THEN PRINT FIELD:**

## HANDS ON (Multiple)  PRINT  OUTPUT TEMPLATE EXAMPLE (optional)

- OUTPUT FROM WHAT FILE: PRESCRIPTION//
- SORT BY: RX #// @'refILL
- REFILL SUB-FIELD: .01  REFILL DATE
- START WITH REFILL DATE: FIRST//
-   WITHIN REFILL DATE, SORT BY:
- 'H113.REFILL' TEMPLATE? No// y  (Yes)
- FIRST PRINT FIELD: REFILL//     (multiple)
-   FIRST PRINT REFILL SUB-FIELD: rx;X//
-    By 'rx', do you mean PRESCRIPTION 'RX #'? Yes//   (Yes)
-   THEN PRINT REFILL SUB-FIELD: "@";X//
-   THEN PRINT REFILL SUB-FIELD: DRUG EXPIRATION DATE;L10;X
-   THEN PRINT REFILL SUB-FIELD: "@";X//
-   THEN PRINT REFILL SUB-FIELD: NUMDATE(issue);X//
-    By 'issue', do you mean PRESCRIPTION 'ISSUE DATE'? Yes//   (Yes)
-   THEN PRINT REFILL SUB-FIELD: "@";X//
-   THEN PRINT REFILL SUB-FIELD: (unit pric*qty);X//
-    By 'unit pric', do you mean PRESCRIPTION 'UNIT PRICE OF DRUG'? Yes//   (Yes)
-    By 'qty', do you mean REFILL 'QTY'? Yes//   (Yes)
-   THEN PRINT REFILL SUB-FIELD: "@";X//
-   THEN PRINT REFILL SUB-FIELD: NUMDATE(REFILL DATE);X
-   Replace
-   THEN PRINT REFILL SUB-FIELD: "@";X//
-   THEN PRINT REFILL SUB-FIELD:

## E-TRIP NATIONAL RESORUCE

**Fileman Homepage:**
- _[http://](http://www.va.gov/vdl/application.asp?appid=5)__[www.va.gov/vdl/application.asp?appid](http://www.va.gov/vdl/application.asp?appid=5)__[=5](http://www.va.gov/vdl/application.asp?appid=5)_

**Notes:**
Additional resources
Fileman vista type documentation includes reporting, utilities and file enter edit.

See Advanced User Manual for report functions.

Additional reference slides in 210H

## DATA VALIDATION 

**Does Your Output Make Sense?**
**Random Sample**
**Time Or Single Events (Snowbirds)**
**Intuition**
**Consult An ADPAC Or Expert**
**Other DATA SOURCES,  CPRS QUERY TOOLS, VISTA REPORTS, Clinical Reminders**

**Notes:**
Compare with menu option, at least do a random sample.

SCI appointments in paper book, search for appointments lower than other services.

## PRIVACY REVIEW

** ****For Protected Health Information (PHI)**
**Distribution:  Need to Know- VISTA Email or Outlook with PKI**
**Secure – Encryption or Server**
**Role of  Local VISN Information Security Officer    **
**National Website:**
**https://vaww.ocis.va.gov/portal/server.pt**

## 1-800-HELP ME

**Phone:  Tom Fagan  (804)675-5298**
**EMAIL:  **_[THOMAS.FAGAN@VA.GOV](file:///../../../vharicfagant/itc2001/itc2001home.htm)__[             ](file:///../../../vharicfagant/itc2001/itc2001home.htm)_

## QUESTIONS

**?**