# Table: Employee Earnings/Deductions

Table: CPEMPD
View: CP0008
Record length: 356
Flags: A R

## Keys: 4

Title | Flags | Fields
--- | --- | ---
Employee Earning/Deduction Code |  | EMPLOYEE, EARNDED
Employee, Category, Type |  | EMPLOYEE, CATEGORY, EARDEDTYPE, EARNDED
Earning/Deduction Code, Distribu | D M | EARNDED, DISTCODE
Earning/Deduction Code, Employee |  | EARNDED, EMPLOYEE

## Fields: 49

Field | Type | Title | Presentation
--- | --- | --- | ---
EMPLOYEE | String*12 | Employee | Mask: %-12N
EARNDED | String*6 | Employee Earning/Deduction | Mask: %-6N
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CALCULATE | Boolean | Calculate | List: 2 entries
0 | = | No
1 | = | Yes
STARTS | Date | Start date |
ENDS | Date | End date |
GLSEG1 | String*15 | Segment Name 1 | Mask: %-15N
GLSEG2 | String*15 | Segment Name 2 | Mask: %-15N
GLSEG3 | String*15 | Segment Name 3 | Mask: %-15N
DISTCODE | String*6 | Distribution code | Mask: %-6N
ERATE | BCD*9.5 | Employee Rate/Amt/Pct. |
RRATE | BCD*9.5 | Employer Amt/Pct. |
WCC | String*6 | Workers' Compensation Code | Mask: %-6N
REPAYID | String*6 | Advance To Be Repaid | Mask: %-6N
CARRYDATE | Date | Carry-over |
BALANCE | BCD*10.3 | Balance |
ACCRUED | BCD*10.3 | Accrued |
PAID | BCD*10.3 | Paid |
DEFAULTHRS | BCD*4.3 | Default hours |
CATEGORY | Integer | Category | List: 6 entries
1 | = | Accrual
2 | = | Earning
3 | = | Advance
4 | = | Deduction
5 | = | Expense Reimbursement
6 | = | Benefit
EARDEDTYPE | Integer | Type | List: 3 entries
7 | = | Vacation
8 | = | Sick
9 | = | Banked Time
AMTPAID | BCD*10.3 | Amount Paid |
USERTC | Boolean | Available in Employee Timecards | List: 2 entries
0 | = | No
1 | = | Yes
WCCGROUP | String*6 | Workers Comp. Group | Mask: %-6N
VALUES | Long | Number of Optional Fields |
SWFLSA | Boolean | Include in Regular Rate OT Calc |
EPERIODMIN | BCD*10.3 | Employee Period Minimum |
EPERIODMAX | BCD*10.3 | Employee Period Maximum |
EANNUALMAX | BCD*10.3 | Employee Annual Maximum |
ELIFETMMAX | BCD*10.3 | Employee Lifetime Maximum |
ELTDAMT | BCD*10.3 | Employee Lifetime Accumulation |
E2NDRATE | BCD*9.5 | Employee Secondary Rate/Amt/Pct. |
RPERIODMIN | BCD*10.3 | Employer Period Minimum |
RPERIODMAX | BCD*10.3 | Employer Period Maximum |
RANNUALMAX | BCD*10.3 | Employer Annual Maximum |
RLIFETMMAX | BCD*10.3 | Employer Lifetime Maximum |
RLTDAMT | BCD*10.3 | Employer Lifetime Accumulation |
R2NDRATE | BCD*9.5 | Employer Secondary Amt/Pct. |
BILLINGS | Long | Billing Rates |
BILLPCT1 | BCD*5.5 | Billing Percentage 1 |
BILLPCT2 | BCD*5.5 | Billing Percentage 2 |
BILLPCT3 | BCD*5.5 | Billing Percentage 3 |
BILLPCT4 | BCD*5.5 | Billing Percentage 4 |
BILLPCT5 | BCD*5.5 | Billing Percentage 5 |
BILLPCT6 | BCD*5.5 | Billing Percentage 6 |
SWALLOCJOB | Boolean | Jobs Alloc Based on Calc Base |

This page was generated on 2008-May-02

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