Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

CHCS Virtual Classroom _VC_ Instructor Guide For FileMan _FM

VIEWS: 41 PAGES: 89

									                       DEFENSE HEALTH INFORMATION MANAGEMENT SYSTEM




     CHCS Virtual Classroom (VC) Instructor Guide
                         For
        FileMan (FM): CHCS Basic Ad Hoc IV




                                       Visit Us Online at:
                                    http://dhims.health.mil

The DHIMS Program Office is a component of the Military Health System Office of the Chief Information Officer.
                               Course Notes

              • Purpose of Course
              • Target Audience

              • Environment for Application Share

              • Acronyms/Pronunciations




           February 2007             FM: Basic Ad Hoc IV, v2           2




Purpose of Course:
This is a continuation class of CHCS Basic Ad Hoc I - II and covers standard
techniques applied when preparing print statements. Examples illustrate the use of
print qualifiers, as introduced in the Supplementary Handout for the Basic Ad Hoc
virtual classroom courses (sessions I-II).
Target Audience:
CHCS ad hoc users (across all CHCS functionalities) who are tasked to retrieve
information from the CHCS database. This includes file/table points of contact
(POCs) who need to manage their files, as well as personnel who need to create
lists of data or statistical reports.
Environment for Application Share:
N/A

Acronyms/Pronunciations:
A list of acronyms is provided on the following slide.




                                                                                     2
                           Course Notes (cont.)

                                       Acronyms

           Acronym         Pronunciation          Description
           CHCS            C-H-C-S                Composite Health Care System
           FM              F-M                    FileMan
           MUMPS           MUMPS                  Massachusetts General Hospital
                                                   Utility Multi-Programming System
           RAM             RAM                    Random Access Memory
           1SD             1-S-D                  One Standard Deviation
           SME             S-M-E                  Subject Matter Experts
           TDB             T-D-B                  CHCS Training Database
           UDK             U-D-K                  User Defined Keys
           VC              V-C                    Virtual Classroom
           X-Ref           Cross Reference        Cross-Reference


           February 2007              FM: Basic Ad Hoc IV, v2                         3




Instructor Notes:
This table shows the acronyms used in this course.




                                                                                          3
                           FileMan (FM):
                          Basic Ad Hoc IV


                            For Beginning Ad Hoc Writers




Instructor Notes:
Be sure to perform sound checks before starting the presentation.
Text:
Welcome to the Basic Ad Hoc IV virtual classroom (VC) presentation. This training is
designed for beginning ad hoc users who have completed Basic Ad Hoc I and Basic
Ad Hoc II. Having completed the Basic Ad Hoc III course would be a plus; however, it
is not a prerequisite.
My name is _________, and I will be your presenter today and __________ is my co-
moderator.




                                                                                       4
                             Table of Contents

           Agenda                                                     6
           Course Objectives                                          7
           Introduction                                               8
           Lesson 1: Format Data Output                               9
           Lesson 2: Control Column Headers                          35
           Lesson 3: Generate Statistics                             49
           Lesson 4: Use Print Qualifiers for Special Applications   66
           Course Summary                                            86
           References                                                87
           Supplementary Resources                                   88
           Questions                                                 89


           February 2007              FM: Basic Ad Hoc IV, v2         5




Instructor Notes:
Skip this slide. It is intended for the hard copy reader.




                                                                          5
                                      Agenda
               Course Objectives
               Introduction
               Lesson 1: Format Data Output
               Lesson 2: Control Column Headers
               Lesson 3: Generate Statistics
               Lesson 4: Use Print Qualifiers for Special Applications
               Course Summary
               References
               Supplementary Resources
               Questions



           February 2007              FM: Basic Ad Hoc IV, v2                   6




Text:
Here is the agenda that we will follow in this presentation [read the slide].
We will take a short break after Lesson 2.




                                                                                    6
                           Course Objectives
            Upon completion of this course, you will be able to
            effectively use print qualifiers to:
            - Specify format of data presented in the output and
              column headers
            - Generate statistical reports
            - Accomplish unique tasks, such as concatenating fields,
              creating or calling up templates, and opening up multiple-
              valued fields where only one sub-field is defined




           February 2007            FM: Basic Ad Hoc IV, v2           7




Text:
These are the course objectives [read the slide].




                                                                           7
                                   Introduction

            • Need for Training
            • Target Audience
            • Methodology
                  - PowerPoint Slides
                  - CHCS Screen Captures
                  - Quiz/Polling Questions




           February 2007               FM: Basic Ad Hoc IV, v2              8




Instructor Notes:
Read the bullets.
Text:
It is important to understand how to effectively use FileMan (FM) print qualifiers to
define output format, to control column headers, to generate statistical tabulations,
and for special applications. Currently, there is limited training available on how to
use FileMan to generate ad hoc reports, and existing CHCS help text does not
address how to create such reports.
This course will assist in meeting the training needs of beginning ad hoc users that
have completed the Basic Ad Hoc I and II class prerequisites.
The presentation today will include PowerPoint slides, as well as CHCS screen
captures. Throughout the course, you have questions to answer so that you can test
your understanding of the content as we go along.
Now, let’s get started with Lesson 1.




                                                                                         8
             Lesson 1: Format Data Output

          Topic 1: Specify Column Position
          Topic 2: Specify Right/Left Justify
          Topic 3: Specify Word-Wrap
          Topic 4: Specify Decimal Accuracy
          Topic 5: Specify Row/Line Position (Y axis)
          Topic 6: Suppress Duplicate Values




Text:
In Lesson 1, we will show you how to use print qualifiers to format data output. The
topics for this lesson are listed here. [Read the lesson title and topics.]




                                                                                       9
                         Lesson 1 Objective:
              Specify format of data presented in the output and
              column headers.




