Batch Report File Versus Hold File

When you generate CIRS ad hoc reports, you can save the output to your batch report file or to one of your hold files (PERMLRG, PERMSML, PERMRPT) so the data can be edited, printed and/or downloaded.  The recommended uses, differences, and the methods for creating the files are discussed below. For additional information on the functions and commands discussed, refer to the CIRS User Manual.  

Batch Report File

We recommend using a batch report file if you are creating large reports, if you need to edit the result before printing, or when you want to download a report (including the headings, footings and column-titles) to Word.   We do not recommended downloading your batch report file into Excel because it is not formatted for easy importation to a spreadsheet.

 

Sample Batch Report File

EDIT   PD.CSUCFOC.RPTUSER.REPORT.UUSER - 01.01 Columns 00001 00072

Command ===>                                      Scroll ===> PAGE

000151 0 NUMBER OF RECORDS IN TABLE=  10   LINES   10          

000152                                                         

000153 1 page    1                                             

000154                                                         

000155       active/onleave positions as of 06/24/2005         

000156                                                         

000157   employee            class     fte        salary

000158   --------            -----     ---        ------

000159   BEAR, PAUL          2354     .400      $1,064.00

000160   COUGAR, CHRIS       2358     .400      $2,654.40

000161   FROG, VIRGINIA      2355     .250        $227.25

000162   LLAMA, WILLIAM      0440    1.000      $3,121.00

000163   NEWT, KATHY         3306    1.000      $9,563.00

 

Hold File (PERMLRG, PERMSML, PERMRPT)

We recommend using hold files to save data for further processing in multi-step reports, and for downloading data to Excel.  You have 3 hold files available for your use.  The size of each file is specific to its owner, but in general, the PERMSML file can hold an amount of data equivalent to the Active Current Status (AC) file and the other files, PERMLRG and PERMRPT can hold larger amounts of data.  Unlike a batch report file, your hold file will contain only the resulting data.

 

Sample Hold File PERMLRG In Lotus Format

  OPTIONS                                                     

BROWSE    PD.CSUCFOC.RPTUSER.PERMLRG.UUSER   Line 00000000 Col

Command ===>                                  Scroll ===> PAGE

************************ Top of Data *************************

”r;BEAR, PAUL                   ”r;,”r;2354”,    .400,    1064.00

”r;COUGAR, CHRIS                ”r;,”2358”,    .400,    2654.40

”r;FROG, VIRGINIA               ”r;,”r;2355”,    .250,     227.25

”r;LLAMA, WILLIAM               ”r;,”0440”,   1.000,    3121.00

”r;NEWT, KATHY                  ”r;,”r;3306”,   1.000,    9563.00