# View: Employee Earnings/Deductions

RotoID: UP0008
Table: UPEMPD
Protocol: Detail, Ordered revisions
DLL: UPEMPD

## Compositions: 3

RotoID | Tables | Title | DLL
--- | --- | --- | ---
UP0014 | UPEMPL | Employees | UPEMPL
UP0125 | UPEMDO | Empl Earn/Ded Optional Fields | UPEMDO
UP0041 | UPEMDB | Employee Billing Details | UPEMDB

## 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: 54

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 | = | Compensatory 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 FLSA Overtime 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 |

This page was generated on 2008-May-02

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