ARC - PAYROLL.TXT -- DOCUMENTATION FOR PAYROLL/PERSONNEL SYSTEM
    ANY Comments would be appreciated. Please address your
    notes to: Martin J. Michaelson
              P. O. Box 771
              West Nyack, NY 10994


  * PERSPAY1.PRG is written for dBASE III +
  * by Martin J. Michaelson, Version 2.6
  * dated 01/15/87
  * Copyright @ 1987, Martin J. Michaelson

The following data files are utilized by PAYROLL.PRG
all files should indexed on "emp_nmbr",et.al.

  USE PAY_PERS (Personnel records db)
  Index on emp_nmbr to empno
  Index on name to persons
  Index on D to dept
  display structure
Structure for database: A:PAY_PERS.dbf
Number of data records:      11
Date of last update   : 01/05/87
Field  Field Name  Type       Width    Dec
    1  EMP_NMBR    Numeric        3
    2  D           Character      1
    3  NAME        Character     24
    4  SS_NMBR     Character     11
    5  ADDRESS     Character     24
    6  CITY_ST     Character     24
    7  ZIP         Character      5
    8  DED         Character      2
    9  DEDUCTS     Numeric        2
   10  PAY_RATE    Numeric        7      2
   11  LAST_UP     Date           8
   12  START_DATE  Character      8
   13  END_DATE    Character      8
   ** Total **                  128

  USE PAY_WEK1 (weekly payroll db)
  (The Payroll System requires four
  pay_wek files, one for each quarter.)
  Index on emp_nmbr to empnm1
  Index on week_end to weekly1
  display structure
Structure for database: A:PAY_WEK1.dbf
Number of data records:      10
Date of last update   : 01/12/87
Field  Field Name  Type       Width    Dec
    1  EMP_NMBR    Numeric        3
    2  WEEK_END    Character      8
    3  HRS_REG     Numeric        4      1
    4  HRS_OVT     Numeric        4      1
    5  GRO_PAY     Numeric        7      2
    6  FCIA        Numeric        6      2
    7  FWT         Numeric        7      2
    8  SWT         Numeric        6      2
    9  CWT         Numeric        6      2
   10  DIS         Numeric        4      2
   11  OTHER       Numeric        7      2
   12  TOT_DED     Numeric        7      2
   13  NET_PAY     Numeric        7      2
   ** Total **                   77

  USE PAY_YTD (Year-to-date earning & deductions)
  Index on emp_nmbr to empnmytd
  display structure
Structure for database: A:PAY_YTD.dbf
Number of data records:      11
Date of last update   : 01/12/87
Field  Field Name  Type       Width    Dec
    1  EMP_NMBR    Numeric        3
    2  GRO_YTD     Numeric        8      2
    3  FCIA_YTD    Numeric        7      2
    4  FWT_YTD     Numeric        8      2
    5  SWT_YTD     Numeric        7      2
    6  CWT_YTD     Numeric        6      2
    7  DIS_YTD     Numeric        5      2
    8  OTH_YTD     Numeric        7      2
    9  NET_YTD     Numeric        8      2
    ** Total **                  60

  USE PAY_QTR1 (Quarter-to-date earnings &
  deductions) (The Payroll System requires
  4 pay_qtr files, one for each quarter.)
  Index on emp_nmbr to qtremp1
  display structure
Structure for database: A:PAY_QTR1.dbf
Number of data records:      11
Date of last update   : 01/12/87
Field  Field Name  Type       Width    Dec
    1  EMP_NMBR    Numeric        3
    2  GRO_PAY     Numeric        8      2
    3  FCIA        Numeric        7      2
    4  FWT         Numeric        8      2
    5  SWT         Numeric        7      2
    6  CWT         Numeric        6      2
    7  DIS         Numeric        4      2
    8  TOT_DED     Numeric        8      2
    9  NET_PAY     Numeric        8      2
    ** Total **                  60

  USE WEEKTOTS (Weekly payroll summary)
  display structure
Structure for database: A:WEEKTOTS.dbf
Number of data records:       2
Date of last update   : 01/12/87
Field  Field Name  Type       Width    Dec
    1  WEEK        Character      8
    2  GROWAGE     Numeric        8      2
    3  FCTOT       Numeric        7      2
    4  FWTOT       Numeric        8      2
    5  SWTOT       Numeric        7      2
    6  CWTOT       Numeric        6      2
    7  DISTOT      Numeric        6      2
    8  NETWAGE     Numeric        8      2
    ** Total **                  59
    E.O.F.