VA FileMan 22.2 Advanced User Manual

3y ago
18 Views
2 Downloads
3.21 MB
348 Pages
Last View : 2m ago
Last Download : 2m ago
Upload by : Ryan Jay
Transcription

VA FileMan 22.2Advanced User ManualJanuary 2017Department of Veterans Affairs (VA)Office of Information and Technology (OI&T)Enterprise Program Management Office (EPMO)

Revision hanges for patch DI*22.2*2.REDACTED Updated Section 9.2.2. Added eight newdata types to Table 91. Added Sections 9.2.12 – 9.2.19 Updated Section 9.3. Added eight newdata types. Added Sections 9.8.9 – 9.8.16. Added Section 17 – Meta Data Dictionary.11/29/20161.3Changes to support release of PatchDI*22.2*4: Updated Section 4.2.2.2 to reflect changein behavior of computed expressions asprint fields. Added Section 4.2.2.5. Updated Figure numbering from Figure 78onward and corresponding crossreferences. Updated ToC, LoF and LoT.09/26/20161.2Tech Edit:09/15/20161.1VA FileMan 22.2Advanced User ManualREDACTEDREDACTED Updated document for Section 508conformance. Updated user entries in Figure 93 andFigure 94. Updated Section 8.4 and removed PIIfrom Figure 112. Updated Section 8.5 and user entries inFigure 113 and Figure 114. Added/Updated Section 11.2.4 and Figure231. Added/Updated Section 11.2.5 and Figure232. Added/Updated Section 11.2.6 and Figure233. Updated “Glossary” table entries. Updated document styles and formattingto follow current documentation standardsand style guidelines.Changes to support release of PatchDI*22.2*3: Note regarding output device added toSection 1.3.2 (How to Export Data). Note regarding Option setup added toSection 10.1 (Verify Fields).ii REDACTEDJanuary 2017

DateRevisionDescription 08/03/20161.0AuthorNote regarding auditing of the Descriptionand Technical Description fields added toSection 11.2 (Auditing a Data Dictionary).Initial release of VA FileMan 22.2 AdvancedUser Manual. VA FileMan 22.2Development TeamREF: For the current patch history related to this software, see the Patch Module (i.e., Patch UserMenu [A1AE USER]) on FORUM.VA FileMan 22.2Advanced User ManualiiiJanuary 2017

