PayTime tm DATABASE CONTENTS

Human Resources Employee file - Database Name: HREMPE.dbf

Human Resources Employee Notes file - Database Name: HRNOTES.dbf

Human Resources Employee Report file -Database Name: HRREPORT.dbf

Human Resources Employee Field Structure file -Database Name: HRSTRU.dbf

Payroll Employee file - Database Name: PREMPE.dbf

Payroll Employer file - Database Name: PREMPR.dbf

Human Resources Report Writer Printing Control file

Database Name: HRIN.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
RI_REPORT	C	30		Y
RI_LIBRARY	C	80		N
RI_MASTER	C	80		N
RI_OUTFILE	C	80		N
RI_OUTAPPN	L	1		N
RI_PEQUIT	L	1		N
RI_CHKTIME	C	1		N
RI_NOESC	L	1		N
RI_PRINTER	C	1		N
RI_BEGPAGE	N	4		N
RI_ENDPAGE	N	4		N
RI_TEST	L	1		N
RI_SCOPE	C	1		N
RI_LOSCOPE	C	100		N
RI_HISCOPE	C	100		N
RI_COPIES	N	4		N
RI_FILTER	C	254		N
RI_QUERY	C	1		N
RI_DISPERR	L	1		N
REPORT	C	65		Y

Payroll Dates file

Database Name: PRDATES.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
CPID	C	4		N
MPFRM	D	8		N
MPTO	D	8		N
MPAYDAY	D	8		N

Payroll Employee Benefits file

Database Name: PREMPBEN.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
CDE	C	13		N
DATE	D	8		N
WK	N	4		N
PCDE	C	1		N
JHRS	N	7	2	N
JRATE	N	5	2	N
COST	C	16		N
PST	C	1		N
JDIV	C	1		N

Payroll Files file

Database Name: PRFILES.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
TYPE	C	3		N	File type
FILE	C	8		A	File ID
DATE	D	8		N	Date of creation
STATUS	C	1		N	File Status

Payroll Hours Entry file

Database Name: PRHRS.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
CDE	C	13		N
JDIV	C	1		N
DATE	D	8		N
PCDE	C	1		N
JHRS	N	7	2	N
JRATE	N	5	2	N
JAMT	N	8	2	N
COST	C	16		N
SDR	N	6	3	N
WK	N	4		N
PST	C	1		N

Payroll Monthly file

Database Name: PRMONTH.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
KEY	C	6		N
CDE	C	13		N	Employee ID + Division
IPERFR	D	8		N	Pay Period From date
IPERTO	D	8		N	Pay Period To date
IRTAMT	N	9	2	N
IOTAMT	N	9	2	N
IDTAMT	N	9	2	N
ICOM	N	9	2	N
IADV	N	9	2	N
IHP	N	9	2	N
IOP	N	9	2	N
INT	N	9	2	N
IGROSS	N	9	2	N
DINCTA	N	9	2	N	Gross Pay
DCPP	N	7	2	N
DQPP	N	7	2	N
DADV	N	9	2	N
DUI	N	7	2	N
DMP1	N	9	2	N
DMP2	N	9	2	N
DDPL	N	9	2	N
DOP1	N	9	2	N
DOP2	N	9	2	N
DRD1	N	9	2	N
DRD2	N	9	2	N
DPEN	N	9	2	N
DUN	N	9	2	N
DPQT	N	9	2	N
DOD	N	9	2	N
DNET	N	9	2	N	Net Pay
DPAYDAY	D	8		N	Pay Day
DCHECK	N	6		N	Check No.
DCODE	N	1		N	Code

Payroll Current Pay file

