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.