logo
    
  • Home
  • Getting Started
    • Creating Your First App
    • Working with the API
    • Authorization
    • JSON vs. XML
    • SDKs
    • Environments
    • Pricing and Charges
  • Key Concepts
    • Design Principles
    • Object Hierarchy
    • Pay Run Flow
    • Calculation Commentary
    • Understanding Pay Instructions
    • Understanding Pay Runs
    • Understanding Pay Codes
    • Understanding Holiday Schemes
    • Meta Data and Tags
    • Reporting
    • Jobs
    • SDK Bridge
    • Customising the Payslip
    • Migrating Payroll Mid-year
    • Correcting Mistakes
    • Versioning
    • Revisible Objects
    • Pre-Calculation Rules
    • Syncing Employees
    • Real Time Information
    • Data Provisioning Service
  • Payroll Help
    • Furlough Payments - Covid-19 Job Retention Scheme Payments (CJRS)
    • Pensions
    • Using the Correct NI Letter
    • Understanding Tax Codes
    • Understanding Periods
    • Pro-rata Calculation Methods
    • Employees as Directors
    • Average Weekly Earnings
    • Auto Enrolment
    • Fixed Rate Loans
    • Claiming the Employment Allowance
    • Company Cars
    • Claiming Small Employer Relief
    • Attachment of Earnings
    • Glossary of Terms
  • How-to Examples
    • Examples
    • Simple Payrun
    • Simple CIS
    • Query Library
    • Employer I/O
    • Pay Schedule I/O
    • Employee I/O
    • Pay Instruction I/O
    • Auto Enrolment
    • Net to Gross
    • Integrating Timesheets
    • Batch Processing
    • Setting the Employee Tax Code
    • Setting the Employee Salary
    • Generating PDF Payslips
    • Generating a P45
    • Generating a P60
  • Validation
  • Privacy and Security
  • Reference
    • Address
    • AE Assessment
    • CIS
      • Sub Contractor
      • CIS Line Type
      • CIS Instruction
      • CIS Line
      • CIS Transaction
    • Bank Account
    • Common Types
    • Employee
    • Employer
    • Error
    • Healthcheck
    • Holiday Accrual Scheme
    • Jobs
      • Pay Run Job Instruction
      • RTI Job Instruction
      • RTI FPS Job Instruction
      • RTI EPS Job Instruction
      • RTI NVR Job Instruction
      • DPS Job Instruction
      • CIS Calculate Job Instruction
      • CIS Return Job Instruction
      • CIS Verify Job Instruction
      • Batch Job Instruction
    • Meta Data
    • Journals
      • Journal Line
      • Journal Instruction
    • Nominal Codes
    • Pay Codes
    • Pay Instructions
      • Attachment of Earning Pay Instruction
      • Benefit Pay Instruction
      • Furlough Pay Instruction
      • Car Benefit Pay Instruction
      • Fixed Rate Loan Pay Instruction
      • Holiday Reclaim Pay Instruction
      • Holiday Scheme Pay Instruction
      • Net to Gross Pay Instruction
      • NI Adjustment Pay Instruction
      • NI Pay Instructions
      • P45 Pay Instruction
      • Pension Pay Instruction
      • Primitive Pay Instruction
      • Rate Pay Instruction
      • Salary Pay Instruction
      • SAP Pay Instruction
      • ShPP Pay Instruction
      • SMP Pay Instruction
      • SPP Pay Instruction
      • SPBP Pay Instruction
      • SSP Pay Instruction
      • Student Loan Pay Instruction
      • Post Graduate Loan Pay Instruction
      • Tax Pay Instruction
      • Termination Pay Instruction
    • Pay Schedule
    • Pay Lines
      • Pay Line AoE
      • Pay Line Benefit
      • Pay Line Furlough
      • Pay Line Car Benefit
      • Pay Line Holiday
      • Pay Line Lone
      • Pay Line NI
      • Pay Line Pension
      • Pay Line Rate
      • Pay Line SAP
      • Pay Line ShPP
      • Pay Line SMP
      • Pay Line SPP
      • Pay Line SSP
      • Pay Line Post Graduate Loan
      • Pay Line Student Loan
      • Pay Line Tax
      • Pay Line Termination
    • Pay Run
    • Pension
    • Report Query Language
      • Query Root
      • Entity Group
      • Name Value Pair
      • Conditions
      • Filters
      • Ordering
      • Outputs
      • Aggregate Outputs
    • Reporting Instruction
      • HMRC Payment Reporting Instruction
      • Opening Balance Reporting Instruction
      • Pension Payment Reporting Instruction
      • Apprenticeship Levy Reporting Instruction
      • CIS Suffered Reporting Instruction
      • Employment Allowance Reporting Instruction
    • Report Line
      • Report Line Pension
      • Report Line Statutory Recovery
      • Report Line Tax Summary
      • Report Line HMRC Payment
      • Report Line Apprenticeship Levy
      • Report Line CIS Suffered
      • Report Line Employment Allowance
    • Reports
      • Report Definition
    • Transforms
      • Transform Definition
    • Real Time Information
      • RTI NVR Transaction
      • RTI FPS Transaction
      • RTI EPS Transaction
    • Secret
    • Year To Date Pay Instructions
      • ShPP YTD Pay Instruction
      • SMP YTD Pay Instruction
      • Rate YTD Pay Instruction
      • SAP YTD Pay Instruction
      • SPBP YTD Pay Instruction
      • Student Loan YTD Pay Instruction
      • Tax YTD Pay Instruction
      • SPP YTD Pay Instruction
      • SSP YTD Pay Instruction
      • Primitive YTD Pay Instruction
      • Car Benefit YTD Pay Instruction
      • Fixed Rate Loan YTD Pay Instruction
      • AOE YTD Pay Instruction
      • Benefit YTD Pay Instruction
      • Furlough YTD Pay Instruction
      • Pension YTD Pay Instruction
      • Post Graduate Loan YTD Pay Instruction
      • Holiday YTD Pay Instruction
      • NI YTD Pay Instruction
      • Termination YTD Pay Instruction
    • Tags
    • Link
    • Library License
  • Release Notes
    • Current Release
    • v20.21.6.60
    • v20.21.6.52
    • v20.21.6.44
    • v20.21.6.36
    • v20.21.6.29
    • v20.21.6.12
    • v20.21.6.3
    • v20.21.5.54
    • v20.21.5.15
    • v20.21.4.30
    • v20.21.4.27
    • v20.21.4.14
    • v20.21.4.13
    • v20.21.4.7
    • v20.21.4.4
    • v20.21.4.3
    • Archive
      • v20.21.3.26
      • v20.21.3.19
      • v20.21.3.15
      • v20.21.3.13
      • v20.21.3.9
      • v20.21.2.102
      • v20.21.2.100
      • v20.21.2.98
      • v20.21.2.93
      • v20.21.1.89
      • v20.21.1.84
      • v20.21.1.76
      • v20.21.1.60
      • v19.20.3.323
      • v19.20.3.315
      • v19.20.3.292
      • v19.20.3.279
      • v19.20.3.277
      • v19.20.3.251
      • v19.20.3.240
      • v19.20.3.226
      • v19.20.3.213
      • v19.20.3.207
      • v19.20.3.204
      • v19.20.3.197
      • v19.20.3.193
      • v19.20.3.179
      • v19.20.3.175
      • v19.20.2.162
      • v19.20.2.153
      • v19.20.2.145
      • v19.20.2.139
      • v19.20.2.135
      • v19.20.2.125
      • v19.20.2.112
      • v19.20.2.106
      • v19.20.2.99
      • v19.20.2.90
      • v19.20.2.82
      • v19.20.2.73
      • v19.20.2.67
      • v19.20.2.59
      • v19.20.1.40
      • v18.19.1.624
      • v18.19.1.593
      • v18.19.1.576
      • v18.19.1.557
      • v18.19.1.561
      • v18.19.1.555
      • v18.19.1.542
      • v18.19.1.513
      • v18.19.1.481-rc
      • v18.19.1.480
      • v18.19.1.460
      • v18.19.1.448
      • v18.19.1.411

Report Query Language

The PayRun.io API features a Report Query Language (RQL) that allows for custom reports to be written, saved and executed without any bespoke programming.

  • Query Root
  • Entity Group
  • Name Value Pair
  • Conditions
  • Filters
  • Ordering
  • Outputs
  • Aggregate Outputs

Copyright © 2020 All right reserved

  • Contact us