Previous page

Next page

Audit Logs

Summary

In general, it can be assumed that any action performed by a user such as inserting, editing, updating or deleting records in the PayGlobal entity framework will write an audit log record.

This makes audit logs invaluable for troubleshooting problems that may occur, as you can track who made a change, and when.

Tracking such changes can be done in a number of different ways. These include:

  • Using the Audit Analysis tool
  • Running the Audit Report (PGPRAUDT001)
  • Viewing system generated audit logs.

However not every change is written to an audit log. Certain tables are never audited, because of the way they are declared in PayGlobal's database structure. Many of these tables are 'transaction' tables. Therefore, many processes will not show up in the AuditLog table because of the restrictions on these tables.

Tables not included in Audit Logs

The following list of tables are not included in Audit Logs:

  • ActualsConfirmation
  • ActualsPerPaySequence
  • ActualsResults
  • ActualsValidationResults
  • Allocation
  • AllocationAllocated
  • AllocationCompetencyOverride
  • AllocationQualificnOverride
  • AllocationSuggestion
  • AllocationTimebandOverride
  • AllowanceActionClause
  • AuditLog
  • AwardRuleActionClause
  • AwardRuleEmployeeClause
  • AwardRuleQualifyingClause
  • AwardRuleTimebandClause
  • BudgetCentreImportSequence
  • BudgetCentreNoteSequence
  • BudgetCentreTransaction
  • ClockTransaction
  • CurrentActualAllowance
  • CurrentActualTimeBand
  • CurrentAllowance
  • CurrentAvailability
  • CurrentDeduction
  • CurrentProportionalCosting
  • CurrentRosterAllowance
  • CurrentRosterTimeBand
  • DbConnection
  • DiaryRuleActionClause
  • DiaryTransaction
  • DocFolder
  • Document
  • DrillDownDefinition
  • EmplLeaveCreditHistory
  • EmployeeHistory
  • EntityCodeChanges
  • EQScale (exit questionnaires)
  • FixedResourceTransaction
  • Generator
  • HistoricalActualAllowance
  • HistoricalActualTimeband
  • HistoricalAllowance
  • HistoricalAvailability
  • HistoricalDeduction
  • HistoricalProportionalCost
  • HistoricalRosterAllowance
  • HistoricalRosterTimeBand
  • Message
  • PayrollResults
  • PayrollRuleActionClause
  • PayrollRuleEmployeeClause
  • PayrollRuleQualifyingClause
  • PgFieldInfo
  • PgIndexInfo
  • PgObjectInfo
  • PgTabInfo
  • PgTableInfo
  • PortalModule
  • PortalModuleContent
  • ReqDate
  • ReqDateCompetencyOverride
  • ReqDateQualificationOverride
  • ReqDateTimebandOverride
  • RosterConfirmation
  • RosterPerPaySequence
  • RosterResults
  • RosterValidationResults
  • Scenario
  • ScenarioOrgFields
  • ScenarioOrgStructure
  • ScenarioRosterAllowance
  • ScenarioRosterConfirmation
  • ScenarioRosterResults
  • ScenarioRosterTimeband
  • ScenarioRosterValidResults
  • ScheduledEvent
  • ScheduleRuleActionClause
  • ScheduleRuleQualifyingClause
  • Scheduling
  • SchedulingHistory
  • Semaphore
  • Setting
  • SingletonRecord
  • TabSettings
  • TransActualCurrentMaster
  • TransActualHistoricalMaster
  • TransCurrentMaster
  • TransCurrentNIC
  • TransHistoricalMaster
  • TransHistoricalNIC
  • TransPermanentMaster
  • TransPerPaySequence
  • TransRosterCurrentMaster
  • TransRosterHistoricalMaster
  • UserDefinedCodeWidth
  • UserDefinedTab
  • WorkflowAudit
  • WorkflowLeave
  • WorkflowSupport
  • WorkflowUnits
  •  

Processes not included

The following process commands do not add records to the Audit Log table:

  • LS/TA Processing
  • Clock Importing
  • Clock Processing
  • LS Open Pay
  • LS Close Pay
  • LS Reset Pay
  • T&A Open Pay
  • T&A Close Pay
  • T&A Reset Pay
  • Operations in Daily View (unless specifically allowed for)
  • Accumulator updates for UDAs
  • PR Close Pay
  • PR End of Month Close Pay
  • PR Open Pay
  • PR Reset Pay
  • PR Process Pay
  • Operations in Transaction View (unless specifically allowed for)
  • Org-Charting / Scenarios
  • Diary Processing
  • Document Management
  • Creating user-defined data structures / forms
  • Scheduling
  •  

Tables with Audit Log flag

In some areas, certain tables are created with a flag that disables auditing. These tables are:

  • Processing UDA breakdowns:

    No auditing on EmplUDABreakdown, CostCentre, Employee, Job and Position.

  • Clock processing:

    No auditing on employee, none of the transaction tables are audited

  • P35 Processing (UK):

    No auditing on Employee or P14

  • Pay-Close:

    No auditing on CostCentre, EmplLeaveCredit, Employee, EmployeeBenefitsInKind, EmployeeNote, EmployeeYTDNIC, Job and Loan

  • End-Of-Year Pay-close:

    No auditing on Employee

  • Synchronisation:

    User-setting ('AuditImport') determines whether imports are logged or not.

  • Updating UserProfile if wrong password at login:

    No auditing on UserProfile

  • Updating bank-branch descriptions:

    No auditing on BankBranch and BankGroup

See also

Audit Analysis

Audit Report (PGPRAUDT001)

Maintain Log Files

Previous page

Next page