Previous Topic: Secondary Mode Example 2Next Topic: Write-Only Mode


Secondary Mode Example 3

CA                                        16:28:10  24 JUN 2010 CA DATACOM/DB REPORTING FACILITY OS  VERSION nn.n                                 PAGE      1      1            OPTION  LIST ON MAP SORT EQ NONE 2            USER    CA      4            NOTE    *************************************************      5            NOTE    *                                               *      6            NOTE    *  THIS REPORTING FACILITY PROGRAM ILLUSTRATES  *      7            NOTE    *  MULTIPLE DATACOM/DB FILE ACCESS.             *      8            NOTE    *                                               *      9            NOTE    *  (THE NEW TECHNIQUES FOR DB FILE              *     10            NOTE    *   DEFINITION AND ACCESS ARE USED HERE.        *         Multiple CA Datacom/DB tables         11            NOTE    *                                               *         with automatic User Requirements      12            NOTE    *************************************************         Table generation                         ┌─────────┐     14 │ PMF001: │INPUT   DATACOM  RECORD=329     15 │         │DEFINE  DB-COMMAND             1-5  X     16 │         │DEFINE  DB-KEY-NAME           6-10  X     17 │         │DEFINE  DB-ELEMENT-LIST    191-201  X     18 │         │DEFINE  EMPLOYEE-NUMBER    301-305  X 'EMPLOYEE' ' NUMBER '     19 │         │DEFINE  NAME               306-329  X        │         │     21 │ PAYROLL:│INPUT   DATACOM  RECORD=340 NAME=PAY DBID=001     22 └─────────┘DEFINE  DB-COMMAND             1-5  X     23            DEFINE  DB-KEY-NAME           6-10  X     24            DEFINE  DB-KEY-VALUE         11-15  X     25            DEFINE  DB-ELEMENT-LIST    191-201  X     26            DEFINE  EMPLOYEE-CODE          306  X     27            DEFINE  STATUS                 307  X     28            DEFINE  CURRENT-RATE       308-315  N3 ' CURRENT ' 'PAY  RATE'     29            DEFINE  YTD-WAGES          316-323  N2     30                    'YEAR-TO-DATE'  '   WAGES'  PIC  '$$$,$$9.99'     31            DEFINE  YTD-COMMISSION     324-331  N2     32                    'YEAR-TO-DATE'  ' COMMISSION '     33            DEFINE  YTD-TAXES          332-339  N2     34                    'YEAR-TO-DATE'  '   TAXES'            ▲  Notice alternate means of defining CA Datacom/DB tables and duplicate field names in both I/O areas.

CA                                        16:28:10  24 JUN 2010 CA DATACOM/DB REPORTING FACILITY OS  VERSION nn.n                                  PAGE      2                                                 ▼  Field Name Qualifiers                ┌─────────────────────────────────────────────────────────┐               │                              ┌──────┐                   │     36        │   MOVE    'GETIT'         TO │PMF001│.DB-COMMAND        │     37        │   MOVE    'EMPNO'         TO │PMF001│.DB-KEY-NAME       │  ◄  Sequential access      38        │   MOVE    'IDEMP      '   TO │PMF001│.DB-ELEMENT-LIST   │               │                              └──────┘                   │               └─────────────────────────────────────────────────────────┘     39            GET     PMF001     40            GO TO   EOJ WHEN PMF001 EQ END-OF-FILE               ┌─────────────────────────────────────────────────────────┐               │                              ┌────────┐                 │     41        │   MOVE    'REDKG'         TO │PAYROLL.│DB-COMMAND       │     42        │   MOVE    'EMPNO'         TO │PAYROLL.│DB-KEY-NAME      │  ◄  Random access      43        │   MOVE    EMPLOYEE-NUMBER TO │PAYROLL.│DB-KEY-VALUE     │     44        │   MOVE    'PAYRC'         TO │PAYROLL.│DB-ELEMENT-LIST  │               │                              └────────┘                 │               └─────────────────────────────────────────────────────────┘     45            GET     PAYROLL     46            GO TO   START WHEN PAYROLL EQ NO-RECORD-FOUND     48            DECODE  STATUS INTO CODE     49                    'H'  EQ  'HOURLY'     50                    'S'  EQ  'SALARY'     51                    ELSE     '******'     52                             'PAY' 'CODE'     53            DECODE  EMPLOYEE-CODE INTO EMPCODE     54                    'A'  EQ  'ACTIVE'     55                    'I'  EQ  'INACTIVE'     56                    ELSE     '******'     57                             'EMPLOYEE' 'CODE'     59            REPORT  'ACTIVE/INACTIVE PERSONEL REPORT'     60            SELECT  'A' WHERE EMPLOYEE-CODE EQ 'A'     61            SELECT  ALL     62            PRINT   EMPLOYEE-NUMBER NAME EMPCODE A;CODE     63                    A;CURRENT-RATE (A;YTD-WAGES) (A;YTD-COMMISSION)     64                    (A;YTD-TAXES)     65   END          COMPILE PHASE COMPLETED - NO ERRORS FOUND                                    NO WARNINGS ISSUED          START 10:05:58 - STOP 10:06:00

CA 16:28:10 24 JUN 2010 CA DATACOM/DB REPORTING FACILITY OS VERSION nn.n PAGE 3 COMPILE DIAGNOSTICS I/P 00001 X 00340 = 00340 PAYROLL 00001 X 00329 = 00329 PMF001 GSA 00000001677 (00000000118 ENTRIES) GSA 1 = 00000000001 NUMERIC CONSTANT ...... CON GSA 2 = 00000000031 QUOTED LITERAL ........ LIT GSA 3 = 00000000001 INTERMEDIATE RESULT ... RES GSA 4 = 00000000076 UNQUOTED LITERAL ...... INT GSA 5 = 00000000003 ACCUMULATOR ........... ACC GSA 6 = 00000000001 VALUE ................. VAL GSA 7 = 00000000000 STRING ................ STR GSA 8 = 00000000005 HEX LITERAL ........... HEX FNT 00000000968 (00000000052 ENTRIES) FNT 0 = 00000000006 LABELS ................ 01 FNT 1 = 00000000044 SCALAR VARIABLES ...... 01 FNT 2 = 00000000002 FILE DESC. BLOCKS ..... 02 FNT 3 = 00000000000 ARRAYS ................ 03 FST 00000005124 (00000000183 ENTRIES) FST 0 = 00000000004 INTERNAL ONLY ......... -02 FST 1 = 00000000002 USER/REPORT ........... 01 FST 2 = 00000000015 INPUT AREA VARIABLE ... 02 FST 3 = 00000000112 GSA VARIABLE .......... 03 FST 4 = 00000000010 DATA MOVEMENT ......... 04 FST 5 = 00000000006 DECODE ................ 05 FST 6 = 00000000001 SEQUENCE AND CONTROL .. 06 FST 7 = 00000000010 CONDITION TEST ........ 07 FST 8 = 00000000003 SELECTION ............. 08 FST 9 = 00000000009 PRINT LAYOUT .......... 09 FST A = 00000000008 HIT RECORD EXTENSION .. 0A FST B = 00000000003 GET RECORD ............ 0B FST C = 00000000000 CONTROL BREAK CALC .... 0C FST D = 00000000000 UNDEFINED ............. 0D FST E = 00000000000 ARRAY DEF/REL. INDEX .. 0E FST F = 00000000000 DUMMY ................. 0F GETMAIN REQUIREMENT FOR GSA/FNT/FST ... APPROX. 008K

CA                                        16:28:10  24 JUN 2010 CA DATACOM/DB REPORTING FACILITY OS  VERSION nn.n                                 PAGE      4      ------ FIELD NAME ------ ORIGIN  QUAL  HIT ARY  ----------------------------------- REPORTS ------------------------------      ABORT:                   *LABEL*      BLANK                    * GSA * (00)      CODE                     * GSA * (00)   X         1      CURRDATE                 * GSA * (00)      CURRENT-DATE             * GSA * (00)      CURRENT-RATE             PAYROLL (02)   X         1      CURRENT-TIME             * GSA * (00)      CURRTIME                 * GSA * (00)      DATACOM                  * GSA * (01)      DATACOM                  * GSA * (02)      DB-COMMAND               PMF001  (01)      DB-COMMAND               PAYROLL (02)      DB-ELEMENT-LIST          PMF001  (01)      DB-ELEMENT-LIST          PAYROLL (02)      DB-KEY-NAME              PMF001  (01)      DB-KEY-NAME              PAYROLL (02)      DB-KEY-VALUE             PAYROLL (02)      DD                       * GSA * (00)      EMPCODE                  * GSA * (00)   X         1      EMPLOYEE-CODE            PAYROLL (02)      EMPLOYEE-NUMBER          PMF001  (01)   X         1      END-OF-FILE              * GSA * (00)      EOJ:                     *LABEL*      HR                       * GSA * (00)      MM                       * GSA * (00)      MN                       * GSA * (00)      NAME                     PMF001  (01)   X         1      NO-RECORD-FOUND          * GSA * (00)      PAYROLL                  * GSA * (00)      PAYROLL:                 *LABEL*      PMF001                   * GSA * (00)      PMF001:                  *LABEL*      QSEQ                     * GSA * (00)      RECORD-FOUND             * GSA * (00)      SPACE                    * GSA * (00)      SPACES                   * GSA * (00)      SS                       * GSA * (00)      START:                   *LABEL*      STATUS                   PAYROLL (02)      TAG                      * GSA * (00)      TEST:                    *LABEL*      XD                       * GSA * (00)      XM                       * GSA * (00)      XY                       * GSA * (00)      YTD-COMMISSION           PAYROLL (02)   X         1      YTD-TAXES                PAYROLL (02)   X         1      YTD-WAGES                PAYROLL (02)   X         1      YY                       * GSA * (00)      ZERO                     * GSA * (00)      ZEROS                    * GSA * (00)

CA                                        16:28:10  24 JUN 2010 CA DATACOM/DB REPORTING FACILITY OS  VERSION nn.n                                 PAGE      5                                                    (3350   ) ......H I T   F I L E   L A Y O U T......  FD  DROUT                                   DROUT:  FILE DISK SEQUENTIAL VARIABLE RECORD=          90 BLOCK=        4562        BLOCK CONTAINS        4562 CHARACTERS        RECORD CONTAINS          90 CHARACTERS        RECORDING MODE V        DATA RECORD IS HITFILE.  01  HITFILE.        02 RDW                             PICTURE X(4)                 DEFINE RDW                             1 -    4 X        02 TAG-CHARACTER                   PICTURE X                    DEFINE TAG-CHARACTER                   5 -    5 X        02 SORT-KEY.           03 REPORT-NUMBER                PICTURE B                    DEFINE REPORT-NUMBER                   6 -    6 B           03 USER-SORT-KEY                PICTURE X(9)                 DEFINE USER-SORT-KEY                   7 -   15 X        02 REPORT-01.                      ACTIVE/INACTIVE PERSONEL REPORT           03 01.EMPLOYEE-NUMBER           PICTURE X(5).                DEFINE 01.EMPLOYEE-NUMBER             16 -   20 X           03 01.NAME                      PICTURE X(24)                DEFINE 01.NAME                        21 -   44 X           03 00.EMPCODE                   PICTURE X(8)                 DEFINE 00.EMPCODE                     45 -   52 X           03 00.CODE                      PICTURE X(6)                 DEFINE 00.CODE                        53 -   58 X           03 02.CURRENT-RATE              PICTURE 9(5)V999             DEFINE 02.CURRENT-RATE                59 -   66 N3           03 02.YTD-WAGES                 PICTURE 9(6)V99              DEFINE 02.YTD-WAGES                   67 -   74 N2           03 02.YTD-COMMISSION            PICTURE 9(6)V99              DEFINE 02.YTD-COMMISSION              75 -   82 N2           03 02.YTD-TAXES                 PICTURE 9(6)V99              DEFINE 02.YTD-TAXES                   83 -   90 N2

CA                                        16:28:10  24 JUN 2010 CA DATACOM/DB REPORTING FACILITY OS  VERSION nn.n                   PAGE     6   REPORT   01 FIELD NAME                  HDR1  HDR2  DTL   ACC   TOTAL       PICTURE            TAG   FROM   TO   LINE   01   01.EMPLOYEE-NUMBER             8     8     5             8                                   1     8               01.NAME                        4          24            24                                  14    37               00.EMPCODE                     8     4     8             8                                  43    50               00.CODE                        3     4     6             6                          A       56    61               02.CURRENT-RATE                9     9    10            10         99999.999-       A       67    76               02.YTD-WAGES                  12     8    11    13      13         $$$,$$9.99       A       82    94               02.YTD-COMMISSION             12    12    10    12      12         999999.99-       A      102   113               02.YTD-TAXES                  12     8    10    12      12         999999.99-       A      121   132

CA 24 JUN 2010                                         ACTIVE/INACTIVE PERSONEL REPORT                                PAGE     1 --------------------------------------------------------------------------------------------------------------------------------- EMPLOYEE     NAME                         EMPLOYEE     PAY         CURRENT       YEAR-TO-DATE       YEAR-TO-DATE     YEAR-TO-DATE  NUMBER                                   CODE         CODE        PAY RATE             WAGES        COMMISSION             TAXES --------------------------------------------------------------------------------------------------------------------------------- 00001        ALLEN ANTHONY                ACTIVE       SALARY      300.000        $78,000.00          25000.00         23000.00 00002        LENZEN RUTH                  ACTIVE       SALARY       40.500        $10,530.00           1000.00           900.00 00003        MEAD HENRY                   ACTIVE       SALARY       40.500        $10,530.00           1100.00           900.00 00004        PARKER WILLIAM               ACTIVE       SALARY       40.000        $10,400.00           1050.00           900.00 00005        RIGSBY JOHN                  ACTIVE       HOURLY        0.855         $8,892.00           1500.00           700.00 00006        SNOW TERRI                   ACTIVE       SALARY       41.000        $10,660.00           1150.00           950.00 00007        TURNER ARNOLD                INACTIVE 00008        WEEKS LEN                    ACTIVE       SALARY       40.500        $10,530.00           1050.00           900.00 00009        LUTHER GARY                  ACTIVE       HOURLY        0.855         $8,892.00           1500.00           700.00 00010        BRATTON GEORGE               ACTIVE       SALARY       40.000        $10,400.00           1000.00           850.00 00011        CONLEY KEITH                 INACTIVE 00012        EDWARDS BARRY                ACTIVE       SALARY       40.000        $10,400.00           1000.00           850.00 00013        COURTNEY ELIZABETH           ACTIVE       HOURLY        1.000        $10,400.00           2500.00          2000.00 00014        HAGAN LEO                    ACTIVE       SALARY       40.000        $10,400.00           1000.00           850.00 00015        HOUSE GREG                   ACTIVE       SALARY       40.000        $10,400.00           1000.00           850.00 00016        WALKER FRANK                 INACTIVE 00017        DAVENPORT JACQUELINE         ACTIVE       SALARY      100.000        $26,000.00          10000.00         15000.00 00018        PATTERSON AL                 ACTIVE       SALARY       40.000        $10,400.00           1000.00           850.00 00019        HAMILTON DAVID               ACTIVE       SALARY       40.000        $10,400.00           1000.00           850.00 00020        SIMMONDS FELIX               INACTIVE 00021        HOPKINS BARRY                INACTIVE 00022        SIMONSEN RONALD              INACTIVE 00023        FARRIOR HOWARD               INACTIVE 00024        PELTIER ROSS                 ACTIVE       SALARY      100.000        $26,000.00           8500.00         11500.00 00025        DRUMMOND GEORGE              ACTIVE       SALARY       90.000        $23,400.00           7500.00         10500.00 00026        SIDWEBER PATRICIA            ACTIVE       SALARY       95.000        $24,700.00           7900.00         11000.00 00027        FULLERTON CARL               ACTIVE       HOURLY        1.100        $11,440.00           2500.00          1500.00 00028        LOVELL RAYMOND               ACTIVE       SALARY       90.000        $23,400.00           8500.00         11000.00 00029        NEEDHAM TIMOTHY              INACTIVE 00030        EVERS DANNY                  ACTIVE       SALARY       97.500        $25,350.00           9000.00          5500.00 00031        YOUNG MICHAEL                ACTIVE       SALARY       92.500        $24,050.00           7500.00          6000.00 00032        SCOTT DAVID                  INACTIVE 00033        NARMOUR ROBERT               ACTIVE       HOURLY        0.865         $8,996.00           1500.00           700.00 00034        OLVERA DONALD                ACTIVE       SALARY       85.000        $22,100.00           7000.00          5500.00 00035        SEAGRAVES ROBERT             ACTIVE       SALARY       80.000        $20,800.00           7300.00          5300.00 00036        MOTT THOMAS                  ACTIVE       SALARY       90.000        $23,400.00              0.00          5800.00 00037        MCEVOY PATRICK               INACTIVE 00038        BREEDEN JERRY                ACTIVE       SALARY       78.500        $20,410.00              0.00          4500.00 00039        CARR STEVE                   ACTIVE       SALARY       87.500        $22,750.00           5000.00          7550.00 00040        DOBBS ANNA                   ACTIVE       HOURLY        0.950         $9,880.00           2000.00          2700.00 00041        FITZHUGH JAMES               INACTIVE 00042        GILMER DONALD                ACTIVE       HOURLY        0.925         $9,620.00           2000.00          2500.00 00043        AINSWORTH STEVE              ACTIVE       SALARY       88.500        $23,010.00              0.00          5300.00 00044        HIFFMAN GREGORY              INACTIVE 00045        JONES WILLIAM                ACTIVE       SALARY       75.000        $19,500.00              0.00          4500.00 00046        LANE GRACE                   ACTIVE       SALARY       75.000        $19,500.00              0.00          4700.00 00047        THOMPSON JEFF                ACTIVE       HOURLY        0.925         $9,620.00           1500.00          2300.00 00048        WALLACE RUTH                 ACTIVE       SALARY       45.000         $1,000.00              0.00          2500.00 00049        YATES FLOYD                  INACTIVE 00050        POWELL ROBERT                ACTIVE       SALARY       80.000        $20,800.00           1500.00          4600.00 00051        MOORE VICTOR                 ACTIVE       SALARY       76.500        $19,890.00           1700.00          4650.00

CA 24 JUN 2010                                         ACTIVE/INACTIVE PERSONEL REPORT                                PAGE     2 -------------------------------------------------------------------------------------------------------------------------------- EMPLOYEE     NAME                         EMPLOYEE     PAY         CURRENT      YEAR-TO-DATE       YEAR-TO-DATE     YEAR-TO-DATE  NUMBER                                   CODE         CODE        PAY RATE            WAGES        COMMISSION             TAXES -------------------------------------------------------------------------------------------------------------------------------- 00052        JEFFERSON ANTON              ACTIVE       SALARY       72.500        $18,850.00           1600.00          4350.00 00053        GRAHAM PATRICK               INACTIVE 00054        COOK HOWARD                  ACTIVE       SALARY       75.500        $19,630.00           1900.00          4850.00 00055        BAXTER JACK                  ACTIVE       SALARY       73.000        $18,980.00           2000.00          5000.00 00056        HIGGINS BENJAMIN             INACTIVE 00057        FINLEY MARY                  ACTIVE       SALARY       76.000        $19,760.00           1900.00          4900.00 00058        RHODES JOHN                  ACTIVE       HOURLY        0.910         $9,464.00           1500.00          2250.00 00059        NASH KEITH                   ACTIVE       SALARY       72.000        $18,720.00           1200.00          5750.00 00060        KEOMIG RICHARD               ACTIVE       SALARY       72.500        $18,850.00           1500.00          2700.00 00061        GANTZ CAROLINE               ACTIVE       SALARY       70.000        $18,200.00           1500.00          2650.00 00062        CARGILL FORREST              INACTIVE 00063        AVERY SCOTT                  ACTIVE       SALARY       71.000        $18,460.00           2000.00          2600.00 00064        BLAIR RONALD                 ACTIVE       SALARY       70.000        $18,200.00           2500.00          2600.00 00065        FISHER JOHN                  INACTIVE 00066        HAWKINS ANDREW               ACTIVE       SALARY       69.000        $17,940.00           1600.00          2650.00 00067        KENT CHARLES                 ACTIVE       SALARY       68.000        $17,680.00           1850.00          2600.00 00068        MOREY ELMER                  ACTIVE       SALARY       67.500        $17,550.00           2300.00          2550.00 00069        ROBERTS MELVIN               ACTIVE       HOURLY        0.900         $9,360.00           1500.00          1000.00 00070        SANDERS JACK                 ACTIVE       SALARY       69.500        $18,070.00           2150.00          2650.00 00071        WORDEN EDWARD                ACTIVE       SALARY       68.500        $17,810.00           1200.00          2500.00 00072        SMALLEY TRAVIS               INACTIVE 00073        MORAN VERNON                 ACTIVE       SALARY       67.500        $17,550.00           1350.00          2550.00 00074        KELLY EUGENE                 ACTIVE       HOURLY        0.900         $9,360.00           1500.00          1000.00 00075        CLARKE LARRY                 ACTIVE       SALARY       65.000        $16,900.00           2150.00          2500.00 00076        AGEE FRANK                   INACTIVE 00077        BREEN GEORGE                 ACTIVE       SALARY       66.000        $17,160.00           1750.00          2550.00 00078        CHANDLER DIANE               ACTIVE       SALARY       63.000        $16,380.00           1600.00          2300.00 00079        GARRISON WILLIAM             ACTIVE       HOURLY        0.890         $9,256.00           1500.00          1000.00 00080        HILL CONRAD                  ACTIVE       SALARY       66.500        $17,290.00           1800.00          2300.00 00081        MORGAN JOSEPH                ACTIVE       SALARY       62.500        $16,250.00           1725.00          2100.00 00082        PULLIAM JAMES                ACTIVE       SALARY       63.500        $16,510.00           1250.00          2150.00 00083        TURNER ALBERT                ACTIVE       SALARY       65.000        $16,900.00           1300.00          2300.00 00084        WHITE PAUL                   ACTIVE       SALARY       64.500        $16,770.00           2300.00          2500.00 00085        SIMPSON HARVEY               ACTIVE       SALARY       63.500        $16,510.00           2000.00          2400.00 00086        RHODES ROYCE                 INACTIVE 00087        OSBORN DONALD                ACTIVE       HOURLY        0.890         $9,256.00           1500.00           850.00 00088        ERWIN ROY                    ACTIVE       SALARY       61.500        $15,990.00           1700.00          2200.00 00089        HOUSLEY EARL                 INACTIVE 00090        IVERSON HECTOR               ACTIVE       SALARY       62.500        $16,250.00           1500.00          2250.00 00091        PARKER STUART                ACTIVE       SALARY       62.000        $16,120.00           1200.00          2200.00 00092        MCDAVID KENNETH              ACTIVE       HOURLY        0.900         $9,360.00           1500.00           850.00 00093        HANSON FRED                  ACTIVE       SALARY       61.500        $15,990.00           1300.00          2000.00 00094        CARLSON RICHARD              ACTIVE       SALARY       61.000        $15,860.00           1250.00          2000.00 00095        JOPLIN TINA                  ACTIVE       SALARY       62.000        $16,120.00           1550.00          2100.00 00096        HENDRICK RONALD              ACTIVE       SALARY       61.000        $15,860.00           1800.00          2150.00 00097        BRET JOHN                    INACTIVE 00098        EVANS LARRY                  ACTIVE       SALARY       62.000        $16,120.00           2100.00          2300.00 00099        HOYLE RUTH                   ACTIVE       SALARY       61.500        $15,990.00           2350.00          2400.00 00100        MADDEN SAMUEL                ACTIVE       HOURLY        0.880         $9,152.00           1500.00           800.00 00101        PULLIAM MARK                 INACTIVE 00102        WILKES EARL                  ACTIVE       SALARY       61.000        $15,860.00           2150.00          2250.00

CA 24 JUN 2010                                         ACTIVE/INACTIVE PERSONEL REPORT                                PAGE     3 --------------------------------------------------------------------------------------------------------------------------------- EMPLOYEE     NAME                         EMPLOYEE     PAY         CURRENT       YEAR-TO-DATE       YEAR-TO-DATE     YEAR-TO-DATE  NUMBER                                   CODE         CODE        PAY RATE             WAGES        COMMISSION             TAXES --------------------------------------------------------------------------------------------------------------------------------- 00103        JARRETT LOUIS                ACTIVE       SALARY       60.000         $15,600.00           2050.00          2150.00 00104        BURGEN JAYNE                 ACTIVE       SALARY       60.500         $15,730.00           1800.00          2150.00 00105        CHURCH PHILLIP               ACTIVE       SALARY       60.000         $15,600.00           1950.00          2100.00 00106        KIDWELL DONALD               ACTIVE       HOURLY        0.885          $9,204.00           1500.00           850.00 00107        ROCKWELL SUSAN               ACTIVE       SALARY       58.500         $15,210.00           1200.00          1900.00 00108        WALKER DENNIS                ACTIVE       SALARY       59.000         $15,340.00           1350.00          2000.00 00109        WOLF PAUL                    ACTIVE       SALARY       58.000         $15,080.00           1425.00          1950.00 00110        STEWARD BYRON                ACTIVE       SALARY       59.000         $15,340.00           1850.00          2100.00 00111        PATMAN ROBERT                ACTIVE       SALARY       57.500         $14,950.00           1900.00          2000.00 00112        LOPEZ DAVID                  ACTIVE       HOURLY        0.875          $9,100.00           1500.00           800.00 00113        FLYNN GARY                   ACTIVE       SALARY       57.000         $14,820.00           2100.00          2000.00 00114        CAREY FRED                   INACTIVE 00115        ABEL PHILIP                  ACTIVE       SALARY       58.000         $15,080.00           1250.00          1900.00 00116        HOLCOMB MARK                 INACTIVE 00117        PRICE JOEL                   ACTIVE       SALARY       57.000         $14,820.00           1350.00          1850.00 00118        SUTER MORRIS                 ACTIVE       SALARY       56.500         $14,690.00           2000.00          1950.00 00119        WEIR HARVEY                  ACTIVE       HOURLY        0.875          $9,100.00           1500.00           800.00 00120        SAUNDERS LOUIS               ACTIVE       SALARY       57.500         $14,950.00           1750.00          1950.00 00121        BAGNALL CLIFTON              ACTIVE       SALARY       56.000         $14,560.00           1650.00          1850.00 00122        FONTANA WALLACE              ACTIVE       SALARY       57.000         $14,820.00           1950.00          2000.00 00123        NEELY ROY                    ACTIVE       SALARY       56.000         $14,560.00           2150.00          2000.00 00124        WREN PATRICIA                INACTIVE 00125        SMITH DANIEL                 INACTIVE 00126        RICHMOND SCOTT               ACTIVE       SALARY       55.000         $14,300.00           1200.00          1750.00 00127        LANSING STEPHEN              ACTIVE       SALARY       51.000         $13,260.00           1850.00          1650.00 00128        DOUGAN RAYMOND               ACTIVE       SALARY       52.500         $13,650.00           1150.00          1550.00 00129        BEACH MARCUS                 ACTIVE       HOURLY        0.885          $9,204.00           1500.00           800.00 00130        DIETER RODNEY                ACTIVE       SALARY       51.000         $13,260.00           1250.00          1550.00 00131        HAYWOOD VANCE                ACTIVE       SALARY       51.500         $13,390.00           2700.00          2000.00 00132        PELTON LEWIS                 ACTIVE       SALARY       53.500         $13,910.00           1650.00          1750.00 00133        WASHBURN STELLA              ACTIVE       SALARY       52.500         $13,650.00           2050.00          1750.00 00134        FREEMAN BERNARD              ACTIVE       HOURLY        0.885          $9,204.00           1500.00           800.00 00135        JACKSON WILBURN              ACTIVE       SALARY       53.500         $13,910.00           1900.00          1800.00 00136        LINDSTROM ROGER              ACTIVE       SALARY       51.000         $13,260.00           1250.00          1550.00 00137        SHEPHERD IRA                 ACTIVE       SALARY       50.000         $13,000.00           1350.00          1500.00 00138        DECKER TERRY                 INACTIVE 00139        NOLAND TURNER                ACTIVE       SALARY       49.000         $12,740.00           1700.00          1500.00 00140        CAMPBELL WAYNE               ACTIVE       SALARY       48.500         $12,610.00           1100.00          1400.00 00141        KERBY RICHARD                ACTIVE       HOURLY        0.880          $9,152.00           1500.00           800.00 00142        MORAN SIMON                  ACTIVE       SALARY       50.000         $13,000.00           1200.00          1650.00 00143        SHULTZ IRWIN                 INACTIVE 00144        TRENT PETER                  ACTIVE       SALARY       47.500         $12,350.00           1000.00          1300.00 00145        GOODWIN PATRICK              ACTIVE       SALARY       48.000         $12,480.00           1000.00          1300.00 00146        LANE BARRY                   ACTIVE       HOURLY        0.880          $9,152.00           1500.00           800.00 00147        MAYFIELD GERALD              ACTIVE       SALARY       47.500         $12,350.00           1000.00          1300.00 00148        TENNISON CLINTON             ACTIVE       SALARY       47.500         $12,350.00           1000.00          1300.00 00149        HORN JAMES                   ACTIVE       SALARY       46.500         $12,090.00           1050.00          1250.00 00150        GEIGER ROBERT                ACTIVE       SALARY       46.500         $12,090.00           1100.00          1250.00 00151        POSEY NANA                   INACTIVE 00152        LONG ROY                     ACTIVE       SALARY       46.000         $11,960.00           1500.00          1150.00 00153        SCHAFER ARTHUR               ACTIVE       HOURLY        0.875          $9,100.00           1500.00           750.00

CA 24 JUN 2010                                         ACTIVE/INACTIVE PERSONEL REPORT                                PAGE     4 --------------------------------------------------------------------------------------------------------------------------------- EMPLOYEE     NAME                         EMPLOYEE     PAY         CURRENT       YEAR-TO-DATE       YEAR-TO-DATE     YEAR-TO-DATE  NUMBER                                   CODE         CODE        PAY RATE             WAGES        COMMISSION             TAXES --------------------------------------------------------------------------------------------------------------------------------- 00154        OWEN JOHN                    ACTIVE       SALARY       46.000         $11,960.00           1400.00          1100.00 00155        NALL CAROL                   INACTIVE 00156        WRIGHT BILL                  ACTIVE       SALARY       45.000         $11,700.00           1350.00          1100.00 00157        TONROY RAY                   ACTIVE       HOURLY        0.875          $9,100.00           1500.00           750.00 00158        IVEY SCOTT                   ACTIVE       SALARY       45.500         $11,830.00           1200.00          1100.00 00159        FIELDS BEN                   ACTIVE       SALARY       46.000         $11,960.00           1250.00          1200.00 00160        CHILDS ROBIN                 ACTIVE       SALARY       45.000         $11,700.00           1150.00          1050.00 00161        AMADON KEVIN                 ACTIVE       SALARY       45.500         $11,830.00           1100.00          1050.00 00162        AKARD LISA                   ACTIVE       SALARY       45.000         $11,700.00           1100.00          1050.00 00163        BURCH DONALD                 INACTIVE 00164        JUDD LENA                    ACTIVE       HOURLY        0.870          $9,048.00           1500.00           750.00 00165        MOORING LOUIS                ACTIVE       SALARY       44.500         $11,570.00           1200.00          1000.00 00166        THORNBERG JERRY              ACTIVE       SALARY       44.500         $11,570.00           1000.00           950.00 00167        BICKMAN FRANK                ACTIVE       SALARY       45.500         $11,830.00           1050.00          1000.00 00168        STANYER VERNON               ACTIVE       SALARY       44.000         $11,440.00           1000.00          1000.00 00169        NATHAN TERESA                INACTIVE 00170        MC BETH CHARLES              ACTIVE       HOURLY        0.870          $9,048.00           1500.00           750.00 00171        HOSEK DONALD                 ACTIVE       SALARY       44.000         $11,440.00           1100.00           950.00 00172        EVERTS PRICE                 ACTIVE       SALARY       43.500         $11,310.00           1150.00          1000.00 00173        BRASHEAR DAVID               ACTIVE       SALARY       44.500         $11,570.00           1200.00          1050.00 00174        ABSHIRE SUE                  ACTIVE       SALARY       43.000         $11,180.00           1100.00          1050.00 00175        IVEY FRANK                   ACTIVE       SALARY       43.000         $11,180.00           1000.00          1000.00 00176        LANGSTON MELVIN              ACTIVE       SALARY       42.500         $11,050.00           1200.00          1000.00 00177        REDMOND FRED                 ACTIVE       HOURLY        0.865          $8,996.00           1500.00           700.00 00178        WEISBERG LESLIE              INACTIVE 00179        VICKERY PETE                 INACTIVE 00180        TOVAR ED                     ACTIVE       SALARY       42.000         $10,920.00           1050.00           900.00 00181        OTTO DAN                     ACTIVE       SALARY       42.500         $11,050.00           1300.00           950.00 00182        NEEDUM VERNICE               ACTIVE       SALARY       42.000         $10,920.00           1250.00           950.00 00183        MERCHAN JOHN                 ACTIVE       HOURLY        0.865          $8,996.00           1500.00           700.00 00184        LINDGREN DONALD              ACTIVE       SALARY       42.000         $10,920.00           1100.00          1000.00 00185        HOLLIS ROBERT                ACTIVE       SALARY       41.500         $10,790.00           1200.00          1000.00 00186        GRIER BRAD                   ACTIVE       SALARY       41.500         $10,790.00           1250.00           950.00 00187        FIELD RAY                    ACTIVE       SALARY       42.000         $10,920.00           1100.00          1000.00 00188        SPEERS ELLEN                 ACTIVE       SALARY       42.000         $10,920.00           1100.00          1000.00 00189        ROWELL PATRICK               ACTIVE       SALARY       41.500         $10,790.00           1000.00           900.00 00190        MILLER CHRIS                 ACTIVE       HOURLY        0.860          $8,944.00           1500.00           700.00 00191        KLEIN CAROL                  INACTIVE 00192        HORST BRUCE                  ACTIVE       SALARY       41.500         $10,790.00           1000.00           900.00 00193        GRANGER BUCK                 ACTIVE       SALARY       41.000         $10,660.00           1150.00           950.00 00194        EGGERT TOM                   INACTIVE 00195        DABBS GARY                   ACTIVE       SALARY       41.000         $10,660.00           1100.00           900.00 00196        BENHAM JERRY                 ACTIVE       HOURLY        0.860          $8,944.00           1200.00           700.00 00197        ATWELL SARAH                 ACTIVE       SALARY       40.500         $10,530.00           1100.00           900.00 00198        BROWN PETE                   ACTIVE       SALARY       41.500         $10,790.00           1050.00           900.00 00199        FISCHER ROGER                ACTIVE       SALARY       41.000         $10,660.00           1100.00           900.00 00200        HOWARD LANE                  ACTIVE       SALARY       41.000         $10,660.00           1150.00           950.00                                                                                  -------------       ------------    ------------ GRAND TOTAL                                                                      $2315,780.00         318050.00        379000.00

RUN DIAGNOSTICS INDEX VIOLATIONS       00000000000 PROGRAM CHECKS         00000000000 HITS FOR REPORT   1  - 00000000200 TOTAL RECORDS SELECTED 00000000200