Database Name: PRPAY.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
CDE	C	13		N	Employee ID + Division
RTAMT	N	9	2	N
OTAMT	N	9	2	N
DTAMT	N	9	2	N
AD1	C	20		N
AA1	N	9	2	N
AD2	C	20		N
AA2	N	9	2	N
AD3	C	20		N
AA3	N	9	2	N
GROSS	N	9	2	N	Gross Pay
INCTAX	N	9	2	N
CPP	N	8	2	N
QPP	N	8	2	N
UI	N	8	2	N
DD1	C	14		N
DA1	N	9	2	N
DD2	C	14		N
DA2	N	9	2	N
DD3	C	14		N
DA3	N	9	2	N
DD4	C	14		N
DA4	N	9	2	N
DD5	C	14		N
DA5	N	9	2	N
DD6	C	14		N
DA6	N	9	2	N
DD7	C	14		N
DA7	N	9	2	N
DD8	C	14		N
DA8	N	9	2	N
RD1	C	14		N
RA1	N	9	2	N
RD2	C	14		N
RA2	N	9	2	N
TDED	N	9	2	N
NET	N	9	2	N	Net Pay
CPPEX	N	9	2	N	Canadian pension plan exemption
HPB	N	9	2	N	Holiday Pay Bank for this Pay Period
EPER	C	1		N
PFRM	D	8		N
PMID	D	8		N
PTO	D	8		N
RT1	N	6	1	N
RT2	N	6	1	N
RT3	N	6	1	N
RT4	N	6	1	N
RT5	N	6	1	N
RT6	N	6	1	N
RTHRS	N	6	1	N
OT1	N	6	1	N
OT2	N	6	1	N
OT3	N	6	1	N
OT4	N	6	1	N
OT5	N	6	1	N
OT6	N	6	1	N
OTHRS	N	6	1	N
DT1	N	6	1	N
DT2	N	6	1	N
DT3	N	6	1	N
DT4	N	6	1	N
DT5	N	6	1	N
DT6	N	6	1	N
DTHRS	N	6	1	N
TOTHRS	N	6	1	N
EWKS	N	7	4	N
INSERN	N	9	2	N
UIWKS	N	7	4	N
UIE	N	6		N
HRS	N	6	1	N
WK1D	N	1		N
WK2D	N	1		N
WK3D	N	1		N
WK4D	N	1		N
WK5D	N	1		N
WK6D	N	1		N
WKTD	N	2		N
UIPD	C	1		N
ETB	N	9	2	N	Estimated Taxable Benefits
PAYDAY	D	8		N	Pay Day
CHKNO	N	6		N	Check No.
HPHRS	N	6	1	N	Holiday Pay hours
SHHRS	N	6	1	N	Sick Pay hours
SPHRS	N	6	1	N	Special hours
LTHRS	N	6	1	N	Lieu time hours

Payroll Pay Rates file

Database Name: PRRATES.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
CDE	C	2		N	Job Code
DESC	C	20		N	Job Description
RATE	N	7	3	N	Rate of Pay (will not be used in 1997)
EMP_ID	C	12		N	Employee ID
EDATE	D	8		N	Effective date of Employee's Pay Rate
ROP	N	8	3	N	Rate of Pay
UNIT	C	1		N	Unit of Pay

Payroll Record of Employment file

Database Name: PRROE.dbf

Payroll Record of Employment Laser Printer file

Database Name: PRROELP.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
FHEADER	C	8		N	"PDFSProe"
CSV	C #	2		N	Current Version [e.g. 03]
MSV	C #	2		N	Minor Version [e.g. 00]
SR	C #	3		N	Software Revision [e.g. 000]
LANG	C	1		N	Print Language [E or F]
ROESN	C	9		N	ROE Serial No.
RROE	C	9		N	Amend/Replace Serial No.
EMP_ID	C	15		N	Employee identification
ENAME	C	60		N	Employer's Name
ADDRESS1	C	30		N	Employer's Address 1
ADDRESS2	C	30		N	Employer's Address 2
POST_CDE	C	6		N	Employer's Postal Code
REMIT_NO	C	15		N	CCRA Business No.
EPER	C	1		N	Pay Period Type
SIN	C	9		N	Social Insurance Number
FNAME	C	28		N	Employee Given Name
INIT	C	1		N	Employee Initial
SNAME	C	28		N	Employee Surname
ADD	C	30		N	Employee Address 1
CTY	C	30		N	Employee Address 2
PROVPC	C	30		N	Employee Address 3
FDW	C *	8		N	First Day Worked
LDWP	C *	8		N	Last Day Which Paid
FPPED	C *	8		N	Final Pay Period End Date
POS	C	30		N	Occupation Description
EDR	C *	8		N	Expected Date of Recall
EDRD	C	1		N	Expected Recall Code
TIHRS	C #	4		N	Total Insurable Hours
TIERN	C #	9		N	Total Insurable Earnings
DE	C	1		N	Detail Earnings [Y or N]
IE01 to IE27	C #	9	[2]	N	Earnings for Pay Period 1 to 27
RFRI	C	1		N	Reason for ROE Code
CONT	C	30		N	Contact Person Name
TELAC	C	3		N	Contact Phone Area Code
TELPN	C	7		N	Contact Phone Number
TELPE	C	4		N	Contact Phone Extension
MOS	C	1		N	Moneys on Seperation [Y or N]
HPC	C	1		N	Vacation Pay Code [V or ' ']
HP	C #	9	[2]	N	Vacation Pay Amount
SH1C	C	1		N	Statutory Holiday 1 Code
SH1D	C *	8		N	Statutory Holiday 1 Date
SH1	C #	9	[2]	N	Statutory Holiday 1 Amount
SH2C	C	1		N	Statutory Holiday 2 Code
SH2D	C *	8		N	Statutory Holiday 2 Date
SH2	C #	9	[2]	N	Statutory Holiday 2 Amount
SH3C	C	1		N	Statutory Holiday 3 Code
SH3D	C *	8		N	Statutory Holiday 3 Date
SH3	C #	9	[2]	N	Statutory Holiday 3 Amount
OMD1	C	1		N	Other Money 1 Description
OM1	C #	9	[2]	N	Other Money 1 Amount
OMD2	C	1		N	Other Money 2 Description
OM2	C #	9	[2]	N	Other Money 2 Amount
OMD3	C	1		N	Other Money 3 Description
OM3	C #	9	[2]	N	Other Money 3 Amount
C1	C	30		N	Comments 1
C2	C	30		N	Comments 2
C3	C	30		N	Comments 3
C4	C	30		N	Comments 4UIA
PSP	C *	8		N	Paid Sick/Parental Date
PSPA	C #	9	[2]	N	Paid Sick/Parental Amount
NSDCD	C	1		N	Paid Sick/Parental Period [D or W]
CLANG	C	1		N	Correspondence Language
ISSUER	C	30		N	Issuer Name
TEL2AC	C	3		N	Issuer Phone Area Code
TEL2PN	C	1		N	Issuer Phone Number
TEL2PE	C	4		N	Issuer Phone Extension
DATE	C *	8		N	Date Issued
AF	C	1		N	Amended Flag [Value="0"]

