View: Earnings/Deductions

RotoID: UP0007
Table: UPDTLM
Protocol: Header
DLL:UPDTLM

Compositions: 8

RotoID Tables Title DLL
UP0015 UPINCL Include List UPINCL
UP0015 UPINCL Include List UPINCL
UP0015 UPINCL Include List UPINCL
UP0015 UPINCL Include List UPINCL
UP0015 UPINCL Include List UPINCL
UP0009 UPDIST Distribution UPDIST
UP0123 UPDTLO Earnings/Deductions Opt Fields UPDTLO
UP0040 UPDTLB Earnings Billing Detail UPDTLB

Keys: 2

Title Fields
Earning/Deduction EARNDED
Category CATEGORY, EARDEDTYPE, EARNDED

Fields: 252

Field Index Type Title Attributes Presentation
EARNDED 1 String*6 Earning/Deduction E A K R  Mask: %-6N
LONGDESC 2 String*60 Earning/Deduction Description E A 
SHORTDESC 3 String*15 Earning/Deduction Short Description E A 
INACTIVE 4 Boolean Inactive E A 
ASOF 5 Date Inactive As Of A C X 
LASTMAINT 6 Date Last Maintained E A C 
CATEGORY 7 Integer Category E A  List:6 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
EARDEDTYPE 8 Integer Type E A P X  List:3 entries
1 = Salary & Wages
2 = Reported Tips
3 = Allocated Tips
FREQUENCY 9 Integer Frequency E A P X  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 10 Integer Starts E A  List:4 entries
1 = Specific Month/Day
2 = Date of Hire
3 = Months after Hire
4 = Days after Hire
STARTMONTH 11 Integer Start Month X 
STARTDAY 12 Integer Start Day X 
ENDS 13 Date Ends E A 
PRNTONCHK 14 Boolean Print On Check E A 
PRNTIF0 15 Boolean RESERVED Print If Current Zero. C 
PRNTYTDIF0 16 Boolean RESERVED Print YTD If Current Zero C 
ECALCMETH 17 Integer Employee Calculation Method E A P X  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 18 Integer Employee W-2 Box E A P X D  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 19 BCD*9.5 Employee Rate X 
EANNUALMAX 20 BCD*10.3 Employee Annual Maximum X 
EDAILYMIN 21 BCD*10.3 Employee Daily Minimum X 
EDAILYMAX 22 BCD*10.3 Employee Daily Maximum X 
EWEEKLYMIN 23 BCD*10.3 Employee Weekly Minimum X 
EWEEKLYMAX 24 BCD*10.3 Employee Weekly Maximum X 
EBIWKLYMIN 25 BCD*10.3 Employee Biweekly Minimum X 
EBIWKLYMAX 26 BCD*10.3 Employee Biweekly Maximum X 
ESEMIMNMIN 27 BCD*10.3 Employee Semimonthly Minimum X 
ESEMIMNMAX 28 BCD*10.3 Employee Semimonthly Maximum X 
EMNTHLYMIN 29 BCD*10.3 Employee Monthly Minimum X 
EMNTHLYMAX 30 BCD*10.3 Employee Monthly Maximum X 
EQRTRLYMIN 31 BCD*10.3 Employee Quarterly Minimum X 
EQRTRLYMAX 32 BCD*10.3 Employee Quarterly Maximum X 
E10PPPYMIN 33 BCD*10.3 Employee Ten Period/Year Minimum X 
E10PPPYMAX 34 BCD*10.3 Employee Ten Period/Year Maximum X 
E13PPPYMIN 35 BCD*10.3 Employee Thirteen Period/Year Minimum X 
E13PPPYMAX 36 BCD*10.3 Employee Thirteen Period/Year Maximum X 
E22PPPYMIN 37 BCD*10.3 Employee Twentytwo Period/Year Minimum X 
E22PPPYMAX 38 BCD*10.3 Employee Twentytwo Period/Year Maximum X 
ELIMITBASE 39 Integer Employee Base Limit E A P X D  List:1 entries
1 = No Limit
WGBRACK1 40 BCD*10.3 Wage Bracket 1 X 
WGADDAMT1 41 BCD*10.3 Add Amount 1 X 
WGPCTOVR1 42 BCD*5.5 Percnt. of Excess 1 X 
WGBRACK2 43 BCD*10.3 Wage Bracket 2 X 
WGADDAMT2 44 BCD*10.3 Add Amount 2 X 
WGPCTOVR2 45 BCD*5.5 Percnt. of Excess 2 X 
WGBRACK3 46 BCD*10.3 Wage Bracket 3 X 
WGADDAMT3 47 BCD*10.3 Add Amount 3 X 
WGPCTOVR3 48 BCD*5.5 Percnt. of Excess 3 X 
WGBRACK4 49 BCD*10.3 Wage Bracket 4 X 
WGADDAMT4 50 BCD*10.3 Add Amount 4 X 
WGPCTOVR4 51 BCD*5.5 Percnt. of Excess 4 X 
WGBRACK5 52 BCD*10.3 Wage Bracket 5 X 
WGADDAMT5 53 BCD*10.3 Add Amount 5 X 
WGPCTOVR5 54 BCD*5.5 Percnt. of Excess 5 X 
WGBRACK6 55 BCD*10.3 Wage Bracket 6 X 
WGADDAMT6 56 BCD*10.3 Add Amount 6 X 
WGPCTOVR6 57 BCD*5.5 Percnt. of Excess 6 X 
WGBRACK7 58 BCD*10.3 Wage Bracket 7 X 
WGADDAMT7 59 BCD*10.3 Add Amount 7 X 
WGPCTOVR7 60 BCD*5.5 Percnt. of Excess 7 X 
WGBRACK8 61 BCD*10.3 Wage Bracket 8 X 
WGADDAMT8 62 BCD*10.3 Add Amount 8 X 
WGPCTOVR8 63 BCD*5.5 Percnt. of Excess 8 X 
WGBRACK9 64 BCD*10.3 Wage Bracket 9 X 
WGADDAMT9 65 BCD*10.3 Add Amount 9 X 
WGPCTOVR9 66 BCD*5.5 Percnt. of Excess 9 X 
WGBRACK10 67 BCD*10.3 Wage Bracket 10 X 
WGADDAMT10 68 BCD*10.3 Add Amount 10 X 
WGPCTOVR10 69 BCD*5.5 Percnt. of Excess 10 X 
WGBRACK11 70 BCD*10.3 Wage Bracket 11 X 
WGADDAMT11 71 BCD*10.3 Add Amount 11 X 
WGPCTOVR11 72 BCD*5.5 Percnt. of Excess 11 X 
WGBRACK12 73 BCD*10.3 Wage Bracket 12 X 
WGADDAMT12 74 BCD*10.3 Add Amount 12 X 
WGPCTOVR12 75 BCD*5.5 Percnt. of Excess 12 X 
WGBRACK13 76 BCD*10.3 Wage Bracket 13 X 
WGADDAMT13 77 BCD*10.3 Add Amount 13 X 
WGPCTOVR13 78 BCD*5.5 Percnt. of Excess 13 X 
WGBRACK14 79 BCD*10.3 Wage Bracket 14 X 
WGADDAMT14 80 BCD*10.3 Add Amount 14 X 
WGPCTOVR14 81 BCD*5.5 Percnt. of Excess 14 X 
WGBRACK15 82 BCD*10.3 Wage Bracket 15 X 
WGADDAMT15 83 BCD*10.3 Add Amount 15 X 
WGPCTOVR15 84 BCD*5.5 Percnt. of Excess 15 X 
WGBRACK16 85 BCD*10.3 Wage Bracket 16 X 
WGADDAMT16 86 BCD*10.3 Add Amount 16 X 
WGPCTOVR16 87 BCD*5.5 Percnt. of Excess 16 X 
WGBRACK17 88 BCD*10.3 Wage Bracket 17 X 
WGADDAMT17 89 BCD*10.3 Add Amount 17 X 
WGPCTOVR17 90 BCD*5.5 Percnt. of Excess 17 X 
WGBRACK18 91 BCD*10.3 Wage Bracket 18 X 
WGADDAMT18 92 BCD*10.3 Add Amount 18 X 
WGPCTOVR18 93 BCD*5.5 Percnt. of Excess 18 X 
WGBRACK19 94 BCD*10.3 Wage Bracket 19 X 
WGADDAMT19 95 BCD*10.3 Add Amount 19 X 
WGPCTOVR19 96 BCD*5.5 Percnt. of Excess 19 X 
WGBRACK20 97 BCD*10.3 Wage Bracket 20 X 
WGADDAMT20 98 BCD*10.3 Add Amount 20 X 
WGPCTOVR20 99 BCD*5.5 Percnt. of Excess 20 X 
RCALCMETH 100 Integer Employer Calculation Method E A P X D  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 101 Integer Employer W-2 Box E A P X D  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 102 BCD*9.5 Employer Rate X 
RANNUALMAX 103 BCD*10.3 Employer Annual Maximum X 
RDAILYMIN 104 BCD*10.3 Employer Daily Minimum X 
RDAILYMAX 105 BCD*10.3 Employer Daily Maximum X 
RWEEKLYMIN 106 BCD*10.3 Employer Weekly Minimum X 
RWEEKLYMAX 107 BCD*10.3 Employer Weekly Maximum X 
RBIWKLYMIN 108 BCD*10.3 Employer Biweekly Minimum X 
RBIWKLYMAX 109 BCD*10.3 Employer Biweekly Maximum X 
RSEMIMNMIN 110 BCD*10.3 Employer Semimonthly Minimum X 
RSEMIMNMAX 111 BCD*10.3 Employer Semimonthly Maximum X 
RMNTHLYMIN 112 BCD*10.3 Employer Monthly Minimum X 
RMNTHLYMAX 113 BCD*10.3 Employer Monthly Maximum X 
RQRTRLYMIN 114 BCD*10.3 Employer Quarterly Minimum X 
RQRTRLYMAX 115 BCD*10.3 Employer Quarterly Maximum X 
R10PPPYMIN 116 BCD*10.3 Employer Ten Per/Year Minimum X 
R10PPPYMAX 117 BCD*10.3 Employer Ten Per/Year Maximum X 
R13PPPYMIN 118 BCD*10.3 Employer Thirteen Per/Year Minimum X 
R13PPPYMAX 119 BCD*10.3 Employer Thirteen Per/Year Maximum X 
R22PPPYMIN 120 BCD*10.3 Employer TwentyTwo Per/Year Minimum X 
R22PPPYMAX 121 BCD*10.3 Employer TwentyTwo Per/Year Maximum X 
RLIMITBASE 122 Integer Employer Base Limit E A P X D  List:1 entries
1 = No Limit
ALLOWWCC 123 Boolean Subject to Workers' Compensation E A X 
COMMAMT1 124 BCD*10.3 Commission Amt. 1 X 
COMMPCT1 125 BCD*5.5 Commission Pct. 1 X 
COMMAMT2 126 BCD*10.3 Commission Amt. 2 X 
COMMPCT2 127 BCD*5.5 Commission Pct. 2 X 
COMMAMT3 128 BCD*10.3 Commission Amt. 3 X 
COMMPCT3 129 BCD*5.5 Commission Pct. 3 X 
COMMAMT4 130 BCD*10.3 Commission Amt. 4 X 
COMMPCT4 131 BCD*5.5 Commission Pct. 4 X 
COMMAMT5 132 BCD*10.3 Commission Amt. 5 X 
COMMPCT5 133 BCD*5.5 Commission Pct. 5 X 
COMMPCTX 134 BCD*5.5 Commission Amt. excess X 
PIECNUM1 135 BCD*10.3 Piece count 1 X 
PIECAMT1 136 BCD*9.5 Piece amount 1 X 
PIECNUM2 137 BCD*10.3 Piece count 2 X 
PIECAMT2 138 BCD*9.5 Piece amount 2 X 
PIECNUM3 139 BCD*10.3 Piece count 3 X 
PIECAMT3 140 BCD*9.5 Piece amount 3 X 
PIECNUM4 141 BCD*10.3 Piece count 4 X 
PIECAMT4 142 BCD*9.5 Piece amount 4 X 
PIECNUM5 143 BCD*10.3 Piece count 5 X 
PIECAMT5 144 BCD*9.5 Piece amount 5 X 
PIECAMTX 145 BCD*9.5 Max Piece Rate Amt. X 
TIPDISB 146 Boolean Tip Disbursement X 
PAYDOWNDED 147 Boolean Repayment Deduction X 
REPAYID 148 String*6 Advance to Be Repaid X 
CARRYOVER 149 Integer Carry-over E A X D  List:4 entries
1 = Specific Month/Day
2 = Date of Hire
3 = Months after Hire
4 = Days after Hire
COVERDAY 150 Integer Carry-over Day X 
COVERMONTH 151 Integer Carry-over Month X 
POSTLIAB 152 Boolean Post Liab. X 
SVCYEAR1 153 Integer Service Year 1 X 
BEGHRS1 154 BCD*10.3 Beginning Hours 1 X 
INCRHRS1 155 BCD*9.5 Increment Hours 1 X 
MAXACCR1 156 BCD*10.3 Max. Annual Accrual 1 X 
MAXCARRY1 157 BCD*10.3 Max. Carry-over Hours 1 X 
SVCYEAR2 158 Integer Service Year 2 X 
BEGHRS2 159 BCD*10.3 Beginning Hours 2 X 
INCRHRS2 160 BCD*9.5 Increment Hours 2 X 
MAXACCR2 161 BCD*10.3 Max. Annual Accrual 2 X 
MAXCARRY2 162 BCD*10.3 Max. Carry-over Hours 2 X 
SVCYEAR3 163 Integer Service Year 3 X 
BEGHRS3 164 BCD*10.3 Beginning Hours 3 X 
INCRHRS3 165 BCD*9.5 Increment Hours 3 X 
MAXACCR3 166 BCD*10.3 Max. Annual Accrual 3 X 
MAXCARRY3 167 BCD*10.3 Max. Carry-over Hours 3 X 
SVCYEAR4 168 Integer Service Year 4 X 
BEGHRS4 169 BCD*10.3 Beginning Hours 4 X 
INCRHRS4 170 BCD*9.5 Increment Hours 4 X 
MAXACCR4 171 BCD*10.3 Max. Annual Accrual 4 X 
MAXCARRY4 172 BCD*10.3 Max. Carry-over Hours 4 X 
LEVEL 173 Integer Level E A X 
LISTUSEBHI 174 Integer Base Hours List Use X 
REGULARBHI 175 Integer Base Hours Regular X 
OVRTIMEBHI 176 Integer Base Hours Overtime X 
LISTUSEBEI 177 Integer Base Earnings List Use X 
REGULARBEI 178 Integer Base Earnings Regular X 
OVRTIMEBEI 179 Integer Base Earnings Overtime X 
SHIFTBEI 180 Integer Base Earnings Shift X 
LISTUSEBDI 181 Integer Base Deductions List Use X 
LISTUSEBTI 182 Integer Base Tax List Use X 
LISTUSETTW 183 Integer List Use of Type of Taxable Wages E A X 
WHMETHTTW 184 Integer Withholding Method for Taxable Wages E A X  List:3 entries
1 = Regular Rate
4 = Taxable, No Withholding
6 = Supplemental Withholding
LISTUSETDB 185 Integer Take Deduction Before List Use X 
ET4BOX 186 Integer RESERVED - Cdn Only P X 
RT4BOX 187 Integer RESERVED - Cdn Only P X 
ER1BOX 188 Integer RESERVED - Cdn Only P X 
RR1BOX 189 Integer RESERVED - Cdn Only P X 
EASSOCW2SW 190 Boolean Associate W-2 printing X 
EASSOCTAX 191 String*6 Associated Tax X 
RASSOCW2SW 192 Boolean Associate W-2 printing X 
RASSOCTAX 193 String*6 Associated Tax X 
POSTBENE 194 Boolean Post Benefit X 
PAYACCRUAL 195 Boolean Pay Accrual X 
NONPERPYMT 196 Boolean RESERVED - Cdn Only X 
LINKEARN 197 String*6 Linked Earning X 
VALUES 198 Long Number of Optional Fields E A C 
SWFLSA 199 Boolean Include in FLSA Overtime Calc X 
COMMINCREM 200 Boolean Progressive Calc - Commissions X 
WGANNUALIZ 201 Boolean Annualized Wage Brackets X 
WGBRINCREM 202 Boolean Progressive Calc - Wage Brackets X 
PIECINCREM 203 Boolean Progressive Calc - Piece Rate X 
ELIFETMMAX 204 BCD*10.3 Employee Lifetime Maximum X 
RLIFETMMAX 205 BCD*10.3 Employer Lifetime Maximum X 
E2NDRATEIN 206 Integer Employee Sec. Rate Effective E A P X D  List:2 entries
0 = Never
1 = After Annual Maximum Reached
R2NDRATEIN 207 Integer Employer Sec. Rate Effective E A P X D  List:2 entries
0 = Never
1 = After Annual Maximum Reached
E2NDRATE 208 BCD*9.5 Employee Secondary Rate X 
R2NDRATE 209 BCD*9.5 Employer Secondary Rate X 
SVCYEAR5 230 Integer Service Year 5 X 
BEGHRS5 231 BCD*10.3 Beginning Hours 5 X 
INCRHRS5 232 BCD*9.5 Increment Hours 5 X 
MAXACCR5 233 BCD*10.3 Max. Annual Accrual 5 X 
MAXCARRY5 234 BCD*10.3 Max. Carry-over Hours 5 X 
SVCYEAR6 235 Integer Service Year 6 X 
BEGHRS6 236 BCD*10.3 Beginning Hours 6 X 
INCRHRS6 237 BCD*9.5 Increment Hours 6 X 
MAXACCR6 238 BCD*10.3 Max. Annual Accrual 6 X 
MAXCARRY6 239 BCD*10.3 Max. Carry-over Hours 6 X 
SVCYEAR7 240 Integer Service Year 7 X 
BEGHRS7 241 BCD*10.3 Beginning Hours 7 X 
INCRHRS7 242 BCD*9.5 Increment Hours 7 X 
MAXACCR7 243 BCD*10.3 Max. Annual Accrual 7 X 
MAXCARRY7 244 BCD*10.3 Max. Carry-over Hours 7 X 
SVCYEAR8 245 Integer Service Year 8 X 
BEGHRS8 246 BCD*10.3 Beginning Hours 8 X 
INCRHRS8 247 BCD*9.5 Increment Hours 8 X 
MAXACCR8 248 BCD*10.3 Max. Annual Accrual 8 X 
MAXCARRY8 249 BCD*10.3 Max. Carry-over Hours 8 X 
SVCYEAR9 250 Integer Service Year 9 X 
BEGHRS9 251 BCD*10.3 Beginning Hours 9 X 
INCRHRS9 252 BCD*9.5 Increment Hours 9 X 
MAXACCR9 253 BCD*10.3 Max. Annual Accrual 9 X 
MAXCARRY9 254 BCD*10.3 Max. Carry-over Hours 9 X 
SVCYEAR10 255 Integer Service Year 10 X 
BEGHRS10 256 BCD*10.3 Beginning Hours 10 X 
INCRHRS10 257 BCD*9.5 Increment Hours 10 X 
MAXACCR10 258 BCD*10.3 Max. Annual Accrual 10 X 
MAXCARRY10 259 BCD*10.3 Max. Carry-over Hours 10 X 
CCOVERRIDE 260 Boolean Cost Center Override Based on Calc Base X 
BILLINGS 261 Long Billing Rates E A C 
BILLPCT1 262 BCD*5.5 Billing Percentage 1 X 
BILLPCT2 263 BCD*5.5 Billing Percentage 2 X 
BILLPCT3 264 BCD*5.5 Billing Percentage 3 X 
BILLPCT4 265 BCD*5.5 Billing Percentage 4 X 
BILLPCT5 266 BCD*5.5 Billing Percentage 5 X 
BILLPCT6 267 BCD*5.5 Billing Percentage 6 X 
MAXONREM 268 Boolean Calc. Max. Carry-over based on Remaining Balance X 
MAXONACCR 269 Boolean Cap Accrual at Max. Accrual E A X 
COVID 270 Integer Report as E A P  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 271 Integer RESERVED - CDN Only E A  List:4 entries
1 = 028 - Other income
2 = 104 - Research grants
3 = 105 - Scholarships, bursaries, fellowships...
4 = 130 - Apprenticeship, incentive grant or...
PROCESSCMD 210 Integer Process Command Code E A C  List:4 entries
0 = Initialize New Record
1 = Insert Optional Fields
2 = Check for Timecard and Manual Checks
3 = Set Attributes

This page was generated on 2021-Nov-24

© 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).