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: 249

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: 12 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)
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 Calcuation 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: 20 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
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 Type of 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 Secondary Rate Effective  E A P X D  List: 2 entries
0=Never
1=After Annual Maximum Reached
R2NDRATEIN  207  Integer  Employer Secondary 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   
PROCESSCMD  210  Integer  Process Command Code  E A C  List: 3 entries
0=Initialize New Record
1=Insert Optional Fields
2=Check for Timecard and Manual Checks

This page was generated on 2008-May-02

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