Table: Delete Inactive Records Audit

Table: UPAUDM
View: UP0220
Record length: 140
Flags: A R 

Keys: 1

Title  Flags  Fields

Run Sequence  RUNSEQ

Fields: 24

Field  Type  Title  Presentation 

RUNSEQ  Long  Run Sequence   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
CLEARDATE  Date  Clearing Date   
DELHIST  Boolean  Delete Employee History  List: 2 entries
0=No
1=Yes
DELEMPS  Boolean  Delete Terminated Employees  List: 2 entries
0=No
1=Yes
DELEARNDED  Boolean  Delete Inactive Earnings/Deductions  List: 2 entries
0=No
1=Yes
DELTAXTBLS  Boolean  Delete Inactive Taxes  List: 2 entries
0=No
1=Yes
RECSCLEARD  Boolean  Records were cleared  List: 2 entries
0=No
1=Yes
HSTARTEMPL  String*12  Delete History From Employee  Mask: %-12N
HENDEMPL  String*12  Delete History To Employee  Mask: %-12N
DSTARTEMPL  String*12  Delete Employees From  Mask: %-12N
DENDEMPL  String*12  Delete Employees To  Mask: %-12N
DSTARTED  String*6  Delete Earn/Ded From  Mask: %-6N
DENDED  String*6  Delete Earn/Ded To  Mask: %-6N
DSTARTTAX  String*6  Delete Taxes From  Mask: %-6N
DENDTAX  String*6  Delete Taxes To  Mask: %-6N
INACDELCNT  Long  Total Inactive Records Deleted   
TERMDELCNT  Long  Total Employees Deleted   
HISTDELCNT  Long  Total Transactions Deleted   
RUNDATE  Date  Run Date   
ORGUSERID  String*8  Original User ID   

This page was generated on 2009-Nov-19

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