# Numeric * Date as DDMMYYYY [o] Implied decimals

Payroll Taxable Benefits file

Database Name: PRTB.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
EMP_ID	C	12		N	Employee identification
FR	N	8	2	N	Housing, board, and lodging
PUA	N	8	2	N	Personal use of employee's auto
IFL	N	9	2	N	Interest-free and low-interest loan
MT	N	9	2	N	Travel in prescribed area
OT	N	9	2	N	[No longer used]
SOB	N	9	2	N	Stock option benefits
OTB	N	8	2	N	Other taxable allowances, benefits
DPSP	N	8	2	N	Deferred profit sharing plan #
PA	N	9	2	N	Pension Adjustment
CH	N	8	2	N	Charitable donations
PSC	N	8	2	N	Past-Service contributions
RPP1	N	1	0	N	Registered pension plan indicator
PASE	N	1	0	N	Placement Agency - SE indicator
NTE	N	10	2	N	Non-taxable earnings - Status Indian
NTECPP	N	1	0	N	Non-taxable earnings - Status Indian (elected CPP indicator)
EOC	N	11	2	N	Employment outside Canada
NDOC	N	3	0	N	Number of days outside Canada
PSEI	N	1	0	N	Power Saw employee indicator
HL	N	10	2	N	Home Loan
SOBF	N	10	2	N	Stock option benefits footnote
SOBI	N	1	0	N	Stock option benefits indicator
CORN	C	33		N	Charitable organization registration number
MT2	N	10	2	N	Medical travel
BL	N	8	2	N	Board and lodging at special work site
MOEA	N	10	2	N	Municipal office's expense allowance
AKA	N	10	2	N	Automobile per-kilometer allowance
OINE	C	20		N	Occupation of individuals who are not employees
AWKS	N	6	4	N	Adjustment to Weeks employed
ACPPEX	N	9	2	N	Adjustment to CPP exempt earnings
ACPP	N	7	2	N	Adjustment to CPP deduction
AUIE	N	9	2	N	Adjustment to Unemployment Insurable earnings
AUI	N	7	2	N	Adjustment to Unemployment Insurable deduction

Payroll Job Costing Total hours file

Database Name: PRTOT.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
CDE	C	18		N
JHRS	N	7	2	N
AMOUNT	N	9	2	N

Payroll Accouting Transaction file

Database Name: PRTRAN.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
DATE	D	8		N	Date of Check or Journal Entry
NAME	C	25		N	Name of Employee
REFERENCE	C	8		N	Check No. or Journal Entry No.
AMOUNT	N	12	2	N	Amount of Check or Journal Entry
GL	C	7		N	General Ledger Account No.
SOURCE	C	2		N	Defaults to 'PT'

Payroll Unemployment Insurance file

Database Name: PRUI.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
CDE	C	12		N
DATE	C	6		N
INSERN	N	7	2	N
UIPER	N	6	4	N

Payroll Workmen's Compensation Rates file

Database Name: PRWCBRTE.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
PCDE	C	3		A	Province Code
PROVINCE	C	20		N	Provincial Name
WCB_MAX	N	9	2	N	Workmen's Compensation Maximum Yearly Earnings
YEAR	N	4		N	Year of above earnings

Payroll Help file

Database Name: PTHELP.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
CONTENTS	C	65		A	Help Contents
KEYS	C	5		N	Key stoke sequence from Master Menu
SCREEN_NO	C	15		N	Screen No from Upper left of screen
TEXT_HELP	M	10		N	Help Text

Payroll Next Check No.

Database Name: PYCHKNO.dbf

Field Name	Type	Lgth	Dec.	Indx	Description
CHKNO	N	6		N	Cheque No.

[Home] [Top] [Overview] [Operations] [Appendix]