Skip to main content

Data Model of Audit Trail

Zuora

Data Model of Audit Trail

The Audit Trail records are stored in the following tables:

  • auditloginevent
  • auditsettingchangeevent

Table auditloginevent

Zuora system records every login for each user in the auditloginevent table and allows you to monitor the login history for each and every user. See the table structure below.

Attribute Type Description
browsertype varchar

The login user's browser type. Possible values are:

  • IE
  • FireFox
  • Safari
  • Netscape
  • Chrome
  • Opera
  • Api
  • Unknown
  • RestLogin
  • RestBiz
browserversion varchar The login user's browser version
createdbyid varchar The login user's id
createddate timestamp with time zone The record's creation date
eventid varchar Id of the login event
hostname varchar The device connected to the network (currently not work, the value is the same as ipaddress)
id varchar Id of the record
ipaddress varchar The login IP address
logintype varchar

The login type. Possible values are:

  • CLIENT_CREDENTIALS
  • SSO
  • PASSWORD
  • SWITCH_ENTITY_UI
sequencenumber bigint The sequence number of the login record
status varchar

The login status. Possible values are:

  • Success
  • AuthFail
  • PasswordExpired
timestamp timestamp with time zone The timestamp of the login
tokenid varchar The id of the login token
userid varchar Id of the login user
username varchar The user name of the login user
version varchar Login History API version

Table auditsettingchangeevent

Zuora system records every setting changes in the auditsettingchangeevent table and allows you to monitor the setting changes that impact accounting and financials.

Changes on the following settings can be monitored by Zuora Audit Trail:

  • Billing
    • Define Billing Rules
    • Manage Tax codes
    • Define Discount Settings
    • Manage Revenue Recognition Codes
  • Payment
    • Configure Application Rules
  • Commerce
    • Synchronize Salesforce.com Data
  • Finance
    • Configure Accounting Codes
    • Configure Accounting Rules
    • Manage Currency Conversion
    • Set Revenue Automation Start Date
    • Configure Revenue Event Types
    • Manage Revenue Recognition Models
    • Configure Segments
    • Configure GL Segmentation Rules
    • Manage Revenue Recognition Rules
    • Manage Chart of Accounts
  • User
  • Role & Permission

See the auditsettingchangeevent table structure below.

Attribute Type Description
action varchar

The setting change action. Possible values are:

  • UPDATED
  • CREATED
  • DELETED
  • ADDED_TO_COLLECTION
  • REMOVED_FROM_COLLECTION
attributeid varchar Id of the changed setting item
attributename varchar The name of the changed setting item
createdbyid varchar The Id of the user who changes the setting item
createddate timestamp with time zone The record's creation date
eventid varchar Id of the event
id varchar Id of the record
namespace varchar

The namespace of the setting change. Possible values are:

  • Finance & Revenue
  • Billing
  • Invoicing
  • Commerce
  • Tenant Property
  • Payments
  • UserManagement
newvalue varchar The new value of the setting
oldvalue varchar The previous value of the setting
sequencenumber bigint The sequence number of the record
settingobjectname varchar

The setting object name.

settingtype varchar

The setting type. For example, BillingRules, TaxCode, RevenueRecognition, etc.

timestamp timestamp with time zone The timestamp of the setting change 
tokenid varchar The Id of the login token
transactionid varchar The Id of the setting change transaction
userid varchar The Id of the user who changes the setting item
username varchar user name