Table: History Audit Headers

Table: UPHHAU
View: UP0021
Record Length: 687

Flags: A R 

Keys: 1

Title Flags Fields

Employee, Date EMPLOYEEEDITDATEEDITTIME

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