Instructor Notes:
Read the lesson objective when indicated in the text.
Text:
This is the objective. By the end of this lesson, you will be able to [read objective].
As a starting point, let’s begin by setting up a report that runs quickly, but the output
is unformatted.




                                                                                            10
                    {Captioned Data for a Record from the Radiology Reports file}

         RADIOLOGY REPORTS LIST                         21 Jun 2001@1150    PAGE 1
         -------------------------------------------------------------------------
         DATE/TIME CREATED: 18 Jun 2001@0341       PATIENT NAME: ROBBINS,ALLAN A
         EXAM DATE/TIME: 18 Jun 2001@0200          REPORT STATUS: VERIFIED
         DATE REPORT ENTERED: 18 Jun 2001@0342     VERIFIED DATE: 18 Jun 2001@0342
         RECORDED BY: RAD,RF           RECORDER'S DIVISION: DIV A - TRAINING HOSPITAL
         VERIFIED BY: RAD,RF           RESULT CODE: NORMAL
         INTERPRETING RADIOLOGIST: REDMAN,ALLAN A      APPROVING RADIOLOGIST: RAD,RF
         STANDARD TEXT USED: USED
          REPORT TEXT:
          The lungs are expanded and clear. The cardiomediastinal silhouette is normal.
          No significant abnormalities are seen in the thorax.

          IMPRESSION: NORMAL CHEST.




          February 2007                   FM: Basic Ad Hoc IV, v2                   11




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
This is the captioned output from a completed record in the Radiology Reports file.
Let’s review a few fields that CHCS populated as the exam was processed. The
date the report was manually entered as a dictated entry is recorded in the
‘DATE/TIME CREATED’ field. Note that the ‘EXAM DATE/TIME’ field displays when
the exam was initially arrived (checked in) at 0200. When the status was changed to
“transcribed” it was captured by the ‘DATE REPORT ENTERED’ field. When the
report was verified (approved by the radiologist) is captured by the ‘VERIFIED
DATE’ field. Finally, we see the APPROVING RADIOLOGIST and the report text
that was sent out to the health care provider (HCP) who requested the examination.
Let’s proceed to the next slide to see which of these fields can be used in an ad hoc
report to quickly select a group of verified records within a given date range.




                                                                                          11
                 {Listing of Regular/Multiple X-Ref Fields – Radiology Reports file}

          FIELD LIST                                     21 Jun 2001@1454    PAGE 1
          -------------------------------------------------------------------------
          [D .01     ] DATE/TIME CREATED(B)
          [D .01     ] DATE/TIME CREATED(ADA)-->MULTIPLE^^^ 74,.01,74,8602
          [D .01     ] DATE/TIME CREATED(ADR)-->MULTIPLE^^^74,.01,74,9
          [P 2       ] PATIENT NAME(C)
          [D 3       ] EXAM DATE/TIME(APRV)-->MULTIPLE^^^74,8608,74,3
          [D 3       ] EXAM DATE/TIME(AF)
          [P 9       ] RECORDED BY(ADR)-->MULTIPLE^^^74,.01,74,9
          [P 8601    ] INTERPRETING RADIOLOGIST(AD)
          [P 8602    ] APPROVING RADIOLOGIST(ADA)-->MULTIPLE^^^74,.01,74,8602
          [P 8608    ] XREF FOR APPROVING(APRV)-->MULTIPLE^^^74,8608,74,3
          [P 8608    ] XREF FOR APPROVING(AC)
          [P 8609    ] SUPERVISING RADIOLOGIST(AE)




           February 2007                  FM: Basic Ad Hoc IV, v2                      12




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
This is the familiar output we obtain by using the FileMan-Master User Defined Key
(UDK) Library, as presented in earlier FileMan courses. Notice that ADA is a
Multiple X-Ref, linking the ‘DATE/TIME CREATED’ and the ‘APPROVING
RADIOLOGIST’ fields, and also the sort order specified on these two fields. The
sequence presented is that the first sort is to be made on the .01 field (DATE/TIME
CREATED), and the next sort is on the 8602 field (APPROVING RADIOLOGIST).
We will set up a sort to target all verified reports that have been approved by
RAD,RF for records created in June 2001.
Let’s proceed to the next slide to set up a sort template, taking advantage of this
multiple X-Ref to initially pare down the database.




                                                                                            12
                          {Initial Sort Statements – Radiology Reports file}

          Select FileMan Menu Option: Print File Entries

          Output from what file: RADIOLOGY REPORTS
          Sort by: 'DATE/TIME CREATED;XADA
          Earliest DATE/TIME CREATED: 20 Jun 2001
          Latest DATE/TIME CREATED: 20 Jun 2001@2359
            Within DATE/TIME CREATED, Sort by: '@APPROVING RADIOLOGIST;1
            Select APPROVING RADIOLOGIST: RAD,RF
              Within APPROVING RADIOLOGIST, Sort by: @VERIFIED DATE
              Earliest VERIFIED DATE: FIRST//
                Within VERIFIED DATE, Sort by: ]
                Within VERIFIED DATE, Sort by:
          Store Sort logic in Template: ECD RAD REPORT
             Are you adding 'ECD RAD REPORT' as a new SORT TEMPLATE? Y (YES)




          February 2007                    FM: Basic Ad Hoc IV, v2             13




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
This is the screen capture of sort statements applied to the Radiology Reports file.
As a review of techniques presented in the VC for Basic Ad Hoc III, notice how the
ADA X-Ref is specified in the initial sort statement, and how we ensure that only
approved reports are captured on the subsequent sort by selecting an APPROVING
RADIOLOGIST. The next sort eliminates any reports that are not verified (by
accepting the FIRST// default) and stacks up the records in chronological order by
when they were verified.
Let’s now proceed to the next set of slides to learn about print statements.




                                                                                       13
                          {Initial Print Statements – Radiology Reports file}

          First Print FIELD: PATIENT NAME
          Then Print FIELD: TIME(EXAM DATE/TIME)
          Then Print FIELD: EXAM DATE/TIME
          Then Print FIELD:

          ==============================[output]===================================

                          Personal Data - Privacy Act of 1974 (PL 93-579)
          RADIOLOGY REPORTS LIST                         21 Jun 2001@0930    PAGE 1
                                          TIME(EXAM
          PATIENT NAME                    DATE/TIME) EXAM DATE/TIME
          -------------------------------------------------------------------------
          ROBBINS,ALLAN A                 3:00 AM     20 Jun 2001@0300
          ROBBINS,BARBARA B               3:05 AM     20 Jun 2001@0305
          ROBBINS,CHARLES C               3:05 AM     20 Jun 2001@0305
          ROBBINS,DONNA D                 3:10 AM     20 Jun 2001@0310
          ROBBINS,EARL E                  3:15 AM     20 Jun 2001@0315
          ROBBINS,FLORENCE F              3:20 AM     20 Jun 2001@0320
          ROBBINS,GEORGE G                3:25 AM     20 Jun 2001@0325
          ZELLER,ALLAN A                  11:08 AM    20 Jun 2001@1108
          NORRIS,A2                       4:03 PM     20 Jun 2001@1603


          February 2007                     FM: Basic Ad Hoc IV, v2                   14




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of a few print statements used to generate the partial
list shown beneath. Notice that there is much unused space between the first two
columns displayed. We’ll address this in our next topic.
Let’s now proceed to the next topic to learn about print statements applied to format
output.




                                                                                           14
               Topic 1: Specify Column Position

                   Focus: Column { Cn } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces the print qualifier used to specify column position to print the
results.




                                                                                         15
                           {Introducing the Column Position (Cn) Print Qualifier}

           First Print FIELD: PATIENT NAME;C1
           Then Print FIELD: TIME(EXAM DATE/TIME);C21;"EXAM AT"
           Then Print FIELD: EXAM DATE/TIME;C31
           Then Print FIELD:

           ==============================[output]===================================

                           Personal Data - Privacy Act of 1974 (PL 93-579)
           RADIOLOGY REPORTS LIST                         21 Jun 2001@0924    PAGE 1
           PATIENT NAME
                               EXAM AT   EXAM DATE/TIME
           --------------------------------------------------------------------------
           ROBBINS,ALLAN A     3:00 AM   20 Jun 2001@0300
           ROBBINS,BARBARA B   3:05 AM   20 Jun 2001@0305
           ROBBINS,CHARLES C   3:05 AM   20 Jun 2001@0305
           ROBBINS,DONNA D     3:10 AM   20 Jun 2001@0310
           ROBBINS,EARL E      3:15 AM   20 Jun 2001@0315
           ROBBINS,FLORENCE F 3:20 AM    20 Jun 2001@0320
           ROBBINS,GEORGE G    3:25 AM   20 Jun 2001@0325
           ZELLER,ALLAN A      11:08 AM 20 Jun 2001@1108
           NORRIS,A2           4:03 PM   20 Jun 2001@1603


           February 2007                      FM: Basic Ad Hoc IV, v2                   16




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of three print statements used to generate the partial
list shown beneath. This time, the column number is specified in the print
statements, and you can see that the spacing between columns has improved.
Notice also that the column headers are on two different lines, and that is because
we have not placed any limits on the length in the print statement. Even though the
data fits neatly on one line per record, the column headers wrap.
Let’s now proceed to the next set of slides to learn about print qualifiers that restrict
the length of columns and headers.




                                                                                             16
              Topic 2: Specify Right/Left Justify

               Focus: Right/Left { Rn/Ln } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces the print qualifiers used to specify the output and column
header length limit, along with forcing right or left justification.




                                                                                   17
                       {Introducing the Left Justify/Length (Ln) Print Qualifier}

           First Print FIELD: PATIENT NAME;C1;L18
           Then Print FIELD: TIME(EXAM DATE/TIME);C21;L8;"EXAM AT"
           Then Print FIELD: EXAM DATE/TIME;C31;L16
           Then Print FIELD:

           ==============================[output]===================================

                           Personal Data - Privacy Act of 1974 (PL 93-579)
           RADIOLOGY REPORTS LIST                         21 Jun 2001@0947    PAGE 1
           PATIENT NAME        EXAM AT   EXAM DATE/TIME
           -------------------------------------------------------------------------
           ROBBINS,ALLAN A     3:00 AM   20 Jun 2001@0300
           ROBBINS,BARBARA B   3:05 AM   20 Jun 2001@0305
           ROBBINS,CHARLES C   3:05 AM   20 Jun 2001@0305
           ROBBINS,DONNA D     3:10 AM   20 Jun 2001@0310
           ROBBINS,EARL E      3:15 AM   20 Jun 2001@0315
           ROBBINS,FLORENCE F 3:20 AM    20 Jun 2001@0320
           ROBBINS,GEORGE G    3:25 AM   20 Jun 2001@0325
           ZELLER,ALLAN A      11:08 AM 20 Jun 2001@1108
           NORRIS,A2           4:03 PM   20 Jun 2001@1603



           February 2007                      FM: Basic Ad Hoc IV, v2                  18




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the same three fields used in print statements to
generate the partial list shown beneath. This time, the length limit is specified in the
print statements by adding an “L” with the number of characters following (e.g.,
L18). You can see that this resolves the problem of the column headers wrapping
onto two lines.
Before exploring the Rn print qualifier, let’s look at an important aspect of the Ln
print qualifier.




                                                                                            18
                              {Truncation Aspect of the (Ln) Print Qualifier}

           First Print FIELD: PATIENT NAME;C1;L11
           Then Print FIELD: TIME(EXAM DATE/TIME);C14;L8;"EXAM AT"
           Then Print FIELD: EXAM DATE/TIME;C24;L11
           Then Print FIELD: NUMBER;C40;L6
           Then Print FIELD: NUMBER;C50;L2
           Then Print FIELD:
           ==============================[output]===================================

                           Personal Data - Privacy Act of 1974 (PL 93-579)
           RADIOLOGY REPORTS LIST                         21 Jun 2001@0956    PAGE 1
           PATIENT                EXAM
           NAME         EXAM AT   DATE/TIME         NUMBER NU
           -------------------------------------------------------------------------
           ROBBINS,ALL 3:00 AM    20 Jun 2001@0300 219      21
           ROBBINS,BAR 3:05 AM    20 Jun 2001@0305 220      22
           ROBBINS,CHA 3:05 AM    20 Jun 2001@0305 221      22
           ROBBINS,DON 3:10 AM    20 Jun 2001@0310 222      22
           ROBBINS,EAR 3:15 AM    20 Jun 2001@0315 223      22
           ROBBINS,FLO 3:20 AM    20 Jun 2001@0320 224      22
           ROBBINS,GEO 3:25 AM    20 Jun 2001@0325 225      22
           ZELLER,ALLA 11:08 AM 20 Jun 2001@1108 291        29
           NORRIS,A2    4:03 PM   20 Jun 2001@1603 238      23

           February 2007                      FM: Basic Ad Hoc IV, v2                  19




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
at the bottom. Note that the result of using the Ln print qualifier differs according to
the data type of the field. In the first column, the left-justified 11-character restriction
applies equally to the column header text and to the output. The 12-character field
name cannot fit within the 11-character restriction, and since the name is composed
of more than one word, the field name is presented as column header text on two
rows with a length limit up to 11 characters. The name is truncated after 11
characters. In the third column, the text of the column header text is packaged into
two rows, as was the patient name in the first column, but the date/time data
remains intact. The last column provides an example of applying this print qualifier
to a field having a numeric data type. The left-justified 2-character restriction applies
equally to the column header text and to the output. Before leaving this slide, notice
the second column and the effect of left-justification that prevents the exam time of
Zeller,Alla to align on the AM/PM part.
Let’s now proceed to a slide showing the Rn print qualifier.




                                                                                               19
                              {Truncation Aspect of the (Rn) Print Qualifier}

           First Print FIELD: PATIENT NAME;C1;R11
           Then Print FIELD: TIME(EXAM DATE/TIME);C21;R8;"EXAM AT"
           Then Print FIELD: EXAM DATE/TIME;C31;R11
           Then Print FIELD: NUMBER;C50;R6
           Then Print FIELD: NUMBER;C58;R2
           Then Print FIELD:
           ==============================[output]===================================

                           Personal Data - Privacy Act of 1974 (PL 93-579)
           RADIOLOGY REPORTS LIST                         21 Jun 2001@1012    PAGE 1
               PATIENT                          EXAM
                  NAME          EXAM AT    DATE/TIME        NUMBER NU
           -------------------------------------------------------------------------
           ROBBINS,ALLAN A      3:00 AM 20 Jun 2001@0300       219 219
           ROBBINS,BARBARA B    3:05 AM 20 Jun 2001@0305       220 220
           ROBBINS,CHARLES C    3:05 AM 20 Jun 2001@0305       221 221
           ROBBINS,DONNA D      3:10 AM 20 Jun 2001@0310       222 222
           ROBBINS,EARL E       3:15 AM 20 Jun 2001@0315       223 223
           ROBBINS,FLORENCE F   3:20 AM 20 Jun 2001@0320       224 224
           ROBBINS,GEORGE G     3:25 AM 20 Jun 2001@0325       225 225
           ZELLER,ALLAN A      11:08 AM 20 Jun 2001@1108       291 291
             NORRIS,A2          4:03 PM 20 Jun 2001@1603       238 238

           February 2007                      FM: Basic Ad Hoc IV, v2                  20




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
at the bottom. The “Rn” print qualifier applies to both column headers and output
data and has a two-fold purpose to right-justify and to restrict length. Note that the
result of using the Rn print qualifier differs according to the data type of the field. In
the first column, the right-justified 11-character restriction applies to the column
header text but not to the output. The column header text is repackaged into two
rows that are right-justified with a length up to 11 characters. The name is not
truncated, but displays fully. We see the same effect to the column header text and
output in the third column. The last column provides an example of applying this
print qualifier to a field having a numeric data type. The right-justified 2-character
restriction applies to the column header text, but not to the output. Finally, notice
how the output of records in the second column align neatly in a very readable
format.
Before moving on to a new print qualifier, I have a question for you to answer.




                                                                                             20
                           Lesson 1 Question 1
         Elizabeth Margaret Kellner was seen in Radiology on 20 June
         2001 at 1638. An ad hoc print template was created using the
         following print statements:
              First Print FIELD: PATIENT NAME;C1;L18;X
              Then Print FIELD: EXAM DATE/TIME;C21;L16

         Ms. Kellner’s name is more than 18 characters in length. What
         would you expect to be the outcome based on the
         print statements?
         1. The name and exam date/time will print on the same line.
         2. The name and exam date/time will print on different lines.
         3. There is not enough information to be certain.



           February 2007              FM: Basic Ad Hoc IV, v2            21




Instructor Notes:
The correct answer is 1.
Text:
The free text patient name is truncated after 18 characters, which enables the exam
date/time to print on the same line, beginning in column 21.
Next, let’s find out how to manage reports containing word processing fields.




                                                                                      21
                        Topic 3: Specify Word-Wrap

                 Focus: Word-Wrap { Wn } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces the print qualifier used to specify the output display width when
printing a word-processing field.




                                                                                          22
                           {Introducing the Word-wrap (Wn) Print Qualifier}

           First Print FIELD: PATIENT NAME;C1;L18
           Then Print FIELD: TIME(EXAM DATE/TIME);C21;R8;"EXAM AT"
           Then Print FIELD: EXAM DATE/TIME;C31;L16
           Then Print FIELD: "Report Text: ";C3;X
           Then Print FIELD: REPORT TEXT;C1;W80;""
           Then Print FIELD:
           ==============================[output]===================================

                         Personal Data - Privacy Act of 1974 (PL 93-579)
           RADIOLOGY REPORTS LIST                         21 Jun 2001@1456    PAGE 1
           PATIENT NAME         EXAM AT EXAM DATE/TIME
           -------------------------------------------------------------------------
           ROBBINS,ALLAN A      3:00 AM 20 Jun 2001@0300
           Report Text:
           MULTIPLE LONGITUDINAL AND TRANSVERSE REAL-TIME SCANS SHOW HOMOGENEOUS AND
           ECHOGENIC STRUCTURES BILATERALLY. THERE IS NO EVIDENCE OF MASS OR
           OBSTRUCTION. THE RENAL CALYCES APPEAR NORMAL.




           February 2007                  FM: Basic Ad Hoc IV, v2                      23




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
shown beneath. The Wn print qualifier allows you to specify the output width of the
word-processing field. In this example, 80 characters is the full width of the screen.
Notice that neither the Ln or Rn print qualifier is applied to a word processing print
statement.
Let’s now proceed to the next topic and find out about managing decimal accuracy.




                                                                                            23
              Topic 4: Specify Decimal Accuracy

                   Focus: Decimal { Dn } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces a print qualifier that is used for statistical reports.




                                                                                24
                  {Print Statement w/o Print Qualifier to Designate Decimal Places}

          First Print FIELD: PATIENT NAME;C1;L18
          Then Print FIELD: EXAM DATE/TIME;C21;L16
          Then Print FIELD: VERIFIED DATE;C39;L16
          Then Print FIELD: MINUTES(VERIFIED DATE,EXAM DATE/TIME)/60;C57;L7;"TAT HRS"
          Then Print FIELD:

          ==============================[output]===================================

           Personal Data - Privacy Act of 1974 (PL 93-579)
          RADIOLOGY REPORTS LIST                         21 Jun 2001@1055    PAGE 1
          PATIENT NAME        EXAM DATE/TIME    VERIFIED DATE     TAT HRS
          -------------------------------------------------------------------------
          ROBBINS,ALLAN A     20 Jun 2001@0300 20 Jun 2001@0407 1.11666
          ROBBINS,BARBARA B   20 Jun 2001@0305 20 Jun 2001@0408 1.05
          ROBBINS,CHARLES C   20 Jun 2001@0305 20 Jun 2001@0409 1.06666
          ROBBINS,DONNA D     20 Jun 2001@0310 20 Jun 2001@0410 1
          ROBBINS,EARL E      20 Jun 2001@0315 20 Jun 2001@0411 .933333
          ROBBINS,FLORENCE F 20 Jun 2001@0320 20 Jun 2001@0411 .85
          ROBBINS,GEORGE G    20 Jun 2001@0325 20 Jun 2001@0412 .783333
          ZELLER,ALLAN A      20 Jun 2001@1108 20 Jun 2001@1120 .2
          NORRIS,A2           20 Jun 2001@1603 20 Jun 2001@1603 0

           February 2007                  FM: Basic Ad Hoc IV, v2                     25




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
shown beneath. The MINUTES function, illustrated on the last print statement, is a
commonly used tool to generate turn-around-time (TAT) reports. In this example,
the minutes difference between the verified date and the exam date/time is divided
by 60 to report the difference in hours. Notice the results in the final column. The
numbers have many more than 2 decimal places in some cases, and none in
others.
Let’s proceed to the next slide and see how to round the result to two decimal
places.




                                                                                           25
                 {Introducing the (Dn) Print Qualifier to Designate Decimal Places}

          First Print FIELD: PATIENT NAME;C1;L18
          Then Print FIELD: EXAM DATE/TIME;C21;L16
          Then Print FIELD: VERIFIED DATE;C39;L16
          Then Print FIELD: MINUTES(VERIFIED DATE,EXAM DATE/TIME)/60;C57;D2;"TAT HRS"
          Then Print FIELD:

          ==============================[output]===================================

           Personal Data - Privacy Act of 1974 (PL 93-579)
          RADIOLOGY REPORTS LIST                         21 Jun 2001@1055    PAGE 1
          PATIENT NAME        EXAM DATE/TIME    VERIFIED DATE       TAT HRS
          -------------------------------------------------------------------------
          ROBBINS,ALLAN A     20 Jun 2001@0300 20 Jun 2001@0407        1.12
          ROBBINS,BARBARA B   20 Jun 2001@0305 20 Jun 2001@0408        1.05
          ROBBINS,CHARLES C   20 Jun 2001@0305 20 Jun 2001@0409        1.07
          ROBBINS,DONNA D     20 Jun 2001@0310 20 Jun 2001@0410        1.00
          ROBBINS,EARL E      20 Jun 2001@0315 20 Jun 2001@0411        0.93
          ROBBINS,FLORENCE F 20 Jun 2001@0320 20 Jun 2001@0411         0.85
          ROBBINS,GEORGE G    20 Jun 2001@0325 20 Jun 2001@0412        0.78
          ZELLER,ALLAN A      20 Jun 2001@1108 20 Jun 2001@1120        0.20
          NORRIS,A2           20 Jun 2001@1603 20 Jun 2001@1603        0.00

           February 2007                  FM: Basic Ad Hoc IV, v2                     26




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
shown beneath. The last print statement was changed from the previous slide to
include the Dn print qualifier application to round the result to two decimal places.
Notice the results in the final column.
Let’s proceed to the next topic and a new print qualifier to specify the line number
for output to print.




                                                                                           26
                         Topic 5: Specify Row/Line
                             Position (Y axis)

                        Focus: Y axis { Yn } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces the print qualifier that enables you to specify the exact line/row
on the page for a line of text to print. One commonly used application of this print
qualifier has to do with printing custom labels. Another application is to print patient
demographic information at the bottom of each page. This is particularly useful with
certain reports that include word processing text that cause footers to print at the top
of the following page.




                                                                                           27
                           {Introducing the Y Axis (Yn) Print Qualifier}

          First Print FIELD: PATIENT NAME;C1;L18
          Then Print FIELD: TIME(EXAM DATE/TIME);C21;R8;"EXAM AT"
          Then Print FIELD: EXAM DATE/TIME;C31;L16
          Then Print FIELD: "Report Text: ";C3;X
          Then Print FIELD: REPORT TEXT;C1;W80;""
          Then Print FIELD: "Interp Radiologist: ";C1;L39;Y40;X
          Then Print FIELD: "Approv Radiologist: ";C42;L38;X
          ==============================[output]===================================
                        Personal Data - Privacy Act of 1974 (PL 93-579)
          RADIOLOGY REPORTS LIST                         21 Jun 2001@1456    PAGE 1
          PATIENT NAME         EXAM AT EXAM DATE/TIME
          -------------------------------------------------------------------------
          ROBBINS,ALLAN A      3:00 AM 20 Jun 2001@0300
          Report Text:
          MULTIPLE LONGITUDINAL AND TRANSVERSE REAL-TIME SCANS SHOW HOMOGENEOUS AND
          ECHOGENIC STRUCTURES BILATERALLY. THERE IS NO EVIDENCE OF MASS OR
          OBSTRUCTION. THE RENAL CALYCES APPEAR NORMAL.

          ... And on line 40:
          Interp Radiologist: REDMAN,ALLAN A            Approv Radiologist: RAD,RF



           February 2007                 FM: Basic Ad Hoc IV, v2                      28




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
shown beneath. Note the last print statement where the interpreting and approving
radiologists are defined to print on row 40. When specifying ;Yn, you must account
for any page header that is displayed, unless "n" is a negative number. That is, the
header is counted in the number of lines if "n" is a positive number, and the field will
print on that line, as counted from the top of the page. If it is negative, the field is
printed on that line, as counted up from the bottom.
Let’s now proceed to the next topic.




                                                                                           28
               Topic 6: Suppress Duplicate Values

                            Focus: { N } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic covers the last print qualifier in this lesson, the one that enables you to
suppress printing of duplicate values.




                                                                                         29
                               {No Suppression of Printing Duplicate Values}

          First Print FIELD: PATIENT NAME;C1;L18
          Then Print FIELD: TIME(EXAM DATE/TIME);C21;R8;"EXAM AT"
          Then Print FIELD: EXAM DATE/TIME;C31;L16
          Then Print FIELD: INTERPRETING RADIOLOGIST;C49;L18

          ==============================[output]===================================

                           Personal Data - Privacy Act of 1974 (PL 93-579)
          RADIOLOGY REPORTS LIST                         21 Jun 2001@0947    PAGE 1
          PATIENT NAME         EXAM AT EXAM DATE/TIME     INTERPRETING RADIOLOGIST
          --------------------------------------------------------------------------
          ROBBINS,ALLAN A      3:00 AM 20 Jun 2001@0300 REDMAN,ALLAN A
          ROBBINS,BARBARA B    3:05 AM 20 Jun 2001@0305 REDMAN,ALLAN A
          ROBBINS,CHARLES C    3:05 AM 20 Jun 2001@0305 REDMAN,ALLAN A
          ROBBINS,DONNA D      3:10 AM 20 Jun 2001@0310 REDMAN,ALLAN A
          ROBBINS,EARL E       3:15 AM 20 Jun 2001@0315 REDMAN,ALLAN A
          ROBBINS,FLORENCE F   3:20 AM 20 Jun 2001@0320 REDMAN,ALLAN A
          ROBBINS,GEORGE G     3:25 AM 20 Jun 2001@0325 REDMAN,ALLAN A
          ZELLER,ALLAN A      11:08 AM 20 Jun 2001@1108 REDMAN,ALLAN A
          NORRIS,A2            4:03 PM 20 Jun 2001@1603 RAD,RF



           February 2007                      FM: Basic Ad Hoc IV, v2                  30




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
shown beneath. Added is the final print statement to print the name of the
interpreting radiologist. Note how the same name appears multiple times in the final
column. Let’s proceed to the next slide to see how this can be modified to suppress
the duplicates from printing.




                                                                                            30
            {Introducing ( N ) Print Qualifier to Suppress Printing Duplicate Values}

          First Print FIELD: PATIENT NAME;C1;L18
          Then Print FIELD: TIME(EXAM DATE/TIME);C21;R8;"EXAM AT"
          Then Print FIELD: EXAM DATE/TIME;C31;L16
          Then Print FIELD: INTERPRETING RADIOLOGIST;C49;L18;N

          ==============================[output]===================================

                           Personal Data - Privacy Act of 1974 (PL 93-579)
          RADIOLOGY REPORTS LIST                         21 Jun 2001@0947    PAGE 1
          PATIENT NAME         EXAM AT EXAM DATE/TIME     INTERPRETING RADIOLOGIST
          --------------------------------------------------------------------------
          ROBBINS,ALLAN A      3:00 AM 20 Jun 2001@0300 REDMAN,ALLAN A
          ROBBINS,BARBARA B    3:05 AM 20 Jun 2001@0305
          ROBBINS,CHARLES C    3:05 AM 20 Jun 2001@0305
          ROBBINS,DONNA D      3:10 AM 20 Jun 2001@0310
          ROBBINS,EARL E       3:15 AM 20 Jun 2001@0315
          ROBBINS,FLORENCE F   3:20 AM 20 Jun 2001@0320
          ROBBINS,GEORGE G     3:25 AM 20 Jun 2001@0325
          ZELLER,ALLAN A      11:08 AM 20 Jun 2001@1108
          NORRIS,A2            4:03 PM 20 Jun 2001@1603 RAD,RF



           February 2007                      FM: Basic Ad Hoc IV, v2                  31




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
shown beneath. This time, the N print qualifier is added to the last print statement.
Note that Redman, Allan A displays next to the initial record only, and is not printed
next to subsequent records. At the bottom is the first record where RAD,RF served
as the interpreting radiologist.
That completes the print qualifiers to be introduced in this lesson. Before moving
on, I have a question for you to answer.




                                                                                            31
                           Lesson 1 Question 2
          Choose the best answer that describes the application of the
          Wn print qualifier, as illustrated in the following print statement:

                    Then Print FIELD: COMMENT;C20;W40;"Comment"

          1. “40” specifies the field width to print before word-wrap is invoked.
          2. It is possible for data to print up to column 60.
          3. This print qualifier can only be used for word-processing fields.
          4. This print qualifier is never used in conjunction with Rn or Ln print
             qualifiers on the same print statement.
          5. All of the above statements are true.




           February 2007                 FM: Basic Ad Hoc IV, v2                     32




Instructor Notes:
The correct answer is 5.
Text:
All answers are correct. Remember that the “Wn” print qualifier applies to word-
processing fields only and is never used in conjunction with other print qualifiers that
restrict length. It enables you to specify the number of characters to be displayed on
a line before invoking word-wrap. In the example presented, word-processing data is
defined to begin printing on column 20. There is an allowance of up to 40 characters
to print on this line before word-wrap is invoked and remaining data starts printing on
the next line at column 20.
This completes Lesson 1 topics, so let’s review the key points from this lesson.




                                                                                           32
                                   Lesson 1 Review
          { Cn/Ln    No column or output restriction to placement or length of
          undefined} characters.

          { Cn }            Column header and output to print in column ‘n’.

                            If Rn/Ln is not defined, the data dictionary will invoke word-
          { Cn }            wrap for column headers and output if there is insufficient
                            space to allow the maximum length of a field.

          { Ln/Rn }         Left or Right Justify and Restrict Length to ‘n’ characters.

                            Absolute length restriction and justification of headers and
          { Ln }            output of free text or numeric data types. No length restriction
                            effect on date data type output.
                            Absolute length restriction and justification of headers. No
          { Rn }
                            length restriction to any data type output.


            February 2007                     FM: Basic Ad Hoc IV, v2                        33




Instructor Notes:
When mentioned in the text, go over the table and review the items listed.
The review continues in the next slide.
Text:
This table summarizes features of the Cn, Ln, and Rn print qualifiers
presented in this lesson.




                                                                                                  33
                              Lesson 1 Review (cont.)

                            For use with word-processing fields, defines the field width to
           { Wn }
                            print. Not to be used in conjunction with Rn or Ln qualifiers.
                            For use with numeric fields or computations that yield numeric
           { Dn }
                            results. The result is rounded to ‘n’ decimal places.
                            For specifying the row or line number to print. If “n” is positive,
                            this would be the number of lines down from the top of the
           { Yn }
                            page, including lines used by the header. If “n” is negative, this
                            would be the number of lines up from the bottom of the page.

           {N}              For suppression of printing duplicate values.




            February 2007                        FM: Basic Ad Hoc IV, v2                      34




Instructor Notes:
When mentioned in the text, go over the table and review the items listed.
Text:
This table summarizes features of the final six print qualifiers presented in
this lesson.
Let’s now proceed to the next lesson to learn about print qualifiers that are
used to manage column headers.




                                                                                                   34
         Lesson 2: Control Column Headers
          Topic 1:   Create Custom Text Header
          Topic 2:   Use Data Dictionary Field Title as Header
          Topic 3:   Suppress Header
          Topic 4:   Suppress Header and Inter-Column Spacing




Text:
In Lesson 2, we will show you how to use print qualifiers to control column headers.
The topics for this lesson are listed here. [Read the lesson title and topics.]




                                                                                       35
                          Lesson 2 Objective:
               Specify column header text for data presented.




Instructor Notes:
Read the lesson objective when indicated in the text.
Text:
This is the objective. By the end of this lesson, you will be able to [read objective].




                                                                                          36
             Topic 1: Create Custom Text Header

              Focus: Free Text { “ABCD” } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces the technique to specify free text column headers.




                                                                           37
                 {Introducing Free Text ( “ABCD” ) Print Qualifier as Custom Header}

          First Print FIELD: PATIENT NAME;C1;L18
          Then Print FIELD: PATIENT NAME:#8000;C21;L14
             By '#8000', do you mean the PATIENT 'FMP/SSN' Field? YES//   (YES)
          Then Print FIELD: PATIENT NAME:#8000;C37;L14;"FMP/SSN"
             By '#8000', do you mean the PATIENT 'FMP/SSN' Field? YES//   (YES)
          Then Print FIELD:
          ==============================[output]===================================
                          Personal Data - Privacy Act of 1974 (PL 93-579)
          RADIOLOGY REPORTS LIST                         21 Jun 2001@1347    PAGE 1
                              PATIENT
          PATIENT NAME        NAME:#8000      FMP/SSN
          --------------------------------------------------------------------------
          ROBBINS,ALLAN A     20/100-10-7525 20/100-10-7525
          ROBBINS,BARBARA B   20/100-10-7526 20/100-10-7526
          ROBBINS,CHARLES C   20/100-10-7527 20/100-10-7527
          ROBBINS,DONNA D     20/100-10-7528 20/100-10-7528
          ROBBINS,EARL E      20/100-10-7529 20/100-10-7529
          ROBBINS,FLORENCE F 20/100-10-7530 20/100-10-7530
          ROBBINS,GEORGE G    20/100-10-7531 20/100-10-7531
          ZELLER,ALLAN A      20/711-90-6508 20/711-90-6508
          NORRIS,A2           20/222-33-4485 20/222-33-4485

           February 2007                  FM: Basic Ad Hoc IV, v2                      38




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
shown beneath. Since no custom column header was defined, the column header in
the first column is the field name, i.e., ‘PATIENT NAME,’ and the column header for
the second column is the literal text of the print statement, ‘PATIENT NAME:#8000.’
Notice the third print statement where “FMP/SSN” is defined as a custom header to
be used in place of the field name as the column header. Quotation marks are
always used in this manner to define free text custom headers.
Next, let’s see how the Data Dictionary can be used to specify a column header.




                                                                                            38
               Topic 2: Use Data Dictionary Field
                         Title as Header

                        Focus: Title { T } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces the technique used to specify data dictionary field titles as
column headers. Let’s start by looking at the data dictionary for the Radiology
Reports file and one of the fields defined with a title.




                                                                                      39
              {Data Dictionary: EXAM DATE/TIME field in the Radiology Reports file}

          Select FileMan Menu Option: List File Attributes

          Output from what file: RADIOLOGY REPORTS
          Select SUB-FILE:
          Select LISTING FORMAT: STANDARD// CUSTOM-TAILORED
          Sort by: LABEL// LABEL;1 LABEL
          Select LABEL: EXAM DATE/TIME
            Within LABEL, Sort by:
          First Print ATTRIBUTE: [CAPTIONED
          ...
          FIELD LIST                                     21 Jun 2001@1419    PAGE 1
          -------------------------------------------------------------------------
          NUMBER: 3         LABEL: EXAM DATE/TIME         SPECIFIER: RDI
          GLOBAL SUBSCRIPT LOCATION: 0;3      TITLE: DATE AND TIME OF EXAM
          ...
          SOURCE: SYSTEM GENERATED
           DESCRIPTION:   This field contains the date and the time the exam status
           changed to ARRIVED (that is, the patient is arrived in radiology).
          ARCHIVE: ARCHIVE/PURGE        MAXIMUM LENGTH OF FIELD: 17
          DATE FIELD LAST EDITED: 29 Jan 1996



          February 2007                 FM: Basic Ad Hoc IV, v2                       40




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the FileMan statements used to generate the Data
Dictionary information stored pertaining to the ‘EXAM DATE/TIME’ field in the
Radiology Reports file. You may remember this technique of using the custom-
tailored format that is presented in Basic Ad Hoc I. In the report, shown on the
bottom half of the slide, notice that a title is defined for this field.
Next, let’s see how a defined title from the Data Dictionary can be used to specify a
column header.




                                                                                           40
            {Introducing ( T ) Print Qualifier to Use Data Dictionary Title as Header}

          First Print FIELD: PATIENT NAME;C1;L18
          Then Print FIELD: TIME(EXAM DATE/TIME);C21;R8;"EXAM AT"
          Then Print FIELD: EXAM DATE/TIME;C31;L16;T
          Then Print FIELD:
          ==============================[output]===================================

                           Personal Data - Privacy Act of 1974 (PL 93-579)
          RADIOLOGY REPORTS LIST                         21 Jun 2001@0947    PAGE 1
                                        DATE AND TIME OF
          PATIENT NAME         EXAM AT EXAM
          --------------------------------------------------------------------------
          ROBBINS,ALLAN A      3:00 AM 20 Jun 2001@0300
          ROBBINS,BARBARA B    3:05 AM 20 Jun 2001@0305
          ROBBINS,CHARLES C    3:05 AM 20 Jun 2001@0305
          ROBBINS,DONNA D      3:10 AM 20 Jun 2001@0310
          ROBBINS,EARL E       3:15 AM 20 Jun 2001@0315
          ROBBINS,FLORENCE F   3:20 AM 20 Jun 2001@0320
          ROBBINS,GEORGE G     3:25 AM 20 Jun 2001@0325
          ZELLER,ALLAN A      11:08 AM 20 Jun 2001@1108
          NORRIS,A2            4:03 PM 20 Jun 2001@1603



           February 2007                      FM: Basic Ad Hoc IV, v2                  41




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
shown beneath. This time, the T print qualifier is added to the last print statement to
specify the title of this field in the data dictionary to be used as the column header.
Let’s proceed to the next couple of topics to see two different ways to suppress the
column header from displaying.




                                                                                            41
                        Topic 3: Suppress Header

                        Focus: Null { "" } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces one technique to suppress column headers.




                                                                  42
                                      {Without any Print Qualifier}

          First Print FIELD: PATIENT NAME;L12
          Then Print FIELD: VERIFIED BY
          Then Print FIELD:

          ==============================[output]===================================

                           Personal Data - Privacy Act of 1974 (PL 93-579)
          RADIOLOGY REPORTS LIST                         21 Jun 2001@1605    PAGE 1
          PATIENT NAME VERIFIED BY
          -------------------------------------------------------------------------
          ROBBINS,ALLA RAD,RF
          ROBBINS,BARB RAD,RF
          ROBBINS,CHAR RAD,RF
          ROBBINS,DONN RAD,RF
          ROBBINS,EARL RAD,RF
          ROBBINS,FLOR RAD,RF
          ROBBINS,GEOR RAD,RF
          ZELLER,ALLAN RAD,RF
          NORRIS,A2     RAD,RF




           February 2007                     FM: Basic Ad Hoc IV, v2                  43




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
shown beneath. Notice that when the Ln print qualifier is used on the free text
‘PATIENT NAME’ field, the system truncates the data after 11 character spaces and
inserts two spaces before printing data in the next column.
Let’s proceed to the next slide to see one way to suppress the column header from
displaying.




                                                                                           43
                           {Introducing ( "" ) Print Qualifier to Suppress Header}

          First Print FIELD: PATIENT NAME;L12;""
          Then Print FIELD: VERIFIED BY
          Then Print FIELD:

          ==============================[output]===================================

                            Personal Data - Privacy Act of 1974 (PL 93-579)
          RADIOLOGY REPORTS LIST                         21 Jun 2001@1613    PAGE 1
                        VERIFIED BY
          -------------------------------------------------------------------------
          ROBBINS,ALLA RAD,RF
          ROBBINS,BARB RAD,RF
          ROBBINS,CHAR RAD,RF
          ROBBINS,DONN RAD,RF
          ROBBINS,EARL RAD,RF
          ROBBINS,FLOR RAD,RF
          ROBBINS,GEOR RAD,RF
          ZELLER,ALLAN RAD,RF
          NORRIS,A2     RAD,RF




           February 2007                      FM: Basic Ad Hoc IV, v2                 44




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
shown beneath. The only change in the initial print statement from the previous slide
is the addition of the double quote marks at the end of the first line. Notice that the
effect in the report is identical to the previous slide, except there is no column
header above the initial column.
Let’s proceed to the next topic to see another way to suppress the column header
from displaying.




                                                                                           44
                  Topic 4: Suppress Header and
                      Inter-Column Spacing

                    Focus: Letter X { X } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces the technique to suppress column headers and inter-column
spacing.




                                                                                  45
           {Introducing ( X ) Print Qualifier to Suppress Header & Inter-column Spacing}

           First Print FIELD: PATIENT NAME;L12;X
           Then Print FIELD: VERIFIED BY
           Then Print FIELD:

           ==============================[output]===================================

                           Personal Data - Privacy Act of 1974 (PL 93-579)
           RADIOLOGY REPORTS LIST                         21 Jun 2001@1619    PAGE 1
           VERIFIED BY
           -------------------------------------------------------------------------
           ROBBINS,ALLARAD,RF
           ROBBINS,BARBRAD,RF
           ROBBINS,CHARRAD,RF
           ROBBINS,DONNRAD,RF
           ROBBINS,EARLRAD,RF
           ROBBINS,FLORRAD,RF
           ROBBINS,GEORRAD,RF
           ZELLER,ALLANRAD,RF
           NORRIS,A2RAD,RF




           February 2007                     FM: Basic Ad Hoc IV, v2                   46




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements used to generate the partial list
shown beneath. This time, the X print qualifier is added to the end of the initial print
statement. Notice the effect of this on the output. Let’s start by looking at the
column header. Not only is the ‘PATIENT NAME’ column header suppressed, but
the 12-character space restriction is also suppressed, with the result of the column
header for the second column appearing directly over the first column. In the output
below, notice that the two fields are merged, with no spacing between.
Although this result looks awkward, a common use of the X print qualifier by sites is
to format delimited reports for insertion into Excel spreadsheets. While this
application is beyond the scope of this course, it is worthy of mention.
This completes the print qualifiers to be introduced in this lesson that directly affect
the column headers. Before proceeding to new information, I have a question for
you to answer.




                                                                                            46
                           Lesson 2 Question
          Which of the following print qualifiers will suppress a column
          header without suppressing inter-column spacing?

          1.   The T print qualifier
          2.   The absence of any print qualifier
          3.   The X print qualifier
          4.   The "" print qualifier
          5.   The @ print qualifier




           February 2007             FM: Basic Ad Hoc IV, v2              47




Instructor Notes:
The correct answer is 4.
Text:
The correct answer is number 4. The “T” print qualifier pulls the field title from the
data dictionary as the column header. While the absence of a print qualifier does
nothing to suppress the generation of a column header, the “X” print qualifier
suppresses both the column header and inter-column spacing. There is no “@” print
qualifier.
Let’s now review the print qualifiers presented in this lesson.




                                                                                         47
                                  Lesson 2 Review

           {"ABCD" } To specify a custom, free text column header format.

                            To specify the Data Dictionary field title as the column
           {T}
                            header.
                            To suppress a column header, yet allow inter-column
           {""}
                            spacing.

           {X}              To suppress both column header and inter-column spacing.




            February 2007                    FM: Basic Ad Hoc IV, v2                   48




Instructor Notes:
When mentioned in the text, go over the table and review the items listed.
Text:
This table summarizes features of the four print qualifiers presented in this
lesson.
Let’s now proceed to the next lesson to learn about print qualifiers that are
used to generate statistics.




                                                                                            48
              Lesson 3: Generate Statistics
           Topic 1: Generate Counts
           Topic 2: Generate Totals
           Topic 3: Generate Totals, Counts, and Means
           Topic 4: Generate Total, Count, Mean, MAX/MIN, and
                    Standard Deviation




Text:
In Lesson 3, we will show you how to use print qualifiers to generate statistics. The
topics for this lesson are listed here. [Read the lesson title and topics.]




                                                                                        49
                            Lesson 3 Objective:

              Generate statistical reports.




Instructor Notes:
Read the lesson objective when indicated in the text.
Text:
This is the objective. By the end of this lesson, you will be able to [read objective].




                                                                                          50
                  {Topic 1 and 2: Initial Sort Statements – Radiology Reports file}

          Select FileMan Menu Option: Print File Entries

          Output from what file: RADIOLOGY REPORTS
          Sort by: 'DATE/TIME CREATED;XADA
          Earliest DATE/TIME CREATED: 01 Jan 2001
          Latest DATE/TIME CREATED: 21 Jun 2001@2359
            Within DATE/TIME CREATED, Sort by: '@APPROVING RADIOLOGIST
            Start with APPROVING RADIOLOGIST: FIRST//
              Within APPROVING RADIOLOGIST, Sort by: '@VERIFIED DATE
              Earliest VERIFIED DATE: FIRST//
                Within VERIFIED DATE, Sort by: ]
                Within VERIFIED DATE, Sort by:
          Store Sort logic in Template: ECD RAD SIMPLE STATS
             Are you adding 'ECD RAD SIMPLE STATS' as a new SORT TEMPLATE? Y    (YES)




           February 2007                  FM: Basic Ad Hoc IV, v2                       51




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
This screen capture of sort statements applied to the Radiology Reports file will
serve to capture all approved and verified reports from 1 January to the present in
the training database (TDB). We will use this population as the basis for topics one
and two.
Let’s now proceed to the first topic for Lesson 3.




                                                                                             51
                        Topic 1: Generate Counts

                        Focus: Exclamation Point { “ ! ” }
                                Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces the technique used to generate simple counts.




                                                                      52
             {Introducing Exclamation Point ( ! ) Print Qualifier to Generate Counts}

           First Print FIELD: !" ";C15
           Then Print FIELD:
           Heading: RADIOLOGY REPORTS STATISTICS     Replace
           Footnote:

           ==============================[output]===================================

           RADIOLOGY REPORTS STATISTICS                   21 Jun 2001@1107    PAGE 1
           -------------------------------------------------------------------------

           COUNT           254




           February 2007                 FM: Basic Ad Hoc IV, v2                        53




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statement used to generate the report.
One of the features of this particular statistical print qualifier is that it is not
dependent on data type, meaning that we can apply it to all records (as shown), or
to any field in the file. Another item to note is that the ‘Heading’ prompt displays the
word, “STATISTICS,” instead of “LIST.” This is a result of applying a statistical print
qualifier.
Let’s say we were curious as to how many of these reports were associated with
male patients. The next topic will allow us to see how to set this up.




                                                                                             53
                        Topic 2: Generate Totals

               Focus: Ampersand { “ & ” } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces the technique used to generate statistical totals.




                                                                           54
                   {Introducing Ampersand ( & ) Print Qualifier to Generate Totals}

           First Print FIELD: &PATIENT NAME:SEX="MALE";C15;L6;"MALE PTS"
           Then Print FIELD: &PATIENT NAME:SEX="FEMALE";C25;L6;"FEMALE PTS"
           Then Print FIELD: &(#.01'="");C35;L6;"TOTAL PTS"
           Then Print FIELD:
           Heading: RADIOLOGY REPORTS STATISTICS Replace
           Footnote:

           ==============================[output]===================================

           RADIOLOGY REPORTS STATISTICS                   21 Jun 2001@1120    PAGE 1
                         MALE      FEMALE    TOTAL
                         PTS       PTS       PTS
           -------------------------------------------------------------------------

           TOTAL           134      120         254




           February 2007                   FM: Basic Ad Hoc IV, v2                     55




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
At the top is a screen capture of the print statements which generate the report.
Whereas the exclamation point is not dependent on data type, the ampersand (&)
print qualifier is. This print qualifier must be applied to a field having a numeric data
type, or to a Boolean expression, as illustrated in the three print statements. Notice
how the three Boolean expressions are defined from the Radiology Reports file to
generate statistical totals to print in the same row.
Let’s say we wanted to know some details about the age range statistics of these
two groups of patients. Let’s proceed to the next topic to see how to set this up.




                                                                                            55
               Topic 3: Generate Totals, Counts,
                          and Means

                 Focus: Plus Sign { “ + ” } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces the technique used to generate statistical totals, counts, and
means.




                                                                                       56
                   {Topic 3 and 4: Initial Sort Statements – Radiology Reports file}

          Select FileMan Menu Option: Print File Entries

          Output from what file: RADIOLOGY REPORTS
          Sort by: 'DATE/TIME CREATED;XADA
          Earliest DATE/TIME CREATED: 01 Jan 2001
          Latest DATE/TIME CREATED: 21 Jun 2001@2359
            Within DATE/TIME CREATED, Sort by: '@APPROVING RADIOLOGIST
            Start with APPROVING RADIOLOGIST: FIRST//
              Within APPROVING RADIOLOGIST, Sort by: 'VERIFIED DATE
              Earliest VERIFIED DATE: FIRST//
                Within VERIFIED DATE, Sort by: +(PATIENT NAME:SEX);C15;L15;S;"Patients"
                Start with Patients: FIRST//
                  Within Patients, Sort by: ]
                  Within Patients, Sort by:
          Store Sort logic in Template: ECD RAD Group STATS
             Are you adding 'ECD RAD Group STATS' as a new SORT TEMPLATE? Y (YES)




           February 2007                   FM: Basic Ad Hoc IV, v2                     57




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
Before looking at the (+) print qualifier, let’s set up a sort template. This screen
capture of sort statements applied to the Radiology Reports file will serve both
topics three and four, to capture all approved and verified reports from 1 January to
the present in the TDB. Since we want to generate statistics on male and female
patients, the last sort statement is introduced to create the two groups, and the plus
(+) sort qualifier enables statistics to be applied to each group.
Let’s now proceed to the next slide to see the print statement.




                                                                                            57
                           {Introducing Plus Sign ( + ) Print Qualifier to Generate:
                                           Totals, Counts, and Means}

           First Print FIELD: +(PATIENT NAME:AGE);C15;L6;"AGE STATS"
           Then Print FIELD:
           Heading: RADIOLOGY REPORTS STATISTICS Replace
           Footnote:

           =======================[output: go to next slide]==========================




           February 2007                       FM: Basic Ad Hoc IV, v2                 58




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
This is a screen capture of the print statement used to generate the report. As with
the ampersand (&), the plus sign (+) print qualifier must also be applied to a field
having a numeric data type or to a Boolean expression. In the example shown, the
(+) sign is being applied to the age of the patient, a numeric value.
Let’s proceed to the next slide to see the results.




                                                                                            58
                                  {Results: Totals, Counts, and Means}

           ==============================[output]===================================

           RADIOLOGY REPORTS STATISTICS                   21 Jun 2001@1145    PAGE 1
                         AGE
                         STATS
           -------------------------------------------------------------------------
                         Patients: FEMALE
           SUBTOTAL      3757
           SUBCOUNT      120
           SUBMEAN       31.31

                          Patients: MALE
           SUBTOTAL       4337
           SUBCOUNT       134
           SUBMEAN        32.37

           TOTAL          8094
           COUNT          254
           MEAN           31.87



          February 2007                    FM: Basic Ad Hoc IV, v2                     59




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
The statistical results of the groups and totals are presented in vertical format. The
subtotal and total is the mathematical sum of ages encountered. The subcount and
count represent the number of records. The submean and mean reflect the
mathematical average as calculated by dividing the subtotal by subcount, or total by
count. Therefore, looking at the top grouping of females, there were 120 records
and the average (mean) age was 31.31 years.
Perhaps we are curious to know the minimum and maximum ages of patients. Let’s
proceed to the next topic to see how to set this up.




                                                                                            59
            Topic 4: Generate Total, Count, Mean,
              MIN/MAX, and Standard Deviation

               Focus: Number Sign { “ # ” } Print Qualifier




Instructor Notes:
Read the topic title.
Text:
This topic introduces the technique used to generate group and cumulative statistics.




                                                                                        60
                       {Introducing Number Sign ( # ) Print Qualifier to Generate:
                           Total, Count, Mean, MIN/MAX, and Standard Deviation}

           First Print FIELD: #(PATIENT NAME:AGE);C15;L6;D2;"AGE STATS"
           Then Print FIELD:
           Heading: RADIOLOGY REPORTS STATISTICS Replace
           Footnote:

           =======================[output: go to next slide]==========================




           February 2007                    FM: Basic Ad Hoc IV, v2                  61




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
This is a screen capture of the print statement used to generate the report. As with
the plus sign (+), the number sign (#) print qualifier must also be applied to a field
having a numeric data type, or to a Boolean expression, as illustrated in the print
statement. The D2 print qualifier (as we have seen earlier in this course) has been
added to round any computation to two decimal places.
Let’s proceed to the next slide to see the results.




                                                                                          61
                {Results: Total, Count, Mean, MIN/MAX, and Standard Deviation (1SD)}

           RADIOLOGY REPORTS STATISTICS                   21 Jun 2001@1154    PAGE 1
                            AGE
                          STATS
           -------------------------------------------------------------------------
                         Patients: FEMALE
           SUBTOTAL      3757.00
           SUBCOUNT         120
           SUBMEAN        31.31
           SUBMINIMUM     17.00
           SUBMAXIMUM     58.00
           SUBDEV.         7.64

                          Patients: MALE
           SUBTOTAL       4337.00
           SUBCOUNT          134
           SUBMEAN         32.37
           SUBMINIMUM      19.00
           SUBMAXIMUM      58.00
           SUBDEV.          9.22



          February 2007                    FM: Basic Ad Hoc IV, v2                     62




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
The statistical results of the groups and totals are presented in vertical format.
Adding to the total, count, and mean that we saw in the results using the plus sign
(+) print qualifier, we now have the minimum, maximum, and standard deviation
statistics derived from the same groupings. In the first group, we see that the
minimum age was 17, the maximum age was 58, and the one standard deviation
(1SD) of age data was 7.64. Alphabetically listed after the females is the next group,
and the statistics of the total population is on the next slide.




                                                                                            62
                {Results: Total, Count, Mean, MIN/MAX, and Standard Deviation (1SD)}

           RADIOLOGY REPORTS STATISTICS                   21 Jun 2001@1154    PAGE 2
                            AGE
                          STATS
           -------------------------------------------------------------------------

           TOTAL          8094.00
           COUNT             254
           MEAN            31.87
           MINIMUM         17.00
           MAXIMUM         58.00
           DEV.             8.51




          February 2007                  FM: Basic Ad Hoc IV, v2                       63




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
Here are the cumulative statistics of all groups combined.
This completes the topics to be presented in this lesson, and I have a question for
you to answer.




                                                                                            63
                            Lesson 3 Question

               Which of the following statistical print qualifiers is most
               useful for simply getting a quick tally of all records?

               1.   The & print qualifier
               2.   The ! print qualifier
               3.   The + print qualifier
               4.   The # print qualifier




           February 2007               FM: Basic Ad Hoc IV, v2               64




Instructor Notes:
The correct answer is 2.
Text:
The correct answer is number 2. All other statistical print qualifiers are dependent on
the data type of the field being numeric or being applied to a Boolean expression.
Let’s proceed to the next slide for a summary review of the print qualifiers presented
in this lesson.




                                                                                          64
                               Lesson 3 Review

           {!}      Generates COUNTS and IS NOT dependent on data type.


                    Generates TOTALS and must be applied to a number, whether a
           {&}
                    numeric field data type or a Boolean expression.

                    Generates TOTALS, COUNTS, and MEANS and must be applied
           {+}      to a number, whether a numeric field data type or a Boolean
                    expression.
                    Generates TOTAL, COUNT, MEAN, MAX/MIN, and STANDARD
           {#}      DEVIATION and must be applied to a number, whether a numeric
                    field data type or a Boolean expression.




            February 2007                FM: Basic Ad Hoc IV, v2               65




Instructor Notes:
When mentioned in the text, go over the table and review the items listed.
Text:
This table summarizes features of the four statistical print qualifiers
presented in this lesson.
Let’s now proceed to the next lesson to learn about print qualifiers that are
used for special applications.




                                                                                    65
           Lesson 4: Use Print Qualifiers for
                Special Applications
           Topic 1: Concatenate Fields
           Topic 2: Force Prompt to Create a Template
           Topic 3: Call Up a Print Template
           Topic 4: Open Multiple-Valued Field with One Sub-Field




Text:
In Lesson 4, we will examine print qualifiers that have special applications. The
topics for this lesson are listed here. [Read the lesson title and topics.]




                                                                                    66
                        Lesson 4 Objective:
           Identify and use print qualifiers with special applications, to
           include: concatenating (joining) fields, creating or calling up
           templates, and opening up multiple-valued fields containing
           a single sub-field.




Instructor Notes:
Read the lesson objective when indicated in the text.
Text:
This is the objective. By the end of this lesson, you will be able to [read objective].




                                                                                          67
                           Topic 1: Concatenate Fields

                   Focus: Underscore { _ } Print Qualifier




           February 2007             FM: Basic Ad Hoc IV, v2               68




Instructor Notes:
Read the topic title.
Text:
This topic introduces the technique used to concatenate, or join, fields in a print
statement.




                                                                                      68
                           {Introducing the Underscore ( _ ) Print Qualifier}

           First Print FIELD: RADIOLOGY EXAM:EXAM NO.;C1;L12;"Rad Exam"
              By 'RADIOLOGY EXAM', do you mean the RADIOLOGY EXAM File,
                  pointing via its 'REPORT TEXT' Field
                  to the RADIOLOGY REPORTS File? YES//   (YES)
           Then Print FIELD: PATIENT NAME;C15;L18
           Then Print FIELD: "Verified by: "_(VERIFIED BY)_" at: "_DATESTRING(VERIFIED
              DATE);C35;L45;""
           Then Print FIELD:




           February 2007                    FM: Basic Ad Hoc IV, v2                  69




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
This is a screen capture of the print statements used to generate the partial list
shown on the following slide. The last print statement illustrates the use of the
underscore ( _ ) print qualifier to join free text and field data on one print statement.
Notice how the placement of the free text words between the quote marks includes
spacing to separate text from the field data to be printed. Also, when joining several
elements on FileMan statements, parenthesis are oftentimes used to encapsulate
fields when the field name contains spacing, as in ‘VERIFIED BY.’ This appears to
enable the FileMan processor to recognize the field by its name and not be
confused by the space or by other fields with similar names. The ‘DATESTRING’
function is applied to the ‘VERIFIED DATE’ field to display the output in user-
friendly format (instead of internal (CYYMMDD.HHMM) format). Finally, at the end
of this wrapped-around print statement, note the use of the double quote marks,
that suppresses the column header.
Let’s proceed to the next slide to see the results.




                                                                                            69
                           {Results Using the Underscore ( _ ) Print Qualifier}

          ==============================[output]===================================
                         Personal Data - Privacy Act of 1974 (PL 93-579)
          RADIOLOGY REPORTS LIST                         21 Jun 2001@1101    PAGE 1
          Rad Exam      PATIENT NAME
          --------------------------------------------------------------------------
          01000693      ROBBINS,ALLAN A     Verified by: RAD,RF at: 20 Jun 2001@0407
          01000694      ROBBINS,BARBARA B   Verified by: RAD,RF at: 20 Jun 2001@0408
          01000695      ROBBINS,CHARLES C   Verified by: RAD,RF at: 20 Jun 2001@0409
          01000696      ROBBINS,DONNA D     Verified by: RAD,RF at: 20 Jun 2001@0410
          01000711      ROBBINS,EARL E      Verified by: RAD,RF at: 20 Jun 2001@0411
          01000697      ROBBINS,FLORENCE F Verified by: RAD,RF at: 20 Jun 2001@0411
          01000698      ROBBINS,GEORGE G    Verified by: RAD,RF at: 20 Jun 2001@0412
          01000963      ZELLER,ALLAN A      Verified by: RAD,RF at: 20 Jun 2001@1120
          01000716      NORRIS,A2           Verified by: RAD,RF at: 20 Jun 2001@1603




           February 2007                     FM: Basic Ad Hoc IV, v2                   70




Instructor Notes:
Point to the banner and highlighted fields when mentioned in the text.
Text:
Here are the results. Notice the gold highlighted line displaying the joined free text
and field data.
Let’s proceed to the next topic to learn about the print qualifier that enables you to
create a print template.




                                                                                            70
                           Topic 2: Force Prompt to
                            Create a Template

           Focus: Right (Close) Bracket { ] } Print Qualifier




           February 2007             FM: Basic Ad Hoc IV, v2               71




Instructor Notes:
Read the topic title.
Text:
This topic introduces the tool used in a print statement to create a print template.




                                                                                       71
                {Introducing the Right Bracket (]) to Force a Print Template Prompt}

           First Print FIELD: PATIENT NAME:
             Then Print PATIENT FIELD: NAME;C1;L18
             Then Print PATIENT FIELD: SEX;C21;L1;"S E X"
             Then Print PATIENT FIELD: "/"_AGE;C24;L4;"Age"
             Then Print PATIENT FIELD: PHONE;C30;L15;"Home"
             Then Print PATIENT FIELD: OFFICE PHONE;C47;L20;"Office"
             Then Print PATIENT FIELD:
           Then Print FIELD: ]
           Heading: RADIOLOGY REPORTS LIST Replace ... With Patient Follow-Up
             Replace
           Footnote:
           Store Print logic in Template:     Enter Template Name here




           February 2007                 FM: Basic Ad Hoc IV, v2                       72




Instructor Notes:
Point to the banner line at the top and to the highlighted fields when mentioned in
the text.
Text:
As a general rule, after entering two or more print statements, a prompt to save a
print template will automatically display after you press <Enter> at the final print
statement. You can also ensure that this prompt displays by entering a Right
Bracket { ] } at the final ‘Then Print FIELD:’ prompt. FileMan interprets this as a
command and then provides you with the means to save a print template. Note that
this entry must be made at the final print prompt, and not earlier when you may be
in a different file, or within a multiple-valued field. Once a print template has been
created, let’s see how to call it up.




                                                                                            72
                 Topic 3: Call Up a Print Template

           Focus: Left (Open) Bracket { [ } Print Qualifier




           February 2007              FM: Basic Ad Hoc IV, v2                 73




Instructor Notes:
Read the topic title.
Text:
This topic introduces the print qualifier used to call up a print template.




                                                                                   73
                    {Introducing the Left Bracket ([) to Call Up a Print Template}

           First Print FIELD: [?

           Choose from:
              CAPTIONED
              CHANGES CAPTIONED
              GS RAD PT CONTACT LIST               (06/21/01)        USER #1016   FILE #74
              HISTORICAL CAPTIONED

           First Print FIELD: [GS RAD PT CONTACT LIST
           Want to edit 'GS RAD PT CONTACT LIST' Template? NO//           (NO)
           Heading: Patient Follow-Up//
           Footnote:
           Start at Page: 1//
           DEVICE:




           February 2007                   FM: Basic Ad Hoc IV, v2                           74




Instructor Notes:
Point to the banner line at the top, and to highlighted lines when mentioned in the
text.
Text:
At the initial ‘First Print FIELD:’ prompt, the Left Bracket { [ } print qualifier signals
FileMan to use an existing print template. Note that [? generates an alphabetical list
of existing print templates available for use (where the red arrow is pointing), which
includes the three universal captioned print templates. To call up and use, or edit, a
specific template, enter a left bracket preceding the name of the print template, as
shown on the gold highlighted line.
Next, I have a question for you to answer.




                                                                                                  74
                            Lesson 4 Question 1
              When creating a new print template, you enter the
              name as: [GS RAD WKLD RPT. What happens when
              you are calling it up as follows:
              First Print FIELD: [GS RAD WKLD RPT

              1. FileMan is able to directly identify your print template.
              2. FileMan corrects the name.
              3. FileMan is unable to identify your template.




            February 2007              FM: Basic Ad Hoc IV, v2               75




Instructor Notes:
The correct answer is 3.
Text:
The correct answer is 3. FileMan does not autocorrect any text. Because the
name of the template contains the left bracket, you would need to enter [[GS
RAD WKLD RPT to call up this template.
Next, let’s explore a curious feature of multiple-valued fields.




                                                                                  75
            Topic 4: Open Multiple-Valued Field
                    with One Sub-Field

           Focus: Pipe or Vertical Bar { | } Print Qualifier




           February 2007             FM: Basic Ad Hoc IV, v2                76




Instructor Notes:
Read the topic title.
Text:
This topic introduces print statements used to open multiple-valued fields defined
with only one sub-field. For this lesson, we will turn our focus to the Provider file,
because it contains this type of field that is frequently used in reports.




                                                                                         76
                           {Example of Multiple-Valued Fields – Provider File}

           First Print FIELD: ??

           Choose from:
              .01            NAME
              .111           HOME STREET ADDRESS 1
           ...
              1              INITIALS
           ...
              8123           CONTINUING EDUCATION    (multiple)
              8124           PERIODIC TRAINING    (multiple)
           ...
              8129           PROVIDER FLAG
              8131           MILITARY SPECIALITY
           ...
              8145           DRUG AUTHORIZATION KEY         (multiple)
              8146           PROVIDER SPECIALTY(S)         (multiple)
              8147           MILITARY STATUS
              8149           LANGUAGE    (multiple)




           February 2007                    FM: Basic Ad Hoc IV, v2              77




Instructor Notes:
Point to the banner line at the top and highlighted fields when mentioned in the text.
Text:
Let’s begin by reviewing the structure of the Provider file. This is a partial listing of
the field list generated by the double question mark (??) query. Note that fields like
‘NAME’ and ‘INITIALS’ are single-valued fields, while others are defined to contain
multiple records, such as ‘CONTINUING EDUCATION.’ Let’s proceed to the next
slide where we have opened up this multiple.




                                                                                            77
             {Example of Encountering a Multiple Defined with More Than One Sub-Field}

           First Print FIELD: CONTINUING EDUCATION      (multiple)
             First Print CONTINUING EDUCATION SUB-FIELD: ??

           Choose from:
              .01          DATE/TIME
              1            SPONSORING INSTITUTION
              2            LOCATION
              3            TITLE OF ACTIVITY
              4            START DATE
              5            END DATE
              6            HOURS
              7            CATEGORY
              8            VERIFICATION DATE




           February 2007                 FM: Basic Ad Hoc IV, v2                     78




Instructor Notes:
Point to the banner line at the top and the highlighted fields when mentioned in the
text.
Text:
When we enter CONTINUING EDUCATION at the ‘First Print FIELD:’ prompt, this
“multiple” opens directly up to the sub-field level. Using the “??” query reveals that
CONTINUING EDUCATION may contain data in nine different sub-fields (.01 – 8).
Let’s proceed to the next slide and see the results of entering a different kind of
multiple.




                                                                                          78
                     {Example of Encountering a Multiple with Only One Sub-Field}

          First Print FIELD: NAME;C1;L18 NAME
          Then Print FIELD: PROVIDER SPECIALTY(S)               (multiple)
          Then Print FIELD:




                                             { Results }
          PROVIDER LIST                                  21 Jun 2001@1543    PAGE 1
                              PROVIDER
          NAME                SPECIALTY(S)
          -------------------------------------------------------------------------
          DOCTOR,CABO         016
                              014
                              100




           February 2007                   FM: Basic Ad Hoc IV, v2                    79




Instructor Notes:
Point to the banner lines at the top and to the gold highlighted field when mentioned
in the text.
Text:
In the top box, note that the ‘PROVIDER SPECIALTY(S)’ field does not
automatically open up to the sub-field level on the following print statement. Further,
when you print the results, notice that three specialties are listed for this provider,
represented by numbers, but there is no description of what these numbers mean.
Let’s go from here and review the captioned output for this record in the Provider
file.




                                                                                           79
                   {Sample Provider Record Having Multiple PROVIDER SPECIALTY(S)}

          NAME: DOCTOR,CABO       SEX: MALE         DOB: 04 Jan 1950
          PROVIDER FLAG: PROVIDER     SSN: 500-60-7001     RANK: LIEUTENANT COMMANDER
          SALUTATION: MD          DATE/TIME FLAGGED FOR RCMAS: 21 Jun 2001@153336
          HOME PHONE: 555-2913          DUTY PHONE 1: 202-555-5426
          CLASS: SPECIAL CLASS (DOCTOR)       PROVIDER ID: DRCABO
          HCP SIDR-ID: 016101           PRIMARY HIPAA TAXONOMY: 207RE0101X
          REQUIRE SUPERVISING PROVIDER: NO
          PERSON IDENTIFIER TYPE CODE: SOCIAL SECURITY NUMBER (SSN)     LOCATION: 10D
          PROVIDER SPECIALTY(S): 016
          PROVIDER SPECIALTY(S): 014
          PROVIDER SPECIALTY(S): 100
          HIPAA TAXONOMY: 207RE0101X
          HIPAA TAXONOMY: 207RC0000X
          HIPAA TAXONOMY: 208600000X
          VERIFIED: YES
          ENTERED BY: TRAINING,MANAGER          DATE@TIME ENTERED: 01 Jan 1999@122231
          VERIFIED BY: TRAINING,MANAGER         DATE VERIFIED: 01 Jan 1999@122251
          CMAC MODIFICATION DATE: 21 Jun 2001



          February 2007                   FM: Basic Ad Hoc IV, v2                   80




Instructor Notes:
Point to the banner line at the top and to the highlighted data when mentioned in the
text.
Text:
Here’s the captioned information for Dr. Cabo. Notice the three entries for this
provider’s record listed in the multiple-valued field, PROVIDER SPECIALTY(S).
These codes are assigned to providers by the Database Administrator or Facility
Quality Assurance Department. As we’ll see in a moment, these assigned codes
reference, or point to, the Provider Specialty file. Let’s take a moment to look at
some of the codes in this file.




                                                                                         80
                           {Samples from the Provider Specialty file}

           PROVIDER SPECIALTY LIST                        21 Jun 2001@1428    PAGE 1
           CODE DESCRIPTION
           -------------------------------------------------------------------------
           011   INTERNIST
           012   ALLERGIST
           013   ONCOLOGIST
           014   CARDIOLOGIST
           015   CARDIOPULMONARY LABORATORY PHYSICIAN
           016   ENDOCRINOLOGIST
           017   GERIATRICIAN
           018   GASTROENTEROLOGIST
           019   HEMATOLOGIST
           020   RHEUMATOLOGIST
           100   GENERAL SURGEON




           February 2007                FM: Basic Ad Hoc IV, v2                        81




Instructor Notes:
Point to the banner line at the top and to highlighted data when mentioned in the
text.
Text:
From the Provider Specialty file, we see that there are descriptions for each code.
Notice that the 014 code is for ‘CARDIOLOGIST’; the 016 code is for
‘ENDOCRINOLOGIST’; and the 100 code is for ‘GENERAL SURGEON.’
Let’s return now to the Provider file and design a print template to print both the
code and description for providers.




                                                                                            81
                           {Introducing the Vertical Bar (|) Print Qualifier}

          First Print FIELD: NAME;C1;L18
          Then Print FIELD: |PROVIDER SPECIALTY(S)
            Then Print PROVIDER SPECIALTY(S) SUB-FIELD: ??             Sub-Field level !!!

             .01            PROVIDER SPECIALTY(S)                      Only One Sub-Field

                Type '&' in front of Field Name to get total for that Field,
                   '!' to get count, '+' to get total & count, '#' to get max & min,
                   ']' to force saving Print Template
                You can follow Field Name with ';' and format specification(s)

          Then Print PROVIDER SPECIALTY(S) SUB-FIELD: ??:
             .01         PROVIDER SPECIALTY(S)                 Forward Pointer !!!
          Choose from:
             .115        HOME STATE
             ...
            Then Print PROVIDER SPECIALTY(S) SUB-FIELD: .01:  File Jump !!!
              Then Print PROVIDER SPECIALTY FIELD: CODE;C21;L4
              Then Print PROVIDER SPECIALTY FIELD: DESCRIPTION;C26;L30
              Then Print PROVIDER SPECIALTY FIELD:




           February 2007                    FM: Basic Ad Hoc IV, v2                           82




Instructor Notes:
Point to the banner line at the top and highlighted data when mentioned in the text.
Text:
Returning to the Provider file, after selecting the record, or records of interest, we
start out by printing the name of the provider. This brings us to the key field,
‘PROVIDER SPECIALTY(S).’ This time, entering the Pipe, or Vertical Bar (|) print
qualifier, opens up this multiple-valued field. Entering double question mark (??)
proves there is only one sub-field, and entering ??: shows this sub-field is a forward
pointer. With this multiple opened up, we can now navigate to the Provider
Specialty file and print both the code and the description. Let’s proceed to the next
slide to see the results.




                                                                                                   82
                                            {Results}

         PROVIDER LIST                                  21 Jun 2001@1447    PAGE 1
         NAME                CODE DESCRIPTION
         --------------------------------------------------------------------------
         DOCTOR,CABO         016 ENDOCRINOLOGIST
                             014 CARDIOLOGIST
                             100 GENERAL SURGEON




          February 2007                 FM: Basic Ad Hoc IV, v2                       83




Instructor Notes:
Point to the banner line at the top and highlighted results when mentioned in the
text.
Text:
Navigating to the Provider Specialty file enables printing both the code and
description, making this a more meaningful report.
Next, I have a question for you to answer.




                                                                                           83
                            Lesson 4 Question 2
               Which FileMan print qualifier enables you to open Multiple
               Valued fields that are defined with only one sub-field?

               1.   Left (Open) Bracket ( [ )
               2.   Right (Close) Bracket ( ] )
               3.   Vertical Bar, or Pipe ( | )
               4.   Underscore ( _ )




            February 2007              FM: Basic Ad Hoc IV, v2             84




Instructor Notes:
The correct answer is 3.
Text:
The correct answer is 3. The Underscore ( _ ) is used to join fields, and the
brackets are used for creating or calling up templates.
Let’s proceed to a review of the print qualifiers from this lesson.




                                                                                84
                            Lesson 4 Review

           {_}               Concatenates – Joins Fields

           {]}               Forces Save Print Template Prompt

           {[}               Calls Up Print Templates

           {|}               Opens Up Multiple-Valued Fields




            February 2007             FM: Basic Ad Hoc IV, v2              85




Instructor Notes:
Go over the table and review the items listed.
Text:
This table summarizes features of the sort qualifiers presented in this lesson.
This concludes the final lesson. Next is the Course Summary.




                                                                                  85
                            Course Summary
          • This course focused on qualifiers used in print statements.
          • Lesson 1 covered print qualifiers used to specify the output
            format of data and headers.
          • Lesson 2 covered print qualifiers used to control text of
            column headers.
          • Lesson 3 covered print qualifiers used to generate statistics.
          • Lesson 4 covered print qualifiers used for special
            applications.




            February 2007          FM: Basic Ad Hoc IV, v2             86




Instructor Notes:
This is the course summary.
Text:
[Read the bullets.]




                                                                             86
                                  References




          Supplementary Handout to the Basic Ad Hoc 101 Instructor Guide, dated
          June 8, 2005




          February 2007              FM: Basic Ad Hoc IV, v2                 87




Instructor Notes:
The handout was introduced in an earlier VC course, and is available upon request.
Text:
Topics presented in this course are from the FileMan Sort Qualifier section in the
handout cited above.
The content for this VC is derived from the contractor’s CHCS software developers,
subject matter experts (SMEs), and implementation specialists (ISs).




                                                                                     87
                           Supplementary Resources
          • Supplementary web sites:
               •   http://www.jacquardsystems.com/
               •   http://tricarene.army.mil/Ad_Hoc/
               •   http://www.chcs-dm.com/           {for SAIC & DoD site access}
               •   Users Manual, FileMan Reference Manual, Vol. 1
               •   Users Manual, FileMan Reference Manual, Vol. 2




           February 2007                 FM: Basic Ad Hoc IV, v2                    88




Instructor Notes:
The web sites are supplementary.
Text:
SAIC On-line FileMan documents: (web site) http://www.chcs-dm.com/
   After log-in, follow the pathway described here:
        (1) Click on CHCS S/W version 4.51.
        (2) Click on CHCS S/W Version 4.51 Documentation, as released on
            4.51 CD-ROM.
        (3) Under "3. LIST OF FILES.", click on 3.3 Users Documentation.
        (4) Use the “zoom in tool” and click to select the page labeled:
            TC-4.5-0050A Users Manual
                                 FileMan Reference Manual
                                 Volume 1        450050a1.pdf
                                 Volume 2        450050a2.pdf




                                                                                         88
                                    Questions?




               February 2007         FM: Basic Ad Hoc IV, v2   89




Instructor Notes:
Point to the title of this slide.
Text:
This concludes the presentation. Do you have any questions?




                                                                    89

								
To top