vSampleSchemeAnalyte
vSampleSchemeAnalyte is a view comprised of sample scheme analyte and related data, from the CCMethod (M_*), CCProduct (P_*), CCProductAnalyte (PA_*), CCQCType (Q_*), CCReportRequestSample (RS_*), CCReportRequestSchemeAnalyte (RSA_*), CCReportRequestScheme (RSC_*), CCReportRequestSampleScheme (RSS_*), CCReportRequestSampleSchemeAnalyte (RSSA_*), CCSample (S_*), CCSchemeAnalyte (SA_*), CCScheme and CCSchemeVersion (SC_*), CCSampleSchemeAnalyte (SSA_*), CCSection (ST_*), CCUnit (U_*) objects.
In the following tables, Scope of default refers to the scope from where the default value is taken when a lab-scope job/sample is linked to an org-scope scheme and scheme version.
vSampleSchemeAnalyte properties are as follows:
|
vSampleSchemeAnalyte Reporting View—M attributes |
Scope of default |
Property type |
|---|---|---|
|
M_ActiveStatus |
Org Scheme Versions Method |
string |
|
M_AuthorisedByUserCode |
Org Scheme Versions Method |
string |
|
M_AuthorisedByUserId |
Org Scheme Versions Method |
string |
|
M_AuthorisedDate |
Org Scheme Versions Method |
dateTime |
|
M_ChangeNotificationDays |
Org Scheme Versions Method |
double |
|
M_ChangeNotificationMessage |
Org Scheme Versions Method |
string |
|
M_Code |
Org Scheme Versions Method |
string |
|
M_Description |
Org Scheme Versions Method |
string |
|
M_Document |
Org Scheme Versions Method |
base64Binary |
|
M_DocumentUrl |
Org Scheme Versions Method |
string |
|
M_FullName |
Org Scheme Versions Method |
string |
|
M_Id |
Org Scheme Versions Method |
string |
|
M_IsActive |
Org Scheme Versions Method |
boolean |
|
M_IsOrganisationScope |
Org Scheme Versions Method |
boolean |
|
M_LaboratoryId |
Org Scheme Versions Method |
string |
|
M_LastChangedDate |
Org Scheme Versions Method |
dateTime |
|
M_MethodCategoryCode |
Org Scheme Versions Method |
string |
|
M_MethodCategoryId |
Org Scheme Versions Method |
string |
|
M_MethodDocExt |
Org Scheme Versions Method |
string |
|
M_MethodText |
Org Scheme Versions Method |
string |
|
M_MethodTextId |
Org Scheme Versions Method |
string |
|
M_Name |
Org Scheme Versions Method |
string |
|
M_OrganisationId |
Org Scheme Versions Method |
string |
|
M_PublishedDate |
Org Scheme Versions Method |
dateTime |
|
M_Publisher |
Org Scheme Versions Method |
string |
|
M_ReportDescription |
Org Scheme Versions Method |
string |
|
M_ReportName |
Org Scheme Versions Method |
string |
|
M_ReviewDueDate |
Org Scheme Versions Method |
dateTime |
|
M_VersionName |
Org Scheme Versions Method |
string |
|
vSampleSchemeAnalyte Reporting View—P attributes |
Scope of default |
Property type |
|---|---|---|
|
P_ApprovedDate |
|
dateTime |
|
P_ApprovedUser |
|
string |
|
P_ChemicalName |
|
string |
|
P_Code |
|
string |
|
P_Description |
|
string |
|
P_DisposalSampleHandlingCode |
|
string |
|
P_DisposalSampleHandlingId |
|
string |
|
P_Document |
|
base64Binary |
|
P_Id |
|
string |
|
P_Image |
|
base64Binary |
|
P_IsAutoValidate |
|
boolean |
|
P_IsOrganisationScope |
|
boolean |
|
P_LaboratoryCode |
|
string |
|
P_LaboratoryId |
|
string |
|
P_LineOfBusinessCode |
|
string |
|
P_LineOfBusinessId |
|
string |
|
P_Manufacturer |
|
string |
|
P_Name |
|
string |
|
P_OrganisationCode |
|
string |
|
P_OrganisationId |
|
string |
|
P_PrimarySpecCode |
|
string |
|
P_PrimarySpecId |
|
string |
|
P_ProductCategoryCode |
|
string |
|
P_ProductCategoryId |
|
string |
|
P_ProductDocExt |
|
string |
|
P_ProductImageExt |
|
string |
|
P_ProductScriptCode |
|
string |
|
P_ProductScriptId |
|
string |
|
P_ProductText |
|
string |
|
P_ProductTextId |
|
string |
|
P_ReportDescription |
|
string |
|
P_ReportName |
|
string |
|
P_SampleTypeCode |
|
string |
|
P_SampleTypeId |
|
string |
|
P_Status |
|
string |
|
P_StatusChangeReason |
|
string |
|
P_StatusChangedByUserCode |
|
string |
|
P_StatusChangedByUserId |
|
string |
|
P_StatusChangedDate |
|
dateTime |
|
vSampleSchemeAnalyte Reporting View—PA attributes |
Scope of default |
Property type |
|---|---|---|
|
PA_AnalyteCode |
|
string |
|
PA_AnalyteDataType |
|
string |
|
PA_BooleanValue |
|
boolean |
|
PA_ConfidenceCategoryCode |
|
string |
|
PA_ConfidenceCategoryId |
|
string |
|
PA_CriticalForSampleGrade |
|
boolean |
|
PA_CriticalForSampleValidation |
|
boolean |
|
PA_Description |
|
string |
|
PA_FromReadMethod |
|
boolean |
|
PA_Id |
|
string |
|
PA_InternalMaxInclusive |
|
boolean |
|
PA_InternalMaxValue |
|
double |
|
PA_InternalMaxWarningInclusive |
|
boolean |
|
PA_InternalMaxWarningValue |
|
double |
|
PA_InternalMinInclusive |
|
boolean |
|
PA_InternalMinValue |
|
double |
|
PA_InternalMinWarningInclusive |
|
boolean |
|
PA_InternalMinWarningValue |
|
double |
|
PA_InternalPercentageFailureValue |
|
double |
|
PA_InternalPercentageWarningValue |
|
double |
|
PA_InternalSpecificationSummary |
|
string |
|
PA_InternalTargetValue |
|
double |
|
PA_IsOrganisationScope |
|
boolean |
|
PA_IsReportable |
|
boolean |
|
PA_IsTextSpecCaseSensitive |
|
boolean |
|
PA_LimitCheckMethod |
|
string |
|
PA_LimitRepeatabilityValue |
|
double |
|
PA_LookupSchemeId |
|
string |
|
PA_NumericSpecificationList |
|
string |
|
PA_RecalculateInternalLimitsOnUI |
|
boolean |
|
PA_RecalculateReportLimitsOnUI |
|
boolean |
|
PA_RecoveryMaxValue |
|
double |
|
PA_RecoveryMaxWarningValue |
|
double |
|
PA_RecoveryMinValue |
|
double |
|
PA_RecoveryMinWarningValue |
|
double |
|
PA_ReportMaxInclusive |
|
boolean |
|
PA_ReportMaxValue |
|
double |
|
PA_ReportMaxWarningInclusive |
|
boolean |
|
PA_ReportMaxWarningValue |
|
double |
|
PA_ReportMinInclusive |
|
boolean |
|
PA_ReportMinValue |
|
double |
|
PA_ReportMinWarningInclusive |
|
boolean |
|
PA_ReportMinWarningValue |
|
double |
|
PA_ReportPercentageFailureValue |
|
double |
|
PA_ReportPercentageWarningValue |
|
double |
|
PA_ReportSpecificationSummary |
|
string |
|
PA_ReportTargetValue |
|
double |
|
PA_ReportableLimits |
|
string |
|
PA_SchemeCode |
|
string |
|
PA_SchemeId |
|
string |
|
PA_SchemeLaboratoryCode |
|
string |
|
PA_SchemeOrganisationCode |
|
string |
|
PA_SchemeVersion |
|
double |
|
PA_SchemeVersionAnalyteId |
|
string |
|
PA_SchemeVersionId |
|
string |
|
PA_SpecLaboratoryId |
|
string |
|
PA_SpecOrganisationId |
|
string |
|
PA_SpecificationCode |
|
string |
|
PA_SpecificationId |
|
string |
|
PA_SpecificationList |
|
string |
|
PA_SpecificationType |
|
string |
|
PA_SpecificationUnitCode |
|
string |
|
PA_SpecificationUnitId |
|
string |
|
PA_SpikeAdjustmentDescription |
|
string |
|
PA_SpikeAdjustmentFactor |
|
double |
|
PA_StatDetectionLimitValue |
|
double |
|
PA_TextSpecificationList |
|
string |
|
vSampleSchemeAnalyte Reporting View—Q attributes |
Scope of default |
Property type |
|---|---|---|
|
Q_AnalyticalType |
|
string |
|
Q_Code |
|
string |
|
Q_Description |
|
string |
|
Q_Id |
|
string |
|
Q_IsActive |
|
boolean |
|
Q_IsCanLinkToUnk |
|
boolean |
|
Q_IsOrganisationScope |
|
boolean |
|
Q_LaboratoryId |
|
string |
|
Q_LinkedQcTypeCode |
|
string |
|
Q_LinkedQcTypeId |
|
string |
|
Q_Name |
|
string |
|
Q_OrganisationId |
|
string |
|
Q_QcTypeCategoryCode |
|
string |
|
Q_QcTypeCategoryId |
|
string |
|
Q_SecondaryAnalyticalType |
|
string |
|
Q_UserStatusScriptCode |
|
string |
|
Q_UserStatusScriptId |
|
string |
|
vSampleSchemeAnalyte Reporting View—RS attributes |
Scope of default |
Property type |
|---|---|---|
|
RS_AgreedDate |
|
dateTime |
|
RS_AnalyticalType |
|
string |
|
RS_ClientCode |
|
string |
|
RS_ClientContactCode |
|
string |
|
RS_ClientContactDisplayName |
|
string |
|
RS_ClientContactId |
|
string |
|
RS_ClientId |
|
string |
|
RS_ClientName |
|
string |
|
RS_ClientProjectCode |
|
string |
|
RS_ClientProjectId |
|
string |
|
RS_ClientSampleName |
|
string |
|
RS_ClientSubmissionNumber |
|
string |
|
RS_DefaultSequence |
|
double |
|
RS_Description |
|
string |
|
RS_FinalisedDate |
|
dateTime |
|
RS_Id |
|
string |
|
RS_IsReportable |
|
boolean |
|
RS_JobCode |
|
string |
|
RS_JobId |
|
string |
|
RS_JobName |
|
string |
|
RS_JobType |
|
string |
|
RS_LaboratoryCode |
|
string |
|
RS_LastReportedDate |
|
dateTime |
|
RS_Name |
|
string |
|
RS_OrganisationCode |
|
string |
|
RS_PossibleDate |
|
dateTime |
|
RS_PrimaryProductSpecCode |
|
string |
|
RS_PrimaryProductSpecId |
|
string |
|
RS_PrimaryProductSpecStatus |
|
string |
|
RS_Priority |
|
string |
|
RS_ProductCode |
|
string |
|
RS_ProductId |
|
string |
|
RS_QcTypeCode |
|
string |
|
RS_QcTypeId |
|
string |
|
RS_ReceivedDate |
|
dateTime |
|
RS_RegisteredDate |
|
dateTime |
|
RS_RegistrationSequence |
|
double |
|
RS_RepReqCode |
|
string |
|
RS_RepReqId |
|
string |
|
RS_RepReqJobId |
|
string |
|
RS_ReportingSpecificationCode |
|
string |
|
RS_ReportingSpecificationId |
|
string |
|
RS_RequiredDate |
|
dateTime |
|
RS_SampleCode |
|
string |
|
RS_SampleId |
|
string |
|
RS_SampledDate |
|
dateTime |
|
RS_StandardCode |
|
string |
|
RS_StandardId |
|
string |
|
RS_StandardLotCode |
|
string |
|
RS_StandardLotId |
|
string |
|
RS_ValidatedDate |
|
dateTime |
|
RS_WorkflowStatus |
|
string |
|
vSampleSchemeAnalyte Reporting View—RSA attributes |
Scope of default |
Property type |
|---|---|---|
|
RSA_AnalyteCode |
Org Scheme Version Analyte record |
string |
|
RSA_AnalyteDescription |
Org Scheme Version Analyte record |
string |
|
RSA_AnalyteName |
Org Scheme Version Analyte record |
string |
|
RSA_AnalyteReportLowerDetectionLimit |
Org Scheme Version Analyte record |
double |
|
RSA_AnalyteReportUnitCode |
Org Scheme Version Analyte record |
string |
|
RSA_AnalyteReportUnitId |
Org Scheme Version Analyte record |
string |
|
RSA_AnalyteReportUpperDetectionLimit |
Org Scheme Version Analyte record |
double |
|
RSA_AnalyteRoundingMethod |
Org Scheme Version Analyte record |
string |
|
RSA_AnalyteRoundingTableCode |
Org Scheme Version Analyte record |
string |
|
RSA_AnalyteRoundingTableId |
Org Scheme Version Analyte record |
string |
|
RSA_DefaultSequence |
Org Scheme Version Analyte record |
double |
|
RSA_IsReportable |
Org Scheme Version Analyte record |
boolean |
|
RSA_JobCode |
Org Scheme Version Analyte record |
string |
|
RSA_LaboratoryCode |
Org Scheme Version Analyte record |
string |
|
RSA_OrganisationCode |
Org Scheme Version Analyte record |
string |
|
RSA_RepReqCode |
Org Scheme Version Analyte record |
string |
|
RSA_RepReqId |
Org Scheme Version Analyte record |
string |
|
RSA_RepReqSchemeAnalyteId |
Org Scheme Version Analyte record |
string |
|
RSA_RepReqSchemeId |
Org Scheme Version Analyte record |
string |
|
RSA_ReportDescription |
Org Scheme Version Analyte record |
string |
|
RSA_ReportName |
Org Scheme Version Analyte record |
string |
|
RSA_ReportSequence |
Org Scheme Version Analyte record |
double |
|
RSA_SchemeCode |
Org Scheme Version Analyte record |
string |
|
RSA_SchemeLaboratoryCode |
Org Scheme Version Analyte record |
string |
|
RSA_SchemeVersion |
Org Scheme Version Analyte record |
double |
|
RSA_SchemeVersionAnalyteId |
Org Scheme Version Analyte record |
string |
|
vSampleSchemeAnalyte Reporting View—RSC attributes |
Scope of default |
Property type |
|---|---|---|
|
RSC_DefaultSequence |
Org Scheme/Version record |
double |
|
RSC_IsOrganisationScope |
Org Scheme/Version record |
boolean |
|
RSC_IsReportable |
Org Scheme/Version record |
boolean |
|
RSC_JobCode |
Org Scheme/Version record |
string |
|
RSC_JobId |
Org Scheme/Version record |
string |
|
RSC_LaboratoryCode |
Org Scheme/Version record |
string |
|
RSC_OrganisationCode |
Org Scheme/Version record |
string |
|
RSC_RepReqCode |
Org Scheme/Version record |
string |
|
RSC_RepReqId |
Org Scheme/Version record |
string |
|
RSC_RepReqSchemeId |
Org Scheme/Version record |
string |
|
RSC_ReportDescription |
Org Scheme/Version record |
string |
|
RSC_ReportName |
Org Scheme/Version record |
string |
|
RSC_ReportSequence |
Org Scheme/Version record |
double |
|
RSC_ResultsHeaderText |
Org Scheme/Version record |
string |
|
RSC_ResultsHeaderTextId |
Org Scheme/Version record |
string |
|
RSC_SchemeCode |
Org Scheme/Version record |
string |
|
RSC_SchemeDescription |
Org Scheme/Version record |
string |
|
RSC_SchemeId |
Org Scheme/Version record |
string |
|
RSC_SchemeLaboratoryCode |
Org Scheme/Version record |
string |
|
RSC_SchemeName |
Org Scheme/Version record |
string |
|
RSC_SchemeVersion |
Org Scheme/Version record |
double |
|
RSC_SchemeVersionDescription |
Org Scheme/Version record |
string |
|
RSC_SchemeVersionId |
Org Scheme/Version record |
string |
|
RSC_SchemeVersionName |
Org Scheme/Version record |
string |
|
vSampleSchemeAnalyte Reporting View—RSS attributes |
Scope of default |
Property type |
|---|---|---|
|
RSS_Id |
|
string |
|
RSS_InstrumentCode |
|
string |
|
RSS_IsReportable |
|
boolean |
|
RSS_JobCode |
|
string |
|
RSS_JobId |
|
string |
|
RSS_JobName |
|
string |
|
RSS_LaboratoryCode |
|
string |
|
RSS_OrganisationCode |
|
string |
|
RSS_RackNumber |
|
big decimal |
|
RSS_RackSequence |
|
big decimal |
|
RSS_RepReqCode |
|
string |
|
RSS_RepReqId |
|
string |
|
RSS_RepReqSampleId |
|
string |
|
RSS_RepReqSchemeId |
|
string |
|
RSS_ReportSequence |
|
double |
|
RSS_SampleCode |
|
string |
|
RSS_SampleDescription |
|
string |
|
RSS_SampleId |
|
string |
|
RSS_SampleName |
|
string |
|
RSS_SamplePrimaryAnalyticalType |
|
string |
|
RSS_SampleSchemeId |
|
string |
|
RSS_SchemeCode |
|
string |
|
RSS_SchemeDefaultSequence |
|
double |
|
RSS_SchemeDescription |
|
string |
|
RSS_SchemeId |
|
string |
|
RSS_SchemeLaboratoryCode |
|
string |
|
RSS_SchemeName |
|
string |
|
RSS_SchemeVersion |
|
double |
|
RSS_SchemeVersionDescription |
|
string |
|
RSS_SchemeVersionId |
|
string |
|
RSS_WorkflowStatus |
|
string |
|
vSampleSchemeAnalyte Reporting View—RSSA attributes |
Scope of default |
Property type |
|---|---|---|
|
RSSA_AnalyteCode |
|
string |
|
RSSA_AnalyteDescription |
|
string |
|
RSSA_AnalyteName |
|
string |
|
RSSA_FormattedFinalValue |
|
string |
|
RSSA_FormattedReportLowerDL |
|
string |
|
RSSA_FormattedReportUpperDL |
|
string |
|
RSSA_Id |
|
string |
|
RSSA_IsReportable |
|
boolean |
|
RSSA_JobCode |
|
string |
|
RSSA_LaboratoryCode |
|
string |
|
RSSA_OrganisationCode |
|
string |
|
RSSA_RepReqCode |
|
string |
|
RSSA_RepReqId |
|
string |
|
RSSA_RepReqJobCode |
|
string |
|
RSSA_RepReqSampleCode |
|
string |
|
RSSA_RepReqSampleSchemeId |
|
string |
|
RSSA_RepReqSchemeAnalyteId |
|
string |
|
RSSA_ReportLowerDL |
|
double |
|
RSSA_ReportSequence |
|
double |
|
RSSA_ReportUnitCode |
|
string |
|
RSSA_ReportUnitId |
|
string |
|
RSSA_ReportUpperDL |
|
double |
|
RSSA_RoundingMethodType |
|
string |
|
RSSA_RoundingTableCode |
|
string |
|
RSSA_RoundingTableId |
|
string |
|
RSSA_SampleCode |
|
string |
|
RSSA_SampleId |
|
string |
|
RSSA_SampleSchemeAnalyteId |
|
string |
|
RSSA_SchemeCode |
|
string |
|
RSSA_SchemeLaboratoryCode |
|
string |
|
RSSA_SchemeVersion |
|
double |
|
RSSA_SchemeVersionAnalyteId |
|
string |
|
RSSA_SchemeVersionId |
|
string |
|
RSSA_UncertaintyValue |
|
string |
|
vSampleSchemeAnalyte Reporting View—S attributes |
Scope of default |
Property type |
|---|---|---|
|
S_ActivatedNow |
|
boolean |
|
S_ActivatedUserCode |
|
string |
|
S_ActivatedUserId |
|
string |
|
S_AgreedDate |
|
dateTime |
|
S_AnalysedDate |
|
dateTime |
|
S_AnalysisText |
|
string |
|
S_AnalysisTextId |
|
string |
|
S_ApplicationId |
|
string |
|
S_ApprovedDate |
|
dateTime |
|
S_ApprovedUser |
|
string |
|
S_ArchivedUserCode |
|
string |
|
S_ArchivedUserId |
|
string |
|
S_AuthUserGroupCode |
|
string |
|
S_AuthUserGroupId |
|
string |
|
S_AuthorisationUserCode |
|
string |
|
S_AuthorisationUserId |
|
string |
|
S_AuthorisedDate |
|
dateTime |
|
S_ClientCode |
|
string |
|
S_ClientContactCode |
|
string |
|
S_ClientContactId |
|
string |
|
S_ClientContactName |
|
string |
|
S_ClientGroupCode |
|
string |
|
S_ClientGroupId |
|
string |
|
S_ClientGroupName |
|
string |
|
S_ClientId |
|
string |
|
S_ClientName |
|
string |
|
S_ClientProjectCode |
|
string |
|
S_ClientProjectId |
|
string |
|
S_ClientProjectName |
|
string |
|
S_ClientSampleName |
|
string |
|
S_ClientSampleNameSyntax |
|
string |
|
S_ClientSubmissionNumber |
|
string |
|
S_CompletedByUserCode |
|
string |
|
S_CompletedByUserId |
|
string |
|
S_CompletedDate |
|
dateTime |
|
S_CompositeQcStatus |
|
string |
|
S_CompositeSpecStatus |
|
string |
|
S_ContactName |
|
string |
|
S_Contract |
|
string |
|
S_ContractSubmissionNumber |
|
string |
|
S_CostCentreCode |
|
string |
|
S_CostCentreId |
|
string |
|
S_DeliveredBy |
|
string |
|
S_DependentRelatedSamples |
|
double |
|
S_Description |
|
string |
|
S_DescriptionSyntax |
|
string |
|
S_DestinationJobCode |
|
string |
|
S_DestinationSampleCode |
|
string |
|
S_Discount |
|
double |
|
S_DupOriginalClientSampleName |
|
string |
|
S_DupOriginalSampleCode |
|
string |
|
S_DupOriginalSampleId |
|
string |
|
S_DupOriginalSampleName |
|
string |
|
S_DupQCTypeCode |
|
string |
|
S_DupQCTypeLabCode |
|
string |
|
S_FinalisationUserCode |
|
string |
|
S_FinalisationUserId |
|
string |
|
S_FinalisedDate |
|
dateTime |
|
S_FirstReportedDate |
|
dateTime |
|
S_FixedPrice |
|
double |
|
S_FixedPriceCurrencyId |
|
string |
|
S_IncludeBiofields |
|
string |
|
S_IncludeSpecifications |
|
string |
|
S_IncludeTests |
|
string |
|
S_IsArchived |
|
boolean |
|
S_IsActiveForAutoRegistration |
|
string |
|
S_IsActiveForManualRegistration |
|
string |
|
S_IsAutoReceive |
|
boolean |
|
S_IsAutoValidate |
|
boolean |
|
S_IsComposite |
|
boolean |
|
S_IsCopyTestsFromTemplate |
|
boolean |
|
S_IsFixedPrice |
|
boolean |
|
S_IsFromAddTestsFromSamples |
|
boolean |
|
S_IsGenerateLabel |
|
boolean |
|
S_IsGeneratePaperwork |
|
boolean |
|
S_IsIncludeInCosts |
|
boolean |
|
S_IsIncludedInJobQc |
|
boolean |
|
S_IsInvoiceable |
|
boolean |
|
S_IsOrganisationScope |
|
boolean |
|
S_IsReportable |
|
boolean |
|
S_IsRequireAuthorisation |
|
boolean |
|
S_IsStartFromNewRack |
|
boolean |
|
S_IsTemplate |
|
boolean |
|
S_JobCode |
|
string |
| S_JobClientCode | string | |
| S_JobClientContactCode | string | |
| S_JobClientContactName | string | |
| S_JobClientName | string | |
|
|
string | |
| S_JobClientProjectName | string | |
|
S_JobDescription |
|
string |
|
S_JobId |
|
string |
|
S_JobName |
|
string |
|
S_JobTemplateCode |
|
string |
|
S_JobType |
|
string |
|
S_LaboratoryCode |
|
string |
|
S_LaboratoryId |
|
string |
|
S_LastActivatedDate |
|
dateTime |
|
S_LastArchivedDate |
|
dateTime |
|
S_LastInvoiceNo |
|
string |
|
S_LastInvoicedDate |
|
dateTime |
|
S_LastInvoicedUserCode |
|
string |
|
S_LastReportId |
|
string |
|
S_LastReportedDate |
|
dateTime |
|
S_LoggingApplicationName |
|
string |
|
S_NoOfDuplicates |
|
bigDecimal |
|
S_NumberOfContainers |
|
double |
|
S_NumberOfHours |
|
double |
|
S_NumberOfSchemes |
|
double |
|
S_NumberOfSchemesCompleted |
|
double |
|
S_NumberOfSchemesStarted |
|
double |
|
S_OrderCode |
|
string |
|
S_OrderId |
|
string |
|
S_OrganisationCode |
|
string |
|
S_OrganisationId |
|
string |
|
S_OriginalJobCode |
|
string |
|
S_OriginalSampleCode |
|
string |
|
S_OwnerChangedDate |
|
dateTime |
|
S_OwnerUserCode |
|
string |
|
S_OwnerUserId |
|
string |
|
S_ParentClientSampleName |
|
string |
|
S_ParentSampleId |
|
string |
|
S_ParentSampleName |
|
string |
|
S_PortionLastSeqNumber |
|
double |
|
S_PossibleDate |
|
dateTime |
|
S_PriceBookCode |
|
string |
|
S_PriceBookId |
|
string |
|
S_PrimaryAnalyticalType |
|
string |
|
S_PrimaryProductSpecCode |
|
string |
|
S_PrimaryProductSpecId |
|
string |
|
S_Priority |
|
string |
|
S_PriorityInSecond |
|
bigDecimal |
|
S_ProductCode |
|
string |
|
S_ProductId |
|
string |
|
S_ProductSpecResultText |
|
string |
|
S_ProductSpecResultTextId |
|
string |
|
S_ProductionDescriptionSyntaxCode |
|
string |
|
S_ProductionDescriptionSyntaxLabCode |
|
string |
|
S_ProductionNameSyntaxCode |
|
string |
|
S_ProductionNameSyntaxLabCode |
|
string |
|
S_QcMaskCode |
|
string |
|
S_QcMaskId |
|
string |
|
S_QcSource |
|
string |
|
S_QcTypeCode |
|
string |
|
S_QcTypeId |
|
string |
|
S_QuoteCode |
|
string |
|
S_QuoteId |
|
string |
|
S_ReceivedDate |
|
dateTime |
|
S_ReceptionUserCode |
|
string |
|
S_ReceptionUserId |
|
string |
|
S_RegisteredDate |
|
dateTime |
|
S_RegistrationSequence |
|
double |
|
S_RegistrationText |
|
string |
|
S_RegistrationTextId |
|
string |
|
S_RegistrationUserCode |
|
string |
|
S_RegistrationUserId |
|
string |
|
S_ReleasedByUserCode |
|
string |
|
S_ReleasedByUserId |
|
string |
|
S_ReleasedDate |
|
dateTime |
|
S_RepReqId |
|
string |
|
S_Report |
|
base64Binary |
|
S_ReportText |
|
string |
|
S_ReportTextId |
|
string |
|
S_RequiredDate |
|
dateTime |
|
S_SampleCode |
|
string |
|
S_SampleCodeSyntaxCode |
|
string |
|
S_SampleCodeSyntaxId |
|
string |
|
S_SampleDescSyntaxCode |
|
string |
|
S_SampleDescSyntaxId |
|
string |
|
S_SampleId |
|
string |
|
S_SampleName |
|
string |
|
S_SampleNameSyntaxCode |
|
string |
|
S_SampleNameSyntaxId |
|
string |
|
S_SamplePointCode |
|
string |
|
S_SamplePointId |
|
string |
|
S_SampleRecordType |
|
string |
|
S_SampleStatus |
|
string |
|
S_SampleSyntax |
|
string |
|
S_SampleTemplateCode |
|
string |
|
S_SampleTemplateId |
|
string |
|
S_SampleTypeCode |
|
string |
|
S_SampleTypeId |
|
string |
|
S_SampledBy |
|
string |
|
S_SampledDate |
|
dateTime |
|
S_SamplesOnly |
|
boolean |
|
S_SamplingDateOffset |
|
string |
|
S_SamplingStartDate |
|
dateTime |
|
S_SamplingStartOffset |
|
string |
|
S_SaveAsOptionCopyAllSampleTests |
|
boolean |
|
S_SaveAsOptionCopyEntireSampleStructure |
|
boolean |
|
S_SaveAsOptionCopySampleHeader |
|
boolean |
|
S_SaveAsOptionCopySampleSpecifications |
|
boolean |
|
S_SaveAsOptionCopySingleSchemeCode |
|
string |
|
S_SaveAsOptionCopySingleSchemeId |
|
string |
|
S_Schedule |
|
string |
|
S_ScheduleJobCode |
|
string |
|
S_ScheduleJobIsOrganisationScope |
|
boolean |
|
S_SecondaryAnalyticalType |
|
string |
|
S_SecondaryQcTypeCode |
|
string |
|
S_SecondaryQcTypeId |
|
string |
|
S_Source |
|
string |
|
S_SourceJobCode |
|
string |
|
S_SourceSampleCode |
|
string |
|
S_SpikeOriginalSampleCode |
|
string |
|
S_SpikeOriginalSampleId |
|
string |
|
S_SplitOriginalSampleCode |
|
string |
|
S_SplitOriginalSampleId |
|
string |
|
S_StandardCode |
|
string |
|
S_StandardId |
|
string |
|
S_StandardLotCode |
|
string |
|
S_StandardLotId |
|
string |
|
S_StartedDate |
|
dateTime |
|
S_StatusChangeReason |
|
string |
|
S_TemplatePriceCode |
|
string |
|
S_TemplatePriceCodeLabCode |
|
string |
|
S_UseScheduleJobFrequency |
|
boolean |
|
S_ValidatedDate |
|
dateTime |
|
S_ValidationUserCode |
|
string |
|
S_ValidationUserId |
|
string |
|
S_WorkflowStatus |
|
string |
|
vSampleSchemeAnalyte Reporting View—SA attributes |
Scope of default |
Property type |
|---|---|---|
|
SA_Alignment |
Org Scheme SVA record |
string |
|
SA_AllowNullResult |
Org Scheme SVA record |
boolean |
|
SA_AllowReportNonValData |
Org Scheme SVA record |
boolean |
|
SA_AnalyteDataType |
Org Scheme SVA record |
string |
|
SA_AnalyteText |
Org Scheme SVA record |
string |
|
SA_AnalyteTextId |
Org Scheme SVA record |
string |
|
SA_AnalyteType |
Org Scheme SVA record |
string |
|
SA_ApplyCorrectionFactor |
Org Scheme SVA record |
boolean |
|
SA_AssocSchemeVerAnalyteCode |
Org Scheme SVA record |
string |
|
SA_AssocSchemeVerAnalyteId |
Org Scheme SVA record |
string |
|
SA_AutoAvgReadings |
Org Scheme SVA record |
boolean |
|
SA_AutoRelease |
Org Scheme SVA record |
boolean |
|
SA_AutoValidate |
Org Scheme SVA record |
boolean |
|
SA_Code |
Org Scheme SVA record |
string |
|
SA_DatagridHeaderName |
Org Scheme SVA record |
string |
|
SA_DefaultDataEntryWidth |
Org Scheme SVA record |
double |
|
SA_DefaultToFirstListValue |
Org Scheme SVA record |
boolean |
|
SA_Description |
Org Scheme SVA record |
string |
|
SA_DisplayMask |
Org Scheme SVA record |
string |
|
SA_ExportName |
Org Scheme SVA record |
string |
|
SA_FalseValue |
Org Scheme SVA record |
string |
|
SA_FormulaScriptCode |
Org Scheme SVA record |
string |
|
SA_HoldingTime |
Org Scheme SVA record |
string |
|
SA_Id |
Org Scheme SVA record |
string |
|
SA_ImportName |
Org Scheme SVA record |
string |
|
SA_IncludeOnWorksheet |
Org Scheme SVA record |
boolean |
|
SA_InternalLowerDetLimit |
Org Scheme SVA record |
double |
|
SA_InternalUpperDetLimit |
Org Scheme SVA record |
double |
|
SA_IsAccredited |
Org Scheme SVA record |
boolean |
|
SA_IsAllLabs |
Org Scheme SVA record |
boolean |
|
SA_IsIncludeInCosts |
Org Scheme SVA record |
boolean |
|
SA_IsInternalLowerDetLimitCritical |
Org Scheme SVA record |
boolean |
|
SA_IsInternalUpperDetLimitCritical |
Org Scheme SVA record |
boolean |
|
SA_IsInvoiceable |
Org Scheme SVA record |
boolean |
|
SA_IsMandatoryProfile |
Org Scheme SVA record |
boolean |
|
SA_IsOnlyFromList |
Org Scheme SVA record |
boolean |
|
SA_IsOrganisationScope |
Org Scheme SVA record |
boolean |
|
SA_IsQcActive |
Org Scheme SVA record |
boolean |
|
SA_IsReportable |
Org Scheme SVA record |
boolean |
|
SA_IsSavedToQcHistory |
Org Scheme SVA record |
boolean |
|
SA_IsSurrogateResultCritical |
Org Scheme SVA record |
string |
|
SA_IsWorkflowCheckActive |
Org Scheme SVA record |
boolean |
|
SA_LaboratoryCode |
Org Scheme SVA record |
string |
|
SA_LaboratoryId |
Org Scheme SVA record |
string |
|
SA_LimitRepeatabilityDuplicateValue |
Org Scheme SVA record |
double |
|
SA_LimitRepeatabilityValue |
Org Scheme SVA record |
double |
|
SA_MsdsName |
Org Scheme SVA record |
string |
|
SA_Name |
Org Scheme SVA record |
string |
|
SA_OrganisationCode |
Org Scheme SVA record |
string |
|
SA_ParentAnalyteCode |
Org Scheme SVA record |
string |
|
SA_ParentAnalyteId |
Org Scheme SVA record |
string |
|
SA_PrecisionScriptCode |
Org Scheme SVA record |
string |
|
SA_PrecisionScriptId |
Org Scheme SVA record |
string |
|
SA_PriceCode |
Org Scheme SVA record |
string |
|
SA_PriceCodeLabCode |
Org Scheme SVA record |
string |
|
SA_ProfileSequence |
Org Scheme SVA record |
double |
|
SA_RegistrationSequence |
Org Scheme SVA record |
double |
|
SA_RepeatRangeTableCode |
Org Scheme SVA record |
string |
|
SA_Repeatability |
Org Scheme SVA record |
double |
|
SA_ReportDescription |
Org Scheme SVA record |
string |
|
SA_ReportDisplayMask |
Org Scheme SVA record |
string |
|
SA_ReportLowerDetectionLimit |
Org Scheme SVA record |
double |
|
SA_ReportName |
Org Scheme SVA record |
string |
|
SA_ReportSequence |
Org Scheme SVA record |
double |
|
SA_ReportUnitCode |
Org Scheme SVA record |
string |
|
SA_ReportUnitId |
Org Scheme SVA record |
string |
|
SA_ReportUpperDetectionLimit |
Org Scheme SVA record |
double |
|
SA_ReprodRangeTableCode |
Org Scheme SVA record |
string |
|
SA_Reproducibility |
Org Scheme SVA record |
double |
|
SA_RoundingMethodType |
Org Scheme SVA record |
string |
|
SA_RoundingScriptCode |
Org Scheme SVA record |
string |
|
SA_RoundingScriptId |
Org Scheme SVA record |
string |
|
SA_RoundingTableCode |
Org Scheme SVA record |
string |
|
SA_RoundingTableId |
Org Scheme SVA record |
string |
|
SA_SchemeAutoRelease |
Org Scheme SVA record |
boolean |
|
SA_SchemeAutoValidate |
Org Scheme SVA record |
boolean |
|
SA_SchemeCategoryCode |
Org Scheme SVA record |
string |
|
SA_SchemeCategoryId |
Org Scheme SVA record |
string |
|
SA_SchemeClientCode |
Org Scheme SVA record |
string |
|
SA_SchemeClientGroupCode |
Org Scheme SVA record |
string |
|
SA_SchemeClientGroupId |
Org Scheme SVA record |
string |
|
SA_SchemeClientId |
Org Scheme SVA record |
string |
|
SA_SchemeCode |
Org Scheme SVA record |
string |
|
SA_SchemeContainerTypeCode |
Org Scheme SVA record |
string |
|
SA_SchemeContainerTypeId |
Org Scheme SVA record |
string |
|
SA_SchemeId |
Org Scheme SVA record |
string |
|
SA_SchemeInstrumentGroupCode |
Org Scheme SVA record |
string |
|
SA_SchemeInstrumentGroupId |
Org Scheme SVA record |
string |
|
SA_SchemeIsOrganisationScope |
Org Scheme SVA record |
boolean |
|
SA_SchemeIsReportable |
Org Scheme SVA record |
boolean |
|
SA_SchemeLaboratoryId |
Org Scheme SVA record |
string |
|
SA_SchemeLimitSpecificationCode |
Org Scheme SVA record |
string |
|
SA_SchemeLimitSpecificationId |
Org Scheme SVA record |
string |
|
SA_SchemeLineOfBusinessCode |
Org Scheme SVA record |
string |
|
SA_SchemeLineOfBusinessId |
Org Scheme SVA record |
string |
|
SA_SchemeOrganisationId |
Org Scheme SVA record |
string |
|
SA_SchemePretreatmentCategoryCode |
Org Scheme SVA record |
string |
|
SA_SchemePretreatmentCategoryId |
Org Scheme SVA record |
string |
|
SA_SchemePriceType |
Org Scheme SVA record |
string |
|
SA_SchemeSectionCode |
Org Scheme SVA record |
string |
|
SA_SchemeSectionId |
Org Scheme SVA record |
string |
|
SA_SchemeVersion |
Org Scheme SVA record |
double |
|
SA_SchemeVersionAnalyteTextId |
Org Scheme SVA record |
string |
|
SA_SchemeVersionDescription |
Org Scheme SVA record |
string |
|
SA_SchemeVersionId |
Org Scheme SVA record |
string |
|
SA_SchemeVersionName |
Org Scheme SVA record |
string |
|
SA_SchemeVersionStatus |
Org Scheme SVA record |
string |
|
SA_SpreadsheetFormula |
Org Scheme SVA record |
string |
|
SA_StatDetectionLimitDuplicateValue |
Org Scheme SVA record |
double |
|
SA_StatDetectionLimitValue |
Org Scheme SVA record |
double |
|
SA_SurrogateQcTypeCode |
Org Scheme SVA record |
string |
|
SA_SurrogateQcTypeId |
Org Scheme SVA record |
string |
|
SA_SurrogateRecLowerLimit |
Org Scheme SVA record |
double |
|
SA_SurrogateRecUpperLimit |
Org Scheme SVA record |
double |
|
SA_SurrogateTargetValue |
Org Scheme SVA record |
double |
|
SA_TrueValue |
Org Scheme SVA record |
string |
|
SA_UncertaintyFactor |
Org Scheme SVA record |
double |
|
SA_UncertaintyRangeTableCode |
Org Scheme SVA record |
string |
|
SA_UncertaintyRangeTableId |
Org Scheme SVA record |
string |
|
SA_UncertaintyScriptCode |
Org Scheme SVA record |
string |
|
SA_UncertaintyScriptId |
Org Scheme SVA record |
string |
|
SA_UncertaintyText |
Org Scheme SVA record |
string |
|
SA_UncertaintyType |
Org Scheme SVA record |
string |
|
SA_UnitCode |
Org Scheme SVA record |
string |
|
SA_UnitId |
Org Scheme SVA record |
string |
|
SA_UpperAnalyteCode |
Org Scheme SVA record |
string |
|
SA_UpperSchemeCode |
Org Scheme SVA record |
string |
|
SA_WarningTime |
Org Scheme SVA record |
string |
|
vSampleSchemeAnalyte Reporting View—SC attributes |
Scope of default |
Property type |
|---|---|---|
|
SC_ApprovedDate |
Org Scheme or Scheme Version record |
dateTime |
|
SC_ApprovedUser |
Org Scheme or Scheme Version record |
string |
|
SC_AssocSchVersionId |
Org Scheme or Scheme Version record |
string |
|
SC_AutoSubContracted |
Org Scheme or Scheme Version record |
boolean |
|
SC_DefaultRackSize |
Org Scheme or Scheme Version record |
double |
|
SC_DefaultSubContractLabCode |
Org Scheme or Scheme Version record |
string |
|
SC_DefaultSubContractLabOrgCode |
Org Scheme or Scheme Version record |
string |
|
SC_Description |
Org Scheme or Scheme Version record |
string |
|
SC_FirstUsedDate |
Org Scheme or Scheme Version record |
dateTime |
|
SC_HoldingTime |
Org Scheme or Scheme Version record |
string |
|
SC_Id |
Org Scheme or Scheme Version record |
string |
|
SC_InternalCost |
Org Scheme or Scheme Version record |
double |
|
SC_IsBatchAcrossJobs |
Org Scheme or Scheme Version record |
boolean |
|
SC_IsEnabledForLab |
Org Scheme or Scheme Version record |
boolean |
|
SC_IsLatest |
Org Scheme or Scheme Version record |
boolean |
|
SC_IsOrganisationScope |
Org Scheme or Scheme Version record |
boolean |
|
SC_LaboratoryCode |
Org Scheme or Scheme Version record |
string |
|
SC_LaboratoryId |
Org Scheme or Scheme Version record |
string |
|
SC_MethodCode |
Org Scheme or Scheme Version record |
string |
|
SC_MethodId |
Org Scheme or Scheme Version record |
string |
|
SC_Name |
Org Scheme or Scheme Version record |
string |
|
SC_OrganisationCode |
Org Scheme or Scheme Version record |
string |
|
SC_PriceCode |
Org Scheme or Scheme Version record |
string |
|
SC_PriceType |
Org Scheme or Scheme Version record |
string |
|
SC_Priority |
Org Scheme or Scheme Version record |
string |
|
SC_QcMaskCode |
Org Scheme or Scheme Version record |
string |
|
SC_QcMaskId |
Org Scheme or Scheme Version record |
string |
|
SC_ReportDescription |
Org Scheme or Scheme Version record |
string |
|
SC_ReportFooterText |
Org Scheme or Scheme Version record |
string |
|
SC_ReportFooterTextId |
Org Scheme or Scheme Version record |
string |
|
SC_ReportHeaderText |
Org Scheme or Scheme Version record |
string |
|
SC_ReportHeaderTextId |
Org Scheme or Scheme Version record |
string |
|
SC_ReportName |
Org Scheme or Scheme Version record |
string |
|
SC_ResultsHeaderText |
Org Scheme or Scheme Version record |
string |
|
SC_ResultsHeaderTextId |
Org Scheme or Scheme Version record |
string |
|
SC_SampleMaxVolume |
Org Scheme or Scheme Version record |
double |
|
SC_SampleMaxWeight |
Org Scheme or Scheme Version record |
double |
|
SC_SampleMinVolume |
Org Scheme or Scheme Version record |
double |
|
SC_SampleMinWeight |
Org Scheme or Scheme Version record |
double |
|
SC_SampleTargetVolume |
Org Scheme or Scheme Version record |
double |
|
SC_SampleTargetWeight |
Org Scheme or Scheme Version record |
double |
|
SC_SampleVolumeAllowances |
Org Scheme or Scheme Version record |
string |
|
SC_SampleVolumeTolerance |
Org Scheme or Scheme Version record |
double |
|
SC_SampleWeightAllowances |
Org Scheme or Scheme Version record |
string |
|
SC_SampleWeightTolerance |
Org Scheme or Scheme Version record |
double |
|
SC_SchemeAutoRelease |
Org Scheme or Scheme Version record |
boolean |
|
SC_SchemeAutoValidate |
Org Scheme or Scheme Version record |
boolean |
|
SC_SchemeBacklog |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeCategoryCode |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeCategoryId |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeClientCode |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeClientGroupCode |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeClientGroupId |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeClientId |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeCode |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeContainerTypeCode |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeContainerTypeId |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeDataGridHeaderName |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeDescription |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeDuration |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeId |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeInstrumentGroupCode |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeInstrumentGroupId |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeIsActive |
Org Scheme or Scheme Version record |
boolean |
|
SC_SchemeIsReportable |
Org Scheme or Scheme Version record |
boolean |
|
SC_SchemeLaboratoryId |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeLimitSpecificationCode |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeLimitSpecificationId |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeLineOfBusinessCode |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeLineOfBusinessId |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeName |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeOrganisationId |
Org Scheme or Scheme Version record |
string |
|
SC_SchemePretreatmentCategoryCode |
Org Scheme or Scheme Version record |
string |
|
SC_SchemePretreatmentCategoryId |
Org Scheme or Scheme Version record |
string |
|
SC_SchemePriceType |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeSectionCode |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeSectionId |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeType |
Org Scheme or Scheme Version record |
string |
|
SC_SchemeVersion |
Org Scheme or Scheme Version record |
double |
|
SC_SchemeVersionTextId |
Org Scheme or Scheme Version record |
string |
|
SC_SectionCapacity |
Org Scheme or Scheme Version record |
double |
|
SC_StandardMaxVolume |
Org Scheme or Scheme Version record |
double |
|
SC_StandardMaxWeight |
Org Scheme or Scheme Version record |
double |
|
SC_StandardMinVolume |
Org Scheme or Scheme Version record |
double |
|
SC_StandardMinWeight |
Org Scheme or Scheme Version record |
double |
|
SC_StandardTargetVolume |
Org Scheme or Scheme Version record |
double |
|
SC_StandardTargetWeight |
Org Scheme or Scheme Version record |
double |
|
SC_StandardVolumeAllowances |
Org Scheme or Scheme Version record |
string |
|
SC_StandardVolumeTolerance |
Org Scheme or Scheme Version record |
double |
|
SC_StandardWeightAllowances |
Org Scheme or Scheme Version record |
string |
|
SC_StandardWeightTolerance |
Org Scheme or Scheme Version record |
double |
|
SC_Status |
Org Scheme or Scheme Version record |
string |
|
SC_StatusChangeReason |
Org Scheme or Scheme Version record |
string |
|
SC_StatusChangedByUserCode |
Org Scheme or Scheme Version record |
string |
|
SC_StatusChangedByUserId |
Org Scheme or Scheme Version record |
string |
|
SC_StatusChangedDate |
Org Scheme or Scheme Version record |
dateTime |
|
SC_TestsForKpi |
Org Scheme or Scheme Version record |
double |
|
SC_WaitingTime |
Org Scheme or Scheme Version record |
string |
|
SC_WarningTime |
Org Scheme or Scheme Version record |
string |
|
vSampleSchemeAnalyte Reporting View—SSA attributes |
Scope of default |
Property type |
|---|---|---|
|
SSA_ActivatedUserCode |
SSA Property |
string |
|
SSA_ActivatedUserId |
SSA Property |
string |
|
SSA_AnalysedByUserCode |
SSA Property |
string |
|
SSA_AnalysedByUserId |
SSA Property |
string |
|
SSA_AnalysedDate |
SSA Property |
dateTime |
|
SSA_ApplicationName |
SSA Property |
string |
|
SSA_AppliesToAllSamples |
SSA Property |
boolean |
|
SSA_BooleanValue |
SSA Property |
boolean |
|
SSA_ClientSampleName |
SSA Property |
string |
|
SSA_Code |
SSA Property |
string |
|
SSA_CompositeCorrectionFactor |
SSA Property |
double |
|
SSA_CompositeQcStatus |
SSA Property |
string |
|
SSA_CompositeSpecStatus |
SSA Property |
string |
|
SSA_CorrectedIntLowerDetLimit |
SSA Property |
double |
|
SSA_CorrectedIntUpperDetLimit |
SSA Property |
double |
|
SSA_CurrentDataType |
SSA Property |
string |
|
SSA_DateTimeValue |
SSA Property |
dateTime |
|
SSA_DefaultWorkflowStatus |
SSA Property |
string |
|
SSA_DilutionFactor |
SSA Property |
double |
|
SSA_Document |
SSA Property |
base64Binary |
|
SSA_DocumentFileId |
SSA Property |
string |
|
SSA_ExpiryDate |
SSA Property |
dateTime |
|
SSA_FirstReportedDate |
SSA Property |
dateTime |
|
SSA_FormattedFinalValue |
SSA Property |
string |
|
SSA_FormattedReportLowerDL |
SSA Property |
string |
|
SSA_FormattedReportUpperDL |
SSA Property |
string |
|
SSA_HoldingTime |
SSA Property |
string |
|
SSA_Id |
SSA Property |
string |
|
SSA_Image |
SSA Property |
base64Binary |
|
SSA_ImageFileId |
SSA Property |
string |
|
SSA_IncludeInAutoReg |
SSA Property |
string |
|
SSA_IncludeInManualReg |
SSA Property |
string |
|
SSA_IntDetLimitStatus |
SSA Property |
string |
|
SSA_IntLowerDetLimit |
SSA Property |
double |
|
SSA_IntUpperDetLimit |
SSA Property |
double |
|
SSA_IsAddToAll |
SSA Property |
boolean |
|
SSA_IsDoDataConvert |
SSA Property |
boolean |
|
SSA_IsIncludeOnWorksheet |
SSA Property |
boolean |
|
SSA_IsIntLowerLimCritical |
SSA Property |
boolean |
|
SSA_IsIntUpperLimCritical |
SSA Property |
boolean |
|
SSA_IsInvoiceable |
SSA Property |
boolean |
|
SSA_IsLabBatchContext |
SSA Property |
boolean |
|
SSA_IsNotesAvailable |
SSA Property |
boolean |
|
SSA_IsOrganisationScope |
SSA Property |
boolean |
|
SSA_IsOverriddenAnalyseDate |
SSA Property |
boolean |
|
SSA_IsQcActive |
SSA Property |
boolean |
|
SSA_IsReportable |
SSA Property |
boolean |
|
SSA_IsSchemeOrganisationScope |
SSA Property |
boolean |
|
SSA_IsUsedInAggregate |
SSA Property |
boolean |
|
SSA_IsWorkflowActive |
SSA Property |
boolean |
|
SSA_JobCode |
SSA Property |
string |
|
SSA_JobId |
SSA Property |
string |
|
SSA_JobSchemeAnalyteId |
SSA Property |
string |
|
SSA_LabBatchJobCode |
SSA Property |
string |
|
SSA_LabBatchSampleCode |
SSA Property |
string |
|
SSA_LaboratoryCode |
SSA Property |
string |
|
SSA_LastActivatedDate |
SSA Property |
dateTime |
|
SSA_LastInvoicedDate |
SSA Property |
dateTime |
|
SSA_LastReportedDate |
SSA Property |
dateTime |
|
SSA_LatestReadingId |
SSA Property |
string |
|
SSA_LimitStatus |
SSA Property |
string |
| SSA_LowerTemplateSampleCode | SSA Property | string |
| SSA_LowerTemplateSampleLabCode | SSA Property | string |
|
SSA_NumericFinalValue |
SSA Property |
double |
|
SSA_NumericRawValue |
SSA Property |
double |
|
SSA_OrganisationCode |
SSA Property |
string |
|
SSA_PackagePriceCode |
SSA Property |
string |
|
SSA_PackagePriceCodeLabCode |
SSA Property |
string |
|
SSA_Param1Name |
SSA Property |
string |
|
SSA_Param1Value |
SSA Property |
string |
|
SSA_Param2Name |
SSA Property |
string |
|
SSA_Param2Value |
SSA Property |
string |
|
SSA_Param3Name |
SSA Property |
string |
|
SSA_Param3Value |
SSA Property |
string |
|
SSA_Param4Name |
SSA Property |
string |
|
SSA_Param4Value |
SSA Property |
string |
|
SSA_Param5Name |
SSA Property |
string |
|
SSA_Param5Value |
SSA Property |
string |
|
SSA_PercentageDifference |
SSA Property |
double |
|
SSA_PrecisionStatus |
SSA Property |
string |
|
SSA_PriceCode |
SSA Property |
string |
|
SSA_PriceItemId |
SSA Property |
string |
|
SSA_ProfileSequence |
SSA Property |
double |
|
SSA_QcIgnoredDate |
SSA Property |
dateTime |
|
SSA_QcIgnoredUserCode |
SSA Property |
string |
|
SSA_QcIgnoredUserId |
SSA Property |
string |
|
SSA_Recovery |
SSA Property |
double |
|
SSA_RegistrationSequence |
SSA Property |
double |
|
SSA_ReleasedByUserCode |
SSA Property |
string |
|
SSA_ReleasedByUserId |
SSA Property |
string |
|
SSA_ReleasedDate |
SSA Property |
dateTime |
|
SSA_RepLowerDetLimit |
SSA Property |
double |
|
SSA_RepUpperDetLimit |
SSA Property |
double |
|
SSA_ReportSequence |
SSA Property |
double |
|
SSA_ReportText |
SSA Property |
string |
|
SSA_ReportTextId |
SSA Property |
string |
|
SSA_ReportUnitCode |
SSA Property |
string |
|
SSA_ReportUnitId |
SSA Property |
string |
|
SSA_RequiredDate |
SSA Property |
dateTime |
|
SSA_RoundingTableCode |
SSA Property |
string |
|
SSA_RoundingTableId |
SSA Property |
string |
|
SSA_Rpd |
SSA Property |
double |
|
SSA_SampleCode |
SSA Property |
string |
|
SSA_SampleId |
SSA Property |
string |
|
SSA_SampleName |
SSA Property |
string |
|
SSA_SampleSchemeId |
SSA Property |
string |
|
SSA_SchemeCode |
Org Scheme/Version record from SSA |
string |
|
SSA_SchemeId |
Org Scheme/Version record from SSA |
string |
|
SSA_SchemeLaboratoryCode |
Org Scheme/Version record from SSA |
string |
|
SSA_SchemeVersion |
Org Scheme/Version record from SSA |
double |
|
SSA_SchemeVersionAnalyteAutoRelease |
Org Scheme/Version record from SSA |
boolean |
|
SSA_SchemeVersionAnalyteAutoValidate |
Org Scheme/Version record from SSA |
boolean |
|
SSA_SchemeVersionAnalyteDescription |
Org Scheme/Version record from SSA |
string |
|
SSA_SchemeVersionAnalyteId |
Org Scheme/Version record from SSA |
string |
|
SSA_SchemeVersionAnalyteIsMandatoryProfile |
Org Scheme/Version record from SSA |
boolean |
|
SSA_SchemeVersionAnalyteName |
Org Scheme/Version record from SSA |
string |
|
SSA_SchemeVersionAnalyteParentAnalyteCode |
Org Scheme/Version record from SSA |
string |
|
SSA_SchemeVersionAnalyteParentAnalyteId |
Org Scheme/Version record from SSA |
string |
|
SSA_SchemeVersionAnalyteReportDescription |
Org Scheme/Version record from SSA |
string |
|
SSA_SchemeVersionAnalyteReportName |
Org Scheme/Version record from SSA |
string |
|
SSA_SchemeVersionId |
Org Scheme/Version record from SSA |
string |
|
SSA_SourceSampleTemplateId |
SSA Property |
string |
|
SSA_SpecificationStatus |
SSA Property |
string |
|
SSA_SpreadsheetFormula |
SSA Property |
string |
|
SSA_StandardStatus |
SSA Property |
string |
|
SSA_StartedDate |
SSA Property |
dateTime |
|
SSA_Status |
SSA Property |
string |
|
SSA_TemplateSampleCode |
SSA Property |
string |
|
SSA_TextValue |
SSA Property |
string |
|
SSA_UncertaintyValue |
SSA Property |
string |
|
SSA_UnitCode |
SSA Property |
string |
|
SSA_UnitId |
SSA Property |
string |
| SSA_UpperTemplateSampleCode | SSA Property | string |
| SSA_UpperTemplateSampleLabCode | SSA Property | string |
|
SSA_UserQcStatus |
SSA Property |
string |
|
SSA_UserWorkflowStatus |
SSA Property |
string |
|
SSA_ValidatedDate |
SSA Property |
dateTime |
|
SSA_ValidationUserCode |
SSA Property |
string |
|
SSA_ValidationUserId |
SSA Property |
string |
|
SSA_Volume |
SSA Property |
double |
|
SSA_WarningDate |
SSA Property |
dateTime |
|
SSA_Weight |
SSA Property |
double |
|
SSA_WorkflowStatus |
SSA Property |
string |
|
vSampleSchemeAnalyte Reporting View—ST attributes |
Scope of default |
Property type |
|---|---|---|
|
ST_AccessUserGroupCode |
|
string |
|
ST_AccessUserGroupId |
|
string |
|
ST_AccessUserGroupName |
|
string |
|
ST_Code |
|
string |
|
ST_Description |
|
string |
|
ST_Id |
|
string |
|
ST_IsActive |
|
boolean |
|
ST_IsOrganisationScope |
|
boolean |
|
ST_IsReportable |
|
boolean |
|
ST_LaboratoryId |
|
string |
|
ST_LocationCode |
|
string |
|
ST_LocationId |
|
string |
|
ST_Name |
|
string |
|
ST_OrganisationId |
|
string |
|
ST_ReleaseResultUserGroupCode |
|
string |
|
ST_ReleaseResultUserGroupId |
|
string |
|
ST_ReleaseResultUserGroupName |
|
string |
|
ST_ReportActive |
|
boolean |
|
ST_ReportSequence |
|
double |
|
ST_ResultsCannedCommentGroupCode |
|
string |
|
ST_ResultsCannedCommentGroupId |
|
string |
|
ST_SectionCategoryCode |
|
string |
|
ST_SectionCategoryId |
|
string |
|
ST_SectionManagerUserGroupCode |
|
string |
|
ST_SectionManagerUserGroupId |
|
string |
|
ST_ValidateResultUserGroupCode |
|
string |
|
ST_ValidateResultUserGroupId |
|
string |
|
vSampleSchemeAnalyte Reporting View—U attributes |
Scope of default |
Property type |
|---|---|---|
|
U_Code |
|
string |
|
U_ConvertToUnitSuffix |
|
string |
|
U_Description |
|
string |
|
U_Id |
|
string |
|
U_IsActive |
|
boolean |
|
U_IsOrganisationScope |
|
boolean |
|
U_LaboratoryId |
|
string |
|
U_LongSymbol |
|
string |
|
U_Name |
|
string |
|
U_OrganisationId |
|
string |
|
U_ShortSymbol |
|
string |
|
U_UnitCategoryCode |
|
string |
|
U_UnitCategoryId |
|
string |
