View: Employee Earnings/Deductions

RotoID: CP0008
Table: CPEMPD
Protocol: Detail, Ordered revisions
DLL:CPEMPD

Compositions: 3

RotoID Tables Title DLL
CP0014 CPEMPL Employees CPEMPL
CP0125 CPEMDO Empl Earn/Ded Optional Fields CPEMDO
CP0041 CPEMDB Employee Billing Details CPEMDB

Keys: 4

Title Fields
Employee Earning/Deduction Code EMPLOYEE, EARNDED
Employee, Category, Type EMPLOYEE, CATEGORY, EARDEDTYPE, EARNDED
Earning/Deduction Code, Distribu EARNDED, DISTCODE
Earning/Deduction Code, Employee EARNDED, EMPLOYEE

Fields: 57

Field Index Type Title Attributes Presentation
EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
EARNDED 2 String*6 Employee Earning/Deduction E A K R X  Mask: %-6N
CALCULATE 3 Boolean Calculate E A  List:2 entries
0 = No
1 = Yes
STARTS 4 Date Start date E A 
ENDS 5 Date End date E A 
GLSEG1 6 String*15 Segment Name 1 E A X  Mask: %-15N
GLSEG2 7 String*15 Segment Name 2 E A X  Mask: %-15N
GLSEG3 8 String*15 Segment Name 3 E A X  Mask: %-15N
DISTCODE 9 String*6 Distribution code E A X  Mask: %-6N
ERATE 10 BCD*9.5 Employee Rate/Amt/Pct. E A X 
RRATE 11 BCD*9.5 Employer Amt/Pct. E A X 
WCC 12 String*6 Workers' Compensation Code E A X  Mask: %-6N
REPAYID 13 String*6 Advance To Be Repaid E A X  Mask: %-6N
CARRYDATE 14 Date Carry-over E A X 
BALANCE 15 BCD*10.3 Balance E A C X 
ACCRUED 16 BCD*10.3 Accrued E A C X 
PAID 17 BCD*10.3 Paid E A C X 
DEFAULTHRS 18 BCD*4.3 Default hours E A X 
CATEGORY 20 Integer Category E A C  List:6 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
EARDEDTYPE 21 Integer Type E A C  List:3 entries
7 = Vacation
8 = Sick
9 = Banked Time
AMTPAID 22 BCD*10.3 Amount Paid E A C X 
USERTC 23 Boolean Available in Employee Timecards E A X  List:2 entries
0 = No
1 = Yes
WCCGROUP 24 String*6 Workers Comp. Group E A X  Mask: %-6N
VALUES 25 Long Number of Optional Fields E A C 
SWFLSA 26 Boolean Include in Regular Rate OT Calc E A X 
EPERIODMIN 27 BCD*10.3 Employee Period Minimum E A X 
EPERIODMAX 28 BCD*10.3 Employee Period Maximum E A X 
EANNUALMAX 29 BCD*10.3 Employee Annual Maximum E A X 
ELIFETMMAX 30 BCD*10.3 Employee Lifetime Maximum E A X 
ELTDAMT 31 BCD*10.3 Employee Lifetime Accumulation E A X 
E2NDRATE 32 BCD*9.5 Employee Secondary Rate/Amt/Pct. E A X 
RPERIODMIN 33 BCD*10.3 Employer Period Minimum E A X 
RPERIODMAX 34 BCD*10.3 Employer Period Maximum E A X 
RANNUALMAX 35 BCD*10.3 Employer Annual Maximum E A X 
RLIFETMMAX 36 BCD*10.3 Employer Lifetime Maximum E A X 
RLTDAMT 37 BCD*10.3 Employer Lifetime Accumulation E A X 
R2NDRATE 38 BCD*9.5 Employer Secondary Amt/Pct. E A X 
TEMPLATE 41 String*12 Template Employee E A X  Mask: %-12N
ECALCMETH 42 Integer Employee Calc Method E A C 
RCALCMETH 43 Integer Employer Calc Method E A C 
PROCESSCMD 44 Integer Process Command Code E A C  List:2 entries
0 = Copy Employee Template
1 = Insert Optional Fields
DESC 45 String*60 Earning/Deduction Description E A C 
ELIMITBASE 46 Integer Employee Base Limit E A C 
RLIMITBASE 47 Integer Employer Base Limit E A C 
E2NDRATEIN 48 Integer Employee Secondary Rate Effective E A C 
R2NDRATEIN 49 Integer Employer Secondary Rate Effective E A C 
BILLINGS 60 Long Billing Rates E A C X 
BILLPCT1 61 BCD*5.5 Billing Percentage 1 E A X 
BILLPCT2 62 BCD*5.5 Billing Percentage 2 E A X 
BILLPCT3 63 BCD*5.5 Billing Percentage 3 E A X 
BILLPCT4 64 BCD*5.5 Billing Percentage 4 E A X 
BILLPCT5 65 BCD*5.5 Billing Percentage 5 E A X 
BILLPCT6 66 BCD*5.5 Billing Percentage 6 E A X 
SWALLOCJOB 67 Boolean Jobs Alloc Based on Calc Base E A X 
GLSEG4 68 String*15 RESERVED - Segment Name 4 E A X  Mask: %-15N
GLSEG5 69 String*15 RESERVED - Segment Name 5 E A X  Mask: %-15N
GLSEG6 70 String*15 RESERVED - Segment Name 6 E A X  Mask: %-15N

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).