Entity AuditTrailTable

Description of Entity AuditTrailTable

There are 2 main types of audit logs that Sage EasyPay Control can generate:
- Login Audit: Keeps a record of successful logins
- Audit Trail: Keeps a record of the changes made by users in the Core and Payroll Modules

By default, the Audit Trail is disabled as it will capture all the changes made, including personal data and wage sensitive data. There is an additional login report, the Transaction Audit. It translates log files created by Sybase Central into SQL statements. It is meant to be used together with the Login Audit and the Audit Trail. However, because there are several hundred tables in Sage EasyPay, keeping track of changes to each table is pointless and will only serve as a distraction.

The Audit Trail Report is currently limited to the following tables: AllowanceRecord, BasicRateProgression, DetailRecord, Employee, PayEmployee, PaymentBankInfo, PeriodPolicySummary and ResidenceStatusRecord.


List of Attributes of the Entity AuditTrailTable

Name

Code

Audit Trail ID

AuditTrailID

Audit User ID

AuditUserID

Audit IP

AuditIP

AuditTimeStamp

AuditTimeStamp

AuditEventType

AuditEventType

AuditTableName

AuditTableName

AuditFieldName

AuditFieldName

Audit Emp ID

AuditEmpID

AuditKey1

AuditKey1

AuditKey2

AuditKey2

AuditKey3

AuditKey3

AuditKey4

AuditKey4

AuditKey5

AuditKey5

AuditKey6

AuditKey6

BeforeValue

BeforeValue

AfterValue

AfterValue


Entity Attribute Audit Trail ID of the Entity AuditTrailTable

Card of Attribute Audit Trail ID of the Entity AuditTrailTable

Name

Audit Trail ID

Code

AuditTrailID

Data Type

integer

Mandatory

Yes


Description of Attribute Audit Trail ID of the Entity AuditTrailTable

Shows the identity of the audit trail. This acts as the primary key for the AuditTrailTable entity.


Entity Attribute Audit User ID of the Entity AuditTrailTable

Card of Attribute Audit User ID of the Entity AuditTrailTable

Name

Audit User ID

Code

AuditUserID

Data Type

char(20)

Mandatory

No


Description of Attribute Audit User ID of the Entity AuditTrailTable

Shows the identity of the user.
Example: EPEMaster etc


Entity Attribute Audit IP of the Entity AuditTrailTable

Card of Attribute Audit IP of the Entity AuditTrailTable

Name

Audit IP

Code

AuditIP

Data Type

char(20)

Mandatory

No


Description of Attribute Audit IP of the Entity AuditTrailTable

Shows the IP address of the audit.


Entity Attribute AuditTimeStamp of the Entity AuditTrailTable

Card of Attribute AuditTimeStamp of the Entity AuditTrailTable

Name

AuditTimeStamp

Code

AuditTimeStamp

Data Type

timestamp

Mandatory

No


Description of Attribute AuditTimeStamp of the Entity AuditTrailTable

Shows the exact date and time of the audit.
Example: 2013-03-05 15:49:04.888


Entity Attribute AuditEventType of the Entity AuditTrailTable

Card of Attribute AuditEventType of the Entity AuditTrailTable

Name

AuditEventType

Code

AuditEventType

Data Type

char(20)

Mandatory

No


Description of Attribute AuditEventType of the Entity AuditTrailTable

Shows the type of event for the audit.
Example: Update / Insert / Delete


Entity Attribute AuditTableName of the Entity AuditTrailTable

Card of Attribute AuditTableName of the Entity AuditTrailTable

Name

AuditTableName

Code

AuditTableName

Data Type

char(100)

Mandatory

No


Description of Attribute AuditTableName of the Entity AuditTrailTable

Shows the table name for the audit.
Example: PayEmployee / BasicRateProgression / PeriodPolicySummary etc


Entity Attribute AuditFieldName of the Entity AuditTrailTable

Card of Attribute AuditFieldName of the Entity AuditTrailTable

Name

AuditFieldName

Code

AuditFieldName

Data Type

char(100)

Mandatory

No


Description of Attribute AuditFieldName of the Entity AuditTrailTable

Shows the field name for the audit.
Example: CurrentBasicRate / BRProgNewBasicRate / TotalCDAC etc


Entity Attribute Audit Emp ID of the Entity AuditTrailTable

Card of Attribute Audit Emp ID of the Entity AuditTrailTable

Name

Audit Emp ID

Code

AuditEmpID

Data Type

char(30)

Mandatory

No


Description of Attribute Audit Emp ID of the Entity AuditTrailTable

Shows the employee ID for the audit.


Entity Attribute AuditKey1 of the Entity AuditTrailTable

Card of Attribute AuditKey1 of the Entity AuditTrailTable

Name

AuditKey1

Code

AuditKey1

Data Type

char(50)

Mandatory

No


Description of Attribute AuditKey1 of the Entity AuditTrailTable

Shows the key for the audit trail table.


Entity Attribute AuditKey2 of the Entity AuditTrailTable

Card of Attribute AuditKey2 of the Entity AuditTrailTable

Name

AuditKey2

Code

AuditKey2

Data Type

char(50)

Mandatory

No


Description of Attribute AuditKey2 of the Entity AuditTrailTable

Shows the key for the audit trail table.


Entity Attribute AuditKey3 of the Entity AuditTrailTable

Card of Attribute AuditKey3 of the Entity AuditTrailTable

Name

AuditKey3

Code

AuditKey3

Data Type

char(50)

Mandatory

No


Description of Attribute AuditKey3 of the Entity AuditTrailTable

Shows the key for the audit trail table.


Entity Attribute AuditKey4 of the Entity AuditTrailTable

Card of Attribute AuditKey4 of the Entity AuditTrailTable

Name

AuditKey4

Code

AuditKey4

Data Type

char(50)

Mandatory

No


Description of Attribute AuditKey4 of the Entity AuditTrailTable

Shows the key for the audit trail table.


Entity Attribute AuditKey5 of the Entity AuditTrailTable

Card of Attribute AuditKey5 of the Entity AuditTrailTable

Name

AuditKey5

Code

AuditKey5

Data Type

char(50)

Mandatory

No


Description of Attribute AuditKey5 of the Entity AuditTrailTable

Shows the key for the audit trail table.


Entity Attribute AuditKey6 of the Entity AuditTrailTable

Card of Attribute AuditKey6 of the Entity AuditTrailTable

Name

AuditKey6

Code

AuditKey6

Data Type

char(50)

Mandatory

No


Description of Attribute AuditKey6 of the Entity AuditTrailTable

Shows the key for the audit trail table.


Entity Attribute BeforeValue of the Entity AuditTrailTable

Card of Attribute BeforeValue of the Entity AuditTrailTable

Name

BeforeValue

Code

BeforeValue

Data Type

char(100)

Mandatory

No


Description of Attribute BeforeValue of the Entity AuditTrailTable

A before value for the audit trail table.


Entity Attribute AfterValue of the Entity AuditTrailTable

Card of Attribute AfterValue of the Entity AuditTrailTable

Name

AfterValue

Code

AfterValue

Data Type

char(100)

Mandatory

No


Description of Attribute AfterValue of the Entity AuditTrailTable

An after value for the audit trail table.