View: History Audit Details

RotoID: UP0024
Table: UPHDAU
Protocol: Detail, Ordered revisions
DLL:UPHDAU

Compositions: 2

RotoID Tables Title DLL
UP0021 UPHHAU History Audit Headers UPHHAU
UP0136 UPHDOA History Audit Detail Opt Fields UPHDOA

Keys: 1

Title Fields
Employee Date EMPLOYEE, EDITDATE, EDITTIME, CATEGORY1, EARNDED1, LINETYPE1, LINENO

Fields: 83

Field Index Type Title Attributes Presentation
EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
EDITDATE 2 Date Edit Date E A K R 
EDITTIME 3 Time Edit Time E A K R 
CATEGORY1 4 Integer Category code - new E A K R  List:10 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = State Tax
9 = Local Tax
10 = User Tax
EARNDED1 5 String*6 Earn/Ded/Tax - new E A K R  Mask: %-6N
LINETYPE1 6 Integer Transaction Type - new E A K R X  List:9 entries
1 = Payment
2 = Accrual
3 = Regular
4 = Overtime
5 = Shift Differential
6 = n/a
7 = Normal Withholding
8 = Backup Withholding
9 = Supplemental Withholding
LINENO 7 Integer Line Number E A K R X 
HISTDATE 8 Date History Date E A 
OPERATION 9 Integer Operation E A  List:3 entries
1 = Add
2 = Modify
3 = Delete
EDTYPE1 10 Integer Earn/Ded/Tax Type - new E A X  List:15 entries
1 = Salary & Wages
2 = Reported Tips
3 = Allocated Tips
7 = Vacation
8 = Sick
9 = Compensatory Time
13 = Cash
14 = Noncash
18 = Insurance Tax
19 = Income Tax
20 = Unemployment Tax
21 = Pension Plan Tax
22 = Health Tax
23 = Other Tax
25 = n/a
ECNTBASE1 11 BCD*10.3 Employee Count or Base - new E A X 
ERATE1 12 BCD*9.5 Employee Rate - new E A X 
EEXTEND1 13 BCD*10.3 Employee Amount - new E A X 
RCNTBASE1 14 BCD*10.3 Employee Count or Base - new E A X 
RRATE1 15 BCD*9.5 Employee Rate - new E A X 
REXTEND1 16 BCD*10.3 Employee Amount - new E A X 
WCC1 17 String*6 Workers' Compensation Code - new E A X  Mask: %-6N
GLSEG1A 18 String*15 G/L Segment One - new E A X 
GLSEG2A 19 String*15 G/L Segment Two - new E A X 
GLSEG3A 20 String*15 G/L Segment Three - new E A X 
TAXWEEKS1 21 BCD*4.3 Weeks Worked for Tax Auth - new E A X 
TAXEARNS1 22 BCD*10.3 Taxable Earnings - new E A X 
TXEARNCL1 23 BCD*10.3 Taxable Earnings Ceiling - new E A X 
TAXTIPS1 24 BCD*10.3 Taxable Tips Without Ceil - new E A X 
TXTIPSCL1 25 BCD*10.3 Taxable Tips With a Ceil - new E A X 
TXONTIPS1 26 BCD*10.3 Amount of Tax Calc on Tips - new E A X 
UNCOLLTX1 27 BCD*10.3 For Uncollected SS/Med - new E A X 
DESC1 28 String*15 Description - new E A 
HOURS1 29 BCD*4.3 Hours - new E A X 
REGRATE1 30 BCD*9.5 Regular Rate - new E A X 
CATEGORY2 31 Integer Category code - old E A  List:10 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = State Tax
9 = Local Tax
10 = User Tax
EARNDED2 32 String*6 Earn/Ded/Tax - old E A  Mask: %-6N
LINETYPE2 33 Integer Transaction Type - old E A X  List:9 entries
1 = Payment
2 = Accrual
3 = Regular
4 = Overtime
5 = Shift Differential
6 = n/a
7 = Normal Withholding
8 = Backup Withholding
9 = Supplemental Withholding
EDTYPE2 34 Integer Earn/Ded/Tax Type - old E A X  List:15 entries
1 = Salary & Wages
2 = Reported Tips
3 = Allocated Tips
7 = Vacation
8 = Sick
9 = Compensatory Time
13 = Cash
14 = Noncash
18 = Insurance Tax
19 = Income Tax
20 = Unemployment Tax
21 = Pension Plan Tax
22 = Health Tax
23 = Other Tax
25 = n/a
ECNTBASE2 35 BCD*10.3 Employee Count or Base - old E A X 
ERATE2 36 BCD*9.5 Employee Rate - old E A X 
EEXTEND2 37 BCD*10.3 Employee Amount - old E A X 
RCNTBASE2 38 BCD*10.3 Employee Count or Base - old E A X 
RRATE2 39 BCD*9.5 Employee Rate - old E A X 
REXTEND2 40 BCD*10.3 Employee Amount - old E A X 
WCC2 41 String*6 Workers' Compensation Code - old E A X  Mask: %-6N
GLSEG1B 42 String*15 G/L Segment One - old E A X 
GLSEG2B 43 String*15 G/L Segment Two - old E A X 
GLSEG3B 44 String*15 G/L Segment Three - old E A X 
TAXWEEKS2 45 BCD*4.3 Weeks Worked for Tax Auth - old E A X 
TAXEARNS2 46 BCD*10.3 Taxable Earnings - old E A X 
TXEARNCL2 47 BCD*10.3 Taxable Earnings Ceiling - old E A X 
TAXTIPS2 48 BCD*10.3 Taxable Tips Without Ceil - old E A X 
TXTIPSCL2 49 BCD*10.3 Taxable Tips With a Ceil - old E A X 
TXONTIPS2 50 BCD*10.3 Amount of Tax Calc on Tips - old E A X 
UNCOLLTX2 51 BCD*10.3 For Uncollected SS/Med - old E A X 
DESC2 52 String*15 Description - old E A 
HOURS2 53 BCD*4.3 Hours - old E A X 
REGRATE2 54 BCD*9.5 Regular Rate - old E A X 
TAXNONPER1 55 BCD*10.3 Taxable Non-periodic Earn - new E A X 
TAXNONPER2 56 BCD*10.3 Taxable Non-periodic Earn - old E A X 
TAXEARNBD1 57 BCD*10.3 Subject to Inc tax bef ded - new E A X 
TAXEARNBD2 58 BCD*10.3 Subject to Inc tax bef ded - old E A X 
WCCGROUP1 59 String*6 Workers Comp. Group - new E A  Mask: %-6N
WCCGROUP2 60 String*6 Workers Comp. Group - old E A  Mask: %-6N
POOLEDTIP1 61 BCD*10.3 RESERVED - Cdn Only E A X 
POOLEDTIP2 62 BCD*10.3 RESERVED - Cdn Only E A X 
EARDEDDAT1 63 Date Earning/Deduction Date - new E A X 
EARDEDDAT2 64 Date Earning/Deduction Date - old E A X 
STARTTIME1 65 Integer Start Time - new E A X 
STARTTIME2 66 Integer Start Time - old E A X 
STOPTIME1 67 Integer Stop Time - new E A X 
STOPTIME2 68 Integer Stop Time - old E A X 
VALUES 69 Long Number of Optional Fields E A C 
ECALCMETH 70 Integer Employee Calculation Method E A X 
RCALCMETH 71 Integer Employer Calculation Method E A X 
WCBASE1 72 BCD*10.3 WC Base - new E A X 
WCBASE2 73 BCD*10.3 WC Base - old E A X 
WCRATE1 74 BCD*6.6 WC Rate - new E A X 
WCRATE2 75 BCD*6.6 WC Rate - old E A X 
WCEXTEND1 76 BCD*10.5 WC Assessment - new E A C X 
WCEXTEND2 77 BCD*10.5 WC Assessment - old E A C X 
GLSEG4A 78 String*15 G/L Segment Four - new E A X 
GLSEG5A 79 String*15 G/L Segment Five - new E A X 
GLSEG6A 80 String*15 G/L Segment Six - new E A X 
GLSEG4B 81 String*15 G/L Segment Four - old E A X 
GLSEG5B 82 String*15 G/L Segment Five - old E A X 
GLSEG6B 83 String*15 G/L Segment Six - old E A X 

This page was generated on 2022-Aug-18

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