Grid Report Data Sources

During the process to create grid reports from a grid, the first part of the process is to extract the data.

The grid content returned from the search is supplied automatically from CCLAS and is termed the 'core result sets'.

The reportable data comprises:

• Result sets based on data transfer objects (DTOs)
• Views constructed from the result sets
• Additional data sources created by a DSC zipped with the report template.

The following section contains details on the various grid-based DTOs.

Population of Result Sets from the DTOs

Note: When referring to a property in a reporting result set, property names are case-sensitive. Refer to the Reporting Result Sets and Views for more details.

Application and Grid	Data Source Alias	Result Set	Corresponding DTO	GRIDCODE from the Result Set
CCACCB search	RSAccreditationBodySearch	RSAccreditationBody	CCAccreditationBodyDTO	Code
CCBFGP search	RSBiofieldGroupSearch	RSBiofieldGroup	CCBiofieldGroupDTO	Code
CCBFLD search	RSBiofieldSearch	RSBiofield	CCBiofieldDTO	Code
CCCNGP search	RSCannedCommentGroupSearch	RSCannedCommentGroup	CCCannedCommentGroupDTO	Code
CCCNCM search	RSCannedCommentSearch	RSCannedComment	CCCannedCommentDTO	Code
CCCTGY search	RSCategoryTypeSearch	RSCategoryType	CCCategoryTypeDTO	CategoryType
CCCLGP search	RSClientGroupSearch	RSClientGroup	CCClientGroupDTO	Code
CCCLNT client quotes	RSClientQuoteSearch	RSClientQuote	CCClientQuoteDTO	QuoteCode
CCCLNT search	RSClientSearch	RSClient	CCClientDTO	Code
CCCNTP search	RSContainerTypeSearch	RSContainerType	CCContainerTypeDTO	Code
CCCOST search	RSCostCentreSearch	RSCostCentre	CCCostCentreDTO	Code
MSECUR search	RSCurrencySearch	RSCurrency	CurrencyDTO	(RSCurrency not populated correctly)
CCDEVI search	RSDeviceSearch	RSDevice	CCDeviceDTO	Code
CCERSH search	RSElectronicRequestSheetSearch	RSElectronicRequestSheet	CCElectronicRequestSheetDTO	Code
CCHZRD search	RSHazardSearch	RSHazard	CCHazardDTO	Code
CCHLDY search	RSHolidaySearch	RSHoliday	CCHolidayDTO	Code
CCINUP search	RSInstrumentFileUploadSearch	RSInstrumentFileUpload	CCInstrumentFileUploadDTO	Code
CCINGP search	RSInstrumentGroupSearch	RSInstrumentGroup	CCInstrumentGroupDTO	Code
CCINSH search	RSInstrumentScheduleSearch	RSInstrumentSchedule	CCInstrumentScheduleDTO	Code
CCINST search	RSInstrumentSearch	RSInstrument	CCInstrumentDTO	Code
CCINV generate invoice batch	RSInvoiceGeneratedDocumentSearch
CCINV search	RSInvoiceSearch	RSInvoice	CCInvoiceDTO	InvoiceNo
CCFNRP search	RSInvoiceSearch	RSInvoice	CCInvoiceDTO	InvoiceNo
CCJAUD group view	RSJobAuditSearch	RSJobAudit	CCJobAuditDTO	JobCode
CCBTSM samples	RSJobBatchMaintenanceSampleSearch	RSJobBatchMaintenanceSample	CCJobBatchMaintenanceSampleDTO	LinkedJobCode
CCBTCH scheme analytes	RSJobBatchSchemeAnalyteSearch	RSJobBatchSchemeAnalyte	CCJobBatchSchemeAnalyteDTO	SchemeCode
CCBTCH samples	RSJobBatchSearch	RSJobBatchSession	CCJobBatchSessionDTO	JobCode
CCJAUD search	RSJobSearch	RSJob	CCJobDTO	Code
CCREGN search	RSJobSearch	RSJob	CCJobDTO	Code
CCSTRP search	RSJobSearch	RSJob	CCJobDTO	Code
CCLBGP search	RSLaboratoryGroupSearch	RSLaboratoryGroup	CCLaboratoryGroupDTO	Code
CCLBRT search	RSLaboratorySearch	RSLaboratory	CCLaboratoryDTO	Code
CCLOFB search	RSLineOfBusinessSearch	RSLineOfBusiness	CCLineOfBusinessDTO	Code
CCLCTN search	RSLocationSearch	RSLocation	CCLocationDTO	Code
CCLOCK search	RSLockSearch	RSLock	CCLockDTO	JobCode
CCMTHD search	RSMethodSearch	RSMethod	CCMethodDTO	Code
CCWKOP search	RSOpenWorkbookSearch	RSOpenWorkbook	CCOpenWorkbookDTO	SchemeCode
CCORGN search	RSOrganisationSearch	RSOrganisation	CCOrganisationDTO	Code
CCPREF search	RSPreferenceSearch	RSPreference	CCPreferenceDTO	PreferenceName
CCPRCADJ search	RSPriceAdjustmentSearch	RSPriceAdjustment	CCPriceAdjustmentDTO	Code
CCPRCCATGP search	RSPriceCatalogueGroupSearch	RSPriceCatalogueGroup	CCPriceCatalogueGroupDTO	PriceCatGroupCode
CCPRCCAT search	RSPriceCatalogueSearch	RSPriceCatalogue	CCPriceCatalogueDTO	PriceCatCode
CCPRCCODE search	RSPriceCodeSearch	RSPriceCode	CCPriceCodeDTO	Code
CCPRCBK schedule	RSPriceScheduleSearch	RSPriceSchedule	CCPriceScheduleDTO	PriceCode
CCPRDT search	RSProductSearch	RSProduct	CCProductDTO	Code
CCPRTN search	RSSamplePortionSearch	RSSamplePortion	CCSamplePortionDTO	Sample_Code || '_' || Portion_Code
CCQCHS QC History summary	RSQCHistorySummaryMemberSearch
CCQCHS search	RSQCHistorySummarySearch	RSQCHistorySummary	CCQCHistorySummaryDTO	SchemeCode
CCQCHS Detail Stats	RSQCHistoryStats (?)	RSQCHistorySummaryStats	RSQCHistoryStatsDTO
CCQCMK search	RSQCMaskSearch	RSQCMask	CCQCMaskDTO	Code
CCQCSM samples	RSQCSampleModificationSearch	RSQCSampleModification	CCQCSampleModificationDTO	SampleCode
CCQCTP search	RSQCTypeSearch	RSQCType	CCQCTypeDTO	Code
CCRNGT search	RSRangeTableSearch	RSRangeTable	CCRangeTableDTO	Code
CCREPT search	RSReportSearch	RSReport	CCReportDTO	Code
CCRPTR search	RSReportRequestSearch	RSReportRequest	CCJobReportRequestDTO	Code
CCTPLR search	RSReportTemplateSearch	RSReportTemplate	CCReportTemplateDTO	Code
CCRNDT search	RSRoundingTableSearch	RSRoundingTable	CCRoundingTableDTO	Code
CCSHND search	RSSampleHandlingSearch	RSSampleHandling	CCSampleHandlingDTO	Code
CCSMPT search	RSSamplePointSearch	RSSamplePoint	CCSamplePointDTO	Code
CCSAMP search	RSSampleSearch	RSSample	CCSampleDTO	SampleCode
CCREGNSAMP samples	RSSampleSearch	RSSample	CCSampleDTO	SampleCode
CCSMTP search	RSSampleTypeSearch	RSSampleType	CCSampleTypeDTO	Code
CCVALN samples	RSSampleValidationSearch	RSSampleValidation	CCSampleValidationDTO	SampleCode
CCSCGP search	RSSchemeGroupSearch	RSSchemeGroup	CCSchemeGroupDTO	Code
CCSCHM search	RSSchemeSearch	RSScheme	CCSchemeDTO	Code
CCSCRT search	RSScriptSearch	RSScript	CCScriptDTO	Code
CCSEGP search	RSSectionGroupSearch	RSSectionGroup	CCSectionGroupDTO	Code
CCSECT search	RSSectionSearch	RSSection	CCSectionDTO	Code
CCSPGP search	RSSpecificationGroupSearch	RSSpecificationGroup	CCSpecificationGroupDTO	Code
CCSPFN search	RSSpecificationSearch	RSSpecification	CCSpecificationDTO	Code
CCSPFNSCHANASRCH add	RSAddSpecificationSchemeVersionAnalyteSearch		CCAddSpecificationSchemeVersionAnalyteDTO	SpecificationCode
CCSPFNSCHANASRCH search	RSSpecificationSchemeVersionAnalyteSearch	RSSpecificationSchemeVersionAnalyte
CCSTGP search	RSStandardGroupSearch	RSStandardGroup	CCStandardGroupDTO	Code
CCSTND search	RSStandardSearch	RSStandard	CCStandardDTO	Code
CCSNTX search	RSSyntaxSearch	RSSyntax	CCSyntaxDTO	Code
CCTAX search	RSTaxCodeSearch	RSTaxCode	CCTaxCodeDTO	TaxCode
CCUNIT search	RSUnitSearch	RSUnit	CCUnitDTO	Code
CCUSGP search	RSUserGroupSearch	RSUserGroup	CCUserGroupDTO	Code
CCUSER search	RSUserSearch	RSUser	CCUserDTO	Code
CCWKBK search	RSWorkbookSearch	RSJob	CCJobDTO	Code

Financial reports have additional views available to them. The data sources are dependent upon the invoice type of invoice/credit note or job cost, and whether the returned records are to display the invoice currency or laboratory currency.

Type of currency	View
	Job cost estimate	Job cost work-in-progress	Invoice or credit note
Invoice currency			CCFNRPALLVIEW
Laboratory currency	CCPECOSTESTVIEW	CCPECOSTWIPVIEW	CCFNRPALLLABVIEW