Make your own free website on Tripod.com

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  30 
RI_LIBRARY  80 
RI_MASTER  80 
RI_OUTFILE  80 
RI_OUTAPPN 
RI_PEQUIT 
RI_CHKTIME 
RI_NOESC 
RI_PRINTER 
RI_BEGPAGE 
RI_ENDPAGE 
RI_TEST 
RI_SCOPE 
RI_LOSCOPE  100 
RI_HISCOPE  100 
RI_COPIES 
RI_FILTER  254 
RI_QUERY 
RI_DISPERR 
REPORT  65 

Payroll Dates file

Database Name: PRDATES.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
CPID 
MPFRM 
MPTO 
MPAYDAY 

Payroll Employee Benefits file

Database Name: PREMPBEN.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
CDE  13 
DATE 
WK 
PCDE 
JHRS 
JRATE 
COST  16 
PST 
JDIV 

Payroll Files file

Database Name: PRFILES.dbf

Field Name  Type Lgth  Dec.  Indx  Description 
TYPE  File type 
FILE  File ID 
DATE  Date of creation 
STATUS  File Status 

Payroll Hours Entry file

Database Name: PRHRS.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
CDE  13 
JDIV 
DATE 
PCDE 
JHRS 
JRATE 
JAMT 
COST  16 
SDR 
WK 
PST 

Payroll Monthly file

Database Name: PRMONTH.dbf

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

Payroll Current Pay file

Database Name: PRPAY.dbf

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

Payroll Pay Rates file

Database Name: PRRATES.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
CDE  Job Code 
DESC  20  Job Description 
RATE  Rate of Pay (will not be used in 1997) 
EMP_ID  12  Employee ID 
EDATE  Effective date of Employee's Pay Rate 
ROP  Rate of Pay 
UNIT  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  15 Employee identification 
ENAME C 60 N Employer's Name
ADDRESS1  30 Employer's Address 1
ADDRESS2 30 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 * Final Pay Period End Date
POS C 30   Occupation Description
EDR C *  Expected Date of Recall
EDRD C 1 N Expected Recall Code
TIHRS C #  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 Contact Phone Number
TELPE C 4 N Contact Phone Extension
MOS  Moneys on Seperation [Y or   N]
HPC C 1 Vacation Pay Code [V or ' ']
HP C # 9 [2] Vacation Pay Amount
SH1C C 1 N Statutory Holiday 1 Code
SH1D  C * Statutory Holiday 1 Date
SH1  C # 9 [2] Statutory Holiday 1 Amount
SH2C C 1 N Statutory Holiday 2 Code
SH2D  C *  Statutory Holiday 2 Date
SH2  C # 9 [2] Statutory Holiday 2 Amount
SH3C C 1 N Statutory Holiday 3 Code
SH3D  C *  Statutory Holiday 3 Date
SH3  C # 9 [2] Statutory Holiday 3 Amount
OMD1  Other Money 1 Description
OM1  C # 9 [2] Other Money 1 Amount
OMD2  Other Money 2 Description
OM2  C #  9 [2] Other Money 2 Amount
OMD3  1 Other Money 3 Description
OM3  C # 9 [2] 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 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 1 Correspondence Language
ISSUER  30 Issuer Name
TEL2AC C 3 N Issuer Phone Area Code
TEL2PN 1 Issuer Phone Number
TEL2PE C 4 N Issuer Phone Extension
DATE  C * Date Issued
AF C 1 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  12  Employee identification 
FR  Housing, board, and lodging 
PUA  Personal use of employee's auto 
IFL  Interest-free and low-interest loan 
MT  Travel in prescribed area 
OT  [No longer used] 
SOB  Stock option benefits 
OTB  Other taxable allowances, benefits 
DPSP  Deferred profit sharing plan # 
PA  Pension Adjustment 
CH  Charitable donations 
PSC  N Past-Service contributions 
RPP1  Registered pension plan indicator 
PASE  Placement Agency - SE indicator 
NTE  10  Non-taxable earnings - Status Indian 
NTECPP  Non-taxable earnings - Status Indian (elected CPP indicator) 
EOC  11  Employment outside Canada 
NDOC  Number of days outside Canada 
PSEI  Power Saw employee indicator 
HL  10 Home Loan 
SOBF  10  Stock option benefits footnote 
SOBI  Stock option benefits indicator 
CORN  33  Charitable organization registration number 
MT2  10  Medical travel 
BL  Board and lodging at special work site 
MOEA  10  Municipal office's expense allowance 
AKA  10  Automobile per-kilometer allowance 
OINE  20  Occupation of individuals who are not employees 
AWKS  Adjustment to Weeks employed 
ACPPEX  Adjustment to CPP exempt earnings 
ACPP  Adjustment to CPP deduction 
AUIE  Adjustment to Unemployment Insurable earnings 
AUI  Adjustment to Unemployment Insurable deduction 

Payroll Job Costing Total hours file

Database Name: PRTOT.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
CDE  18 
JHRS  2
AMOUNT 

Payroll Accouting Transaction file

Database Name: PRTRAN.dbf

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

Payroll Unemployment Insurance file

Database Name: PRUI.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
CDE  12 
DATE 
INSERN 
UIPER 

Payroll Workmen's Compensation Rates file

Database Name: PRWCBRTE.dbf

Field Name  Type  Lgth  Dec.  Indx Description 
PCDE  Province Code 
PROVINCE  20  Provincial Name 
WCB_MAX  Workmen's Compensation Maximum Yearly Earnings 
YEAR  Year of above earnings 

Payroll Help file

Database Name: PTHELP.dbf

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

Payroll Next Check No.

Database Name: PYCHKNO.dbf

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


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