Difference between revisions of "Insert Audit"

From Charitylog Manual
Jump to: navigation, search
Line 9: Line 9:
 
* '''Earliest Date''' - Select the start of the period you wish to report on.
 
* '''Earliest Date''' - Select the start of the period you wish to report on.
 
* '''Latest Date''' - Select the end of the period you wish to report on.
 
* '''Latest Date''' - Select the end of the period you wish to report on.
* '''User Name''' - Allows you to apply a user filter or to display all users.
+
* '''User Name''' - Allows you to apply a user filter or to display all users.  If you select all users you must specify a table name, due to the size of the report.
* '''Table Name''' - Allows you to select all tables or a specific table.
+
* '''Table Name''' - Allows you to select all tables or a specific table.  If you select all tables you must specify a user, due to the size of the report.
  
 
The following tables are available in the report:
 
The following tables are available in the report:
Line 148: Line 148:
 
* '''Travel rules groups'''
 
* '''Travel rules groups'''
 
* '''User Groups'''
 
* '''User Groups'''
 +
 +
Click 'Display in Browser' button to run the report or 'Export to Spreadsheet'.

Revision as of 10:21, 20 September 2018

Helpheader small.png

File:Menu insertaudit.PNG

The Insert Audit report allows you to display users that have created records in some of the key tables of the systems database.

File:Rep insertcriteria.PNG

  • Earliest Date - Select the start of the period you wish to report on.
  • Latest Date - Select the end of the period you wish to report on.
  • User Name - Allows you to apply a user filter or to display all users. If you select all users you must specify a table name, due to the size of the report.
  • Table Name - Allows you to select all tables or a specific table. If you select all tables you must specify a user, due to the size of the report.

The following tables are available in the report:

  • Accommodation Types
  • Actions
  • Alert Condition Time Preferences
  • Alert Conditions
  • Alerts
  • Answers to Classification Code Questions
  • Associated people
  • Benefit definitions
  • Benefits applied and received
  • Branches and Views
  • Cancellation Reasons
  • Carer-dependant assignments
  • Checkbox visibility in Group Access
  • Classification Code Questions
  • Classification Codes
  • Classification Codes entered
  • Clinic Attendance Cancellations
  • Clinic Cancellation Reasons
  • Clinic Meeting breaks
  • Clinic Transport methods
  • Clinic Volunteers
  • Clinic attendances
  • Clinic meetings
  • Clinic members
  • Clinic treatments and activities
  • Clinic treatments and activities
  • Clinic treatments and activities for attendances
  • Clubs and Clinics
  • Consent Rule / Responses Links
  • Consent Rule Responses
  • Consent Rule definitions
  • Contract definitions
  • Course and Qualification definitions
  • Emails sent
  • Equipment
  • Equipment issued
  • Extension Database Fields
  • Extension Database select list options
  • Extension Databases
  • Extra links for org/people records
  • Facilities
  • Field Sets
  • Field definitions
  • Fields on Org/People tabs
  • Funding Streams
  • Group Access
  • Handyperson charges
  • Handyperson job cards
  • Handyperson job types
  • Handyperson jobs
  • Handyperson materials
  • Handyperson referrals
  • Handyperson time and materials
  • In Project records
  • Information Link Subheadings
  • Information Links
  • Information Links main headings
  • Input Field Rules
  • Invoice layouts
  • Letter access
  • Letter template access
  • Letter templates
  • Letter types
  • Letters and mailmerge audits
  • Lines on Support Plans
  • Log of Data Upgrades after version 737
  • Lookup folder fields
  • Lookup folders
  • Mailmerge criteria
  • Mailmerges
  • Main Menu Tabs
  • Membership and skills definitions
  • Menu items
  • Next of Kins
  • Org/People Courses and Qualifications
  • Org/People Ezitracker details
  • Org/People Income
  • Org/People consent rules
  • Org/People extra records
  • Org/People memberships / skills
  • Org/People old addresses
  • Org/People tab definitions
  • Org/People tabs
  • Org/People type definitions
  • Organisations and People
  • Private Notes
  • Private Notes visibility
  • Project Subcategories
  • Project Timesplits
  • Project nominal code links
  • Project project rules (basic)
  • Project referral reason links
  • Project subcategory links
  • Projects
  • Publications
  • Publications provided
  • RaC options locations
  • Rates
  • Record branch visibility
  • Referral Deletions
  • Referral Reasons
  • Referral Templates
  • Referral reasons
  • Referral stage change audit
  • Referral template stages
  • Referrals
  • Relationship Types
  • Relationships
  • Saved KPI report names
  • Select options on Classification Code Questions
  • Simple outcomes
  • Software patches
  • Sub Menu Heading Placement
  • Sub Menu Link Placement
  • Support Job Cards statuses
  • Support Plan audits
  • Support Plan manager change audits
  • Support Plans
  • Support Worker Job Card audits
  • Support Worker Matching Exclusion Definitions
  • Support Worker Matching Exclusions
  • Support Worker Services
  • Support Worker Tasks
  • Support Worker Tasks for Services
  • Support Worker Unavailabilities
  • Support Worker and Client time preferences
  • Support Worker shifts
  • Supporting People Talks
  • Termination Reasons
  • Timesheets
  • Timesheets lines
  • Timesplit lines
  • Travel rules
  • Travel rules groups
  • User Groups

Click 'Display in Browser' button to run the report or 'Export to Spreadsheet'.