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 |
