View: Earnings Hourly Report

RotoID: CP0093
Table: CPEHRP
Protocol: Flat
DLL: CPEHRP

Compositions: 0

Keys: 2

Title  Fields
Employee  RPTTIME, RPTSUMRY, EMPLOYEE, SORTORDER, PLINETYPE, EARNDED, LINETYPE, CLASSSUM, CLASS
Class  RPTTIME, RPTSUMRY, CLASS, CLASSSUM, EMPLOYEE, SORTORDER, PLINETYPE, EARNDED, LINETYPE

Fields: 19

Field  Index  Type  Title  Attributes  Presentation
RPTTIME  1  Long  Time  E A K R   
RPTSUMRY  2  Boolean  Report Summary  E A K R   
EMPLOYEE  3  String*12  Employee  E A K R  Mask: %-12N
SORTORDER  4  Integer  Sort Order  E A K R  List: 16 entries
1=n/a
2=Earning
3=Gross Pay
4=Cash Benefit
5=Total Earnings
6=Expense Reimbursemnt
7=Cash Advance
8=Taxes and Deductions
9=Net Pay
10=NonCash Item
11=NonCash Advance
12=Accural
13=Hours
14=Hours
15=Pieces
16=Sales
PLINETYPE  5  Integer  P Line Type  E A K R  List: 42 entries
11=CHKD Regular Line
11=CHKD Overtime Line
11=CHKD Shift Diff Line
14=CHKD Disbursed Tips
15=CHKD Vacation Payment
16=CHKD Sick Payment
17=CHKD Comp. Time Payment
21=CHKD Deduction Entry
31=CHKD Federal Income Entry
32=CHKD Federal Insurance Entry
33=CHKD Federal EI Entry
34=CHKD Federal Pension Entry
35=CHKD Federal Health Entry
36=CHKD Federal Other Entry
41=CHKD State Income Entry
42=CHKD State Insurance Entry
43=CHKD State EI Entry
44=CHKD State Pension Entry
45=CHKD State Health Entry
46=CHKD State Other Entry
51=CHKD Local Income Entry
52=CHKD Local Insurance Entry
53=CHKD Local EI Entry
54=CHKD Local Pension Entry
55=CHKD Local Health Entry
56=CHKD Local Other Entry
61=CHKD User Income Entry
62=CHKD User Insurance Entry
63=CHKD User EI Entry
64=CHKD User Pension Entry
65=CHKD User Health Entry
66=CHKD User Other Entry
71=CHKD Exp Reimbursement
72=CHKD Cash Advance
73=CHKD Reported Tips
74=CHKD Allocated Tips
75=CHKD Noncash Advance
76=CHKD Vac Accrual
77=CHKD Sick Accrual
78=CHKD Comp Accrual
81=CHKD Cash Benefit
82=CHKD Noncash Benefit
EARNDED  6  String*6  E/D or Tax  E A K R  Mask: %-6N
LINETYPE  7  Integer  Line Type  E A K R  List: 9 entries
1=Payment
2=Accrual
3=Regular
4=Overtime
5=Shift Differential
6=n/a
7=Normal Withholding
8=Backup Withholding
9=Supplemental Withholding
CLASSSUM  8  Boolean  Class Summary Line  E A K R   
CLASS  9  String*6  Class Code  E A K R  Mask: %-6N
MONTHAMT  10  BCD*10.3  Month Amt  E A   
QUARTERAMT  11  BCD*10.3  Quarter Amt  E A   
YEARAMT  12  BCD*10.3  Year Amt  E A   
MHOURS  13  BCD*9.3  Month Hours  E A   
QHOURS  14  BCD*9.3  Quarter Hours  E A   
YHOURS  15  BCD*9.3  Year Hours  E A   
LASTNAME  16  String*20  Last Name  E A   
FIRSTNAME  17  String*15  First Name  E A   
MIDDLENAME  18  String*15  Middle Name  E A   
SHORTDESC  19  String*15  Description  E A   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.