# Table: History Audit Headers

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

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Employee, Date |  | EMPLOYEE, EDITDATE, EDITTIME

## Fields: 27

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 |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.