Table: History Audit Headers

Table: CPHHAU
View: CP0021
Record length: 687
Flags: A R 

Keys: 1

Title  Flags  Fields
Employee, Date  EMPLOYEE, EDITDATE, EDITTIME

Fields: 28

Field  Type  Title  Presentation 
EMPLOYEE  String*12  Employee  Mask: %-12N
EDITDATE  Date  Edit Date   
EDITTIME  Time  Edit Time   
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
CLASS1A  String*6  Class 1 - new  Mask: %-6N
CLASS2A  String*6  Class 2 - new  Mask: %-6N
CLASS3A  String*6  Class 3 - new  Mask: %-6N
CLASS4A  String*6  Class 4 - new  Mask: %-6N
DESC1  String*250  Description - new   
NETPAY1  BCD*10.3  Net Pay - new   
CLASS1B  String*6  Class 1 - old  Mask: %-6N
CLASS2B  String*6  Class 2 - old  Mask: %-6N
CLASS3B  String*6  Class 3 - old  Mask: %-6N
CLASS4B  String*6  Class 4 - old  Mask: %-6N
DESC2  String*250  Description - old   
NETPAY2  BCD*10.3  Net Pay - old   
LASTNAME  String*20  Last Name   
FIRSTNAME  String*15  First Name   
MIDDLENAME  String*15  Middle Name   
WORKPROV1  Integer  Province of Employment - new  List: 14 entries
1=Alberta
2=British Columbia
3=Manitoba
4=New Brunswick
5=Newfoundland & Labrador
6=Northwest Territories
7=Nova Scotia
8=Ontario
9=Outside Canada
10=Prince Edward Island
11=Quebec
12=Saskatchewan
13=Yukon Territory
14=Nunavut
WORKPROV2  Integer  Province of Employment - old  List: 14 entries
1=Alberta
2=British Columbia
3=Manitoba
4=New Brunswick
5=Newfoundland & Labrador
6=Northwest Territories
7=Nova Scotia
8=Ontario
9=Outside Canada
10=Prince Edward Island
11=Quebec
12=Saskatchewan
13=Yukon Territory
14=Nunavut
VALUES  Long  Number of Optional Fields   
ORGUSERID  String*8  Original User ID   

This page was generated on 2009-Nov-19

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