Appendix

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