Table: Employee Earnings/Deductions

Table: UPEMPD
View: UP0008
Record Length: 401

Flags: A R 

Keys: 4

Title Flags Fields

Employee Earning/Deduction Code EMPLOYEEEARNDED
Employee, Category, Type EMPLOYEECATEGORYEARDEDTYPEEARNDED
Earning/Deduction Code, Distribu D M  EARNDEDDISTCODE
Earning/Deduction Code, Employee EARNDEDEMPLOYEE

Fields: 52

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 = Compensatory 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 FLSA Overtime 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
GLSEG4 String*15 RESERVED - Segment Name 4 Mask: %-15N
GLSEG5 String*15 RESERVED - Segment Name 5 Mask: %-15N
GLSEG6 String*15 RESERVED - Segment Name 6 Mask: %-15N