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

Field  Index  Type  Title  Attributes  Presentation

EMPLOYEE  String*12  Employee  E A K R  Mask: %-12N
EDITDATE  Date  Edit Date  E A K R   
EDITTIME  Time  Edit Time  E A K R   
CATEGORY1  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  String*6  Earn/Ded/Tax - new  E A K R  Mask: %-6N
LINETYPE1  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  Integer  Line Number  E A K R X   
HISTDATE  Date  History Date  E A   
OPERATION  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   

This page was generated on 2009-Nov-19

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