RSJobScheme

RSJobScheme is a result set built directly from the CCJobScheme DTOReport and Invoice Setup > Job Report Result Sets and Views, that is, contains all schemes in the report request, not just those that are reportable.

RSJobScheme is referenced using the JS_* alias for a job scheme.

RSJobScheme properties are as follows:

RS Column

DTO Property

Property Type

ActivatedUserCode

activatedUserCode

String

ActivatedUserId

activatedUserId

String

AnalysedDate

analysedDate

Time Stamp

AnalysisText

analysisText

String

AnalysisTextId

analysisTextId

String

CompletedByUserCode

completedByUserCode

String

CompletedByUserId

completedByUserId

String

CompletedDate

completedDate

Time Stamp

CompositeQcStatus

compositeQcStatus

String

CompositeSpecStatus

compositeSpecStatus

String

CurrentBatchId

currentBatchId

String

FirstReportedDate

firstReportedDate

Time Stamp

FixedBasePrice

fixedBasePrice

Big Decimal

FixedBlockPrice

fixedBlockPrice

Big Decimal

IsAutoValidate

isAutoValidate

Boolean

IsIncludedInJobQC

isIncludedInJobQC

Boolean

IsOrganisationScope

isOrganisationScope

Boolean

IsReportable

isReportable

Boolean

IsSchemeLabEnabled

isSchemeLabEnabled

Boolean

JobAssocSchemeId

jobAssocSchemeId

String

JobAssocSchemeVersionId

jobAssocSchemeVersionId

String

JobCode

jobCode

String

JobId

jobId

String

JobName

jobName

String

JobSchemeId

jobSchemeId

String

LaboratoryCode

laboratoryCode

String

LastActivatedDate

lastActivatedDate

Time Stamp

LastReportedDate

lastReportedDate

Time Stamp

NumberOfSamples

numberOfSamples

Big Decimal

NumberOfUnits

numberOfUnits

Big Decimal

NumberOfUnknownSamples

numberOfUnknownSamples

Big Deimal

OrganisationCode

organisationCode

String

PossibleDate

possibleDate

Time Stamp

PrepMiscSchemeWorkflowStatus

prepMiscSchemeWorkflowStatus

String

PriceCode

priceCode

String

PriceCodeLabCode

priceCodeLabCode

String

RegistrationSequence

registrationSequence

Big Decimal

ReleasedDate

releasedDate

Time Stamp

ReportDescription

reportDescription

String

ReportFooterText

reportFooterText

String

ReportFooterTextID

reportFooterTextID

String

ReportHeaderText

reportHeaderText

String

ReportHeaderTextId

reportHeaderTextId

String

ReportName

reportName

String

ReportSequence

reportSequence

Big Decimal

ReportText

reportText

String

ReportTextId

reportTextId

String

RequiredDate

requiredDate

Time Stamp

ResultHeaderText

resultHeaderText

String

ResultHeaderTextId

resultHeaderTextId

String

SchemeCode

schemeCode

String

SchemeId

schemeId

String

SchemeLaboratoryCode

schemeLaboratoryCode

String

SchemeName

schemeName

String

SchemePriceType

schemePriceType

String

SchemeVersion

schemeVersion

Big Decimal

SchemeVersionId

schemeVersionId

String

StartedDate

startedDate

Time Stamp

SubcontractLaboratoryCode

subcontractLaboratoryCode

String

SubcontractLaboratoryOrgCode

subcontractLaboratoryOrgCode

String

ValidatedDate

validatedDate

Time Stamp

ValidationUserCode

validationUserCode

String

ValidationUserId

validationUserId

String

WorkflowStatus

workflowStatus

String