View: Delete Inactive Records Audit

RotoID: CP0220
Table: CPAUDM
Protocol: Header
DLL:CPAUDM

Compositions: 2

RotoID Tables Title DLL

CP0221 CPAUDMI Delete Audit Inactive Details CPAUDMI
CP0222 CPAUDMH Delete Audit Transaction Details CPAUDMH

Keys: 1

Title Fields

Run Sequence RUNSEQ

Fields: 20

Field Index Type Title Attributes Presentation

RUNSEQ 1 Long Run Sequence E A K R 
CLEARDATE 2 Date Clearing Date E A 
DELHIST 3 Boolean Delete Employee History E A  List:2 entries
0 = No
1 = Yes
DELEMPS 4 Boolean Delete Terminated Employees E A  List:2 entries
0 = No
1 = Yes
DELEARNDED 5 Boolean Delete Inactive Earnings/Deductions E A  List:2 entries
0 = No
1 = Yes
DELTAXTBLS 6 Boolean Delete Inactive Taxes E A  List:2 entries
0 = No
1 = Yes
RECSCLEARD 7 Boolean Records were cleared E A  List:2 entries
0 = No
1 = Yes
HSTARTEMPL 8 String*12 Delete History From Employee E A X  Mask: %-12N
HENDEMPL 9 String*12 Delete History To Employee E A X  Mask: %-12N
DSTARTEMPL 10 String*12 Delete Employees From E A X  Mask: %-12N
DENDEMPL 11 String*12 Delete Employees To E A X  Mask: %-12N
DSTARTED 12 String*6 Delete Earn/Ded From E A X  Mask: %-6N
DENDED 13 String*6 Delete Earn/Ded To E A X  Mask: %-6N
DSTARTTAX 14 String*6 Delete Taxes From E A X  Mask: %-6N
DENDTAX 15 String*6 Delete Taxes To E A X  Mask: %-6N
INACDELCNT 16 Long Total Inactive Records Deleted E A 
TERMDELCNT 17 Long Total Employees Deleted E A 
HISTDELCNT 18 Long Total Transactions Deleted E A 
RUNDATE 19 Date Run Date E A 
ORGUSERID 20 String*8 Original User ID E A