Table: Earnings/Deductions

Table: UPDTLM
View: UP0007
Record Length: 1826

Flags: A R 

Keys: 2

Title Flags Fields

Earning/Deduction EARNDED
Category CATEGORYEARDEDTYPEEARNDED

Fields: 255

Field Type Title Presentation

EARNDED String*6 Earning/Deduction Mask: %-6N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
LONGDESC String*60 Earning/Deduction Description
SHORTDESC String*15 Earning/Deduction Short Description
INACTIVE Boolean Inactive
ASOF Date Inactive As Of
LASTMAINT Date Last Maintained
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
1 = Salary & Wages
2 = Reported Tips
3 = Allocated Tips
FREQUENCY Integer Frequency List:10 entries
1 = Float
2 = Daily
3 = Weekly
4 = Biweekly
5 = Semimonthly
10 = Twenty-two per Year
9 = Thirteen per Year
6 = Monthly
8 = Ten per Year
7 = Quarterly
STARTS Integer Starts List:4 entries
1 = Specific Month/Day
2 = Date of Hire
3 = Months after Hire
4 = Days after Hire
STARTMONTH Integer Start Month
STARTDAY Integer Start Day
ENDS Date Ends
PRNTONCHK Boolean Print On Check
PRNTIF0 Boolean RESERVED Print If Current Zero.
PRNTYTDIF0 Boolean RESERVED Print YTD If Current Zero
ECALCMETH Integer Employee Calculation Method List:7 entries
2 = Flat
3 = Fixed
4 = Hourly Rate
5 = Amount per Hour
6 = Piece Rate Table
7 = Percentage of Base
8 = Sales Commission Table
EW2BOX Integer Employee W-2 Box List:15 entries
1 = Not Applicable
2 = Other Information Box
3 = Dependent Care
4 = Employee 401(k)
5 = Employee 403(b)
6 = Employee 408(k)(6)
7 = Employee 457
8 = Employee 501(c)(18)(d)
9 = SIMPLE Retirement Acct
10 = Deferrals under section 409A
11 = Roth contributions to Employee 401(k)
12 = Roth contributions to Employee 403(b)
13 = Health Savings Account
14 = Employer Provided Health Care
15 = Roth contributions under governmental 457(b)
ERATE BCD*9.5 Employee Rate
EANNUALMAX BCD*10.3 Employee Annual Maximum
EDAILYMIN BCD*10.3 Employee Daily Minimum
EDAILYMAX BCD*10.3 Employee Daily Maximum
EWEEKLYMIN BCD*10.3 Employee Weekly Minimum
EWEEKLYMAX BCD*10.3 Employee Weekly Maximum
EBIWKLYMIN BCD*10.3 Employee Biweekly Minimum
EBIWKLYMAX BCD*10.3 Employee Biweekly Maximum
ESEMIMNMIN BCD*10.3 Employee Semimonthly Minimum
ESEMIMNMAX BCD*10.3 Employee Semimonthly Maximum
EMNTHLYMIN BCD*10.3 Employee Monthly Minimum
EMNTHLYMAX BCD*10.3 Employee Monthly Maximum
EQRTRLYMIN BCD*10.3 Employee Quarterly Minimum
EQRTRLYMAX BCD*10.3 Employee Quarterly Maximum
E10PPPYMIN BCD*10.3 Employee Ten Period/Year Minimum
E10PPPYMAX BCD*10.3 Employee Ten Period/Year Maximum
E13PPPYMIN BCD*10.3 Employee Thirteen Period/Year Minimum
E13PPPYMAX BCD*10.3 Employee Thirteen Period/Year Maximum
E22PPPYMIN BCD*10.3 Employee Twentytwo Period/Year Minimum
E22PPPYMAX BCD*10.3 Employee Twentytwo Period/Year Maximum
ELIMITBASE Integer Employee Base Limit List:1 entries
1 = No Limit
WGBRACK1 BCD*10.3 Wage Bracket 1
WGADDAMT1 BCD*10.3 Add Amount 1
WGPCTOVR1 BCD*5.5 Percnt. of Excess 1
WGBRACK2 BCD*10.3 Wage Bracket 2
WGADDAMT2 BCD*10.3 Add Amount 2
WGPCTOVR2 BCD*5.5 Percnt. of Excess 2
WGBRACK3 BCD*10.3 Wage Bracket 3
WGADDAMT3 BCD*10.3 Add Amount 3
WGPCTOVR3 BCD*5.5 Percnt. of Excess 3
WGBRACK4 BCD*10.3 Wage Bracket 4
WGADDAMT4 BCD*10.3 Add Amount 4
WGPCTOVR4 BCD*5.5 Percnt. of Excess 4
WGBRACK5 BCD*10.3 Wage Bracket 5
WGADDAMT5 BCD*10.3 Add Amount 5
WGPCTOVR5 BCD*5.5 Percnt. of Excess 5
WGBRACK6 BCD*10.3 Wage Bracket 6
WGADDAMT6 BCD*10.3 Add Amount 6
WGPCTOVR6 BCD*5.5 Percnt. of Excess 6
WGBRACK7 BCD*10.3 Wage Bracket 7
WGADDAMT7 BCD*10.3 Add Amount 7
WGPCTOVR7 BCD*5.5 Percnt. of Excess 7
WGBRACK8 BCD*10.3 Wage Bracket 8
WGADDAMT8 BCD*10.3 Add Amount 8
WGPCTOVR8 BCD*5.5 Percnt. of Excess 8
WGBRACK9 BCD*10.3 Wage Bracket 9
WGADDAMT9 BCD*10.3 Add Amount 9
WGPCTOVR9 BCD*5.5 Percnt. of Excess 9
WGBRACK10 BCD*10.3 Wage Bracket 10
WGADDAMT10 BCD*10.3 Add Amount 10
WGPCTOVR10 BCD*5.5 Percnt. of Excess 10
WGBRACK11 BCD*10.3 Wage Bracket 11
WGADDAMT11 BCD*10.3 Add Amount 11
WGPCTOVR11 BCD*5.5 Percnt. of Excess 11
WGBRACK12 BCD*10.3 Wage Bracket 12
WGADDAMT12 BCD*10.3 Add Amount 12
WGPCTOVR12 BCD*5.5 Percnt. of Excess 12
WGBRACK13 BCD*10.3 Wage Bracket 13
WGADDAMT13 BCD*10.3 Add Amount 13
WGPCTOVR13 BCD*5.5 Percnt. of Excess 13
WGBRACK14 BCD*10.3 Wage Bracket 14
WGADDAMT14 BCD*10.3 Add Amount 14
WGPCTOVR14 BCD*5.5 Percnt. of Excess 14
WGBRACK15 BCD*10.3 Wage Bracket 15
WGADDAMT15 BCD*10.3 Add Amount 15
WGPCTOVR15 BCD*5.5 Percnt. of Excess 15
WGBRACK16 BCD*10.3 Wage Bracket 16
WGADDAMT16 BCD*10.3 Add Amount 16
WGPCTOVR16 BCD*5.5 Percnt. of Excess 16
WGBRACK17 BCD*10.3 Wage Bracket 17
WGADDAMT17 BCD*10.3 Add Amount 17
WGPCTOVR17 BCD*5.5 Percnt. of Excess 17
WGBRACK18 BCD*10.3 Wage Bracket 18
WGADDAMT18 BCD*10.3 Add Amount 18
WGPCTOVR18 BCD*5.5 Percnt. of Excess 18
WGBRACK19 BCD*10.3 Wage Bracket 19
WGADDAMT19 BCD*10.3 Add Amount 19
WGPCTOVR19 BCD*5.5 Percnt. of Excess 19
WGBRACK20 BCD*10.3 Wage Bracket 20
WGADDAMT20 BCD*10.3 Add Amount 20
WGPCTOVR20 BCD*5.5 Percnt. of Excess 20
RCALCMETH Integer Employer Calculation Method List:6 entries
2 = Flat
5 = Amount per Hour
6 = Piece Rate Table
7 = Percentage of Base
8 = Sales Commission Table
9 = Wage Bracket Table
RW2BOX Integer Employer W-2 Box List:22 entries
1 = Not Applicable
2 = Other Information Box
3 = Allocated Tips
4 = Dependent Care
5 = Fringe Benefit
6 = Cost of Group Term over $50,000
7 = Uncollected Soc Sec Tax on Cost of Group Term over $50,000
8 = Uncollected Medicare Tax on Cost of Group Term over $50,000
9 = Sick Pay Not Includible as Income (3rd Party Sick Pay)
10 = Excess Golden
11 = Allowed per Diem
12 = Nonqualified Plan
13 = Section 457
14 = Excludable Moving Expense Reimbursements
15 = Nontaxable combat pay
16 = Medical Savings Acct
17 = Adoption Benefit
18 = Non-statutory Stock Options
19 = Health Savings Account
20 = Income under section 409A
21 = Employer Provided Health Care
22 = Permitted Benefits Under a QSEHRA
RRATE BCD*9.5 Employer Rate
RANNUALMAX BCD*10.3 Employer Annual Maximum
RDAILYMIN BCD*10.3 Employer Daily Minimum
RDAILYMAX BCD*10.3 Employer Daily Maximum
RWEEKLYMIN BCD*10.3 Employer Weekly Minimum
RWEEKLYMAX BCD*10.3 Employer Weekly Maximum
RBIWKLYMIN BCD*10.3 Employer Biweekly Minimum
RBIWKLYMAX BCD*10.3 Employer Biweekly Maximum
RSEMIMNMIN BCD*10.3 Employer Semimonthly Minimum
RSEMIMNMAX BCD*10.3 Employer Semimonthly Maximum
RMNTHLYMIN BCD*10.3 Employer Monthly Minimum
RMNTHLYMAX BCD*10.3 Employer Monthly Maximum
RQRTRLYMIN BCD*10.3 Employer Quarterly Minimum
RQRTRLYMAX BCD*10.3 Employer Quarterly Maximum
R10PPPYMIN BCD*10.3 Employer Ten Per/Year Minimum
R10PPPYMAX BCD*10.3 Employer Ten Per/Year Maximum
R13PPPYMIN BCD*10.3 Employer Thirteen Per/Year Minimum
R13PPPYMAX BCD*10.3 Employer Thirteen Per/Year Maximum
R22PPPYMIN BCD*10.3 Employer TwentyTwo Per/Year Minimum
R22PPPYMAX BCD*10.3 Employer TwentyTwo Per/Year Maximum
RLIMITBASE Integer Employer Base Limit List:1 entries
1 = No Limit
ALLOWWCC Boolean Subject to Workers' Compensation
COMMAMT1 BCD*10.3 Commission Amt. 1
COMMPCT1 BCD*5.5 Commission Pct. 1
COMMAMT2 BCD*10.3 Commission Amt. 2
COMMPCT2 BCD*5.5 Commission Pct. 2
COMMAMT3 BCD*10.3 Commission Amt. 3
COMMPCT3 BCD*5.5 Commission Pct. 3
COMMAMT4 BCD*10.3 Commission Amt. 4
COMMPCT4 BCD*5.5 Commission Pct. 4
COMMAMT5 BCD*10.3 Commission Amt. 5
COMMPCT5 BCD*5.5 Commission Pct. 5
COMMPCTX BCD*5.5 Commission Amt. excess
PIECNUM1 BCD*10.3 Piece count 1
PIECAMT1 BCD*9.5 Piece amount 1
PIECNUM2 BCD*10.3 Piece count 2
PIECAMT2 BCD*9.5 Piece amount 2
PIECNUM3 BCD*10.3 Piece count 3
PIECAMT3 BCD*9.5 Piece amount 3
PIECNUM4 BCD*10.3 Piece count 4
PIECAMT4 BCD*9.5 Piece amount 4
PIECNUM5 BCD*10.3 Piece count 5
PIECAMT5 BCD*9.5 Piece amount 5
PIECAMTX BCD*9.5 Max Piece Rate Amt.
TIPDISB Boolean Tip Disbursement
PAYDOWNDED Boolean Repayment Deduction
REPAYID String*6 Advance to Be Repaid
CARRYOVER Integer Carry-over List:4 entries
1 = Specific Month/Day
2 = Date of Hire
3 = Months after Hire
4 = Days after Hire
COVERDAY Integer Carry-over Day
COVERMONTH Integer Carry-over Month
POSTLIAB Boolean Post Liab.
SVCYEAR1 Integer Service Year 1
BEGHRS1 BCD*10.3 Beginning Hours 1
INCRHRS1 BCD*9.5 Increment Hours 1
MAXACCR1 BCD*10.3 Max. Annual Accrual 1
MAXCARRY1 BCD*10.3 Max. Carry-over Hours 1
SVCYEAR2 Integer Service Year 2
BEGHRS2 BCD*10.3 Beginning Hours 2
INCRHRS2 BCD*9.5 Increment Hours 2
MAXACCR2 BCD*10.3 Max. Annual Accrual 2
MAXCARRY2 BCD*10.3 Max. Carry-over Hours 2
SVCYEAR3 Integer Service Year 3
BEGHRS3 BCD*10.3 Beginning Hours 3
INCRHRS3 BCD*9.5 Increment Hours 3
MAXACCR3 BCD*10.3 Max. Annual Accrual 3
MAXCARRY3 BCD*10.3 Max. Carry-over Hours 3
SVCYEAR4 Integer Service Year 4
BEGHRS4 BCD*10.3 Beginning Hours 4
INCRHRS4 BCD*9.5 Increment Hours 4
MAXACCR4 BCD*10.3 Max. Annual Accrual 4
MAXCARRY4 BCD*10.3 Max. Carry-over Hours 4
LEVEL Integer Level
LISTUSEBHI Integer Base Hours List Use
REGULARBHI Integer Base Hours Regular
OVRTIMEBHI Integer Base Hours Overtime
LISTUSEBEI Integer Base Earnings List Use
REGULARBEI Integer Base Earnings Regular
OVRTIMEBEI Integer Base Earnings Overtime
SHIFTBEI Integer Base Earnings Shift
LISTUSEBDI Integer Base Deductions List Use
LISTUSEBTI Integer Base Tax List Use
LISTUSETTW Integer List Use of Type of Taxable Wages
WHMETHTTW Integer Withholding Method for Taxable Wages List:3 entries
1 = Regular Rate
4 = Taxable, No Withholding
6 = Supplemental Withholding
LISTUSETDB Integer Take Deduction Before List Use
ET4BOX Integer RESERVED - Cdn Only
RT4BOX Integer RESERVED - Cdn Only
ER1BOX Integer RESERVED - Cdn Only
RR1BOX Integer RESERVED - Cdn Only
EASSOCW2SW Boolean Associate W-2 printing
EASSOCTAX String*6 Associated Tax
RASSOCW2SW Boolean Associate W-2 printing
RASSOCTAX String*6 Associated Tax
POSTBENE Boolean Post Benefit
PAYACCRUAL Boolean Pay Accrual
NONPERPYMT Boolean RESERVED - Cdn Only
LINKEARN String*6 Linked Earning
VALUES Long Number of Optional Fields
SWFLSA Boolean Include in FLSA Overtime Calc
COMMINCREM Boolean Progressive Calc - Commissions
WGANNUALIZ Boolean Annualized Wage Brackets
WGBRINCREM Boolean Progressive Calc - Wage Brackets
PIECINCREM Boolean Progressive Calc - Piece Rate
ELIFETMMAX BCD*10.3 Employee Lifetime Maximum
RLIFETMMAX BCD*10.3 Employer Lifetime Maximum
E2NDRATEIN Integer Employee Sec. Rate Effective List:2 entries
0 = Never
1 = After Annual Maximum Reached
R2NDRATEIN Integer Employer Sec. Rate Effective List:2 entries
0 = Never
1 = After Annual Maximum Reached
E2NDRATE BCD*9.5 Employee Secondary Rate
R2NDRATE BCD*9.5 Employer Secondary Rate
SVCYEAR5 Integer Service Year 5
BEGHRS5 BCD*10.3 Beginning Hours 5
INCRHRS5 BCD*9.5 Increment Hours 5
MAXACCR5 BCD*10.3 Max. Annual Accrual 5
MAXCARRY5 BCD*10.3 Max. Carry-over Hours 5
SVCYEAR6 Integer Service Year 6
BEGHRS6 BCD*10.3 Beginning Hours 6
INCRHRS6 BCD*9.5 Increment Hours 6
MAXACCR6 BCD*10.3 Max. Annual Accrual 6
MAXCARRY6 BCD*10.3 Max. Carry-over Hours 6
SVCYEAR7 Integer Service Year 7
BEGHRS7 BCD*10.3 Beginning Hours 7
INCRHRS7 BCD*9.5 Increment Hours 7
MAXACCR7 BCD*10.3 Max. Annual Accrual 7
MAXCARRY7 BCD*10.3 Max. Carry-over Hours 7
SVCYEAR8 Integer Service Year 8
BEGHRS8 BCD*10.3 Beginning Hours 8
INCRHRS8 BCD*9.5 Increment Hours 8
MAXACCR8 BCD*10.3 Max. Annual Accrual 8
MAXCARRY8 BCD*10.3 Max. Carry-over Hours 8
SVCYEAR9 Integer Service Year 9
BEGHRS9 BCD*10.3 Beginning Hours 9
INCRHRS9 BCD*9.5 Increment Hours 9
MAXACCR9 BCD*10.3 Max. Annual Accrual 9
MAXCARRY9 BCD*10.3 Max. Carry-over Hours 9
SVCYEAR10 Integer Service Year 10
BEGHRS10 BCD*10.3 Beginning Hours 10
INCRHRS10 BCD*9.5 Increment Hours 10
MAXACCR10 BCD*10.3 Max. Annual Accrual 10
MAXCARRY10 BCD*10.3 Max. Carry-over Hours 10
CCOVERRIDE Boolean Cost Center Override Based on Calc Base
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
MAXONREM Boolean Calc. Max. Carry-over based on Remaining Balance
MAXONACCR Boolean Cap Accrual at Max. Accrual
COVID Integer Report as List:5 entries
0 = None
1 = Form 941 - Emergency Paid Sick Leave
8 = Form 941 - Emergency Paid Sick Leave for Others
2 = Form 941 - Emergency Paid Family Leave
3 = Form 941 - Qualified Retention Credit Earnings
OTHERBOX Integer RESERVED - CDN Only List:4 entries
1 = 028 - Other income
2 = 104 - Research grants
3 = 105 - Scholarships, bursaries, fellowships...
4 = 130 - Apprenticeship, incentive grant or...