Reporting Result Sets and Views

This section contains information on all result sets and views exposed as DTOs when generating reports from CCLAS.

This information is of use when authoring report templates, resource field definition (RFD) files, direct source connection (DSC) files, or scripts for reports.

Note: Where any field is removed from a grid via personalisation (for example, removing some of the less required fields from the UI for performance reasons) or was not included in the grid in the core application, then the field is not populated in ExportToReport. This could mean, that a report template run on the same result set from one screen could behave differently to the same report template run on the same result set on another screen. Refer to RSSample for further notes on this.

The following table lists the views and result sets populated for a job report.

Result sets Comment Working in templates?
vJob Composites of multiple result sets. Y
vSample Composites of multiple result sets. Y
vSampleSchemeAnalyte Composites of multiple result sets. Y
vBiofieldValue (as vJobBiofield, as vSampleBiofield in templates) Composites of multiple result sets. Y
vUser (as vSignatory in templates) Composites of multiple result sets, from the Signatory Group on the report request; vSignatory not vUser in templates. Y
RSAccreditationBody Only for the schemes that are linked to accreditation bodies via method accreditations. Not linked to the laboratory's accreditation bodies at all. Y
RSAddress

A result set built directly from the CCAddress object, populated with the following addresses:

  • The default address for the job's client

  • The default address for the job's contact

  • The default address for the report request's client

  • The default address for the report request's contact.

It does not use the contact's Use Client Address flag when populating this result set. This flag is used when addresses are populated into the vJob view's A_* and AR_* columns.

 Y
RSBiofield Also covered in vBiofieldValue as B_*.  
RSBiofieldValue Also covered in vBiofieldValue as BV_*.  
RSCategory Covered in each of the views that have links to categories, but just as Category Code in most cases.  
RSClient Both the job's client and the report request's client; covered in vJob as C_* and CR_*.  
RSClientContact Both the job's client contact and the report request's client contact; covered in vJob as CT_* and CTR_*.  
RSClientProject Job's client project; covered in vJob as CP_*.  
RSJob Also covered in vJob as J_*.  
RSJobScheme

Job schemes (but reports all schemes in the report request, not just those reportable in the report request).

 Y
RSLaboratory Current laboratory.  
RSLaboratoryContact

Current laboratory's contacts (and reports ALL contacts for the laboratory). Note that there is NO default or main contact for a laboratory. The Laboratory Manager is not a contact but links to a user (however, this is NOT included in the RSUser result set

 Y
RSLaboratoryAccreditationBody

Current laboratory's accreditation bodies.

 Y
RSLaboratoryAddress Current laboratory's addresses. Y
RSMethod Also covered in vSampleSchemeAnalyte as M_*. Y
RSMethodAccreditationBody

Method's accrediations; populates with all CCMETHODACCREDBODY records.

  
RSOrganisation    
RSProduct Also covered in vSAMPLE and vSampleSchemeAnalyte as P_*. Y
RSQCType Also covered in vSAMPLE and vSampleSchemeAnalyte as Q_*.  
RSReport   N
RSReportRequest Report request. Y
RSReportRequestJob Report request job.  
RSReportRequestReport Report request report. N
RSReportRequestReportRecipient Not populated at all (and is not necessary). N
RSReportRequestSample Also covered in vSampleSchemeAnalyte as RS_*.  
RSReportRequestSampleScheme Also covered in vSampleSchemeAnalyte as RSS_*.  
RSReportRequestSampleSchemeAnalyte Also covered in vSampleSchemeAnalyte as RSA_*.  
RSReportRequestScheme Also covered in vSampleSchemeAnalyte as RSC_*.  
RSReportRequestSchemeAnalyte Also covered in vSampleSchemeAnalyte as RSA_*.  
RSSample Also covered in vSAMPLE and vSampleSchemeAnalyte as S_*.  
RSSampleScheme Not covered in any views (but is required if any SS properties are wanted). N
RSSampleSchemeAnalyte Also covered in vSampleSchemeAnalyte as SSA_* and RSSA_*.  
RSSampleSchemeAnalyteReading Not populated at all (and is not necessary). N
RSScheme

Also some properties are covered in vSampleSchemeAnalyte as SC_*. There are a few fields not in the vSampleSchemeAnalyte view, so might need to use RSScheme if required.

  
RSSchemeVersion

Reporting all scheme versions in the report request, not just report-active ones. Also covered in vSampleSchemeAnalyte as SC_*.

  
RSSchemeVersionAnalyte

Not reporting some properties from SVA. Also covered in vSampleSchemeAnalyte as SA_* (and also missing the same properties as from RSSchemeVersionAnaltye).

  
RSScript   N
RSSection Only for the sections linked to the schemes on the report request.  
RSSpecification

Also covered in part on vSample & vSampleSchemeAnalyte as P_* (just for Sample->SampleSpecs).

In the report request, covers:

  • Standard specifications

  • Product specifications—This does not follow any ccSampleSpec.IsReportable flags, that is, all sample specifications are reported, even if the report request sample is not reportable.

  • Scheme specifications—Reports all scheme specifications, regardless of whether the scheme is reportable or not on the report request.

 Y
RSSpecificationSchemeVersionAnalyte

Populates records, but not with any content; also covered in part on vSampleSchemeAnalyte as PA_* values.

 N
RSStandard

Reports the standards on QC samples, for the primary and secondary analytical types. Covered in part of vSample & vSampleSchemeAnalyte as S_* (just the Codes of the standard).

 Y
RSStandardLot

Reports the standard lots on QC samples, for the primary and secondary analytical types. Covered in part of vSample & vSampleSchemeAnalyte as S_* (just the Codes of the standard).

 Y
RSSyntax Not populated at all (and is not necessary). N
RSText Not populated at all (and is not necessary). N
RSUnit Also covered in vSampleSchemeAnalyte as U_*.  
RSUser

Reports the following users:

  • Current reporting user

  • Account manager of the job's client

  • Account manager of the job's project

  • Report's client.

The number of account manager's users in this list could be 0 to 3.

Also covered in stakeholder signatories in vUser as SIG_*, but this is for signatories only, and not for the listed users.

  
RSUserGroup    
RSUserGroupMember    

The following diagram shows the relationships between some of these views and result sets.