Data Sources for Job Reports
During the process to create job reports from a report request, the first part of the process is to extract the reportable data.
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.
Population of DTOs
Population of the CCJobScheme, CCJobSchemeAnalyte, CCSampleScheme, CCSampleSchemeAnalyte DTOs, Scheme Links and Precursor Scheme Relationships:
- Population of the CCJobScheme DTO
- Population of the CCJobSchemeAnalyte DTO
- Population of the CCSampleScheme DTO
- Population of the CCSampleSchemeAnalyte DTO
Population of the CCReportRequestScheme, CCReportRequestSchemeAnalyte, CCReportRequestSampleScheme, CCReportRequestSampleSchemeAnalyte DTOs:
The population of the result sets is based upon the content of the report request, but limited to the content of the report template. That is, if an entity is not required by the report template, that data are not included in the result sets.
- Population of the CCReportRequestSample DTO
- Population of the CCReportRequestScheme DTO
- Population of the CCReportRequestSchemeAnalyte DTO
- Population of the CCReportRequestSampleScheme DTO
- Population of the CCReportRequestSampleSchemeAnalyte DTO
Refer to Using Organisational Schemes vs Laboratory Schemes for the effect of scheme scope when calculating uncertainty in certificate reports.
Population of Result Sets from the DTOs
- RSAccreditationBody
- RSAddress
- RSAddSpecificationSchemeVersionAnalyte
- RSBiofield
- RSBiofieldGroup
- RSBiofieldValue
- RSCannedComment
- RSCannedCommentGroup
- RSCategory
- RSCategoryType
- RSClient
- RSClientContact
- RSClientGroup
- RSClientProject
- RSClientQuote
- RSContainerType
- RSCostCentre
- RSCurrency
- RSDevice
- RSElectronicRequestSheet
- RSHazard
- RSHoliday
- RSInstrument
- RSInstrumentFileUpload
- RSInstrumentGroup
- RSInstrumentSchedule
- RSInvoice
- RSJob
- RSJobAudit
- RSJobBatch
- RSJobBatchMaintenanceSample
- RSJobBatchSchemeAnalyte
- RSJobBatchSession
- RSJobReportRequest
- RSJobScheme
- RSJobStakeholder
- RSLaboratory
- RSLaboratoryAccreditationBody
- RSLaboratoryAddress
- RSLaboratoryContact
- RSLaboratoryGroup
- RSLineOfBusiness
- RSLocation
- RSLock
- RSMethod
- RSMethodAccreditationBody
- RSOpenWorkbook
- RSOrganisation
- RSPreference
- RSPriceAdjustment
- RSPriceCatalogue
- RSPriceCatalogueGroup
- RSPriceCode
- RSPriceSchedule
- RSProduct
- RSProductHazard
- RSProductSpecification
- RSQCHistorySummary
- RSQCHistorySummaryStats
- RSQCMask
- RSQCSampleModification
- RSQCType
- RSRangeTable
- RSReport
- RSReportRequest
- RSReportRequestJob
- RSReportRequestReport
- RSReportRequestReportRecipient
- RSReportRequestSample
- RSReportRequestSampleScheme
- RSReportRequestSampleSchemeAnalyte
- RSReportRequestScheme
- RSReportRequestSchemeAnalyte
- RSReportTemplate
- RSRoundingTable
- RSSample
- RSSampleHandling
- RSSamplePoint
- RSSamplePortion
- RSSampleScheme
- RSSampleSchemeAnalyte
- RSSampleSchemeAnalyteReading
- RSSampleType
- RSSampleValidation
- RSScheme
- RSSchemeGroup
- RSSchemeVersion
- RSSchemeVersionAnalyte
- RSScript
- RSSection
- RSSectionGroup
- RSSpecification
- RSSpecificationGroup
- RSSpecificationSchemeVersionAnalyte
- RSStandard
- RSStandardGroup
- RSStandardLot
- RSSyntax
- RSTaxCode
- RSText
- RSUnit
- RSUser
- RSUserGroup
- RSUserGroupMember
Population of Views
- vBiofieldValue
- vJob
- vJobBiofield
- vSample
- vSampleBiofield
- vSampleSchemeAnalyte
- vSignatory (referenced as vUser in the JAR file)
