Dec 282017
 
Very good Payroll Program written in dBase III. Includes source.
File PAYROLL.ZIP from The Programmer’s Corner in
Category Databases and related files
Very good Payroll Program written in dBase III. Includes source.
File Name File Size Zip Size Zip Type
EDITEMPS.PRG 848 439 deflated
EMPYTD.FRM 1990 939 deflated
NAMES.PRG 160 147 deflated
NEWQTR.PRG 533 327 deflated
PAYEMPS.PRG 1322 590 deflated
PAYMENU.PRG 758 394 deflated
PAYROLL.TXT 4304 1102 deflated
PAYWEEK.FRM 1990 1305 deflated
PAY_.FMT 853 342 deflated
PAY_TAX.MEM 161 85 deflated
PERSPAY1.PRG 2407 916 deflated
QTRLY.PRG 294 228 deflated
W2FORM.PRG 838 439 deflated
WAGES.PRG 4935 1774 deflated
YTD.FRM 1990 929 deflated

Download File PAYROLL.ZIP Here

Contents of the PAYROLL.TXT file


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.


 December 28, 2017  Add comments

Leave a Reply