Types of Queries and Their Parameters

Audition Pupil Analysis will display a list of all pupils from an Audition within parameters.

  • AuditionPupilAnalysis 
  • FromDate smalldatetime,
  • ToDate smalldatetime, 
  • Audition UniqueIdentifier 


Audition Pupil List Detail will display a list of details of all pupils within an Audition from within the parameters.

  • AuditionPupilListDetail 
  • FromDate smalldatetime, 
  • ToDate smalldatetime, 
  • Audition UniqueIdentifier 
  • IncludeAll as bit 


Audition Pupil List Summary will display a summary view of pupils within an Audition from within the parameters.

  • AuditionPupilListSummary
  • FromDate smalldatetime, 
  • ToDate smalldatetime, 
  • Audition UniqueIdentifier
  • IncludeAll as bit 


Card Failed Scheduled will display all card schedules that have failed. There are no parameters for this query.

  • CardFailedScheduled 
  • No parameters 


Card Register will display all cards that are registered with your organisations within the parameters.

  • CardRegister 
  • FromDate smalldatetime, 
  • ToDate smalldatetime 


Card Schedule Due Payments will display the due dates for all card schedules from within the parameters.

  • CardScheduleDuePayments 
  • ScheduleDate smalldatetime 


Debtor Balances will display all remaining balances from within the parameters. 

  • DebtorBalances 
  • ToDate SmallDateTime 


DL Invoice Outstanding will display a list of all outstanding invoices within your systems from within the parameters.

  • DLInvoiceOutstanding 
  • ToDate SmallDateTime, 
  • IncludeScheduledPaymentDebt as bit 


DL Invoice Outstanding Detailed will display a list of all outstanding invoices with all related details within your systems from within the parameters. 

  • DLInvoiceOutstandingDetailed 
  • ToDate SmallDateTime, 
  • IncludeScheduledPaymentDebt bit 


DL Invoice Register will display a register of all invoices within your systems from within the parameters.

  • DLInvoiceRegister 
  • FromDate smalldatetime, 
  • ToDate smalldatetime 


DL Receipt Register will display a register of all receipts in your system from within the parameters.

  • DLReceiptRegister  
  • FromDate smalldatetime, 
  • ToDate smalldatetime 


DL Refund Register will display a register with all refund receipts in your system from within the parameters.

  • DLRefundRegister 
  • FromDate smalldatetime, 
  • ToDate smalldatetime 


Event Pupil Analysis will display an analysis of all pupils for the selected Event from within the parameters.

  • EventPupilAnalysis 
  • FromDate smalldatetime, 
  • ToDate smalldatetime 
  • EventID UniqueIdentifier 


Event Pupil List Detail will display an analysis of all pupils with their details for the selected Event from within the parameters.

  • EventPupilListDetail 
  • FromDate smalldatetime, 
  • ToDate smalldatetime, 
  • EventID UniqueIdentifier, 
  • IncludeEvaluating as bit 
  • IncludeAll as bit 

Event Pupil List Finance will display a list of finances for each pupil for the selected Event from within the parameters.

  • EventPupilListFinance 
  • FromDate smalldatetime, 
  • ToDate smalldatetime, 
  • EventID UniqueIdentifier 


Event Pupil List Finance Summary will display a list summary of finances for each pupil for the selected Event from within the parameters.

  • EventPupilListFinanceSummary 
  • FromDate smalldatetime, 
  • ToDate smalldatetime, 
  • EventID UniqueIdentifier 


Event Pupil List Summary will display a list summary of each pupil for the selected Event from within the parameters.

  • EventPupilListSummary 
  • FromDate smalldatetime, 
  • ToDate smalldatetime, 
  • EventID UniqueIdentifier, 
  • IncludeEvaluating bit, 
  • IncludeAll as bit  

 

Exam Session Pupil Analysis will display all pupil information for the selected Exam from within the parameters.

  • ExamSessionPupilAnalysis 
  • FromDate smalldatetime, 
  • ToDate smalldatetime, 
  • ExamSession UniqueIdentifier 


Exam Session Pupil List Detail will display a list of all pupil details for the selected Exam from within the parameters.

  • ExamSessionPupilListDetail 
  • FromDate smalldatetime, 
  • ToDate smalldatetime, 
  • ExamSession UniqueIdentifier 
  • IncludeAll as bit 


Exam Session Pupil List Summary will display a summary of all the pupils for the selected Exam from within the parameters.

  • ExamSessionPupilListSummary 
  • FromDate smalldatetime, 
  • ToDate smalldatetime, 
  • ExamSession UniqueIdentifier 
  • IncludeAll as bit 

List Card Transactions will display a list of all card transactions in your systems from within the parameters.

  • ListCardTransactions 
  • FromDate smalldatetime, 

ToDate smalldatetime