View: History Audit Detail Opt Fields

RotoID: CP0136
Table: CPHDOA
Protocol: Detail, Ordered revisions
DLL:CPHDOA

Compositions: 1

RotoID Tables Title DLL

CP0024 CPHDAU History Audit Details CPHDAU

Keys: 1

Title Fields

Earn/Ded/Tax Opt Field EMPLOYEEEDITDATEEDITTIMECATEGORYEARNDEDLINETYPELINENOOPTFIELD

Fields: 19

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 
CATEGORY 4 Integer Category E A K R  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
EARNDED 5 String*6 Earn/Ded/Tax E A K R  Mask: %-6N
LINETYPE 6 Integer Transaction Type E A K R  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 
OPTFIELD 8 String*12 Optional Field E A K R  Mask: %-12N
OPERATION 9 Integer Operation E A  List:3 entries
1 = Add
2 = Modify
3 = Delete
TYPE 10 Integer Type E A  List:7 entries
1 = Text
100 = Amount
6 = Number
8 = Integer
9 = Yes/No
3 = Date
4 = Time
LENGTH 11 Integer Length E A 
DECIMALS 12 Integer Decimals E A 
ALLOWNULL 13 Boolean Allow Blank E A  List:2 entries
0 = No
1 = Yes
VALIDATE 14 Boolean Validate E A  List:2 entries
0 = No
1 = Yes
FDESC 15 String*60 Optional Field Description E A 
VALUE1 16 String*60 Value - new E A X 
VDESC1 17 String*60 Value Description - new E A X 
VALUE2 18 String*60 Value - old E A X 
VDESC2 19 String*60 Value Description - old E A X