RSSample

RSSample is a result set built directly from the CCReportRequestSample DTO.

Refer to the population of the CCReportRequestSample DTO.

RSSample is referenced in the vSample and vSampleSchemeAnalyte views using the S_* alias for a sample.

Note:

The RSSampleSearch result set displayed in the search results grid of the CCSAMP—Sample Search screen is populated by the CCSample.Search service.

The RSSampleSearch result set displayed in the samples grid on the Samples tab of the CCREGN—Update Job screen is populated by the CCSample.searchWithResultsContainingBioFieldsAsCustomAttributes service.

Some fields in the RSSampleSearch result set are populated in the former but not in the latter result set, for example, JobName. However, if JobName is added to the samples grid on the Samples tab of the CCREGN—Update Job screen via personalisation, then, even if it is subsequently made a hidden column on that grid, it is populated. That is, ExportToReport only exposes what is populated.

RSSample properties are as follows:

RS Column	DTO Property	Property Type
ActivatedNow	activatedNow	Boolean
ActivatedUserCode	activatedUserCode	String
ActivatedUserId	activatedUserId	String
AgreedDate	agreedDate	Time Stamp
AnalysedDate	analysedDate	Time Stamp
AnalysisText	analysisText	String
AnalysisTextId	analysisTextId	String
ApplicationId	applicationId	String
ApprovedDate	approvedDate	Time Stamp
ApprovedUser	approvedUser	String
ArchivedUserCode	archivedUserCode	String
ArchivedUserId	archivedUserId	String
AuthUserGroupCode	authUserGroupCode	String
AuthUserGroupId	authUserGroupId	String
AuthorisationUserCode	authorisationUserCode	String
AuthorisationUserId	authorisationUserId	String
AuthorisedDate	authorisedDate	Time Stamp
ClientCode	clientCode	String
ClientContactCode	clientContactCode	String
ClientContactId	clientContactId	String
ClientContactName	clientContactName	String
ClientGroupCode	clientGroupCode	String
ClientGroupId	clientGroupId	String
ClientGroupName	clientGroupName	String
ClientId	clientId	String
ClientName	clientName	String
ClientProjectCode	clientProjectCode	String
ClientProjectId	clientProjectId	String
ClientProjectName	clientProjectName	String
ClientSampleName	clientSampleName	String
ClientSampleNameSyntax	clientSampleNameSyntax	String
ClientSubmissionNumber	clientSubmissionNumber	String
CompletedByUserCode	completedByUserCode	String
CompletedByUserId	completedByUserId	String
CompletedDate	completedDate	Time Stamp
CompositeQcStatus	compositeQcStatus	String
CompositeSpecStatus	compositeSpecStatus	String
ContactName	contactName	String
Contract	contract	String
ContractSubmissionNumber	contractSubmissionNumber	String
CostCentreCode	costCentreCode	String
CostCentreId	costCentreId	String
DeliveredBy	deliveredBy	String
DependentRelatedSamples	dependentRelatedSamples	Big Decimal
Description	description	String
DescriptionSyntax	descriptionSyntax	String
DestinationJobCode	destinationJobCode	String
DestinationSampleCode	destinationSampleCode	String
Discount	discount	Big Decimal
DupOriginalClientSampleName	dupOriginalClientSampleName	String
DupOriginalSampleCode	dupOriginalSampleCode	String
DupOriginalSampleId	dupOriginalSampleId	String
DupOriginalSampleName	dupOriginalSampleName	String
FinalisationUserCode	finalisationUserCode	String
FinalisationUserId	finalisationUserId	String
FinalisedDate	finalisedDate	Time Stamp
FirstReportedDate	firstReportedDate	Time Stamp
FixedPrice	fixedPrice	Big Decimal
FixedPriceCurrencyId	fixedPriceCurrencyId	String
IncludeBiofields	includeBiofields	String
IncludeSpecifications	includeSpecifications	String
IncludeTests	includeTests	String
IsArchived	isArchived	Boolean
IsAutoReceive	isAutoReceive	Boolean
IsAutoValidate	isAutoValidate	Boolean
IsComposite	isComposite	Boolean
IsCopyTestsFromTemplate	isCopyTestsFromTemplate	Boolean
IsFixedPrice	isFixedPrice	Boolean
IsFromAddTestsFromSamples	isFromAddTestsFromSamples	Boolean
IsGenerateLabel	isGenerateLabel	Boolean
IsGeneratePaperwork	isGeneratePaperwork	Boolean
IsIncludeInCosts	isIncludeInCosts	Boolean
IsIncludedInJobQc	isIncludedInJobQc	Boolean
IsInvoiceable	isInvoiceable	Boolean
IsOrganisationScope	isOrganisationScope	Boolean
IsReportable	isReportable	Boolean
IsRequireAuthorisation	isRequireAuthorisation	Boolean
IsStartFromNewRack	isStartFromNewRack	Boolean
IsTemplate	isTemplate	Boolean
JobCode	jobCode	String
JobClientCode	jobClientCode	String
JobClientContactCode	jobClientContactCode	String
JobClientContactName	jobClientContactName	String
JobClientName	jobClientName	String
JobClientProjectCode	jobClientProjectCode	String
JobClientProjectName	jobClientProjectName	String
JobId	jobId	String
JobName	jobName	String
JobTemplateCode	jobTemplateCode	String
JobType	jobType	String
LaboratoryCode	laboratoryCode	String
LaboratoryId	laboratoryId	String
LastActivatedDate	lastActivatedDate	Time Stamp
LastArchivedDate	lastArchivedDate	Time Stamp
LastInvoiceNo	lastInvoiceNo	String
LastInvoicedDate	lastInvoicedDate	Time Stamp
LastInvoicedUserCode	lastInvoicedUserCode	String
LastReportId	lastReportId	String
LastReportedDate	lastReportedDate	Time Stamp
LoggingApplicationName	loggingApplicationName	String
NumberOfContainers	numberOfContainers	Big Decimal
NumberOfHours	numberOfHours	Big Decimal
NumberOfSchemes	numberOfSchemes	Big Decimal
NumberOfSchemesCompleted	numberOfSchemesCompleted	Big Decimal
NumberOfSchemesStarted	numberOfSchemesStarted	Big Decimal
OrderCode	orderCode	String
OrderId	orderId	String
OrganisationCode	organisationCode	String
OrganisationId	organisationId	String
OriginalJobCode	originalJobCode	String
OriginalSampleCode	originalSampleCode	String
OwnerChangedDate	ownerChangedDate	Time Stamp
OwnerUserCode	ownerUserCode	String
OwnerUserId	ownerUserId	String
ParentClientSampleName	parentClientSampleName	String
ParentSampleId	parentSampleId	String
ParentSampleName	parentSampleName	String
PortionLastSeqNumber	portionLastSeqNumber	Big Decimal
PossibleDate	possibleDate	Time Stamp
PriceBookCode	priceBookCode	String
PriceBookId	priceBookId	String
PrimaryAnalyticalType	primaryAnalyticalType	String
PrimaryProductSpecCode	primaryProductSpecCode	String
PrimaryProductSpecId	primaryProductSpecId	String
Priority	priority	String
ProductCode	productCode	String
ProductId	productId	String
ProductSpecResultText	productSpecResultText	String
ProductSpecResultTextId	productSpecResultTextId	String
QcMaskCode	qcMaskCode	String
QcMaskId	qcMaskId	String
QcTypeCode	qcTypeCode	String
QcTypeId	qcTypeId	String
QuoteCode	quoteCode	String
QuoteId	quoteId	String
ReceivedDate	receivedDate	Time Stamp
ReceptionUserCode	receptionUserCode	String
ReceptionUserId	receptionUserId	String
RegisteredDate	registeredDate	Time Stamp
RegistrationSequence	registrationSequence	Big Decimal
RegistrationText	registrationText	String
RegistrationTextId	registrationTextId	String
RegistrationUserCode	registrationUserCode	String
RegistrationUserId	registrationUserId	String
ReleasedByUserCode	releasedByUserCode	String
ReleasedByUserId	releasedByUserId	String
ReleasedDate	releasedDate	Time Stamp
RepReqId	repReqId	String
Report	report	Blob
ReportText	reportText	String
ReportTextId	reportTextId	String
RequiredDate	requiredDate	Time Stamp
SampleCode	sampleCode	String
SampleCodeSyntaxCode	sampleCodeSyntaxCode	String
SampleCodeSyntaxId	sampleCodeSyntaxId	String
SampleDescSyntaxCode	sampleDescSyntaxCode	String
SampleDescSyntaxId	sampleDescSyntaxId	String
SampleId	sampleId	String
SampleName	sampleName	String
SampleNameSyntaxCode	sampleNameSyntaxCode	String
SampleNameSyntaxId	sampleNameSyntaxId	String
SamplePointCode	samplePointCode	String
SamplePointId	samplePointId	String
SampleRecordType	sampleRecordType	String
SampleStatus	sampleStatus	String
SampleSyntax	sampleSyntax	String
SampleTemplateCode	sampleTemplateCode	String
SampleTemplateId	sampleTemplateId	String
SampleTypeCode	sampleTypeCode	String
SampleTypeId	sampleTypeId	String
SampledBy	sampledBy	String
SampledDate	sampledDate	Time Stamp
SamplesOnly	samplesOnly	Boolean
SaveAsOptionCopyAllSampleTests	saveAsOptionCopyAllSampleTests	Boolean
SaveAsOptionCopyEntireSampleStructure	saveAsOptionCopyEntireSampleStructure	Boolean
SaveAsOptionCopySampleHeader	saveAsOptionCopySampleHeader	Boolean
SaveAsOptionCopySampleSpecifications	saveAsOptionCopySampleSpecifications	Boolean
SaveAsOptionCopySingleSchemeCode	saveAsOptionCopySingleSchemeCode	String
SaveAsOptionCopySingleSchemeId	saveAsOptionCopySingleSchemeId	String
SecondaryAnalyticalType	secondaryAnalyticalType	String
SecondaryQcTypeCode	secondaryQcTypeCode	String
SecondaryQcTypeId	secondaryQcTypeId	String
Source	source	String
SourceJobCode	sourceJobCode	String
SourceSampleCode	sourceSampleCode	String
SpikeOriginalSampleCode	spikeOriginalSampleCode	String
SpikeOriginalSampleId	spikeOriginalSampleId	String
SplitOriginalSampleCode	splitOriginalSampleCode	String
SplitOriginalSampleId	splitOriginalSampleId	String
StandardCode	standardCode	String
StandardId	standardId	String
StandardLotCode	standardLotCode	String
StandardLotId	standardLotId	String
StartedDate	startedDate	Time Stamp
StatusChangeReason	statusChangeReason	String
TemplatePriceCode	templatePriceCode	String
TemplatePriceCodeLabCode	templatePriceCodeLabCode	String
ValidatedDate	validatedDate	Time Stamp
ValidationUserCode	validationUserCode	String
ValidationUserId	validationUserId	String
WorkflowStatus	workflowStatus	String