Table: History Audit Details

Table: CPHDAU
View: CP0024
Record Length: 721

Flags: A R 

Keys: 1

Title Flags Fields

Employee Date EMPLOYEEEDITDATEEDITTIMECATEGORY1EARNDED1LINETYPE1LINENO

Fields: 87

Field Type Title Presentation

EMPLOYEE String*12 Employee Mask: %-12N
EDITDATE Date Edit Date
EDITTIME Time Edit Time
CATEGORY1 Integer Category code - new List:10 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = Provincial Tax
9 = Local Tax
10 = User Tax
EARNDED1 String*6 Earn/Ded/Tax - new Mask: %-6N
LINETYPE1 Integer Transaction Type - new 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
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
HISTDATE Date History Date
OPERATION Integer Operation List:3 entries
1 = Add
2 = Modify
3 = Delete
EDTYPE1 Integer Earn/Ded/Tax Type - new List:16 entries
1 = Salary & Wages
2 = Reported Tips
3 = Allocated Tips
7 = Vacation
8 = Sick
9 = Banked Time
10 = Disability
13 = Cash
14 = Noncash
18 = Insurance Tax
19 = Income Tax
20 = Employment Tax
21 = Pension Plan Tax
22 = Health Tax
23 = Other Tax
25 = n/a
ECNTBASE1 BCD*10.3 Employee Count or Base - new
ERATE1 BCD*9.5 Employee Rate - new
EEXTEND1 BCD*10.3 Employee Amount - new
RCNTBASE1 BCD*10.3 Employee Count or Base - new
RRATE1 BCD*9.5 Employee Rate - new
REXTEND1 BCD*10.3 Employee Amount - new
WCC1 String*6 Workers' Compensation Code - new Mask: %-6N
GLSEG1A String*15 G/L Segment One - new
GLSEG2A String*15 G/L Segment Two - new
GLSEG3A String*15 G/L Segment Three - new
TAXWEEKS1 BCD*4.3 Weeks Worked for Tax Auth - new
TAXEARNS1 BCD*10.3 Taxable Earnings - new
TXEARNCL1 BCD*10.3 Taxable Earnings Ceiling - new
TAXTIPS1 BCD*10.3 Taxable Tips Without Ceil - new
TXTIPSCL1 BCD*10.3 Taxable Tips With a Ceil - new
TXONTIPS1 BCD*10.3 Amount of Tax Calc on Tips - new
UNCOLLTX1 BCD*10.3 For Uncollected SS/Med - new
DESC1 String*15 Description - new
HOURS1 BCD*4.3 Hours - new
REGRATE1 BCD*9.5 Regular Rate - new
CATEGORY2 Integer Category code - old List:10 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = Provincial Tax
9 = Local Tax
10 = User Tax
EARNDED2 String*6 Earn/Ded/Tax - old Mask: %-6N
LINETYPE2 Integer Transaction Type - old 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 Integer Earn/Ded/Tax Type - old List:16 entries
1 = Salary & Wages
2 = Reported Tips
3 = Allocated Tips
7 = Vacation
8 = Sick
9 = Banked Time
10 = Disability
13 = Cash
14 = Noncash
18 = Insurance Tax
19 = Income Tax
20 = Employment Tax
21 = Pension Plan Tax
22 = Health Tax
23 = Other Tax
25 = n/a
ECNTBASE2 BCD*10.3 Employee Count or Base - old
ERATE2 BCD*9.5 Employee Rate - old
EEXTEND2 BCD*10.3 Employee Amount - old
RCNTBASE2 BCD*10.3 Employee Count or Base - old
RRATE2 BCD*9.5 Employee Rate - old
REXTEND2 BCD*10.3 Employee Amount - old
WCC2 String*6 Workers' Compensation Code - old Mask: %-6N
GLSEG1B String*15 G/L Segment One - old
GLSEG2B String*15 G/L Segment Two - old
GLSEG3B String*15 G/L Segment Three - old
TAXWEEKS2 BCD*4.3 Weeks Worked for Tax Auth - old
TAXEARNS2 BCD*10.3 Taxable Earnings - old
TXEARNCL2 BCD*10.3 Taxable Earnings Ceiling - old
TAXTIPS2 BCD*10.3 Taxable Tips Without Ceil - old
TXTIPSCL2 BCD*10.3 Taxable Tips With a Ceil - old
TXONTIPS2 BCD*10.3 Amount of Tax Calc on Tips - old
UNCOLLTX2 BCD*10.3 For Uncollected SS/Med - old
DESC2 String*15 Description - old
HOURS2 BCD*4.3 Hours - old
REGRATE2 BCD*9.5 Regular Rate - old
TAXNONPER1 BCD*10.3 Taxable Non-periodic Earn - new
TAXNONPER2 BCD*10.3 Taxable Non-periodic Earn - old
TAXEARNBD1 BCD*10.3 Subject to Inc tax bef ded - new
TAXEARNBD2 BCD*10.3 Subject to Inc tax bef ded - old
WCCGROUP1 String*6 Workers Comp. Group - new Mask: %-6N
WCCGROUP2 String*6 Workers Comp. Group - old Mask: %-6N
POOLEDTIP1 BCD*10.3 Pooled Tips - new
POOLEDTIP2 BCD*10.3 Pooled Tips - old
EARDEDDAT1 Date Earning/Deduction Date - new
EARDEDDAT2 Date Earning/Deduction Date - old
STARTTIME1 Integer Start Time - new
STARTTIME2 Integer Start Time - old
STOPTIME1 Integer Stop Time - new
STOPTIME2 Integer Stop Time - old
VALUES Long Number of Optional Fields
ECALCMETH Integer Employee Calculation Method
RCALCMETH Integer Employer Calculation Method
WCBASE1 BCD*10.3 WC Base - new
WCBASE2 BCD*10.3 WC Base - old
WCRATE1 BCD*6.6 WC Rate - new
WCRATE2 BCD*6.6 WC Rate - old
WCEXTEND1 BCD*10.5 WC Assessment - new
WCEXTEND2 BCD*10.5 WC Assessment - old
GLSEG4A String*15 G/L Segment Four - new
GLSEG5A String*15 G/L Segment Five - new
GLSEG6A String*15 G/L Segment Six - new
GLSEG4B String*15 G/L Segment Four - old
GLSEG5B String*15 G/L Segment Five - old
GLSEG6B String*15 G/L Segment Six - old