SYAUDIT - Audit Trail (AU) Database

SYAUDIT field information

 

Seq Field Name Type Length Dec Description

1

A_DATE

T

8

0

Change Date

2

A_DIFF

C

11

0

Numeric Value Differences

3

A_FIELD

C

10

0

Field Name That Changed

4

A_FILE

C

10

0

File Name That Changed

5

A_KEY

C

40

0

Record Key Value

6

A_NEW

C

50

0

New Field Value

7

A_OLD

C

50

0

Old Field Value

8

A_TASK

C

20

0

Task Name

9

A_TIME

C

8

0

Time of Change

10

A_TYPE

C

1

0

Type Of Change (Add, Change, Remove)

11

A_USERID

C

10

0

User Id

12

D_ENCRYPT

L

1

0

Allow encryption on field

13

_ZFILTER

C

25

0

Filter Function