How To Use This Site
About HR-Data Operations
Ad Hoc Reporting
    Batch Versus Online Execution
    Batch Report Versus Hold Files
    Creating Hold Files for Downloading
    Copy Command Improved
    Creating a 'Unique' Key Field in Systemwide Files
    Creating Laser Printer Labels
    Checking Job Status
    Differences Between PH, PY and PHS Files
    Differences Between TR and EH Files
    Employee Versus Position Status
    Evolution Of A Report Request
    Finding Sample Report Requests
    FOCUS Version 7.6
    Getting Campus Name In Payment Data Reports
    Getting Accurate Payment & Deduction Data
    Holding And Reusing Data
    How FOCUS Processes A Request
    How To Execute Multiple Reports
    How To Identify Full-Time Faculty
    How To Identify Intermittent Employees
    Joining To The Pay Scales File
    Status Messages
    No Data For Report Request?
    Renaming Fields In Hold Files
    Reporting On A Point In Time
    System Messages
    Tenured/Tenure-Track Positions
    Using Smart Date Values
    Where To Find Student Data
    Verifying Data
    Extract Files
    Data Elements
    File Transfer
    FOCUS Commands
       The ALL prefix
       Comparing Value To Value
       Compound Screening Statements
       FOCUS Users Manual
       FOCUS subroutine: CTRAN
       FOCUS Version
       Generating A Running Total
       Getting All Parent Segment Instances
       How To Use Multiple Verbs
       INCLUDE Command
       In-Groups-Of Command
       Insufficient Field Lengths
       Last Command
       Matching Multiple Files
       Prefix Operators
       Using Joins
       Using Multiple Verbs
       Using Record Limits
       Using WHERE TOTAL Selection Tests
       When To Use IF and WHERE
       WHERE Screening Statements
       Retrieving All Fields In A Segment
       Ranking Sort Field Values
       Download Data -TABT format
    Hints and Tips
    Sample Requests
Contacts & Links
Manuals and Documents
Screen Messages