View: Employee Histories

RotoID: CP0034
Table:
DLL: CPHSTD

Compositions: 1


RotoID  Table  Title  DLL 

CP0012    Employee Histories Header  CPHSTH

Keys: 1


Title  Fields

Employee   EMPLOYEE, HISTDATE, CATEGORY, EARNDED, LINETYPE, LINENO

Fields: 32


Field  Index  Type  Title  Attributes  Presentation

EMPLOYEE  String*12  Employee  E A K R  Mask: %-12N
HISTDATE  Date  History Date  E A K R   
CATEGORY  Integer  Category code  E A K C R  List: 10 entries
1=Accrual
2=Earning
3=Advance
4=Deduction
5=Expense Reimbursement
6=Benefit
7=Federal Tax
8=State Tax
9=Local Tax
10=User Tax
EARNDED  String*6  Earnings/Deduction-Tax  E A K R  Mask: %-6N
LINETYPE  Integer  Type  E A K R X  List: 6 entries
1=Payment
2=Accrual
3=Regular
4=Overtime
5=Shift Differential
6=n/a
LINENO  Integer  Line Number  E A K C R X   
EARDEDTYPE  Integer  Earnings/Deduction-Tax Type  E A C X  List: 16 entries
1=Salary & Wages
2=Reported Tips
3=Allocated Tips
7=Vacation
8=Sick
9=Banked Time
10=
13=Cash
14=Noncash
18=Insurance Tax
19=Income Tax
20=Employment Tax
21=Pension Plan Tax
22=Health Tax
23=Other Tax
25=n/a
ECNTBASE  BCD*10.3  Employee Base/Sales/Pieces  E A X   
ERATE  BCD*9.5  Employee Rate  E A X   
EEXTEND  10  BCD*10.3  Employee Amount  E A X   
RCNTBASE  11  BCD*10.3  Employer Base/Sales/Pieces  E A X   
RRATE  12  BCD*9.5  Employer Rate  E A X   
REXTEND  13  BCD*10.3  Employer Amount  E A X   
WCC  14  String*6  WCC Code  E A X  Mask: %-6N
GLSEG1  15  String*15  G/L Segment One  E A C X   
GLSEG2  16  String*15  G/L Segment Two  E A C X   
GLSEG3  17  String*15  G/L Segment Three  C X   
TAXWEEKS  18  BCD*4.3  RESERVED - US Only  E A X   
TAXEARNS  19  BCD*10.3  No Ceiling Wage  E A X   
TXEARNCEIL  20  BCD*10.3  Ceiling Wage  E A X   
TAXTIPS  21  BCD*10.3  RESERVED - US Only  E A X   
TXTIPSCEIL  22  BCD*10.3  RESERVED - US Only  E A X   
TAXONTIPS  23  BCD*10.3  RESERVED - US Only  E A X   
UNCOLLTAX  24  BCD*10.3  RESERVED - US Only  E A X   
ECALCMETH  25  Integer  Employee Calculation Method  E A C X  List: 13 entries
1=None
2=Flat
3=Fixed
4=Hourly Rate
5=Amount per Hour
6=Piece Rate Table
7=Percentage of Base
8=Sales Commission Table
9=Wage Bracket Table
10=Hours per Hour Worked
12=Hours per Frequency
13=Tax Bracket Table
14=Percentage of Another Tax
RCALCMETH  26  Integer  Employer Calculation Method  E A C X  List: 8 entries
1=None
2=Flat
5=Amount per Hour
6=Piece Rate Table
7=Percentage of Base
8=Sales Commission Table
9=Wage Bracket Table
15=Percentage of Employee Contribution
DESC  27  String*15  Description  A C   
HOURS  28  BCD*4.3  Hours  E A X   
REGRATE  29  BCD*9.5  Regular Rate  E A X   
TAXNONPER  30  BCD*10.3  Taxable Non-periodic Earnings  E A X   
TAXEARNBD  31  BCD*10.3  Subject to Income Tax before Ded  E A X   
POOLEDTIPS  32  BCD*10.3  Pooled Tips  E A X   

This page was generated on 2003-May-05

Copyright © 2003 ACCPAC International, Inc. All rights reserved.