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