Table: History Audit Headers

Table: UPHHAU
View: UP0021
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 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).