100 likes | 251 Views
WELCOME TO Intermediate VA FILEMAN REPORTS SESSION. Tom Fagan, Pharmacy Benefits Management Clinical Informatics VA FileMan Instructor and Clinical Applications Coordinator at VAMC Richmond, Virginia. LEARNING OBJECTIVES AND CLASS FORMAT.
E N D
WELCOME TO Intermediate VA FILEMAN REPORTS SESSION Tom Fagan, Pharmacy Benefits Management ClinicalInformatics VA FileMan Instructor and Clinical Applications Coordinator at VAMC Richmond, Virginia
LEARNING OBJECTIVES AND CLASS FORMAT • Be able to use select VAFileMan Functions to manage output • Know where to find additional References for Functions • Understand unique SORT strategies used together to SEARCH • Know how to use List File Attributes to identify regular indexed field for efficient SORT or SEARCH • Be Familiar with Intermediate Applications (template sharing, data capture, flatten Multiple) • Understand Importance of Data Validation and Privacy/Security
Select VA FileMan Functions Note: Most work with output and SORT or SEARCH SYNTAX is important = reduce frustration • $E Extract • $P Piece or QARNAME or QARTEXT • NUMDATE • NUMDATE4 • DAYOFWEEK • $S Select Mr for male or Ms. For female
Pharmacy Benefit Management Pharmacy Informatics Training Sharepoint Reference • Symbology reference http://vaww.infoshare.va.gov/sites/vapharmacyinformatics/WIKI/FileMan/FileMan_Symbols.aspx • Terminology http://vaww.infoshare.va.gov/sites/vapharmacyinformatics/WIKI/FileMan_Documents/FileMan_Information/FileMan_basic_reference.pdf • Link to primary source and more details Advanced VA FileMan Manual on VDL http://www.va.gov/vdl/documents/Infrastructure/Fileman/fm22_0um
Unique Sort Strategies • Harmony + Print SORT ! Print Output used to subcount with statistics • SORT [ contains with text string on left side use with $E for shorter ! statement RX Status or Drug name example • Cascading word processing field search ORDER file #100 ORDER ACTION (multiple) ORDER TEXT field example
Indexed Fields • Indentify “REGULAR” with LIST File Attributes • Use in SORT with PRINT FILE Entries • Use in SEARCH with SEARCH FILE Entries
Applications • Multiples unique challenges • Flatten Nth and COUNT • PARAM and SETPARAM • COPY and PASTE Sharing of Print SORT and Print OUTPUT templates • Data Capture Demonstration
1-800-HELP ME Phone: Tom Fagan (804)675-5298 EMAIL: THOMAS.FAGAN@VA.GOV
LOG IN FOR HANDS ON ACCESS: nnVEHU VERIFY: VEHUnn nn number to be assigned by instructor Training Menu 1 List File Attributes 2 Inquire to File Entries 3 Print File Entries 4 Search File Entries 5 Template Edit