Table of ContentsRevision History . iiList of Figures . xiList of Tables . xixOrientation .xxii1Import and Export Tools. 11.11.21.32What Applications Can You Exchange Data With? . 1How Data is Moved between Applications . 1Dependency on Correct Data Communication . 21.3.1Data Formats . 21.3.2How to Export Data . 41.3.3How to Import Data . 161.3.4Foreign Formats. 22Relational Navigation . 342.1Simple Extended Pointer. 352.1.1Simple Extended Pointer Syntax (Short form) . 362.1.2Simple Extended Pointer Syntax (Long Form) . 362.1.3Examples . 372.1.4How to Navigate With a Variable Pointer Field . 372.2Relational Jumps across Files. 382.3Backward Extended Pointer . 402.4Join Extended Pointer . 422.4.1Limitations. 422.4.2Example . 432.5Multiline Return Values . 432.5.1WORD-PROCESSING Field . 442.5.2Multiples . 442.5.3Backward Pointer . 453Advanced Edit Techniques . 473.1Field Value Stuffing . 473.1.1Set Field Default (2 //) . 473.1.2Stuff/Delete Field Value (3///) . 473.1.3Unvalidated Stuffs: (4////). 483.1.4Variable Stuffs . 483.1.5WORD-PROCESSING Field Stuffing . 493.1.6Looping ( LOOP) . 493.2INPUT Templates . 513.2.1Overview . 513.2.2Branching within INPUT Templates . 523.3Edit Qualifiers . 553.3.1Edit Qualifiers and Customizing Data Editing . 55VA FileMan 22.2Advanced User ManualivJanuary 2017

3.3.2Forcing Special Prompts . 553.3.3Duplicating Input Values . 563.3.4Forcing Required Input . 563.4Text Formatting in Word-processing Fields . 573.4.1Word Wrapping . 573.4.2Tabs. 573.4.3Formatting Text with Word-processing Windows (Frames) . 573.4.4Text Formatting Expressions in Word-processing Windows . 584Computed Expressions . 604.1Syntax. 604.1.1Elements of Computed Expressions . 604.1.2Operators in Computed Expressions. 614.1.3Data Types in Computed Expressions . 634.1.4Using Functions as Elements in Computed Expressions. 644.2Where to Use. 654.2.1Using Computed Expressions in COMPUTED Fields . 654.2.2Where to Use Computed Expressions “On-the-Fly” . 675VA FileMan Functions. 735.15.25.36How to Use VA FileMan Functions . 73Documentation Conventions for VA FileMan Functions . 73VA FileMan Function Categories . 745.3.1Date/Time Functions . 765.3.2Environmental Functions. 835.3.3File and File Data Functions . 865.3.4Mathematical Functions . 935.3.5Printing Related Functions . 965.3.6String Functions . 975.3.7Temporary Data Storage Functions . 1005.3.8M-Related Functions . 102Statistics . 1106.16.2How to Generate Statistics from Reports . 110Descriptive Statistics . 1106.2.1Initial Print . 1116.2.2Generating the Descriptive Statistics. 1116.3Scattergram. 1126.3.1Initial Print . 1126.3.2Generating the Scattergram . 1136.4Histogram . 1147System Management . 1177.1Setup . 1177.1.1Initialization . 1177.1.2Security. 117VA FileMan 22.2Advanced User ManualvJanuary 2017

7.2Standalone VA FileMan . 1187.2.1Device Handling for Standalone VA FileMan. 1187.2.2NEW PERSON File for Standalone VA FileMan . 1237.3 %ZOSF Nodes . 1267.3.1Manually Setting %ZOSF Nodes . 1267.4Alternate Editors . 1277.4.1Setting Up Alternate Editors . 1277.5COMPILED ROUTINE File. 1297.5.1COMPILED ROUTINE File Cleanup: ENRLS DIOZ( ) . 1297.6Compare Data and Data Dictionaries cross Environments . 1297.6.1Compare Data Dictionaries . 1297.6.2Compare File Entries . 1308List File Attributes . 1328.1List File Attributes Option . 1328.1.1Brief Data Dictionary . 1338.1.2Condensed Data Dictionary . 1358.1.3Standard and Modified Standard Data Dictionaries . 1388.1.4Custom-Tailored Data Dictionary . 1418.1.5Templates Only Format. 1448.1.6Global Map . 1448.1.7Indexes and Cross-references Only . 1458.1.8Keys Only . 1468.2Map Pointer Relations Option . 1468.3Check/Fix DD Structure Option . 1478.4Find Pointers Into a File Option . 1488.5Meta Data Dictionary . 1509Creating Files and Fields. 1539.1Creating a File . 1539.1.1Naming a New File. 1539.2Creating Fields . 1549.2.1Screen Mode Field Editing . 1549.2.2Field Data Types . 1569.2.3DATE/TIME Data Type . 1579.2.4NUMERIC Data Type . 1589.2.5SET OF CODES Data Type . 1599.2.6FREE TEXT Data Type . 1609.2.7WORD-PROCESSING Data Type . 1619.2.8COMPUTED Data Type . 1629.2.9POINTER TO A FILE Data Type . 1639.2.10 VARIABLE-POINTER Data Type . 1649.2.11 MUMPS Data Type . 1669.2.12 BOOLEAN Data Type . 1669.2.13 LABEL REFERENCE Data Type . 166VA FileMan 22.2Advanced User ManualviJanuary 2017

9.2.14 TIME Data Type . 1679.2.15 YEAR Data Type. 1679.2.16 UNIVERSAL TIME Data Type . 1679.2.17 FT POINTER Data Type . 1679.2.18 FT DATE Data Type . 1679.2.19 RATIO Data Type . 1679.3Multiple-Valued Field (Multiples) . 1689.4Making a Field Mandatory . 1699.5Field Number Sequences . 1699.6NUMBER (.001) Field . 1699.6.1Forced Lookups Using Numbers . 1709.7Changing and Deleting Fields. 1719.7.1Changing Field Attributes . 1719.7.2Changing a Field’s DATA TYPE Value. 1749.7.3Deleting an Existing Field. 1749.8Examples of File and Field Creation. 1759.8.1File Creation . 1769.8.2DATE/TIME Fields . 1779.8.3SET OF CODES Field . 1789.8.4FREE TEXT Field . 1799.8.5WORD-PROCESSING Field . 1809.8.6COMPUTED Field. 1829.8.7POINTER TO A FILE Field . 1839.8.8VARIABLE-POINTER Field . 1849.8.9BOOLEAN Field . 1859.8.10 LABEL REFERENCE Field . 1859.8.11 TIME Field . 1879.8.12 YEAR Field . 1889.8.13 UNIVERSAL TIME Field . 1899.8.14 FT POINTER Field . 1909.8.15 FT DATE Field . 1909.8.16 RATIO Field . 1919.8.17 Creating a Multiple . 19210 File Utilities. 19610.1 Verify Fields . 19610.2 Cross-Reference a Field or File .

VA FileMan 22.2 Advanced User Manual ii January 2017 Revision History Date Revision Description Author 01/17/2017 1.4 Changes for patch DI*22.2*2.

Related Documents:

VA FileMan 22.2 User Manual ii October 2018 Revision History Date Revision Description Author 1

Advanced metering for SMEs The Impact of advanced metering for SMEs 0 Executive summary 02 Introduction to advanced metering 7.06 The potential benefits 06 .2 Use of advanced metering in businesses 06 .3 SupplierPrinciples of advanced metering 07 .4 Analysing advanced metering data 07 .5 Sources of energy savings 08 .6 Advanced metering technology 08 .7 Advanced metering services 09

Table 3 and Section 10. Added ENTITY (#1.5) file and description in Table 4. Added DDE routines to Table 5. Updated Section 4.5 to add DDE menu and submenu options. Added Section 5.18 with a list of cross-references for the ENTITY (#1.5) file. REDACTED 10/01/2018 1.5 Reviewer Feedback Edits: Added the DDERR routine to Table 5.

Please send your photographic prints by a web link (e.g. APEX FileMan, Dropbox, WeTransfer etc.) to Secretariat (e: cp@sia.org.sg). 3.0 Materials to be submitted 3.1 Key Personnel(s) Image(s) . Singapore Institute of Architects 79 Neil Road Singapore 088904 Tel: 6226 2668 Fax: 6226 2663 Email: cp@sia.org.sg Page 3 of 2

C5051 / C5045 / C5035 / C5030 advanced authentication advanced adobe integrations advanced storage advanced integration to enterprise systems advanced color quality advanced scanning Advanced made simple for you. . Canon’s new built-in document sharing solution simply makes sense. Multiple users can collaborate easily on a shared

Advanced Screen Systems Advanced Screen Systems Advanced Screen Systems Advanced Screen Systems Advanced Screen Systems Read completely through the installation instructions before proceeding with installation Installation requires two people Use appropriate protective equipment, including safety glasses Children should not be .

Pearson Edexcel Level 3 Advanced Subsidiary and Advanced GCE in Statistics Statistical formulae and tables For first certification from June 2018 for: Advanced Subsidiary GCE in Statistics (8ST0) For first certification from June 2019 for: Advanced GCE in Statistics (9ST0) This copy is the property of Pearson. It is not to be removed from the

ASTM D-2310 Classifi cation: RTRP-11AX for static hydrostatic design basis; IPD cured. Complies with ASTM F-1173 Classifi cation. Approvals Quick-Lock Uses and applications Characteristics Taper/Taper 18-40 inch 1-16 inch A complete library of Bondstrand pipe and fi ttings in PDS and PDMS-format is available on CD-ROM. Please contact Ameron for details. For specifi c fi re protection .